Mysql基础部分(16)---标识列

待我称王封你为后i 2023-03-13 05:28 19阅读 0赞

Mysql基础部分内容：  
[Mysql基础部分(1)—基础操作指令与语法规范][Mysql_1]  
[Mysql基础部分(2)—基础查询][Mysql_2]  
[Mysql基础部分(3)—条件查询][Mysql_3]  
[Mysql基础部分(4)—排序查询][Mysql_4]  
[Mysql基础部分(5)—常见函数][Mysql_5]  
[Mysql基础部分(6)—分组函数][Mysql_6]  
[Mysql基础部分(7)—分组查询][Mysql_7]  
[Mysql基础部分(8)—sql99语法][Mysql_8_sql99]  
[Mysql基础部分(9)—子查询][Mysql_9]  
[Mysql基础部分(10)—分页查询][Mysql_10]  
[Mysql基础部分(11)—联合查询][Mysql_11]  
[Mysql基础部分(12)—数据的增删改][Mysql_12]  
[Mysql基础部分(13)—库和表的管理][Mysql_13]  
[Mysql基础部分(14)—常见的数据类型][Mysql_14]  
[Mysql基础部分(15)—常见约束][Mysql_15]  
[Mysql基础部分(16)—标识列][Mysql_16]  
[Mysql基础部分(17)—事务][Mysql_17]  
[Mysql基础部分(18)—视图][Mysql_18]  
[Mysql基础部分(19)—变量][Mysql_19]  
[Mysql基础部分(20)—存储过程][Mysql_20]  
[Mysql基础部分(21)—函数][Mysql_21]  
[Mysql基础部分(22)—流程控制结构][Mysql_22]

#标识列
    /* 又称为自增长列 含义：可以不用手动的插入值，系统提供默认的序列值 特点： 1.标识列必须和逐渐搭配吗？ 不一定是主键，但要求是一个key 2.一个表中可以有几个标识列？ 至多一个 3.标识列的类型只能是数值型 4.标识列可以通过 set auto_increment_increment=3;设置步长 可以通过手动插入值，设置起始值 */
    
    #一、创建表时设置标识列
    DROP TABLE IF EXISTS tab_identity;
    CREATE TABLE tab_identity(
    	id INT PRIMARY KEY AUTO_INCREMENT,
    	uname VARCHAR(20)
    );
    
    TRUNCATE TABLE tab_identity;
    
    INSERT INTO tab_identity VALUES(NULL,'john');
    INSERT INTO tab_identity(id,uname) VALUES(NULL,'mike');
    INSERT INTO tab_identity(uname) VALUES('jerry');
    SELECT * FROM tab_identity;
    
    
    SHOW VARIABLES LIKE '%auto_increment%';
    
    SET auto_increment_increment = 3;
    
    
    #二、修改表时设置标识列
    ALTER TABLE tab_identity MODIFY COLUMN id INT PRIMARY KEY AUTO_INCREMENT;
    
    #三、修改表时删除标识列
    ALTER TABLE tab_identity MODIFY COLUMN id INT;

[Mysql_1]: https://blog.csdn.net/weixin_43900321/article/details/105664839
[Mysql_2]: https://blog.csdn.net/weixin_43900321/article/details/105729424
[Mysql_3]: https://blog.csdn.net/weixin_43900321/article/details/105729465
[Mysql_4]: https://blog.csdn.net/weixin_43900321/article/details/105729506
[Mysql_5]: https://blog.csdn.net/weixin_43900321/article/details/105729526
[Mysql_6]: https://blog.csdn.net/weixin_43900321/article/details/105729554
[Mysql_7]: https://blog.csdn.net/weixin_43900321/article/details/105729593
[Mysql_8_sql99]: https://blog.csdn.net/weixin_43900321/article/details/105810240
[Mysql_9]: https://blog.csdn.net/weixin_43900321/article/details/105849897
[Mysql_10]: https://blog.csdn.net/weixin_43900321/article/details/105869419
[Mysql_11]: https://blog.csdn.net/weixin_43900321/article/details/105978422
[Mysql_12]: https://blog.csdn.net/weixin_43900321/article/details/105978492
[Mysql_13]: https://blog.csdn.net/weixin_43900321/article/details/106000721
[Mysql_14]: https://blog.csdn.net/weixin_43900321/article/details/106000793
[Mysql_15]: https://blog.csdn.net/weixin_43900321/article/details/106057742
[Mysql_16]: https://blog.csdn.net/weixin_43900321/article/details/106057793
[Mysql_17]: https://blog.csdn.net/weixin_43900321/article/details/106156900
[Mysql_18]: https://blog.csdn.net/weixin_43900321/article/details/106156942
[Mysql_19]: https://blog.csdn.net/weixin_43900321/article/details/106233375
[Mysql_20]: https://blog.csdn.net/weixin_43900321/article/details/106233530
[Mysql_21]: https://blog.csdn.net/weixin_43900321/article/details/106233577
[Mysql_22]: https://blog.csdn.net/weixin_43900321/article/details/106253492