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 votes405 views1 answer
Where clause for child record apex
SQL
-1 vote349 views1 answer
Mysql #1064 error
SQL
0 vote384 views3 answers
How to verify sequence result in oracle SQL
SQL
3 votes375 views1 answer
Sql timestamp to date
SQL
0 vote369 views1 answer
Mysql update from select on same table
SQL
5 votes355 views2 answers
Add column postgres with default value
SQL
11 votes368 views2 answers
Insert current date sql
SQL
2 votes377 views3 answers
Sql server: how to concatenate column data using comma
SQL
2 votes346 views1 answer
Mysql find tables with name
SQL
1 vote345 views1 answer
Base nosql
SQL