How to assign custom id in mysql

CREATE TABLE document_control (
  id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  name VARCHAR(10)
);

Source: stackoverflow.com

How to assign custom id in mysql

CREATE TABLE document_control (
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT...

Source: stackoverflow.com

How to assign custom id in mysql

INSERT INTO document_control 
  SELECT CONCAT_WS('-', RIGHT(YEAR(CURRENT_TIMESTAMP), 2), LPAD(COUNT(*) + 1, 3, 0)) 
  FROM document_control
  WHERE LEFT(id_custom, 2) = RIGHT(YEAR(CURRENT_TIMESTAMP), 2)

Source: stackoverflow.com

Similar codes

0 vote254 views1 answer
Delet all record statment sql
SQL
1 vote259 views4 answers
Alter schema sql
SQL
23 votes175 views4 answers
How to show all users in mysql
SQL
5 votes179 views1 answer
Sort order on two columns sql
SQL
1 vote183 views1 answer
Mysql average of multiple columns
SQL
1 vote160 views1 answer
Oracle rolling back
SQL
-1 vote172 views1 answer
How to open blade file from blade in laravel
SQL
0 vote189 views1 answer
Createdb with postgresql on ubuntu
SQL
0 vote182 views1 answer
ACCEPT nome PROMPT on oracle
SQL
0 vote198 views1 answer
Excel vba import data to sql server
SQL