Tag: SQL

To concat in MySQL you can use the concat or concat_ws function. Sample CONCAT output HELLO|WORLD|TEST Sample CONCAT_WS output HELLO|WORLD|TEST for more informations see DEV.MYSQL: Concat, CONCAT_WS

To get a list of all functions in mssql you can use the following snippet. Sample MSSQL

To rearrange columns in MySQL you can use the following snippet.

To list all users in MSSQL you can use the following snippet.

To copy a table in MySQL you can use the following snippet. Sample MySQL

To list all databases in MSSQL you can use the following snippet. Sample 1 MSSQL Sample 2 MSSQL

To select entries less than 24 hours old in MySQL you can use the following snippet. Sample MySQL

When using a case-insensitive Server Collation your sql queries are case-insensitive by default. To write a case-sensitive MS-SQL query, you need to add the keyword. In this sample we used…