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 vote253 views1 answer
Select last N rows mysql
SQL
9 votes249 views6 answers
Sql add column with default value
SQL
0 vote234 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
0 vote300 views1 answer
Pl sql join 3 tables
SQL
0 vote242 views1 answer
Mysql update sequence with order by
SQL
1 vote249 views2 answers
Datetrunc hour snowflake
SQL
0 vote259 views1 answer
Mysql shell ERROR: Not connected.
SQL
38 votes319 views6 answers
Ubuntu install mysql client
SQL
50 votes304 views6 answers
Install mysql on ubuntu
SQL
0 vote249 views1 answer
Mysql count by month
SQL