Category: Mysql

SELECT * FROM Products WHERE Price <> 18; SELECT * FROM Products WHERE Price BETWEEN 50 AND 60; SELECT *… Read more

Base Grammar SELECT columns FROM tableName WHERE conditions GROUP BY columns HAVING conditions ORDER BY columns LIMIT numbers

Add Data — Add data for fixed columns. INSERT INTO tableName (column1,column1,…) VALUES(value1,value2,…); — Add data for whole columns INSERT… Read more

Date and Time Data Types Data type Description DATE A date. Format: YYYY-MM-DD. The supported range is from ‘1000-01-01’ to… Read more

Numeric Data Types BIT(size) A bit-value type. The number of bits per value is specified in size. The size parameter… Read more

String Data Types Date Type Description CHAR(size) A FIXED length string (can contain letters, numbers, and special characters). The size… Read more

1. Database operation — The "[xxx]" are optional. — Show all databases SHOW DATABASES; — show current database you used…. Read more