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 vote198 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL
-1 vote221 views1 answer
Mysql change database charset and collation
SQL
0 vote208 views1 answer
Sum values by month mariadb
SQL
0 vote218 views1 answer
Kotlin sqlite delete row
SQL
11 votes187 views2 answers
Having clause
SQL
0 vote203 views3 answers
Create and attach user to a postgresql database
SQL
6 votes206 views2 answers
Where clause in sql
SQL
1 vote221 views1 answer
Tsql update datetime
SQL
6 votes204 views1 answer
Oracle trigger after connect
SQL
0 vote210 views1 answer
Drop unique
SQL