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 vote336 views1 answer
Pass array parameter to stored procedure c#
SQL
1 vote307 views1 answer
Oracle current sequence value
SQL
0 vote336 views3 answers
Sql delete all except
SQL
10 votes358 views4 answers
SELECT FROM WHERE
SQL
0 vote368 views1 answer
MySQL - Enabling the Event Scheduler
SQL
4 votes334 views2 answers
How to insert ip address in mysql using php
SQL
2 votes341 views1 answer
Scaffold npgsql net core
SQL
1 vote367 views1 answer
Homebrew install mysql
SQL
0 vote346 views1 answer
Varchar2 length in oracle
SQL
21 votes360 views5 answers
Oracle all tables
SQL