Jump to content
Sign in to follow this  
Sia

select_into_from

Recommended Posts

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?

Share this post


Link to post
Share on other sites
enaiman

What`s wrong?

The Forum!

This one is AutoIt not sql. :)


SNMP_UDF ... for SNMPv1 and v2c so far, GetBulk and a new example script

wannabe "Unbeatable" Tic-Tac-Toe

Paper-Scissor-Rock ... try to beat it anyway :)

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
Yashied

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.