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

2 votes268 views4 answers
Duplicate record mysql
SQL
1 vote257 views1 answer
Adding a default constraint to an existing column in sql
SQL
4 votes250 views2 answers
How to delete row in sql
SQL
0 vote315 views1 answer
What is metadata in sql
SQL
0 vote266 views1 answer
Postgresql certain first 4 characters in string
SQL
49 votes307 views6 answers
Alter table add column
SQL
0 vote284 views1 answer
How to print sql query
SQL
5 votes296 views1 answer
Add column table sql default value
SQL
0 vote274 views1 answer
Get who is hired in month in sql
SQL
23 votes260 views3 answers
Mysqldump
SQL