SELECT INTO problem!Pomoc hitno!!!!

[ _Punisher_ @ 19.04.2005. 22:20 ] @

zasto ovo ne radi

Code:
SELECT * INTO `backup` FROM `nuke_artikli_arhiva`

To sam nasao na svim sajtovima koje sam nasao preko googla.

Dobijam sledecu gresku

Code:
MySQL said:
#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 'backup` FROM `nuke_artikli_arhiva` LIMIT 0, 30' at line 1

Sta je problem

[ ivan jeremic @ 20.04.2005. 14:59 ] @

Nema ti to MySQL ... to si pokupio sa nekog drugog servera? Recimo MSSQL .... Ovamo koristi create table evo ti primer sintakse :
CREATE TABLE foo (a TINYINT NOT NULL) SELECT b+1 AS a FROM bar;
BTW ... nemoj da koristis "select into" nikada kada bash nemorash.

[ caiser @ 20.04.2005. 16:07 ] @

http://dev.mysql.com/doc/mysql/en/insert-select.html