Re: Update a table by adding a new row with an expression
Can you do a DESC table on the new table ?
Post it here.
I don't think MYSQL can do a SELECT INTO, but it has something
similar in the Manual.
Chapter 1.8.5.1. SELECT INTO TABLE
MySQL Server doesn't support the SELECT ... INTO TABLE Sybase SQL extension.
Instead, MySQL Server supports the INSERT INTO ... SELECT standard SQL
syntax, which is basically the same thing. See Section 12.2.5.1, “INSERT ...
SELECT Syntax”. For example:
INSERT INTO tbl_temp2 (fld_id)
SELECT tbl_temp1.fld_order_id
FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100;
Alternatively, you can use SELECT ... INTO OUTFILE or CREATE TABLE ...
SELECT.
As of MySQL 5.0, you can use SELECT ... INTO with user-defined variables. The
same syntax can also be used inside stored routines using cursors and local
variables. See Section 12.8.3.3, “SELECT ... INTO Statement”.
I haven't used MS Access as a front-end for a while, just the odd statement
to execute. Does it allow you to use the JET-style syntax on MySQL ?
>
Thanks, Jay
Subject
Views
Written By
Posted
3985
September 18, 2009 07:15AM
Re: Update a table by adding a new row with an expression
2014
September 18, 2009 09:00AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.