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 vote258 views1 answer
Power query case when
SQL
0 vote298 views2 answers
How to get max from each department in sql
SQL
0 vote258 views2 answers
Sql regex vowel
SQL
0 vote273 views1 answer
Postgres week number
SQL
0 vote265 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
0 vote266 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL
0 vote265 views1 answer
Set engine to innodb
SQL
0 vote276 views1 answer
SQL query to verify the size of the table
SQL
0 vote328 views1 answer
Sp help text in postgresql
SQL
8 votes263 views1 answer
Oracle search source code
SQL