Showing posts with the label MySQLShow all

View View table, view (SQL View)

Kevin Li
by Kevin Li 4:40 AM

View is a data table generated by the dynamic combination of SQL SELECT queries (tha…

CREATE INDEX statement (SQL CREATE INDEX Statement)

Kevin Li
by Kevin Li 4:36 AM

Just like if a book has an index (index), you can find the information you need fast…

AUTO INCREMENT column (SQL AUTO INCREMENT column)

Kevin Li
by Kevin Li 4:33 AM

The AUTO INCREMENT field will automatically increment the value of the column, becau…

SQL Constraint

Kevin Li
by Kevin Li 4:05 AM

Constraint is used to conditionally restrict which data can be stored in the data ta…