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

1 vote125 views1 answer
Oracle truncate partition
SQL
0 vote120 views1 answer
Sql #region
SQL
0 vote123 views1 answer
Redudancy in SQL
SQL
0 vote114 views1 answer
Mysql sum with group by
SQL
3 votes72 views1 answer
System.debug apex
SQL
0 vote129 views1 answer
Mysql where in maintain order
SQL
0 vote143 views1 answer
Select top values sql
SQL
0 vote117 views1 answer
Authentication modes in sql server
SQL
7 votes114 views3 answers
Convert ansi sql
SQL
2 votes118 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL