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 vote238 views3 answers
Showing all columns in an sqlite table
SQL
12 votes247 views2 answers
Update column data type postgres
SQL
5 votes237 views1 answer
Oracle asynchronous update
SQL
0 vote234 views1 answer
Windows services sql
SQL
0 vote238 views1 answer
Psql list view rules
SQL
0 vote236 views2 answers
Plsql regex match whole word
SQL
0 vote249 views1 answer
Can we rollback in sql
SQL
7 votes222 views1 answer
Grant schema permissions postgres
SQL
0 vote235 views1 answer
Test connection to sql server
SQL
4 votes236 views2 answers
REST API
SQL