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 vote41 views1 answer
Check if a word appears at the end sql query
SQL
1 vote47 views1 answer
How to change owner in postgres
SQL
0 vote53 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
0 vote50 views1 answer
Do postgresql
SQL
1 vote44 views1 answer
Mysql not supported auth mode
SQL
0 vote53 views1 answer
Sql server set complex constraints
SQL
2 votes41 views1 answer
Postgresql transaction
SQL
22 votes46 views2 answers
Mysql show all tables
SQL
3 votes59 views3 answers
Raw select laravel
SQL
12 votes42 views4 answers
Mysql version
SQL