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 vote258 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
0 vote291 views1 answer
Grant privileges of databse to user
SQL
0 vote277 views1 answer
Oracle sql number to varchar2
SQL
4 votes268 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote250 views1 answer
Mysql order by desc null last
SQL
1 vote286 views3 answers
Union in sql
SQL
0 vote262 views1 answer
Sql fetch next 10 rows pdo
SQL
0 vote288 views1 answer
Create table database in psql
SQL
15 votes272 views4 answers
Sql update from select
SQL
0 vote277 views1 answer
Mysql subtract month from timestamp
SQL