MySQL Forums
Forum List  »  Microsoft Access

Re: Update a table by adding a new row with an expression
Posted by: Jay Alverson
Date: September 18, 2009 09:00AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
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.