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

2 votes220 views1 answer
Mysql create user with mysql_native_password
SQL
0 vote225 views1 answer
Mysql last 6 months
SQL
1 vote185 views1 answer
Python escape string for sql
SQL
6 votes239 views2 answers
Mysql timestamp to date
SQL
3 votes222 views2 answers
Mysql config user password
SQL
6 votes213 views3 answers
Mysql change auto_increment start value
SQL
0 vote223 views1 answer
Oracle sql log to console
SQL
3 votes215 views1 answer
Apex set debug level
SQL
0 vote213 views1 answer
Enable full text search mysql
SQL
1 vote213 views1 answer
Sql list all procedures
SQL