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

3 votes135 views1 answer
Oracle detect invalid password
SQL
0 vote145 views1 answer
Sql order by number not ordered
SQL
2 votes118 views1 answer
How to select first row of database sql
SQL
0 vote112 views1 answer
Mysql date minus 1 day
SQL
6 votes130 views3 answers
What is where in sql
SQL
0 vote120 views2 answers
Select index table oracle
SQL
13 votes139 views3 answers
Sql select from multiple tables without join
SQL
-2 votes129 views2 answers
Union vs union all in sql
SQL
1 vote128 views1 answer
Sql server today minus n
SQL
14 votes114 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL