re: ERROR 1064 (42000): You have an error in your SQL syntax;

2006-06-07 Thread Chris Sansom
At 15:19 +0100 7/6/06, Rob Desbois wrote: With the CHANGE clause of ALTER TABLE statement, you must provide the column definition, so something like this is what you need: ALTER TABLE actors CHANGE director_id actor_id MEDIUMINT UNSIGNED NOT NULL; or whatever your original definition is. Wo

RE: ERROR 1064 (42000): You have an error in your SQL syntax;

2006-06-07 Thread J.R. Bullington
bject: ERROR 1064 (42000): You have an error in your SQL syntax; Hi All, gee I really hate bugging you all for this. I looked at this page, http://dev.mysql.com/doc/refman/5.0/en/alter-table.html which has this, To change column |a| from |INTEGER| to |TINYINT NOT NULL| (leaving the name the

re: ERROR 1064 (42000): You have an error in your SQL syntax;

2006-06-07 Thread Rob Desbois
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 1 Sorry, little confused right about now, eh. Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: h

Re: ERROR 1064 (42000): You have an error in your SQL syntax;

2006-06-07 Thread Chris Sansom
At 0:09 +1000 8/6/06, Mark Sargent wrote: ALTER TABLE t2 MODIFY a TINYINT NOT NULL, CHANGE b c CHAR(20); for changing the name of a column, right? So, why doesn't the below work? mysql> ALTER TABLE actors CHANGE director_id actor_id; I'm no great expert myself, but off the top of my head, may

ERROR 1064 (42000): You have an error in your SQL syntax;

2006-06-07 Thread Mark Sargent
well as renaming it from |b| to |c|: ALTER TABLE t2 MODIFY a TINYINT NOT NULL, CHANGE b c CHAR(20); for changing the name of a column, right? So, why doesn't the below work? mysql> ALTER TABLE actors CHANGE director_id actor_id; I get this, ERROR 1064 (42000): You have an error in

Re: ERROR 1064: You have an error in your SQL syntax....

2005-04-08 Thread Peter Brawley
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)

ERROR 1064: You have an error in your SQL syntax....

2005-04-08 Thread Chuzo Okuda
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) = (s

RE: error in your SQL syntax

2005-01-26 Thread Artem Koltsov
lists.mysql.com > Subject: Re: 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:

Re: error in your SQL syntax

2005-01-26 Thread Daniel Sousa
: 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

Re: error in your SQL syntax

2005-01-26 Thread SGreen
ROTECTED]> wrote on 01/26/2005 06:45:32 AM: > 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, prod

Re: error in your SQL syntax

2005-01-26 Thread Rhino
ch machine. Are the different machines all running the exact same version of MySQL? Rhino - Original Message - From: "Daniel Sousa" <[EMAIL PROTECTED]> To: Sent: Wednesday, January 26, 2005 6:45 AM Subject: error in your SQL syntax I have a problem. 1064 - You have a

error in your SQL syntax

2005-01-26 Thread Daniel Sousa
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.pro

Re: error in your SQL syntax near 'order by 'Variable_name' ????

2001-10-01 Thread Benjamin Pflugmann
: > > MySQL said: You have an error in your SQL syntax near 'order by 'Value' ASC' > at line 1 This means that the clicking produced an invalid SQL command. Seemingly it wanted to run show variables order by 'Value' ASC which is no valid command (SHOW VARI

Re: error in your SQL syntax near 'order by 'Variable_name' ????

2001-10-01 Thread Emailit2
messing around with the control panel on my website and went to MySQL database. I clicked on: Show MySQL system variables. Then I could click on: Variable_name, or Value both give me this: MySQL said: You have an error in your SQL syntax near 'order by 'Value' ASC' at line

Re: error in your SQL syntax near 'order by 'Variable_name' ????

2001-10-01 Thread Rodney Broom
From: <[EMAIL PROTECTED]> > MySQL said: You have an error in your SQL syntax near 'order by > 'Variable_name' ASC' at line 1 > > Any ideas as to what this means, and how to fix it? Hi Dave, How 'bout sending us the entire SQL statement, pleas

error in your SQL syntax near 'order by 'Variable_name' ????

2001-10-01 Thread Emailit2
Hi, MySQL said: You have an error in your SQL syntax near 'order by 'Variable_name' ASC' at line 1 Any ideas as to what this means, and how to fix it? Thanks, Dave - Before posting, please check: