select_into_from

[Sia]

please could not you help with syntax:

I try to use this:

<

SELECT *

INTO new_table_name

FROM old_tablename

<

found it there: http://www.w3schools.com/sql/sql_select_into.asp

but

_Query($sql,"SELECT * INTO new FROM old WHERE id = "&$value&";")

does not work

_Query($sql,"SELECT * INTO new FROM old")

does not work also

I use cdkid`s mysql.au3. Other functions used - SELECT FROM, INSERT TO, UPDATE work.

What`s wrong?

[enaiman]

What`s wrong?

The Forum!

This one is AutoIt not sql.

[Sia]

SELECT INTO FROM does not work with mysql: http://dev.mysql.com/doc/refman/5.0/en/insert-select.html

this function works instead:

_Query($sql,"INSERT INTO table2 (field1, field2) SELECT * FROM table1 WHERE id = "&$value&";")

The Forum is OK, but I`m very sorry if sent this message into wrong thread

[Yashied]

The Forum!