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

0 vote180 views1 answer
Sparql if bound query
SQL
0 vote141 views1 answer
Différence entre deux dates sql oracle
SQL
0 vote158 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
1 vote134 views1 answer
Update mysql centos
SQL
1 vote142 views1 answer
What is in condition in sql
SQL
0 vote138 views1 answer
Sql show all users
SQL
0 vote147 views1 answer
Mysql where in keep order
SQL
1 vote144 views1 answer
Sql dcl
SQL
0 vote150 views1 answer
Sparql list all graphs
SQL
0 vote148 views1 answer
Query to get all primary keys and foreign key
SQL