stanmc

Hello, I'm try to use the "CREATE TABLE SELECT * FROM SOURCE" from VB can
someone help me. Please!

Stan


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=mysql-win32@freebsd.csie.nctu.edu.tw

stanmc

Thank for the reply Joel,

What I'm trying to do is create a table using information from to other
tables.

From mySQL prompt I can use the statement "CREATE TABLE destination SELECT *
FROM source" to create a new table from the source table. I want to
duplicate that code in VB.

-----Original Message-----

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=mysql-win32@freebsd.csie.nctu.edu.tw

It would go something like this

Set Conn1 =3D New ADODB.Connection
Conn1.ConnectionString =3D "DRIVER=3D{MySQL ODBC 3.51 Driver};" _
& "SERVER=3Dlocalhost;" _
& "DATABASE=3DMusic;"
Conn1.Open
Conn1.Execute "CREATE TABLE destination SELECT * FROM source"

HTH

John Bonnett

-----Original Message-----
From: Stan McCowan [mailto:stanmc@comcast.net]
Sent: Friday, 17 October 2003 11:35 AM
To: Joel Fentin
Cc: win32@lists.mysql.com
Subject: RE: command from VB


Thank for the reply Joel,

What I'm trying to do is create a table using information from to other
tables.

From mySQL prompt I can use the statement "CREATE TABLE destination =
SELECT *
FROM source" to create a new table from the source table. I want to
duplicate that code in VB.

-----Original Message-----

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dmysql-win32@freebsd.csie.nctu.edu.tw