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 vote184 views1 answer
Import big data to mysql
SQL
0 vote184 views1 answer
H2 auto increment and unique
SQL
0 vote233 views1 answer
Capabilities of sql select statements
SQL
0 vote172 views1 answer
Transaction database with php
SQL
0 vote164 views1 answer
Sql cross apply vs join
SQL
0 vote253 views1 answer
Jooq replace
SQL
24 votes182 views4 answers
Postgres remove database
SQL
2 votes204 views1 answer
Express api ith mysql data
SQL
0 vote213 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
18 votes174 views3 answers
Mysql add column with default value
SQL