Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

feature: When show the table structure,it will support keyword display "AUTO INCREMENT". #1201

Closed
haitaoguan opened this issue Jan 9, 2023 · 1 comment · Fixed by #1315
Closed
Assignees
Labels
A-feature feature with good idea B-SQL SQL layer prio: high High priority

Comments

@haitaoguan
Copy link
Collaborator

###InnoDB
create table ttt(id int primary key auto_increment,name varchar(5));
insert into ttt(name) values('AAA');

mysql> show create table ttt\G
*************************** 1. row ***************************
       Table: ttt
Create Table: CREATE TABLE `ttt` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4
1 row in set (0.00 sec)

###Tianmu
mysql> show create table ttt\G
*************************** 1. row ***************************
       Table: ttt
Create Table: CREATE TABLE `ttt` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=TIANMU DEFAULT CHARSET=utf8mb4
1 row in set (0.01 sec)
@haitaoguan haitaoguan added the A-feature feature with good idea label Jan 9, 2023
@davidshiz
Copy link
Collaborator

Similar to #1059

@isredstar isredstar self-assigned this Jan 10, 2023
@isredstar isredstar added this to the stonedb_5.7_v1.0.3 milestone Jan 10, 2023
@isredstar isredstar added the prio: high High priority label Jan 13, 2023
@wisehead wisehead added the B-SQL SQL layer label Jan 30, 2023
@hustjieke hustjieke added B-storage data type, data storage, insert,update,delete, transactions and removed B-storage data type, data storage, insert,update,delete, transactions labels Jan 30, 2023
@mergify mergify bot closed this as completed in #1315 Feb 21, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-feature feature with good idea B-SQL SQL layer prio: high High priority
Projects
None yet
5 participants