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 vote146 views1 answer
How to print mysql query of codeigniter query builder
SQL
2 votes226 views1 answer
Oracle run_duration to number
SQL
0 vote147 views1 answer
Sql get number of days between two dates
SQL
0 vote168 views1 answer
Pgadmin check database
SQL
8 votes149 views1 answer
Sql remove leading spaces
SQL
7 votes167 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
0 vote165 views2 answers
What is the default password for sql server sa
SQL
0 vote140 views1 answer
Sql comparison operators
SQL
0 vote156 views1 answer
Sql doesn't contain
SQL
0 vote147 views1 answer
Sql recherche nom prenom
SQL