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 vote154 views1 answer
Psql lst trigger
SQL
2 votes141 views1 answer
Mysql find tables with name
SQL
0 vote161 views1 answer
Sql query to find duplicate email address
SQL
0 vote157 views1 answer
Sql common columns
SQL
0 vote152 views2 answers
Postgresql get last day of month
SQL
0 vote158 views1 answer
Mssql disable foreign key constraint
SQL
1 vote158 views1 answer
Oracle nvl2
SQL
-1 vote149 views1 answer
Ssql to lowercqse
SQL
0 vote158 views1 answer
R write csv without index
SQL
4 votes142 views1 answer
Sql group by year
SQL