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
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
-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
- 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
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
|
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
6 matches
Mail list logo