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 vote330 views1 answer
Select a row include list of array with join table SQL
SQL
0 vote310 views4 answers
Best data type to represent money in mysql
SQL
12 votes318 views4 answers
Mysql ifnull
SQL
0 vote318 views1 answer
Mysql default timestamp value to be current timestamp
SQL
-1 vote312 views1 answer
How to switch user in mysql
SQL
6 votes332 views2 answers
Difference between join vs union
SQL
0 vote319 views1 answer
Sql server select record with max id
SQL
8 votes335 views2 answers
How to fetch data from database without last column
SQL
1 vote337 views1 answer
Oracle get current schema
SQL
27 votes311 views4 answers
Get all tables with column name sql
SQL