Re: SQL for Access vs MySQL

2007-03-06 Thread Jochem van Dieten
Jim Wright wrote: > Pete wrote: >> >> They have a piece of code: >> >> select * >> into visaudactvols >> from visualauditrecs > > I don't believe MySQL supports this use of INTO. You can use: > INSERT INTO visaudactvols(somecolumn) > SELECT somecolumn FROM visualauditrecs > > but the table will

Re: SQL for Access vs MySQL

2007-03-06 Thread Jim Wright
Pete wrote: > Hi > > Hoping someone might be able to assist - its 4am and I have just been called > by a client coz their system crashed. They have just moved from using an > Access DB to MySQL. > > They have a piece of code: > > select * > into visaudactvols > from visualauditrecs > I don't

RE: SQL for Access vs MySQL

2007-03-06 Thread Ben Forta
-into-table.html --- Ben -Original Message- From: Pete [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 06, 2007 1:23 PM To: CF-Talk Subject: SQL for Access vs MySQL Hi Hoping someone might be able to assist - its 4am and I have just been called by a client coz their system crashed. They have

Re: SQL for Access vs MySQL

2007-03-06 Thread Josh Nathanson
- Original Message - From: "Pete" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Tuesday, March 06, 2007 10:23 AM Subject: SQL for Access vs MySQL > Hi > > Hoping someone might be able to assist - its 4am and I have just been > called > by a client coz their

RE: SQL for Access vs MySQL

2007-03-06 Thread Ian Skinner
Are you sure your Mysql DBMS understands the 'INTO' SQL command. I have not seen that used much and do not know how universal it is among database systems. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Sudoku |

SQL for Access vs MySQL

2007-03-06 Thread Pete
Hi Hoping someone might be able to assist - its 4am and I have just been called by a client coz their system crashed. They have just moved from using an Access DB to MySQL. They have a piece of code: select * into visaudactvols from visualauditrecs The error says Undeclared variable: visaudact