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

14 votes136 views4 answers
Remove record from table sql
SQL
0 vote138 views1 answer
Sql offfset
SQL
4 votes133 views1 answer
Mysql copy table with new name
SQL
2 votes189 views2 answers
Create table mysql integer NOT null
SQL
0 vote130 views1 answer
Sql string length postgresql
SQL
0 vote132 views1 answer
Access refused mysql xampp server
SQL
1 vote144 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
1 vote130 views1 answer
Scaffold mysql database
SQL
0 vote104 views1 answer
Store query result in variable sql
SQL
4 votes136 views1 answer
Mysql timestamp in laravel migration
SQL