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 vote286 views2 answers
Athena drop partition
SQL
0 vote317 views1 answer
New rails app with mysql
SQL
0 vote288 views1 answer
Oracle table free space
SQL
0 vote278 views1 answer
How to close external sql connection in laravel
SQL
0 vote270 views2 answers
T SQl Checking Your Username
SQL
2 votes280 views1 answer
How to get weekday from old date in sql
SQL
0 vote274 views1 answer
Redudancy in SQL
SQL
0 vote262 views1 answer
Default column value in sql same as other column
SQL
1 vote294 views2 answers
Backup table mssql
SQL
0 vote269 views1 answer
Sql server inner join convert collation
SQL