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

1 vote249 views1 answer
Oracle sql pad left zeros
SQL
0 vote238 views1 answer
Mysql where in maintain order
SQL
11 votes247 views3 answers
Sql line numbers
SQL
38 votes261 views6 answers
Ubuntu install mysql client
SQL
2 votes263 views3 answers
Xampp mysql database not starting
SQL
0 vote243 views1 answer
Sql tabelle erstellen
SQL
0 vote225 views1 answer
Export partttion and import in oracle
SQL
0 vote235 views1 answer
Sql find record cannot cast date
SQL
0 vote237 views1 answer
Select even number id data from table
SQL
1 vote214 views5 answers
Sql 2nd highest salary
SQL