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

7 votes345 views6 answers
Reset identity column in sql server
SQL
50 votes407 views4 answers
Sql alter type of column
SQL
1 vote391 views1 answer
Drop colum oracle 18c
SQL
-2 votes356 views1 answer
Trunc in sql
SQL
0 vote394 views1 answer
Delete from IN subquery
SQL
0 vote330 views1 answer
Sql if else in select
SQL
0 vote354 views1 answer
Declarative base sqlalchemy
SQL
0 vote354 views1 answer
Leftjoin in sql
SQL
0 vote347 views3 answers
Insert or ignore postgres
SQL
13 votes332 views4 answers
Mysql select last 10 rows
SQL