Shulou(Shulou.com)06/01 Report--

Sometimes we need to change the data table name and table field, then through what command line to change the data table name, table field change, add, delete, here is a detailed description of how to operate the data table

1. Modify the name of the table command line ALTER TABLE table_name rename to new_table_name 2, modify the structure of the table to add fields complete ALTER TABLE dc3688 ADD COLUMN complete DECIMAL (2) NULL AFTER description3, modify the structure of the table to delete the field ALTER TABLE dc3688 DROP COLUMN description 4. Modify the structure of the table, modify the field, change the type parameter of the data table field, ALTER TABLE tasks CHANGE COLUMN task_id task_id INT (11) NOT NULL AUTO_INCREMENT Change the name of the datasheet field method one, Alter table tbl_name modify [column] col_name [first | after col_name] method two, alter table tab_name change [column] old_name new_name [first | after col_name] summarize all operations for the datasheet summary articles from http://www.dc3688.com/

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.