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 vote160 views2 answers
Datetime sql server week
SQL
6 votes200 views2 answers
Oracle
SQL
1 vote207 views1 answer
Postgresql define pk sequence next number
SQL
1 vote197 views1 answer
Mysql select if empty result
SQL
0 vote217 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
0 vote191 views1 answer
Sql_inner_join
SQL
3 votes191 views1 answer
Mysql load sql from file
SQL
0 vote231 views1 answer
How to define a non primary composite key in sql
SQL
1 vote179 views1 answer
Mysql count words
SQL
15 votes201 views2 answers
Select where duplicate mysql
SQL