mysqlCreate table
CREATE TABLE tbl(id int auto_increment primary key, name varchar(128));ctrl + ctbltable name to create | id intfirst column definition, named |
auto_incrementautomatically set ids based on int counter | primary keyset first column as primary key (can't have duplicate values) |
name varchar(128)second column definition, named | |
More of Mysql
- Disable ONLY_FULL_GROUP_BY mode
- How to find my.cnf config file
- How to find duplicate varchar/text column values in table
- Make a pager (limit / offset) select query
- Insert/update multiple rows in single query
- What is the LONGTEXT column max size (length) in Mysql
- Get largest tables list
- What is the MEDIUMTEXT column max size (length) in Mysql
- Insert new values only if row doesn't exist already
- Truncate all tables in a specific database
See more codes...