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 vote109 views1 answer
Sql: extract day text from datetime value
SQL
0 vote103 views1 answer
Psql list rules
SQL
0 vote88 views1 answer
Duplicate foreign key constraint name
SQL
0 vote119 views1 answer
T-SQL - Where Used List (Table/View)
SQL
0 vote113 views1 answer
Power bi union columns
SQL
0 vote110 views1 answer
Oracle current session details
SQL
1 vote104 views1 answer
Sql delete row with auto increment
SQL
0 vote114 views1 answer
Import excel to sql
SQL
9 votes108 views2 answers
Oracle all tables in schema
SQL
0 vote133 views1 answer
How to define a non primary composite key in sql
SQL