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 vote169 views1 answer
Delete data from database sqlite android
SQL
11 votes214 views2 answers
Having keyword sql
SQL
0 vote161 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
10 votes166 views5 answers
Create table mysql query
SQL
16 votes172 views4 answers
Mysql import from sql file
SQL
5 votes154 views1 answer
Sql first day of current year
SQL
4 votes191 views3 answers
Sqlite show columns
SQL
3 votes190 views3 answers
Start postgresql ubuntu
SQL
11 votes195 views2 answers
Set default column value sql
SQL
12 votes159 views4 answers
Install mysql ubuntu 18.04
SQL