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 vote169 views1 answer
Local pg_sql to heroku pg_sql
SQL
3 votes138 views1 answer
Delete all content in table mysql
SQL
0 vote154 views1 answer
How to find table lock and row lock in mysql
SQL
0 vote175 views1 answer
Month mysql
SQL
4 votes132 views1 answer
Check database name postgresql
SQL
3 votes164 views1 answer
What is having
SQL
0 vote140 views1 answer
See Foreign Key
SQL
0 vote150 views1 answer
Mysql exception output
SQL
36 votes140 views6 answers
Delete from where sql
SQL
0 vote127 views1 answer
Clear query cache sql server
SQL