Found it (after some days of searching):
https://code.launchpad.net/ubuntu/+source/mysql-workbench must be the
official repository according to
https://dev.mysql.com/doc/refman/5.7/en/installing-development-tree.html.
-Kalle
Am 15.10.2015 um 22:11 schrieb Karl-Philipp Richter:
> Hi,
> The only
Hello Steve,
To what list should I post with a post-installation config and startup
question?
This list, the MySQL General Mailing List, is the right place if the
question is about MySQL!
Cheers
--
Claudio
2011/04/25 18:45 +, Larry McGhaw
CREATE VIEW `myview2` AS
SELECT a.*, IF(b.`Name` IS NULL, '', b.`Name`) AS `TypeName`
FROM `mytable` a
LEFT JOIN `types` b ON a.`Type` = b.`ID`;
Well, for this construct
IF(b.`Name` IS NULL, '', b.`Name`)
there is a special function
On 04/26/11 05:32, Halász Sándor wrote:
2011/04/25 18:45 +, Larry McGhaw
CREATE VIEW `myview2` AS
SELECT a.*, IF(b.`Name` IS NULL, '', b.`Name`) AS `TypeName`
FROM `mytable` a
LEFT JOIN `types` b ON a.`Type` = b.`ID`;
Well, for this construct
IF(b.`Name` IS NULL,
Cc: Daevid Vincent; mysql@lists.mysql.com
Subject: Re: WHERE does not work on calculated view field - Found word(s) list
error in the Text body
On 04/22/11 22:41, Larry McGhaw wrote:
It does appear to be some type of bug to me.
Hm... do you have an idea how to work around this bug then?
Yours
Hi,
On 04/25/11 20:45, Larry McGhaw wrote:
My best advice is to not use a custom MySQL function in a view when the
parameter to that function
is a column or expression that has the potential to result in NULL because of
being on the right side
of a left outer join (or the left side of a right
-
From: Daniel Kraft [mailto:d...@domob.eu]
Sent: Friday, April 22, 2011 1:05 PM
To: Daevid Vincent
Cc: mysql@lists.mysql.com
Subject: Re: WHERE does not work on calculated view field - Found word(s) list
error in the Text body
Hi,
thanks for the fast reply!
On 04/22/11 21:39, Daevid Vincent
Hi Daniel,
Could you check the 'myview' once again? I think you thought to create the
view as follows:
CREATE VIEW `myview2` AS SELECT a.*, EMPTY_STRING(b.`Name`) AS
`TypeName`FROM `mytable` a LEFT JOIN `types` b ON *a.ID* *= b.`ID`*;
Now your select queries will give results as
Hi,
thanks for the answer!
On 04/23/11 11:33, ars k wrote:
Could you check the 'myview' once again? I think you thought to create the
view as follows:
CREATE VIEW `myview2` AS SELECT a.*, EMPTY_STRING(b.`Name`) AS
`TypeName`FROM `mytable` a LEFT JOIN `types` b ON *a.ID* *= b.`ID`*;
-Original Message-
From: Daniel Kraft [mailto:d...@domob.eu]
Sent: Friday, April 22, 2011 12:37 PM
To: mysql@lists.mysql.com
Subject: WHERE does not work on calculated view field
Hi all,
I'm by no means a (My)SQL expert and just getting started working with
VIEWs and stored
Hi,
thanks for the fast reply!
On 04/22/11 21:39, Daevid Vincent wrote:
DROP DATABASE `test`;
CREATE DATABASE `test`;
USE `test`;
CREATE TABLE `mytable`
(`ID` SERIAL,
`Type` INTEGER UNSIGNED NULL,
PRIMARY KEY (`ID`));
INSERT INTO `mytable` (`Type`) VALUES (NULL);
CREATE TABLE
On 22.04.2011 21:37, Daniel Kraft wrote:
Hi all,
I'm by no means a (My)SQL expert and just getting started working with
VIEWs and stored procedures, and now I'm puzzled by this behaviour:
DROP DATABASE `test`;
CREATE DATABASE `test`;
USE `test`;
CREATE TABLE `mytable`
(`ID` SERIAL,
`Type`
Hi Carsten,
On 04/22/11 22:11, Carsten Pedersen wrote:
On 22.04.2011 21:37, Daniel Kraft wrote:
DROP DATABASE `test`;
CREATE DATABASE `test`;
USE `test`;
CREATE TABLE `mytable`
(`ID` SERIAL,
`Type` INTEGER UNSIGNED NULL,
PRIMARY KEY (`ID`));
INSERT INTO `mytable` (`Type`) VALUES (NULL);
@lists.mysql.com
Subject: Re: WHERE does not work on calculated view field - Found word(s) list
error in the Text body
Hi,
thanks for the fast reply!
On 04/22/11 21:39, Daevid Vincent wrote:
DROP DATABASE `test`;
CREATE DATABASE `test`;
USE `test`;
CREATE TABLE `mytable`
(`ID` SERIAL,
`Type
On 22.04.2011 22:41, Larry McGhaw wrote:
It does appear to be some type of bug to me.
I agree. I was thrown by Daniels first and third comment, which I
guess should read second and third
I reproduced the behavior in 5.1.53-community on Windows.
/ Carsten
--
MySQL General Mailing List
For
Putting the 'HAVING' in there, works perfectly :)
THANKS!
Steven Staples
-Original Message-
From: SHAWN L.GREEN [mailto:shawn.l.gr...@oracle.com]
Sent: June 10, 2010 8:03 PM
To: Steven Staples
Cc: 'MySql'
Subject: Re: WHERE clause from AS result
On 6/10/2010 4:38 PM, Steven
You can use an Alias in ORDER BY but not in WHERE clauses.
Keith
On Thu, 2010-06-10 at 16:38 -0400, Steven Staples wrote:
Ok, I have done it before, where I have used the AS result in an ORDER BY,
but now, I can't figure out why I can't use it in a WHERE clause?
SELECT `email`, (SELECT
On 6/10/2010 4:38 PM, Steven Staples wrote:
Ok, I have done it before, where I have used the AS result in an ORDER BY,
but now, I can't figure out why I can't use it in a WHERE clause?
SELECT `email`, (SELECT CONCAT(`phone_pref`, '-', `phone_suff`) FROM `pnums`
WHERE `id`=`usertable`.`id`) AS
Hey Chris,
Please send the explain plan for this query, the estimated table sizes (in
MB or GB) and the RAM capacity.
These are also the requisites for helping optimizing your query if
required...
Thanks.
Anirudh Sundar
On Fri, May 7, 2010 at 12:14 PM, Chris Knipe sav...@savage.za.org wrote:
My appologies for leaving that bit out...
mysql EXPLAIN SELECT COUNT(FlightRoutes.FlightID) AS Count,
FlightRoutes.Dep AS Dep, FlightRoutes.Des AS Des FROM FlightRoutes LEFT JOIN
IVAOData ON FlightRoutes.FlightID=IVAOData.FlightID WHERE
IVAOData.TrackerTime = UNIX_TIMESTAMP('2010-04-01 00:00:00')
Added whitespace for readabilty:
SELECT
COUNT(FlightRoutes.FlightID) AS Count,
FlightRoutes.Dep AS Dep,
FlightRoutes.Des AS Des
FROM FlightRoutes
LEFT JOIN IVAOData ON FlightRoutes.FlightID=IVAOData.FlightID
WHERE IVAOData.TrackerTime =UNIX_TIMESTAMP('2010-04-01 00:00:00')
On Fri, May 7, 2010 at 10:42 AM, Rob Wultsch wult...@gmail.com wrote:
Second thing:
How selective is
WHERE IVAOData.TrackerTime =UNIX_TIMESTAMP('2010-04-01 00:00:00')
AND IVAOData.TrackerTime =UNIX_TIMESTAMP('2010-04-30 23:59:50')
Test by running
SELECT COUNT(*)
FROM IVAOData
something tells me I need to rethink this yes.
If you were to add a computed column yearmonth, you could write WHERE
yearmonth=201004.
PB
-
Chris Knipe wrote:
On Fri, May 7, 2010 at 10:42 AM, Rob Wultsch wult...@gmail.com wrote:
Second thing:
How selective is
WHERE
You could be running into this:
http://dev.mysql.com/doc/refman/5.0/en/how-to-avoid-table-scan.html
On Fri, May 7, 2010 at 10:05 AM, Peter Brawley
peter.braw...@earthlink.netwrote:
something tells me I need to rethink this yes.
If you were to add a computed column yearmonth, you could
Hello Chris,
Your Query Build
EXPLAIN SELECT COUNT(FlightRoutes.FlightID) AS Count, FlightRoutes.Dep AS
Dep, FlightRoutes.Des AS Des FROM FlightRoutes LEFT JOIN IVAOData ON
FlightRoutes.FlightID=IVAOData.FlightID WHERE IVAOData.TrackerTime =
UNIX_TIMESTAMP('2010-04-01
On 06/02/2010, at 5:31 PM, MuraliKrishna wrote:
Hi
I am in need to know about handlers and cursors.. if any site giving
detailed explanation and examples on these. thanks in advance
Cursors: http://dev.mysql.com/doc/refman/5.1/en/cursors.html
Handlers:
Andy Shellam wrote:
My thoughts exactly!
This article might help:
http://dev.mysql.com/tech-resources/articles/mysql-54.html
It worries me though that 5.1 went through a large number of alpha
releases, then a set of beta releases before the GA release came out.
It looks like they've
My thoughts exactly!
This article might help:
http://dev.mysql.com/tech-resources/articles/mysql-54.html
It worries me though that 5.1 went through a large number of alpha
releases, then a set of beta releases before the GA release came out.
It looks like they've thrown 5.4 straight out
.
From: Andy Shellam [andy-li...@networkmail.eu]
Sent: Thursday, April 30, 2009 2:19 PM
To: Daevid Vincent
Cc: mysql@lists.mysql.com
Subject: Re: Where the hell did 5.4 come from?
My thoughts exactly!
This article might help:
http://dev.mysql.com/tech-resources/articles/mysql-54
Hi, Dan Nelson Rolando Edwards
It works, thank you. :-)
2009/3/26 Rolando Edwards redwa...@logicworks.net:
The table mysql.proc always contains the hard code of stored procedures and
functions.
Triggers in 5.0 are stored in a .TRG file
Make sure, if you used mysqldump, to include
In the last episode (Mar 26), Cui Shijun said:
It seems that the stored functions isn't stored in a seperated file
like trigger does.
Where are them?
If I copy the database directory from a server to another, can I get
the same functions on the both servers?
They're stored in the
The table mysql.proc always contains the hard code of stored procedures and
functions.
Triggers in 5.0 are stored in a .TRG file
Make sure, if you used mysqldump, to include --triggers as a dump option
Rolando A. Edwards
MySQL DBA (CMDBA)
155 Avenue of the Americas, Fifth Floor
New York, NY
On Tue, Feb 3, 2009 at 12:24 PM, Jerry Schwartz
jschwa...@the-infoshop.com wrote:
Somebody, I think it was somebody from MySQL, said that you should never put
anything into a WHERE clause that could be put into the ON clause of a JOIN.
My guess is that this helps with the optimization, but it
-Original Message-
From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On
Behalf Of Baron Schwartz
Sent: Wednesday, February 04, 2009 10:03 AM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: WHERE vs. ON
On Tue, Feb 3, 2009 at 12:24 PM, Jerry Schwartz
jschwa
Never tried it in MySQL and Im not
in a position to do so
at the moment
but in Oracle you can do a left outer join in the where
clause something
like this
SELECT t1.col1, t2.col2
FROM table1 t1, table2 t2
WHERE t1.join_col_name = t2.join_col_name(+)
Does this not work in MySQL?
Never tried it
-Original Message-
From: John Daisley [mailto:john.dais...@mypostoffice.co.uk]
Sent: Wednesday, February 04, 2009 10:41 AM
To: mysql@lists.mysql.com
Cc: Jerry Schwartz
Subject: Re: WHERE vs. ON
Never tried it in MySQL and Im not
in a position to do so
at the moment
but in Oracle you can
Never tried it in MySQL and Im not
in a position to do so
at the moment
but in Oracle you can do a left outer join in the where
clause something
like this
SELECT t1.col1, t2.col2
FROM table1 t1, table2 t2
WHERE t1.join_col_name = t2.join_col_name(+)
Does this not work in MySQL?
Luckily, it
2009/2/4 Baron Schwartz ba...@xaprb.com
On Tue, Feb 3, 2009 at 12:24 PM, Jerry Schwartz
jschwa...@the-infoshop.com wrote:
Somebody, I think it was somebody from MySQL, said that you should never
put
anything into a WHERE clause that could be put into the ON clause of a
JOIN.
My guess is
ON condition uses the same columnname from both source and target tables
whereas any column expressions can go in the WHERE clause...
Martin
__
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the
On Tue, Feb 3, 2009 at 12:24 PM, Jerry Schwartz
jschwa...@the-infoshop.com wrote:
Somebody, I think it was somebody from MySQL, said that you should never put
anything into a WHERE clause that could be put into the ON clause of a JOIN.
My guess is that this helps with the optimization, but it
On Tue, Feb 3, 2009 at 1:54 PM, Jerry Schwartz
jschwa...@the-infoshop.com wrote:
From: Martin Gainty [mailto:mgai...@hotmail.com]
Sent: Tuesday, February 03, 2009 1:03 PM
To: Jerry Schwartz; mysql@lists.mysql.com
Subject: RE: WHERE vs. ON
ON condition uses the same columnname from both source
From: Martin Gainty [mailto:mgai...@hotmail.com]
Sent: Tuesday, February 03, 2009 1:03 PM
To: Jerry Schwartz; mysql@lists.mysql.com
Subject: RE: WHERE vs. ON
ON condition uses the same columnname from both source and target tables
whereas any column expressions can go in the WHERE
Hi!
Moon's Father wrote:
Hi.
Where can I download a mysql 4.0.12? I found nowhere to download it.
You will not find it anywhere at MySQL, it is out of support since more
than 2 years (September 2006).
For an explanation, read the text here:
If you still want it you can download it from the Proven Scaling mirror.
http://mirror.provenscaling.com/mysql/community/source/4.0/
-Eric
On Thu, Nov 6, 2008 at 1:58 AM, Joerg Bruehe [EMAIL PROTECTED] wrote:
Hi!
Moon's Father wrote:
Hi.
Where can I download a mysql 4.0.12? I found
Thanks for alll of you reply.
I know this version is too old and it has many bugs and security issues, but
this is our current using edition .I have no choice for it.
Thanks for you again!
On Fri, Nov 7, 2008 at 4:31 AM, Eric Bergen [EMAIL PROTECTED] wrote:
If you still want it you can download
On Thu, 2008-07-24 at 09:34 +0530, Sivasakthi wrote:
How can we normalize the tables? could you explain bit more?
Thanks,
Siva
Normalization is a complex subject. I suggest you search the web for
tutorials. Try the search terms: RDBM normalization
--
Just my 0.0002 million
Hi
If you're searching for, effectively, %123% you probably can't use IN(). You
could get away with wildcard patterns - if it's a heavily used field
consider an index to increase performance. Hard to tell if this may be a FK
of sorts, but if so you should use it as one which may involve
A text field -Lets call it 'field1'- contains datas seperated by
commas(,)
like this (123,5764,8795,9364,11,232,.
The solution is to normalise the data.
PB
Ali Deniz EREN wrote:
Hi all,
I have a problem as below:
A text field -Lets call it 'field1'- contains datas seperated by
On Wed, 2008-07-23 at 17:05 +0300, Ali Deniz EREN wrote:
Hi all,
I have a problem as below:
A text field -Lets call it 'field1'- contains datas seperated by
commas(,) like this (123,5764,8795,9364,11,232,. and go on) And so
my lines like these:
id title filed1
How about: WHERE ( field1 LIKE '123,%' OR field1 LIKE '*,123,%' OR
field1 LIKE '%,123' OR field1 = '123' )
Note that this could that a long time on large tables. You'd be better
off to normalize your tables ;)
How can we normalize the tables? could you explain bit more?
Thanks,
Siva
Il giorno 08/feb/08, alle ore 21:55, Riccardo Perotti ha scritto:
Hi all:
Our sistem crashed and we're trying to recover our data. The disc is
fine but the OS is gone, so I'm trying to get at the actual mysql
databases document. Does anybody know where to look for them in a
*nix system?
On Fri, February 8, 2008 13:09, Paolo Amodio wrote:
Il giorno 08/feb/08, alle ore 21:55, Riccardo Perotti ha scritto:
Hi all:
Our sistem crashed and we're trying to recover our data. The disc is
fine but the OS is gone, so I'm trying to get at the actual mysql
databases document. Does
RedHat centric systems store them in /var/lib/mysql
On Feb 8, 2008, at 2:55 PM, Riccardo Perotti wrote:
Hi all:
Our sistem crashed and we're trying to recover our data. The disc is
fine but the OS is gone, so I'm trying to get at the actual mysql
databases document. Does anybody know
Il giorno 08/feb/08, alle ore 22:29, Riccardo Perotti ha scritto:
On Feb 8, 2008, at 4:02 PM, Paolo Amodio wrote:
Il giorno 08/feb/08, alle ore 21:55, Riccardo Perotti ha scritto:
Hi all:
Our sistem crashed and we're trying to recover our data. The disc
is fine but the OS is gone, so
On Sat, 2008-01-19 at 19:02 +, Apple wrote:
Fatal error: Call to undefined function mysql_connect() in
/home/re/script.php on line 3
I've googled and found out that I need to add extension=mysql.so
in CLI's php.ini file (separate php.ini file that works for CLI only).
The
Hi,
Try the following link
ftp://ftp.pbone.net/mirror/remi.collet.free.fr/rpms/fc6.x86_64/php-mysql-5.2.5-1.fc6.remi.x86_64.rpm
if that doesn't match your need search http://rpm.pbone.net
Saravanan
--- On Sun, 1/20/08, Apple [EMAIL PROTECTED] wrote:
From: Apple [EMAIL PROTECTED]
Olav Mørkrid wrote:
hello
does anyone know what is returned when you do a where column without
further parameters?
SELECT * FROM TABLE WHERE COLUMN;
for integer columns it seems to return non-zero columns, but for other
types of columns the results seemed unpredictable.
The value of the
- Original Message -
From: Olav Mørkrid [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, August 24, 2007 1:07 AM
Subject: where column
hello
does anyone know what is returned when you do a where column without
further parameters?
SELECT * FROM TABLE WHERE COLUMN;
for
Hello Michael. Here is the query you wanted - you were almost there.
SELECT DISTINCT NAME FROM PEOPLE
WHERE ID IN
(SELECT PID FROM PEOPLE_CITY_MAP
WHERE CID = 1)
Thanks.
-Original Message-
From: Michael Fischer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 31, 2007 11:53
@lists.mysql.com
Subject: Re: WHERE (NOT) EXISTS problem
Michael Fischer wrote:
Having a very bad time with the subject sorts of queries.
Here is a simple reproduction of the problem for me.
Perhaps I'm blind/stupid while looking at the docs,
or there's a bug...
mysql version 5.0.24-standard
simple
Michael Fischer wrote:
Having a very bad time with the subject sorts of queries.
Here is a simple reproduction of the problem for me.
Perhaps I'm blind/stupid while looking at the docs,
or there's a bug...
mysql version 5.0.24-standard
simple schema:
mysql desc people;
VeeJay wrote:
Hi
Where one can find Source Distribution of MySQL Server 5.0 Standard for
FreeBSD?
Not on the website, that's for sure.
Have you tried the usual warez sites, p2p networks, etc?
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW,
Daniel Kasak wrote:
VeeJay wrote:
Hi
Where one can find Source Distribution of MySQL Server 5.0 Standard for
FreeBSD?
Not on the website, that's for sure.
Have you tried the usual warez sites, p2p networks, etc?
Actually the source tarball IS on the mysql download site.
--
One day at
On Thursday 14 December 2006 14:37, Bruce Ferrell wrote:
Where one can find Source Distribution of MySQL Server 5.0 Standard for
FreeBSD?
Not on the website, that's for sure.
Have you tried the usual warez sites, p2p networks, etc?
Actually the source tarball IS on the mysql download
Daniel Kasak wrote:
VeeJay wrote:
Where one can find Source Distribution of MySQL Server 5.0 Standard for
FreeBSD?
Not on the website, that's for sure.
Have you tried the usual warez sites, p2p networks, etc?
Really? Seems pretty straightforward to me. One the downloads page,
under the
Thanks.. the problem is I'm running MySQL 4.1.16
I might try FULLTEXT...
On 9/27/06, Dan Buettner [EMAIL PROTECTED] wrote:
You can create FULLTEXT indexes on text fields - but that may not be
the best solution for your situation since you are querying for an
exact match.
In MySQL 5.0.3 and
Peter Van Dijck wrote:
Thanks.. the problem is I'm running MySQL 4.1.16
I might try FULLTEXT...
U can create normal indexes on text columns if u specify a prefix
length.
--
Chris Wagner
CBTS
GE Aircraft Engines
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives:
I think you have to specify a key length when you use an index on a
text field...
mysql alter table t2 add index i2(t1(3));
That would create an index (called i2) on the first 3 characters of
field t1 of table t2.
I think that's right?
Douglas Sims
[EMAIL PROTECTED]
On Sep 27, 2006,
You can create FULLTEXT indexes on text fields - but that may not be
the best solution for your situation since you are querying for an
exact match.
In MySQL 5.0.3 and later, you can create VARCHAR columns of up to
65,535 character lengths:
http://dev.mysql.com/doc/refman/5.0/en/char.html
I
To Jimmy Guerrero, Paul DuBois and Fred Ballard,
Your information was very valuable, I already solved the problem, thank you.
Misingo :-)
Hello,
A default install should drop data and databases into C:\Program
Files\MySQL\MySQL Server 5.0.\data
If you run something like:
--
MySQL
-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 07, 2006 5:49 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: where are the .MYI and .MYD files?
[EMAIL PROTECTED] wrote:
I've installed MySQL, created a database and tables and
then loaded fields
Hello,
A default install should drop data and databases into C:\Program
Files\MySQL\MySQL Server 5.0.\data
If you run something like:
mysql CREATE DATABASE test1;
Query OK, 1 row affected (0.00 sec)
mysql USE test1;
Database changed
mysql CREATE TABLE t (i INT) ENGINE = MYISAM;
Query OK, 0
[EMAIL PROTECTED] wrote:
I've installed MySQL, created a database and tables and then loaded fields
into them. I use the command line client and can see the fields, use the
select command and every thing is OK, but when I look for the table files
in the data directory, only the .frm ones appear,
Greg 'groggy' Lehey wrote:
I have downloaded a code on c++ to talk to MySQL database from net which
included a file sqlplus.hh , where may I find the file?Please help me
soon.
That's the main header file for MySQL++ v1.7.9. You can download that
release from the official MySQL++ page:
On Thursday, 3 August 2006 at 22:56:54 -0700, Ratnadeep Nayak wrote:
Hello,
I have downloaded a code on c++ to talk to MySQL database from net which
included a file sqlplus.hh , where may I find the file?Please help me
soon.
It's not in our code. It must be in the code you downloaded. If
nayak_ratnadeep wrote:
Hello,
I have downloaded a code on c++ to talk to MySQL database from net which
included a file sqlplus.hh , where may I find the file?Please help me
soon.
Why have you posted this 5 times?
Did you look at the mysql website at ALL?
It took me 30 seconds to find
nayak_ratnadeep wrote:
I found in net but can't get the file. please help me..
Always reply to the list.
Here's a hint: look for C++ API in the documentation.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Peter Lauri wrote:
Best group member,
I have this query on MySQL version 4.0.27:
SELECT part.memberid, part.prefname, part.email, COUNT(*) AS numberofans
FROM tblparticipants part
LEFT JOIN tblanswers answer ON (answer.par_num=part.memberid)
LEFT OUTER JOIN profilepdfauth pdfauth ON
Use the HAVING clause:
SELECT part.memberid, part.prefname, part.email, COUNT(*) AS numberofans
FROM tblparticipants part
LEFT JOIN tblanswers answer ON (answer.par_num=part.memberid)
LEFT OUTER JOIN profilepdfauth pdfauth ON (part.memberid=pdfauth.memberid)
WHERE pdfauth.id IS NULL
GROUP BY
That did it, thank you all!
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 27, 2006 2:10 AM
To: Peter Lauri
Cc: mysql@lists.mysql.com
Subject: Re: WHERE problem, or is it a problem?
Peter Lauri wrote:
Best group member,
I have this query
Hi Rick, all!
Rick Robinson wrote:
The documentation shows MySQL 5.0.23 as released on July 4 - but I do not see it on any mirror anywhere? Does anyone know where MySQL
5.0.23 is? Is it released, as the doc says? Is it being held until release 5.0.24?
The release date in the documentation
On 6/1/06, Patrik Wallstrom [EMAIL PROTECTED] wrote:
Easy setup: two mysql 5 servers, one running master, the other one is
slave. The database have triggers to create history of rows in history
tables.
What is expected from the slave? Is it expected to run the triggers,
as well as receiving the
[EMAIL PROTECTED] wrote:
I want to select a list, where it was registered in tbl
club_get_match with Id-
Member in tbl detail_club_member, but it's not registered in tbl
wager.
Your schema has a problem: wagers.name_club is too short. If no
club_get_match.name_club value is longer than 20
[EMAIL PROTECTED] wrote:
Sory if my question makes you confused
I've a problem with my sintax,
I don't know how to select a list, whether it's not registered in another
table, but it have 2 IDs.
Not enough info. Show the Create Table statements, a bit of data, and
the desired result.
PB
CREATE TABLE `club_get_match` (
`id_match` bigint(100) NOT NULL default '0',
`name_club` varchar(30) NOT NULL default '',
`status` varchar(30) default NULL,
`prediction_match` varchar(5) NOT NULL default '',
`equal_match` char(3) NOT NULL default '',
`score` varchar(50) default NULL,
The code of insert_client.html which wasn't attached last mail:
http://www.spalha.com.br/spalha/form_client.html
Tom
From: Tom Lobato [EMAIL PROTECTED]
From: Peter Brawley [EMAIL PROTECTED]
Tom,
UPDATE command is not working for only the record that I want, but
for
all in the table.
[snip]
The php and db structure and data are attacheds. Two infos: 1) Im
not a
expert 2) The code is in the beggining of the development, so are too
many
uglyness yet =)
[/snip]
Find a place online to post your code or paste it into the message (only
the relevant parts). Usually no one will
[snip]
Find a place online to post your code or paste it into the message (only
the relevant parts). Usually no one will open an attachment on a mailing
list.
[/snip]
Post the line of PHP where this query exists.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
From: Jay Blanchard [EMAIL PROTECTED]
Find a place online to post your code or paste it into the message (only
the relevant parts). Usually no one will open an attachment on a mailing
list.
Oh Yes, sorry. In really, I indeed uploaded the files to the server
www.spalha.com.br/spalha.
Tom
Tom,
snip
Maybe a comunication trouble... Let me confirm. Are you saying that
http://www.spalha.com.br/spalha/DB_code.html
http://www.spalha.com.br/spalha/insert_client_code.html
are not the code Im having troubles? As the code Im having trouble
were some secret or so?
if ($yes){
From: Jay Blanchard [EMAIL PROTECTED]
Post the line of PHP where this query exists.
Well, I think that show
$result = mysql_query($command);
won't help us, because the $command indeed begins to be constructed 120
lines before this. Only looking the code =(
Tom
--
MySQL
5:00 a.m.
To: mysql@lists.mysql.com
Subject: Re: WHERE doesn'r works
From: Jay Blanchard [EMAIL PROTECTED]
Post the line of PHP where this query exists.
Well, I think that show
$result = mysql_query($command);
won't help us, because the $command indeed begins to be constructed 120
Solved =)
From: Quentin Bennett [EMAIL PROTECTED]
Have you tried turning on the logging on the MySQL server, and seeing
exactly what command the server is receiving - it may be different from the
one (you
think) you are sending.
Turning on the logging on the MySQL server, I saw PHP
Solved =)
From: Quentin Bennett [EMAIL PROTECTED]
Have you tried turning on the logging on the MySQL server, and seeing
exactly what command the server is receiving - it may be different from the
one (you
think) you are sending.
Turning on the logging on the MySQL server, I saw PHP
From: [EMAIL PROTECTED]
you really need to show your php code and the output from an echo of
the update line so that people can try to spot what you're doing wrong.
from what i've seen, people are basically just guessing at the issue
with you saying tried that, didn't work.
updating mysql
From: [EMAIL PROTECTED]
you really need to show your php code and the output from an echo of
the update line so that people can try to spot what you're doing wrong.
from what i've seen, people are basically just guessing at the issue
with you saying tried that, didn't work.
updating mysql
- Original Message -
From: Tom Lobato [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Saturday, April 22, 2006 4:03 AM
Subject: Re: WHERE doesn'r works
From: [EMAIL PROTECTED]
you really need to show your php code and the output from an echo of
the update line so that people can
From: Rhino [EMAIL PROTECTED]
Most of the time, when I see a column named 'id', it is defined as an
integer. If _your_ 'id' column is defined as an integer, then the reason
your WHERE clause is failing is very simple: Your WHERE clause is looking
for all the rows where the 'id' value is a
- Original Message -
From: Tom Lobato [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Saturday, April 22, 2006 4:18 PM
Subject: Re: WHERE doesn'r works
From: Rhino [EMAIL PROTECTED]
Most of the time, when I see a column named 'id', it is defined as an
integer. If _your_ 'id
Tom,
UPDATE command is not working for only the record that I want, but for
all in the table. I sees WHERE is not interpretated by Mysql server. At
least the result is identic to it. For example, If my php execute
UPDATE clientes SET tipo='r', nome_fantasia='cc', estado='24'
WHERE
1 - 100 of 367 matches
Mail list logo