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 vote201 views2 answers
Extract weekday from date in sql
SQL
0 vote199 views3 answers
How to increase size of column in sql
SQL
0 vote209 views3 answers
Sql query checker
SQL
0 vote191 views1 answer
How to export table data from mysql table in sql format
SQL
0 vote205 views1 answer
Cannot pip install mysqlclient
SQL
0 vote242 views1 answer
Selecting from a view SQL
SQL
0 vote238 views1 answer
Reindexing all tables sql server
SQL
4 votes205 views1 answer
T-sql get duplicate rows
SQL
0 vote198 views1 answer
Set a default value for a column in sqlite
SQL
2 votes197 views1 answer
Mysql sql add created updated timestamp to existing table
SQL