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

3 votes346 views2 answers
Sqlite print all column names
SQL
0 vote418 views1 answer
How to check foreign key constraint in sql
SQL
19 votes335 views2 answers
Mysql tinyint max value
SQL
1 vote315 views1 answer
Mysql collation
SQL
1 vote344 views1 answer
How to show index type in postgresql
SQL
5 votes340 views1 answer
Postgres integer to serial
SQL
8 votes309 views2 answers
Phpmyadmin password
SQL
2 votes311 views1 answer
Convert series number to date in sql
SQL
0 vote318 views2 answers
Mysql get routine parameter list
SQL
20 votes348 views3 answers
Update values in select statement sql
SQL