insert, update, delete

Forum|Forum|17 years ago
August 14, 2008
4 replies
915 views

If I have a cfquery with the relevant datasource and name etc. then will the sql be the same for:

1. insert, update, delete with mysql and mssql?
2. Are unions and joins different for mysql and mssql?

Thank you!

Database access

This topic has been closed for replies.

Correct answer Dan_Bracuk

Whenever you compare two db's it's reasonable to assume that they will behave identically if you stick to plain vanilla sql and that there will at least one difference when it comes to functions.

H

HydrowizardAuthor

Inspiring

OK thanks I saw a cheat sheet from pete freitag for mssql so I'll have a look at that. Thanks Dan

D

Dan_BracukCorrect answer

Inspiring

Whenever you compare two db's it's reasonable to assume that they will behave identically if you stick to plain vanilla sql and that there will at least one difference when it comes to functions.

-

-__cfSearching__-

Inspiring

Hydrowizard wrote:
> If I have a cfquery with the relevant datasource and name etc. then will the sql be the same for:
> 1. insert, update, delete with mysql and mssql?
> 2. Are unions and joins different for mysql and mssql?

Always? No. There are similarities in syntax, but there are also differences. IIRC, an example is INSERT. I do not believe MS SQL allows this structure, whereas MySQL does.

INSERT INTO Table (..Columns..) VALUES (..set one...), (..set two...), (...set three..)

For more specific details about syntax differences you will need to do some searching. Also check migration documents for MySQL or MS SQL. They usually provide a good summary of differences between the two database types.

D

Dan_Bracuk

Inspiring

What happened when you tried it?