Geek asks and answers

SQL Server Query query to convert MySQL queries

I am doing query conversion from SQL Server to MySQL. So can anyone suggest a website that contains different keywords that will perform the same operation in SQL Server and MySQL respectively?

For example, to get the current time, we will use the following keywords

 MSSQL   getdate()
 MYSQL   now()

like this, for all operations I need keywords.

+3
source share
3 answers

I have done this several times, my suggestion is to google as follows

Mssql getdate () in mysql

and how do you get to sites like http://www.x7media.com/resources/SQL_Differences_Between_Microsoft_SQL_Server_and_MySQL.asp

+2
source

MySQL, -?

: Microsoft SQL Server MySQL

, , , , .

: Microsoft SQL Server MySQL

( Access)

+2

SQL- MS SQL MySQL , , MS SQL MySQL:

  • MySQL , ` . : [] `object`.

  • JOIN, WHERE MS SQL ON MySQL. : ... table1 CROSS JOIN table2 WHERE condition ... table1 CROSS JOIN table2 ON condition.

  • PHP SQL MS SQL SQLSRV, MySQL MYSQL. : sqlsrv_fetch_array, sqlsrv_num_rows, sqlsrv_query mysql_fetch_array, mysql_num_rows, mysql_query.

  • MS SQL LEN() . MySQL LENGTH().

  • The CONVERT () function is used to convert the expression of one data type to another in MS SQL. In MySQL, the CONVERT () function converts text data between different character sets. However, there is an equivalent CAST () function, so each conversion occurrence (type, expression) in an MS SQL query must be replaced with the cast method (AS type expression) in the MySQL query.

We’ll just list just a few tips. See this page for more details . Hooray!

0
source

More articles:


All Articles