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 vote128 views1 answer
Change schema of all tables postgres
SQL
4 votes121 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote132 views1 answer
Utiliser sql ligne de commande
SQL
0 vote87 views1 answer
Split a string with expression and get the last value of split sql
SQL
-1 vote132 views1 answer
Export mysql table to file
SQL
7 votes127 views1 answer
Sql management studio display line numbers
SQL
3 votes154 views5 answers
Duplicate table sql
SQL
2 votes139 views1 answer
Mysql id of inserted row
SQL
22 votes116 views2 answers
Mysql show all tables
SQL
1 vote119 views1 answer
Sql server select rows by distinct column
SQL