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

3 votes118 views2 answers
Laravel tosql with bindings
SQL
1 vote140 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL
0 vote128 views1 answer
Get primary key of table
SQL
1 vote119 views1 answer
Drush sql-dump
SQL
0 vote135 views2 answers
Return the number of records in a single table mysql
SQL
1 vote208 views1 answer
Mysql breakline on string
SQL
0 vote123 views1 answer
Update top 100 order by sql server
SQL
21 votes136 views4 answers
Oracle add column
SQL
0 vote122 views1 answer
Create table if not exist with exceptions
SQL
0 vote132 views1 answer
How to find lowest in sql
SQL