mrkeck Sharing the Love

29Jun/110

MSSQL to MySQL SQL Commands

replace(convert(varchar, NOW(), 101),'/','') to date_format(NOW(),'%m%d%Y')  = 06292011

'E-'+cast(stub_id as varchar(15)) to concat('E-',stub_id) = E-12345

GETDATE() to NOW() = Current Timestamp

Note: MySql dates are in 2011-06-29 form

SELECT TOP 1 * from table1 to SELECT * from table1 LIMIT 1 = Return one row

I did a conversion recently and these 4 are the things I ran into the most.

Filed under: MSSQL, mySQL Leave a comment
Comments (0) Trackbacks (0)

No comments yet.


Leave a comment

No trackbacks yet.