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

4 votes189 views1 answer
Refresh postgres config
SQL
0 vote185 views1 answer
Bigquery declare
SQL
0 vote188 views1 answer
Query by column for substring sql
SQL
3 votes204 views1 answer
Start mysql server by terminal in linux
SQL
1 vote173 views1 answer
Order by oracle
SQL
0 vote178 views1 answer
Create boolean column in MySQL with false as default value?
SQL
1 vote272 views3 answers
Showing all columns in an sqlite table
SQL
0 vote183 views2 answers
Mysql updating multiple column values from array variable
SQL
2 votes216 views1 answer
Sql count having
SQL
1 vote196 views1 answer
Oracle turn off constraint
SQL