David Ulevitch wrote:
On Jul 12, 2005, at 6:15 AM, gerald_clark wrote:
Nightly backup and binlogs can take you to any point in the day.
I failed to make my entire point clear then. That's true.
But when someone does the oh fsck, I think I just ran a catastrophic
query on our
Good issue, I totally had the same concerns, so we built our own
system. As a side note we run an admin server which we use to
generate reports, run backups and so on - it takes load off the
production servers, where speed is critical. Recovery from backup
however is a whole other issue,
[ Note to list admin, you are blocking messages from gmail.com ]
MySQL List,
I have a large MySQL database (around 20 gigs in total, some tables
=3gigs. All tables are MyISAM. We have replication setup to a
number of slaves including one dedicated for backups.
All are running some semi-recent
(fkJobPosting, dtSnapShot, cJobTitle) VALUES
(211584,'2005-06-26',2) ON DUPLICATE KEY UPDATE cJobTitle=2
DBD::mysql::st execute failed: You have an error in your SQL syntax. Check
the manual that corresponds to your MySQL server version for the right
syntax to use near 'ON DUPLICATE KEY UPDATE cJobTitle
SQL syntax. error, and not those specified in this bug report.
This means the SQL parser failed to understand its query.
Regards,
Jocelyn
Hi Siegfried,
I think you've run into bug #8732:
...
Description:
if you do a INSERT INTO table (col_list) SELECT ... ON DUPLICATE KEY
UPDATE and
refer
Hi All,
trying to create a new user with the below,
GRANT ALL PRIVILEGES ON *samhain* TO 'samhain'@'localhost' IDENTIFIED BY
'passwd' WITH GRANT OPTION;
but, it gives a syntax error message. mysql version is 4.1.12. What is
wrong with the syntax.? Cheers.
Mark Sargent.
--
MySQL General
Hi,
trying to create a new user with the below,
GRANT ALL PRIVILEGES ON *samhain* TO 'samhain'@'localhost'
IDENTIFIED BY 'passwd' WITH GRANT OPTION;
That should be 'samhain.*', not '*samhain*'.
Regards,
Martijn
--
The information contained in this communication and any attachments is
Mark Sargent wrote:
Hi All,
trying to create a new user with the below,
GRANT ALL PRIVILEGES ON *samhain* TO 'samhain'@'localhost' IDENTIFIED BY
'passwd' WITH GRANT OPTION;
but, it gives a syntax error message. mysql version is 4.1.12. What is
wrong with the syntax.? Cheers.
Mark
PRIVILEGES ON *samhain* TO 'samhain'@'localhost' IDENTIFIED BY
'passwd' WITH GRANT OPTION;
but, it gives a syntax error message. mysql version is 4.1.12. What is
wrong with the syntax.? Cheers.
Mark Sargent.
--
For technical support contracts, goto https://order.mysql.com/?ref
.
But then it tells me I have a syntax error!
DBD::mysql::st execute failed: Duplicate entry '209689-2005-06-26' for key 1
at ./crawl-hot-jobs.pl line 675.
The primary key consists of two fields: fkJobPosting (integer) and
dtSnapshot (date).
Now if my SQL had a syntax error, would it not give me an error
INTO jobtitlecount (fkJobPosting, dtSnapShot, cJobTitle) VALUES
(209689,'2005-06-26',1)
This indicates success.
But then it tells me I have a syntax error!
DBD::mysql::st execute failed: Duplicate entry '209689-2005-06-26' for
key 1
at ./crawl-hot-jobs.pl line 675.
The primary key consists of two
line 675.
How could this be?
Now here is another example where I detect a duplicate and delete the
statement before trying to insert:
DELETE jobtitlecount WHERE dtSnapShot ='2005-06-26' AND fkJobPosting =
211151
DBD::mysql::st execute failed: You have an error in your SQL syntax. Check
the manual
::mysql::st execute failed: You have an error in your SQL syntax. Check
the manual that corresponds to your MySQL server version for the right
syntax to use near 'ON DUPLICATE KEY UPDATE cJobTitle=2' at line 1 at
./crawl-hot-jobs.pl line 675.
I'm looking at the documentation on
http://dev.mysql.com
Hi,
Are you using MySQL-4.1 ? (ON DUPLICATE KEY syntax has been introduced
in 4.1)
Regards,
Jocelyn
Siegfried Heintze wrote:
Thanks for deciphering that terrible message, Shawn. I accidentally must
have hit the paste key too many times.
Anyway, here is my new insert statement:
INSERT
code (not an edited version).
Now here is another example where I detect a duplicate and delete the
statement before trying to insert:
DELETE jobtitlecount WHERE dtSnapShot ='2005-06-26' AND fkJobPosting =
211151
DBD::mysql::st execute failed: You have an error in your SQL syntax. Check
I have two servers doing replication for logs. When I do extended insert
syntax on the master to combine multiple log entries, the slave complains
about duplicate primary key numbers, even though my inserts don't set the
primary key and the primary key is auto_increment.
So any time I use
servers doing replication for logs. When I do extended insert
syntax on the master to combine multiple log entries, the slave complains
about duplicate primary key numbers, even though my inserts don't set the
primary key and the primary key is auto_increment.
So any time I use extended insert
The inserts succeed on the master, so the problem isn't my SQL syntax. They
are legal extended inserts. It's just that the replication slave seems to
insert them out of order and screw up the auto-increment primary key.
- Original Message -
From: [EMAIL PROTECTED]
To: Jeremiah
see this for troubleshootings :
http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/Replication_Problems.html
hope that helps
Mathias
Selon Jeremiah Gowdy [EMAIL PROTECTED]:
The inserts succeed on the master, so the problem isn't my SQL syntax. They
are legal extended inserts. It's
Hello,
I am accustomed to Oracle query syntax, and I am having trouble with this
following query which uses the IN. I am running mysql ( Ver 12.21 Distrib
4.0.15, for Win95/Win98 (i32) ) which does not support the IN.
How do I rewrite the below query to function?
Basically what I have is three
Sorry, mysql doesn't support sub queries until version 4.1
-Eric
Scott Purcell wrote:
Hello,
I am accustomed to Oracle query syntax, and I am having trouble with this
following query which uses the IN. I am running mysql ( Ver 12.21 Distrib
4.0.15, for Win95/Win98 (i32) ) which does not support
Scott Purcell [EMAIL PROTECTED] wrote on 05/13/2005 12:05:05 PM:
Hello,
I am accustomed to Oracle query syntax, and I am having trouble with
this following query which uses the IN. I am running mysql ( Ver 12.
21 Distrib 4.0.15, for Win95/Win98 (i32) ) which does not support the
IN.
How
Is there any statement named create and complie java
source named .. syntax in the mysql for creation
of a java source file for loading data from java files
or retriving data etc .
Any help is welcome .
__
Do You Yahoo!?
Tired of spam
Hello.
Question 1: How do I check my syntax against the version and distribution
that I am
running?
In manual it is usually said which features are available as of which
version. Use the special form of comments to adopt your queries to
corresponding version. See:
http
: need help in syntax for create package or compile etc
Is there any statement named create and complie java
source named .. syntax in the mysql for creation
of a java source file for loading data from java files
or retriving data etc .
Any help is welcome
running: mysql Ver 12.22 Distrib 4.0.23, for Win95/Win98(i32) downloaded from
www.devside.net/web/servers/free/download.
When I run a script with the following commands I get sql syntax errors:
Create table 'test' ( 'helper' varchar(22) )
ENGINE=MYISAM DEFAULT CHARSET=latin1;
I get a sql
I'm used to doing something simple such as the following in sql server:
SELECT u.Username, p.UserID
FROM Users u LEFT JOIN
Person p ON u.UserID = p.UserID
However, I'm not seeing the same results in MySQL. I don't get all
the recs in the users table and NULLs in the userID
Rich Brant [EMAIL PROTECTED] wrote on 04/19/2005 03:05:51 PM:
I'm used to doing something simple such as the following in sql server:
SELECT u.Username, p.UserID
FROM Users u LEFT JOIN
Person p ON u.UserID = p.UserID
However, I'm not seeing the same results in MySQL.
Subject: Re: mysql syntax
Rich Brant [EMAIL PROTECTED] wrote on 04/19/2005 03:05:51 PM:
I'm used to doing something simple such as the following in sql server:
SELECT u.Username, p.UserID
FROM Users u LEFT JOIN
Person p ON u.UserID = p.UserID
However, I'm not seeing
, but is what I cant get to work in
mysql...
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 19, 2005 3:14 PM
To: Rich Brant
Cc: mysql@lists.mysql.com
Subject: Re: mysql syntax
Rich Brant [EMAIL PROTECTED] wrote on 04/19/2005 03:05:51
Rich Brant wrote:
I forgot the important part: what I want is to filter on a userID in the
person table such as -
SELECT u.Username, p.UserID
FROM Users u LEFT OUTER JOIN
Person p ON u.UserID = p.UserID
WHERE (p.UserID = 5) OR
(p.UserID
.
The following caused the same error of:
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'select max(length(testName)) from test)' at line 1
select testName from test where length(testName) = (select
max
.
The following caused the same error of:
ERROR 1064: You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL server version for the right syntax to
use near 'select max(length(testName)) from test)' at line 1
select testName from test where length(testName) = (select
max
- Original Message -
From: Daniel Kasak [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, March 30, 2005 11:24 PM
Subject: What's up with this syntax?
update
_cached_LinesNotTolling LNT inner join TelecomLinePosting TLP
on LNT.Line=TLP.Line
inner join
Hello.
Select syntax is correct on my 4.1.10a MySQL instance.
EXPLAIN is telling me 'Impossible WHERE' until I put
values in the tables so the query could produce at
least several rows. After that everything was OK.
Graham Anderson [EMAIL PROTECTED] wrote:
this sql works on mysql
)/1*12,
LNT.PhoneType=SitRepDesc,
MaxOfInvDate=InvDate
where
TAP.DanPK=41675
group by
TLP.Line
It's giving me:
You have an error in your SQL syntax. Check the manual that corresponds
to your MySQL server version for the right syntax to use near 'group
on TLP.LineType=PhoneTypes.ID
set
AnnualService=sum(TLP.Service)/1*12,
LNT.PhoneType=SitRepDesc,
MaxOfInvDate=InvDate
where
TAP.DanPK=41675
group by
TLP.Line
It's giving me:
You have an error in your SQL syntax. Check the manual
on TLP.LineType=PhoneTypes.ID
set
AnnualService=sum(TLP.Service)/1*12,
LNT.PhoneType=SitRepDesc,
MaxOfInvDate=InvDate
where
TAP.DanPK=41675
group by
TLP.Line
It's giving me:
You have an error in your SQL syntax. Check the manual
this sql works on mysql version 3.23.58...my remote server
SELECT c.City, r.Region, co.Country
FROM subnets s, cities c, regions r, countries co
WHERE c.CityId = s.CityId
AND c.RegionID = r.RegionID
AND c.CountryID = co.CountryId
AND s.SubNetAddress = '24.24.172'
LIMIT 0 , 30
but the same syntax
=cities.cityid?
JOIN regions on subnets.regionid=regions.regionid
JOIN countries on subnets.countryid=countries.countryid
where subnets.subnetaddress='24.24.172'
this gives a syntax error:
#1064 - You have an error in your SQL syntax near 'on
subnets.cityid=subnets.cityid
JOIN regions
subnets.subnetaddress='24.24.172'
this gives a syntax error:
#1064 - You have an error in your SQL syntax near 'on
subnets.cityid=subnets.cityid
JOIN regions on subnets.regionid=regions.regi' at line
all the tables seem proper named and populated.
what could this be ?
g
--
MySQL General Mailing List
Hello Users
does anyone know a tool or a way for validation sqlcode on the
command_line???
For example
./sqlsyntaxchecker select * f test
-- Error not valid sql syntax
thx christian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Is there any equivalent syntax similiar to dir /w /s for all *.doc to
insert into mysql database?
--
Power to people, Linux is here.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
://www.pantek.com/linux [EMAIL PROTECTED] |
/ One Hour Emergency Response (877) 546-8934 |
\___|
On Wed, 2 Mar 2005, Scott Hamm wrote:
Is there any equivalent syntax similiar to dir /w /s for all *.doc to
insert into mysql database?
--
MySQL
|
\___|
On Wed, 2 Mar 2005, Scott Hamm wrote:
Is there any equivalent syntax similiar to dir /w /s for all *.doc to
insert into mysql database?
--
Power to people, Linux is here.
--
MySQL General Mailing List
For list archives: http
. I also tried using the 'CASE .. WHEN .. THEN .. END' but couldn't figure out the syntax errors I was getting.
Thanks again for your help and support-
Sue
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Harald Fuchs wrote:
That's correct, but it can be written shorter and clearer:
CASE Lccation
WHEN 1 THEN 'Downstairs Cat Room'
WHEN 2 THEN 'Kitten Room'
WHEN 3 THEN 'Quarantine'
ELSE 'Unknown' END AS Location
- surely it would be better to have the location ids and location names
in a lookup
I want to test it again for another value... I
couldn't find any information about this construct in the manuals or
past list messages. I also tried using the 'CASE .. WHEN .. THEN ..
END' but couldn't figure out the syntax errors I was getting.
Thanks again for your help and support-
Sue
about this construct in the manuals or past list messages. I also
tried using the 'CASE .. WHEN .. THEN .. END' but couldn't figure out the
syntax errors I was getting.
Thanks again for your help and support-
Sue
to test it
again for another value... I couldn't find any
information about this construct in the manuals or
past list messages. I also tried using the 'CASE ..
WHEN .. THEN .. END' but couldn't figure out the
syntax errors I was getting.
Thanks again for your help and support-
Sue
Thomas Sundberg [EMAIL PROTECTED] wrote on 04/02/2005
11:39:12:
Hi!
I'm looking for the syntax diagram for MySQL and can't find it. I have
downloaded the entire MySQL manual as one html page and searched it for
the
definition of where_definition and I cant find it. Could somebody please
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: den 4 februari 2005 12:45
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: Syntax diagram, where is it located in the doc?
Thomas Sundberg [EMAIL PROTECTED] wrote
on 04/02/2005
11:39:12
: Thomas Sundberg [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, February 04, 2005 2:46 PM
Subject: RE: Syntax diagram, where is it located in the doc?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: den 4 februari 2005 12:45
To: [EMAIL
need this, someone could provide you with the answer you need.
Michael
Thomas Sundberg wrote:
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: den 4 februari 2005 12:45
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: Syntax diagram, where
Thomas Sundberg [EMAIL PROTECTED] wrote on 04/02/2005
12:46:02:
Does anybody at the list know the answer to my question? I
sent it a
few days ago and haven't received any response. It does
exist a syntax
diagram
for MySQL, doesn't it?
Since no-one replied to your first
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: den 4 februari 2005 14:19
To: Thomas Sundberg
Cc: mysql@lists.mysql.com
Subject: Re: Syntax diagram, where is it located in the doc?
From the manual, where_definition consists of the keyword
WHERE
clause. And if so, how should the syntax be written? That
Yes, you can use XOR in the where clause.
SELECT * FROM mytable WHERE col1 XOR col2;
This is not a bitwise XOR, it evaluates each column to true or false first
then evals the XOR.
example for an int column:
a | b | eval
0
xor in a
where
clause. And if so, how should the syntax be written? That would have
been
extremely simple if the syntax diagram started just above the quote you
supplied us with had been completed and not ended when things got a bit
interesting.
It would probably not have been very hepful
Hello.
May be it is not exactly what you want, but usually, I look at
the sql/sql_yacc.yy in a source distribution.
Thomas Sundberg [EMAIL PROTECTED] wrote:
Hi!
I'm looking for the syntax diagram for MySQL and can't find it. I have
downloaded the entire MySQL manual as one html
Thomas,
As you've discovered, MySQL documentation doesn't (yet) include a
syntax diagram, but there's a manual page for WHERE clauses, there's a
manual page for logical operators including XOR, and they show that the
answer to your question about WHERE clauses using XOR is 'yes', as does
Hi Thomas,
I'm looking for the syntax diagram for MySQL and can't find it. I have
Just to give you a complete answer to your question, this is what is
valid (I've stripped out the C code parts to leave just the definition):
where_clause:
/* empty */
| WHERE expr
expr: expr_expr
and I get Syntax error or access violation near (AnimalName, 1,1) FROM
Animal at Line 1. I can use the following with no error, so I know it has
to be in the SUBSTRING option:
SELECT AnimalName
FROM Animal
I also get a syntax error when I use an IF statement. I get the same error
on my home
Try SELECT SUBSTRING(AnimalName, 1, 1)
MySQL wants the ( to immediately follow the function i.e. no spaces.
-Original Message-
From: Sue Cram [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 03, 2005 9:28 AM
To: mysql@lists.mysql.com
Subject: Syntax Failures with SELECT SUBSTRING
Hi!
I'm looking for the syntax diagram for MySQL and can't find it. I have
downloaded the entire MySQL manual as one html page and searched it for the
definition of where_definition and I cant find it. Could somebody please
point me to a location where the complete syntax diagram can be found
Dear list,
My ColdFusion server tells me I have an error in my query syntax, but I
can't work out what it is - because I'm working with code that someone
very kindly gave me and I only have a vague idea of what the first
line's doing! Can anyone see the problem here?
SELECT DATEDIFF
Chris Kavanagh wrote:
My ColdFusion server tells me I have an error in my query syntax, but I
can't work out what it is - because I'm working with code that someone
very kindly gave me and I only have a vague idea of what the first
line's doing! Can anyone see the problem here?
SELECT
[snip]
My ColdFusion server tells me I have an error in my query syntax, but I
can't work out what it is - because I'm working with code that someone very
kindly gave me and I only have a vague idea of what the first line's doing!
Can anyone see the problem here?
SELECT DATEDIFF(leadtime_type
Thanks very much for the replies, guys. My version is 4.1.7-max.
The error message I get is:
--
Error Executing Database Query.
Syntax error or access violation: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near
I think datediff only takes two arguments and you have three listed.
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original Message-
From: Chris Kavanagh
Sent: Monday, January 31, 2005 5:33 PM
To: mysql@lists.mysql.com
Subject: Re: SQL syntax error: help a noob
On 31 Jan 2005, at 11:39 pm, Tom Crimmins wrote:
I think datediff only takes two arguments and you have three listed.
Nailed it! Thanks, Tom.
Best regards,
CK.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have a problem.
1064 - You have an error in your SQL syntax near '(((specials INNER JOIN
(products_to_categories INNER JOIN categories ON products' at line 2
SELECT DISTINCT specials.specials_id, products_to_categories.products_id,
categories.parent_id, products_description.products_name
.
Are the different machines all running the exact same version of MySQL?
Rhino
- Original Message -
From: Daniel Sousa [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, January 26, 2005 6:45 AM
Subject: error in your SQL syntax
I have a problem.
1064 - You have an error
have an error in your SQL syntax near '(((specials INNER
JOIN (products_to_categories INNER JOIN categories ON products' at line
2
SELECT DISTINCT specials.specials_id, products_to_categories.
products_id, categories.parent_id, products_description.
products_name, products.products_price
: error in your SQL syntax
Here is your original query, reformatted merely so that we humans can read it
better:
SELECT DISTINCT specials.specials_id
, products_to_categories.products_id
, categories.parent_id
, products_description.products_name
: error in your SQL syntax
Thanks, works fines.
I use access because i don´t know a GUI tool that make SQL
querys more easy.
Thanks all again,
Daniel Sousa
- Original Message -
From: [EMAIL PROTECTED]
To: Daniel Sousa
Cc: mysql@lists.mysql.com
Sent
Hi,
I am trying to get all field names from my table that begin with
letter X or Y, however the following statement and many variations I
have tried produce an error:
SHOW COLUMNS FROM TABLE LIKE X% OR LIKE Y%
Any help here would be much appreciated :)
--
MySQL General Mailing List
For list
shaun thornburgh wrote:
I am trying to get all field names from my table that begin with
letter X or Y, however the following statement and many variations I
have tried produce an error:
SHOW COLUMNS FROM TABLE LIKE X% OR LIKE Y%
According to the manual, the pattern for SHOW COLUMNS is:
SHOW
Hi,
I am trying to get all field names from my table that begin with letter X or
Y, however the following statement and many variations I have tried produce
an error:
SHOW COLUMNS FROM TABLE LIKE X% OR LIKE Y%
Any help here would be much appreciated :)
--
MySQL General Mailing List
For list
Hello,
Can somebody tell me from which version of MySQL is -
ALTER TABLECHANGE...
syntax supported.
Regards,
Karam
__
Do you Yahoo!?
Yahoo! Mail - Easier than ever with enhanced search. Learn more.
http://info.mail.yahoo.com/mail_250
Which version are you running. Quite often when you see a 'check the
version you are running' message indicates a syntax error in your mySQL
statement..
Andy
On Tue, 2005-01-11 at 05:13 -0800, Karam Chand wrote:
Hello,
Can somebody tell me from which version of MySQL is -
ALTER TABLE
are running' message indicates a syntax
error in your mySQL
statement..
Andy
On Tue, 2005-01-11 at 05:13 -0800, Karam Chand
wrote:
Hello,
Can somebody tell me from which version of MySQL
is -
ALTER TABLECHANGE...
syntax supported.
Regards,
Karam
Hello,
I plan to reorder some columns of my table. So I am
using ALTER TABLE STATEMENT .. with CHANGE syntax as
suggested at:
http://dev.mysql.com/doc/mysql/en/ALTER_TABLE_problems.html
I believe its the only way to reorder columns? Is
there something better?
If CHANGE is the best option
Hello.
Yes.
Karam Chand [EMAIL PROTECTED] wrote:
So if I use FLUSH MASTERS and FLUSH SLAVES, it will
have the same effect with new versions of MySQL too.
Karam
--- Gleb Paharenko [EMAIL PROTECTED] wrote:
Hello.
Also, from which version of MySQL LOCAL and
),
- Description BLOB,
- );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near ')' at line 10
mysql
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
, 2005 3:28 PM
Subject: weird syntax error
When I use 4.0 on windows I don't get this error but now that i'm using
4.1.x I'm getting error 1064 , is BLOB depricated or something ??? Please
help !
thanks in advance
===
Your MySQL connection id is 97
Hello.
Also, from which version of MySQL LOCAL and
NO_WRITE_TO_BINLOG options supported?
4.1.1
RESET MASTER and RESET SLAVE were named FLUSH MASTER and FLUSH SLAVES
before MySQL 3.23.26.
Karam Chand [EMAIL PROTECTED] wrote:
Hello,
From the MySQL docs:
So if I use FLUSH MASTERS and FLUSH SLAVES, it will
have the same effect with new versions of MySQL too.
Karam
--- Gleb Paharenko [EMAIL PROTECTED] wrote:
Hello.
Also, from which version of MySQL LOCAL and
NO_WRITE_TO_BINLOG options supported?
4.1.1
RESET MASTER and RESET SLAVE were
Hello,
From the MySQL docs:
http://dev.mysql.com/doc/mysql/en/FLUSH.html
What does FLUSH MASTER and FLUSH SLAVES does? Its not
documented?
Also, from which version of MySQL LOCAL and
NO_WRITE_TO_BINLOG options supported?
Regards,
Karam
__
Do
alone
and
they work fine. (e.g. if I enter a 5 after the equal sign, it works and if I
just
type the subquery alone, it returns the single number 5.)
So, why does mysql give me a syntax error?
---
SELECT personRoleDBNum FROM PersonRole
between two
upper tables, Person and Role. I have tested the
two pieces of the query alone and
they work fine. (e.g. if I enter a 5 after the
equal sign, it works and if I just
type the subquery alone, it returns the single
number 5.)
So, why does mysql give me a syntax error
syntax not working!
I have read through quite a bit of the MySQL manual concerning subqueries
and cannot
seem to get even the simplist of queries to work!
I have a table called PersonRole which is the many-to-many joint table
between two
upper tables, Person and Role. I have tested the two pieces
Hello,
I have problem with this syntax:
SELECT game_id FROM game WHERE game_id NOT IN (SELECT game_id FROM player WHERE
user_id!=$id_user)
I need select games where user is not connected. I have two tables
game(game_id, ) and player(player_id, game_id, user_id, ...). In table
player
I have problem with this syntax:
SELECT game_id FROM game WHERE game_id NOT IN (SELECT game_id FROM player
WHERE user_id!=$id_user)
I need select games where user is not connected. I have two tables
game(game_id, ) and player(player_id, game_id, user_id, ...). In table
player are many
and it runs fine. However the same query loaded into MySQL
Query Browser fails after the first line. Is there a way to structure
the syntax differently so I can run the multiple truncates in one query
via Qeury Browser?
Any advice is appreciated,
Eben
--
MySQL General Mailing List
For list archives
- Original Message -
From: kalin mintchev [EMAIL PROTECTED]
To: Adam [EMAIL PROTECTED]
Cc: MySQL General [EMAIL PROTECTED]
Sent: Sunday, November 14, 2004 11:33 PM
Subject: Re: syntax question..
Kalin,
Kalin thanks to all... yes, Rhino - i'm new. my first
Kalin post
I think you need to do something like this:
select t1.data
from table1 t1 inner join table2 t2 on t1.zip = t2.zip
where t2.chain like '%carmike%';
i tried this one... it seams to work. i'll read a bit more about joins ..
thank you... appreciate it...
You're welcome!
Rhino
--
hi everybody..
can somebody please explain what is wrong with this command:
select t1.data from table1 as t1 where t1.zip=(select * from table2 as t2
where t2.chain like %carmike%);
thank you...
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
November 2004 23:06
To: [EMAIL PROTECTED]
Subject: syntax question..
hi everybody..
can somebody please explain what is wrong with this command:
select t1.data from table1 as t1 where t1.zip=(select * from table2 as t2
where t2.chain like %carmike%);
thank you...
--
--
MySQL General
On Sunday 14 November 2004 05:05 pm, kalin mintchev wrote:
can somebody please explain what is wrong with this command:
select t1.data from table1 as t1 where t1.zip=(select * from table2 as t2
where t2.chain like %carmike%);
If your no usiing 4.1, subselects are not even allowed..
If so..
- Original Message -
From: kalin mintchev [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, November 14, 2004 6:05 PM
Subject: syntax question..
hi everybody..
can somebody please explain what is wrong with this command:
select t1.data from table1 as t1 where t1.zip=(select
201 - 300 of 991 matches
Mail list logo
