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

3 votes337 views1 answer
Uppercase and lowercase in sql
SQL
12 votes317 views2 answers
Delete all nodes neo4j
SQL
0 vote336 views1 answer
Sql file in postgres with pgadmin
SQL
0 vote313 views1 answer
Denormalise SQL command
SQL
0 vote344 views2 answers
Script all indexes in a database
SQL
0 vote332 views1 answer
Mysql join column order By and group By
SQL
0 vote389 views1 answer
Delete ids between sql
SQL
0 vote329 views1 answer
Postgresql concat string with separator
SQL
1 vote316 views1 answer
Sql Split string function
SQL
0 vote332 views1 answer
Search starting with mysql
SQL