how to convert sql server query in mysql

Question

0.00/5 (No votes)

See more:

MySQL

select * into tbl_Distination from tbl_Source;

Posted 29-Sep-15 19:00pm

bhartimithilesh

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

DamithSL · Answer 1 · 2015-09-29T19:08:00

Solution 1

MySQL Server doesn't support the SELECT ... INTO TABLE Sybase SQL extension. Instead, MySQL Server supports the INSERT INTO ... SELECT standard SQL syntax

SELECT INTO TABLE[^]

Posted 29-Sep-15 19:08pm

DamithSL

Comments

PIEBALDconsult 30-Sep-15 1:21am

INSERT/SELECT is also in SQL Server, but doesn't do the same thing -- SELECT INTO creates and fills the table; INSERT/SELECT doesn't create, only fills -- does it create the table in MySQL?

bhartimithilesh 30-Sep-15 1:24am

insert into tbl_Distination select * from tbl_Source;

not working.

DamithSL 30-Sep-15 1:34am

what is the error you get? have you check the column data types & sizes etc.. machine with destination or not? try to give column names like below
INSERT INTO tbl_temp2 (fld_id)
SELECT tbl_temp1.fld_order_id
FROM tbl_temp1

Maciej Los 30-Sep-15 2:03am

5ed!

DamithSL 30-Sep-15 6:55am

Thank you