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 vote285 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL
0 vote512 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
22 votes315 views3 answers
Year format in date mysql
SQL
0 vote299 views1 answer
Mysql root permission denied lost
SQL
9 votes306 views1 answer
Alter table column change data type to text mysql
SQL
16 votes295 views2 answers
Sql exists
SQL
0 vote277 views1 answer
Char varchar nvarchar sql
SQL
0 vote321 views1 answer
Local pg_sql to heroku pg_sql
SQL
0 vote279 views1 answer
Get who is hired in january in sql
SQL
0 vote262 views1 answer
Sql requete number pair
SQL