دستورات بانک اطلاعاتی MySQL

backup: mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql mysqldump –all-databases -u [user] -p[pass] –skip-lock-tables –force > mysql-11-18-2015.sql restore: mysql -u root -p[root_password] [database_name] <

توابع Like/Not Like در MSSQL

SELECT column_name(s) FROM table_name WHERE column_name LIKE %pattern%; SELECT column_name(s) FROM table_name WHERE column_name NOT LIKE %pattern%;

تابع Select در MSSQL

SELECT * FROM table_name; SELECT column_name,column_name FROM table_name; SELECT column_name,column_name FROM table_name WHERE column_name operator value; SELECT * FROM table_name WHERE column_name operator valu