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 vote293 views1 answer
Kill a pid redshift
SQL
0 vote280 views2 answers
Sql 2 way of select unique
SQL
1 vote298 views1 answer
Create another table from existing table sql oracle
SQL
0 vote327 views1 answer
Drop a view in sqlite
SQL
2 votes333 views1 answer
Postgresql group by month and year
SQL
1 vote308 views3 answers
Date_add mysql
SQL
2 votes284 views1 answer
Sql update alias
SQL
0 vote290 views2 answers
Cambiar nombre tabla mysql
SQL
4 votes426 views6 answers
Laravel jwt
SQL
16 votes281 views2 answers
Oracle ddl
SQL