Re: sql syntax error

Hi, Le 08/08/2014 17:48, Johan De Meersman a écrit : > > As your code is french, I'll assume you're on Azerty; the backtick is Alt-Gr > plus the rightmost key (right next to return) on the middle row. Enjoy > spraining your fingers :-p > > /johan > Alt-GR plus '7' for French keyboard layout

Re: sql syntax error

- Original Message - > From: "florent larose" > Subject: sql syntax error > > near ''membres2' WHERE > [...] > FROM 'espace_membre2'.'membres2' WHERE You were on the right path - mysql is wibbly about quotes. Either

sql syntax error

hello, i am working on my personal website wih php 5.4.16 / mysql 5.6.12 (my system : windows 7 / wampserver 2). i have a bug when i am running my connection to database webpage. My error message is the following : Erreur SQL : You have an error in your SQL syntax; check the manual that correspon

Re: alter table modify syntax error

> From: Tim Dunphy [mailto:bluethu...@gmail.com] > > Sent: Sunday, 29 June 2014 10:09 > > To: Jesper Wisborg Krogh > > Cc: mysql@lists.mysql.com > > Subject: Re: alter table modify syntax error > > > > > > > > The syntax "sixth" is

RE: alter table modify syntax error

Hi Tim, > -Original Message- > From: Tim Dunphy [mailto:bluethu...@gmail.com] > Sent: Sunday, 29 June 2014 10:09 > To: Jesper Wisborg Krogh > Cc: mysql@lists.mysql.com > Subject: Re: alter table modify syntax error > > > > > The syntax "sixth"

Re: alter table modify syntax error

M, Jesper Wisborg Krogh wrote: > Hi Tim, > > > -Original Message- > > From: Tim Dunphy [mailto:bluethu...@gmail.com] > > Sent: Sunday, 29 June 2014 03:45 > > Cc: mysql@lists.mysql.com > > Subject: Re: alter table modify syntax error > > > > Hey guys

RE: alter table modify syntax error

Hi Tim, > -Original Message- > From: Tim Dunphy [mailto:bluethu...@gmail.com] > Sent: Sunday, 29 June 2014 03:45 > Cc: mysql@lists.mysql.com > Subject: Re: alter table modify syntax error > > Hey guys, > > Sorry to hit you with one more. But I'm tryi

Re: alter table modify syntax error

Hey guys, Sorry to hit you with one more. But I'm trying to use a positional statement in a column move based on what you all just taught me: mysql> alter table modify column color varchar(10) sixth; But I am getting this error: ERROR 1064 (42000): You have an error in your SQL syntax; check t

Re: alter table modify syntax error

Cool guys, that did it.. ALTER TABLE car_table MODIFY COLUMN color VARCHAR(10) AFTER model; For some reason the book I'm following doesn't specify that you have to note the data type in moves! This helped. and thanks again. Tim On Sat, Jun 28, 2014 at 1:24 PM, Carsten Pedersen wrote: > On 28

Re: alter table modify syntax error

On 28-06-2014 19:11, Tim Dunphy wrote: Hello, I'm trying to use a very basic alter table command to position a column after another column. This is the table as it exists now: mysql> describe car_table; +-+--+--+-+-++ | Field | Type | Null |

alter table modify syntax error

Hello, I'm trying to use a very basic alter table command to position a column after another column. This is the table as it exists now: mysql> describe car_table; +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--

Re: stored procedure syntax error

I think, you have to use prepare() before run that select statement. i.e SET @s = CONCAT("SELECT * INTO OUTFILE", c ,"FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM cells_summary WHERE PMMDATEANDTIME=b"); PREPARE stmt FROM @s; EXECUTE stmt; regards, nilnandan

stored procedure syntax error

Hi all ! I m getting an error while writing stored procedure, the code is as below and error CODE -- DELIMITER $$ DROP PROCEDURE IF EXISTS `aaa` $$ CREATE definer=`ro...@`%

Re: LOAD DATA INFILE Syntax error

Johnny Withers schrieb: Group is a keyword in mysql: You need to put backticks around it in your statement: | LOAD DATA INFILE 'test.csv' INTO TABLE table | FIELDS TERMINATED BY ',' | LINES STARTING BY '' TERMINATED BY '\n' | (Page, Device, `GROUP` , ItemID, Item, Value); Ooookay. Thank

Re: LOAD DATA INFILE Syntax error

Group is a keyword in mysql: You need to put backticks around it in your statement: | LOAD DATA INFILE 'test.csv' INTO TABLE table | FIELDS TERMINATED BY ',' | LINES STARTING BY '' TERMINATED BY '\n' | (Page, Device, `GROUP` , ItemID, Item, Value); On Mon, Jun 29, 2009 at 7:07 AM, Ralph K

LOAD DATA INFILE Syntax error

Hallo List! I have a CVS file which i would like to import to MySQL. The file header and an example: | Page,Device,Group,ItemID,Item,Value | Overview,General,Computer,513,OS,Linux The table has: | Create Table: CREATE TABLE `table` ( | `ID` int(11) NOT NULL auto_increment, | `Page` varch

Re: SOS mysql signal syntax error

kat...@gmail.com] > Sent: Wednesday, May 20, 2009 10:58 AM > To: mysql > Subject: SOS mysql signal syntax error > > Hi Folks, > > I am getting syntax error with the mysql signal. I have a trigger > that needs a signal for raising an error condition if a row with > specific v

RE: SOS mysql signal syntax error

l Message- From: Alex Katebi [mailto:alex.kat...@gmail.com] Sent: Wednesday, May 20, 2009 10:58 AM To: mysql Subject: SOS mysql signal syntax error Hi Folks, I am getting syntax error with the mysql signal. I have a trigger that needs a signal for raising an error condition if a row with s

SOS mysql signal syntax error

Hi Folks, I am getting syntax error with the mysql signal. I have a trigger that needs a signal for raising an error condition if a row with specific value is removed. CREATE TRIGGER my_trig BEFORE DELETE ON my_tbl FOR EACH ROW BEGIN DECLARE mysig CONDITION FOR SQLSTATE '

Re: Now() : SQL syntax error. But why?

Always echo out your SQL string, it will make it a lot more obvious. You want to see the result. I php concatenated string can be confusing at times. Also, you are not escaping your data, so if you had a word of 'stops, here' that would break it as well. So in your case, you very well m

Re: Now() : SQL syntax error. But why?

Thanks, Scott. I thought I couldn't have missed ','(comma) before. But today somehow it works... ;; I wasted hours figuring this out, but you saved me! Maybe I'm still a complete newbie! Thanks, again. Have a great day. :) On Thu, Apr 30, 2009 at 12:52 PM, Scott Haneda wrote: > > On Apr 29,

Re: Now() : SQL syntax error. But why?

On Apr 29, 2009, at 11:29 AM, Antonio PHP wrote: This is MySQL data structure. - I underlined where it causes the error message. (datetime) `id_Company` smallint(6) unsigned NOT NULL AUTO_INCREMENT, `Name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL `Revenue` mediumint(6) NO

Re: Now() : SQL syntax error. But why?

Thanks. NOW() and php date(); work for my newly created test tables, but it doesn't work for my working table. I can't insert date, time or now() into my old table (which is as below). For now, I'm using MySQL auto timestamp ('Updated' field), but I need to insert date when the data was created!

Re: Now() : SQL syntax error. But why?

We need to see your entire query and the table structure. timestamp fields can have options set to auto update them, where order matters, and only one field can support that feature. Please supply more data. On Apr 28, 2009, at 2:18 PM, Antonio PHP wrote: You have an error in your SQL synt

Re: Now() : SQL syntax error. But why?

Can you please give the full table structure and query? On Tue, Apr 28, 2009 at 23:18, Antonio PHP wrote: > 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 'Created = NOW(), > Updated = NOW()' at line 8 > > 'C

Now() : SQL syntax error. But why?

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 'Created = NOW(), Updated = NOW()' at line 8 'Created' and 'Updated' are set to datetime (InnoDB). The same syntax works for some newly created tables... and gives

Re: Creating table syntax error with mysql 5.0!

mysql> CREATE TABLE memberDetails -> *(* ->memberId INT NOT NULL AUTO_INCREMENT, ->PRIMARY KEY(memberId), ->first_name varchar(100), ->last_name varchar(100), ->Email varchar(60), ->phoneNum varchar(25) -> *);* Works withou

Creating table syntax error with mysql 5.0!

I'm new with MySQL server 5.0 ,I tried to create a table MemberDetails from the mysql command shell, I got an error 1064 (42000): *You have an error in your SQL syntax*; Here is my code: mysql> CREATE TABLE memberDetails -> *(* ->memberId INT NOT NULL AUTO_INCREMENT, ->

Re: Syntax Error in Stored Procedure

Thanks. That fixed the problem. I put all of my DECLARE statements at the beginning of the procedure. I finally got the thing to compile and it looks like this: DELIMITER $$ DROP PROCEDURE IF EXISTS `code_library`.`Search_Code_Samples` $$ CREATE [EMAIL PROTECTED] PROCEDURE `Search_Code_Sampl

RE: Syntax Error in Stored Procedure

Information Technology 1700 Pratt Drive Blacksburg, VA 24060 Email: [EMAIL PROTECTED] Phone: (540) 231-4396 -Original Message- From: Tom Khoury [mailto:[EMAIL PROTECTED] Sent: Monday, August 13, 2007 2:38 PM To: mysql@lists.mysql.com Subject: Syntax Error in Stored Procedure Below is a

Syntax Error in Stored Procedure

nt. 106:PREPARE search_statement FROM Final_SQL; 107:EXECUTE search_statement; 108:END; $$ When attempting to compile this procedure I get this error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to u

Re: Syntax error

.date DESC , o.status, u.username LIMIT 0 , 30 -- View this message in context: http://www.nabble.com/Syntax-error-tf2938979.html#a8216881 Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Syntax error

LIMIT 0, 30' at line 5 I've test it without the SUM() and GROUP BY so I know its my aggregate function that is doing it. Like I said - pretty rusty. -- View this message in context: http://www.nabble.com/Syntax-error-tf2938979.html#a8216800 Sent from the MySQL - General mailing l

Re: Syntax Error

Hi Mark. On Fri, 7 Apr 2006, Mark Sargent wrote: > To: mysql@lists.mysql.com > From: Mark Sargent <[EMAIL PROTECTED]> > Subject: Syntax Error > > Hi All, > > am trying to get up to speed on cli syntax again, > > mysql> show open tables from osc > ->

Re: Syntax Error

Hi All, Ah, sorry, a semicolon makes it a whole new world, eh. Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Syntax Error

Hi All, am trying to get up to speed on cli syntax again, mysql> show open tables from osc -> what is wrong with the command above and the one below, mysql> show tables from osc -> Why do I not get any output? I was following here, http://dev.mysql.com/doc/refman/5.1/en/show-open-table

Re: // confusing syntax error when importing //

How did you try to do it on the remote system? I copied and pasted your query to a server running MySQL 4.1.12-standard-log, and another running MySQL 5.0.19-standard-log, and they both created the table just fine. Have you tried copying and pasting the table creation itself to see if that works?

// confusing syntax error when importing //

--apologies if you receive this email from another account-- hi, i exported a *.sql using phpMyAdmin on a system running: mysql Ver 14.12 Distrib 5.0.19, for pc-linux-gnu (i486) using readline 5.1 i'm trying to import it from this localhost to a remote host running:

Re: an backup syntax error

wangxu wrote: >Follow is my preform and result: >- >mysql> backup table ht_detail to '/'; >+++--+--+ >| Table | Op | Msg_type | Msg_text

RE: an backup syntax error

--- -Original Message- From: wangxu [mailto:[EMAIL PROTECTED] Sent: Thursday, 5 January 2006 1:29 PM To: mysql@lists.mysql.com Subject: an backup syntax error Follow is my preform and result: - mysql

an backup syntax error

Follow is my preform and result: - mysql> backup table ht_detail to '/'; +++--+--+ | Table | Op | Msg_type | Msg_text | +-

Re: LOAD DATA INFILE Syntax Error

Okay, now I get it. I was using the 4.1 series. Looks like an upgrade is in order. Jason On 9/26/05, Jasper Bryant-Greene <[EMAIL PROTECTED]> wrote: > > Robert L Cochran wrote: > > http://mirror.tomato.it/mysql/doc/mysql/en/load-data.html > > There's a lot to read there for one small paragraph, s

Re: LOAD DATA INFILE Syntax Error

I've been over that page before posting, with no luck. It might be an obvious error in syntax, but I can't figure it out. Jason On 9/26/05, Robert L Cochran <[EMAIL PROTECTED]> wrote: > > http://mirror.tomato.it/mysql/doc/mysql/en/load-data.html > > Bob Cochran > > > Jason Ferguson wrote: > > >I

Re: LOAD DATA INFILE Syntax Error

Robert L Cochran wrote: http://mirror.tomato.it/mysql/doc/mysql/en/load-data.html There's a lot to read there for one small paragraph, so from the above link: "Before MySQL 5.0.3, the column list must contain only names of columns in the table being loaded, and the SET clause is not supporte

Re: LOAD DATA INFILE Syntax Error

http://mirror.tomato.it/mysql/doc/mysql/en/load-data.html Bob Cochran Jason Ferguson wrote: I am attempting to import a large file with data in this format: 1923158|GA|1996 Olympic Yachting Cauldron|park|Chatham|13|051 |320446N|0810502W|32.07944|- 81.08389Savannah With this command:

LOAD DATA INFILE Syntax Error

I am attempting to import a large file with data in this format: 1923158|GA|1996 Olympic Yachting Cauldron|park|Chatham|13|051 |320446N|0810502W|32.07944|- 81.08389Savannah With this command: LOAD DATA LOCAL INFILE 'C:\\PHP\\FL_DECI.txt' INTO TABLE locations2 FIELDS TERMINATED BY '|' LINE

RE: Where exists query syntax error?

:[EMAIL PROTECTED] > Sent: Friday, September 02, 2005 11:48 AM > To: Barbara Deaton > Cc: mysql@lists.mysql.com > Subject: Re: Where exists query syntax error? > > > > > "Barbara Deaton" <[EMAIL PROTECTED]> wrote on 09/02/2005 11:33:19 AM: > > &g

RE: Where exists query syntax error?

: Where exists query syntax error? "Barbara Deaton" <[EMAIL PROTECTED]> wrote on 09/02/2005 11:33:19 AM: > I need help re-writing a query. > > When accessing DB2 I can execute the below: > delete from DM_KOHLS.clr_plan_price_change_metrics A &g

Re: Where exists query syntax error?

005' ) and > exists ( select * from SESSION.delete_table_tmp B >where A.clr_plan_sk = B.clr_plan_sk) > > > I modified it to be what I thought was a valid MySQL statement but > when I execute it against MySQL I get a syntax e

Where exists query syntax error?

t was a valid MySQL statement but when I execute it against MySQL I get a syntax error: ERROR: Execute error: 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 'exists ( select * from dele

Re: Grant Syntax Error.?

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. &

Re: Grant Syntax Error.?

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 wi

RE: Grant Syntax Error.?

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

Grant Syntax Error.?

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. M

Re: Newbie: mysql syntax error question

ityid=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.cit

Newbie: mysql syntax error question

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 Gene

SOLVED: 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]

RE: SQL syntax error: help a noob

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

Re: SQL syntax error: help a noob

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 syn

RE: SQL syntax error: help a noob

[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, GET

Re: SQL syntax error: help a noob

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 DATEDIFF

SQL syntax error: help a noob

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(leadtime_t

Re: weird syntax error

07, 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 >

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 to server version: 4.1.8-standard Type 'help;'

Re:[SOLVED] SQL syntax error

--- Jim Winstead <[EMAIL PROTECTED]> wrote: > My point was that you can't compare a column with an > array > of numbers using the '=' operator. You have to use > the IN > operator, as in the line of code I posted: Thank you Jim , it's working now! Stuart -- MySQL General Mailing List For li

Re: SQL syntax error

On Sat, Nov 13, 2004 at 12:46:12PM -0800, Stuart Felenstein wrote: > > --- Jim Winstead <[EMAIL PROTECTED]> wrote: > > > You can't compare a column with a comma-delimited > > list of numbers like > > that... > > What should the seperator be then ? My point was that you can't compare a colum

Re: SQL syntax error

--- Jim Winstead <[EMAIL PROTECTED]> wrote: > You can't compare a column with a comma-delimited > list of numbers like > that... What should the seperator be then ? Thank you Stuart -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://li

Re: SQL syntax error

On Sat, Nov 13, 2004 at 12:30:43PM -0800, Stuart Felenstein wrote: > $sql = "SELECT PostStart, JobTitle, Industry, > LocationState, VendorID > FROM VendorJobs"; > echo $sql; > //if ($Ind) > $sql .= "WHERE VendorJobs.Industry = $s_Ind"; > > As you can see above s_ind is an array , comma > d

SQL syntax error

I've had this going over on the php-general list. Thought I would throw it out here . Running PHP 4.0.22 Keep getting this error - SELECT PostStart, JobTitle, Industry, LocationState, VendorID FROM VendorJobsSELECT PostStart, JobTitle, Industry, LocationState, VendorID FROM VendorJobsWHERE Vendo

Re: deleting from multiple tables syntax error

Turns out to be 4.1.7 This suggestion fixed my query, thanks. I'd tried that approach yesterday, but it was on an older version of MySQL (on our non-production server; I wasn't paying attention to the versions of MySQL betw. our test and production servers) - so my previous attempts with this syn

Re: deleting from multiple tables syntax error

Did you upgrade to 4.0.17 or 4.1.7? In 4.1, you have to use the alias between FROM and USING: DELETE FROM rls USING rsrc_linx_specialty rls,... This is documented at the bottom of the manual page you referenced. Michael [EMAIL PROTECTED] wrote: I had a working query that suddenly doesn't work

deleting from multiple tables syntax error

I had a working query that suddenly doesn't work anymore. It follows the syntax found in the documentation at http://dev.mysql.com/doc/mysql/en/DELETE.html specifically, DELETE FROM t1, t2 USING t1, t2, t3 WHERE t1.id=t2.id AND t2.id=t3.id; my query is: DELETE FROM rsrc_linx_specialty USING rsrc_

Re: MySQL -- SQL syntax error.....

com> cc: Fax to: 06/16/200

RE: MySQL -- SQL syntax error.....

From: Scott Fletcher [mailto:[EMAIL PROTECTED] > When I use this SQL statement, ... > > --snip-- > UPDATE BUSINESS_CATEGORY SET > (BUSINESS_CATEGORY.BUS_CAT,BUSINESS_CATEGORY.BUS_DESC) = > ('JUNKKK','JUNK123KK') WHERE BUSINESS_CATEGORY.BUS_CAT_ID = '73

MySQL -- SQL syntax error.....

When I use this SQL statement, ... --snip-- UPDATE BUSINESS_CATEGORY SET (BUSINESS_CATEGORY.BUS_CAT,BUSINESS_CATEGORY.BUS_DESC) = ('JUNKKK','JUNK123KK') WHERE BUSINESS_CATEGORY.BUS_CAT_ID = '733788' --snip-- I get the SQL syntax error saying, --snip-- You ha

syntax error

I want to do something like this: delete from records where records.id in (select audit_log_records.id from audit_log_records, audit_log where audit_log.tracker_id=audit_log_records.tracker_id and audit_log.operation='D'); -- MySQL General Mailing List For list archives: http://lists.mysql.com/

Re: Error 1064 (Syntax error) after adding ENUM or Set types to table definition

e from my current DB to make adjustments and also migrate to Innodb tables. In the process I have tried to add some ENUM types in select table. Obviously, I am doing something wrong as each one give me a syntax error 1064 when I try to source in the text file. I've read the manual and do not s

Error 1064 (Syntax error) after adding ENUM or Set types to table definition

I created the dump file from my current DB to make adjustments and also migrate to Innodb tables. In the process I have tried to add some ENUM types in select table. Obviously, I am doing something wrong as each one give me a syntax error 1064 when I try to source in the text file. I've

sql syntax error

r/local/sbin/amavisd debug Error in config file /etc/amavisd.conf: syntax error at /etc/amavisd.conf line 829, near "' ORDER BY users.priority DESC ';" Here are the lines from my /etc/amavisd.conf file: $sql_select_policy = 'SELECT *,users.vuid FROM users,policy_names&#

Re: syntax error on create

"warwick mayson" <[EMAIL PROTECTED]> wrote: > > I am new to mysql and have a create script that when sourced throws a syntax error. > > The script : > > CREATE TABLE employee ( > id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, > name VARCHAR(255) NOT NU

syntax error on create

hi I am new to mysql and have a create script that when sourced throws a syntax error. The script : CREATE TABLE employee ( id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL, PRIMARY KEY(id) ) TYPE=InnoDB; CREATE TABLE position ( id INTEGER UNSIGNED NOT NULL

Re: How to diagnose MySQL syntax error

Ken Elder writes: >Today I experimented on two computers. One consistently got the error >message; the other consistently did not get the error message. Both >computers were Win98SE with IE6.0. Their Win 98 and IE settings were >identical (except for trivial stuff like home page and mouse contro

How to diagnose MySQL syntax error

SQL gurus: A few days ago we went live with a PHP/MySQL site. One of the pages requires entry of a username and password. If a corresponding record is found in the password table, the next page appears. The authentication technique we used was a session variable. For most users, but not all, t

Re: subqurey syntax error

subqueries are introduced in 4.1 only - Original Message - From: "Emmanuel Ohannessian" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, January 26, 2004 12:10 PM Subject: subqurey syntax error > I am getting the error message: > > mysql

subqurey syntax error

I am getting the error message: mysql> SELECT s1 FROM t1 WHERE s1 IN(SELECT s1 FROM t2); ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp onds to your MySQL server version for the right syntax to use near 'SELECT s1 FR OM t2)' at line 1 mysql> I am using M

Re: "Interval ... week" produces syntax error.

At 01:20 PM 1/22/2004, Paul DuBois wrote: At 10:49 -0600 1/22/04, mos wrote: I'm using MySQL 4.1.1 for NT and noticed the following select date_sub('2003-08-29', interval 21 week) produces a syntax error. It doesn't recognize "week" or "quarter". But I c

Re: "Interval ... week" produces syntax error.

At 10:49 -0600 1/22/04, mos wrote: I'm using MySQL 4.1.1 for NT and noticed the following select date_sub('2003-08-29', interval 21 week) produces a syntax error. It doesn't recognize "week" or "quarter". But I can substitute "day", "month&

"Interval ... week" produces syntax error.

I'm using MySQL 4.1.1 for NT and noticed the following select date_sub('2003-08-29', interval 21 week) produces a syntax error. It doesn't recognize "week" or "quarter". But I can substitute "day", "month", "year" and

Re: SQL syntax error

Hi Asif, Asif Iqbal wrote: I have been pushing my syslogs to the following mysql table However whenever it sees lines with a ' (apostrophe) it complains about SQL syntax You need to escape those reserved characters, i.e. have ' replaced by \' because otherwise mysql will treat the apostrophe as

SQL syntax error

Hi All I have been pushing my syslogs to the following mysql table However whenever it sees lines with a ' (apostrophe) it complains about SQL syntax Here are two lines with ' from my syslog: Jan 1 03:58:15 dal-svcs-02.inet.qwest.net 203: *Jan 1 08:58:13.926 UTC: %PFINIT-SP-5-CONFIG_SYNC: Syn

[syntax error in configure and configure.in]

>Description: configure contains the lines compile_readline= no compile_libedit= no which causes a message ./configure: line xxx: no: command not found unless you happen to have a program named "no" in your path. >How-To-Repeat: ./confi

RE: Inserting HTML page to TEXT fails... syntax error?! (Python MySQLdb)

> -Original Message- > From: Paul DuBois [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 17, 2003 9:38 PM > To: Nick Arnett; [EMAIL PROTECTED] Well, Paul, just knowing you were on the job inspired me and I finally realized the dumb thing I'd done. The list I'm iterating, urls, comes from

Re: Inserting HTML page to TEXT fails... syntax error?! (Python MySQLdb)

1' WHERE url = %s",(url,)) It's retrieving the document just fine, resulting in a big ol' string (it really is a string, I checked), but that string just won't go into the database. rss_article is a TEXT column in a MyISAM table. I get an SQL syntax error and MySQL tells me

Inserting HTML page to TEXT fails... syntax error?! (Python MySQLdb)

retrieving the document just fine, resulting in a big ol' string (it really is a string, I checked), but that string just won't go into the database. rss_article is a TEXT column in a MyISAM table. I get an SQL syntax error and MySQL tells me to check the syntax with a snippet from ri

RE: SQL Query Syntax Error

Trevor Sather wrote: > Hello > > The following query used to work when I was using an Access database, > but now that I've moved to MySQL I get a syntax error when I try and > run it: > > SELECT *, (SELECT COUNT (*) > FROM Links > WHERE Links.CAT_ID = Categories

SQL Query Syntax Error

Hello The following query used to work when I was using an Access database, but now that I've moved to MySQL I get a syntax error when I try and run it: SELECT *, (SELECT COUNT (*) FROM Links WHERE Links.CAT_ID = Categories.CAT_ID AND LINK_APPROVED = 'Yes') AS LINK_COUNT FROM C

Re: SELECT MIN(order), MAX(order) SYNTAX ERROR

esn't work and gives me a SYNTAX ERROR. If I use my 'id' column (the primary key) instead of the 'order' column, it works fine: mysql_query("SELECT MIN(id), MAX(id) FROM downloads WHERE class='1'"); My columns are defined as follows: CREATE TABLE downl

SELECT MIN(order), MAX(order) SYNTAX ERROR

Hi... silly question maybe. I want to execute the following query: mysql_query("SELECT MIN(order), MAX(order) FROM downloads WHERE class='1'"); ...but it doesn't work and gives me a SYNTAX ERROR. If I use my 'id' column (the primary key) instead o

RE: Import Batch syntax error

Gerald R. Jensen wrote: > I just ran your query (create and both inserts), and it > worked like a charm on a Win32 MySQL 3.23.52. > > Just out of curiousity, why are putting the \r in? > Gerald (and all who were interested), I didn't put the \r in, actually...mysqldump did. The solution to the

Re[6]: Import Batch syntax error

Tab, >> file). Anyway, it can't help to try the following: >> C:\mysql\bin>>mysql --max-allowed-packet=32M < \dev_hotel_data.sql > Thanks, I'll try that... But in the meantime, is there something I can > do to get Mysql to show me more information about

  1   2   >