本文实例讲述了MySQL数据库列的增删改实现方法。分享给大家供大家参考,具体如下:新建表user_info:CREATE TABLE user_info(id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,username CHAR(20) NOT NULL DEFAULT '',gender TINYINT UNSIGNED NOT NULL ..
1 判断数据库是否存在if exists (select * from sys.databases where name = '数据库名') drop database [数据库名]2 判断表是否存在if exists (select * from sysobjects where id = object_id(N'[表名]') and OBJECTPROPERTY(id, N'IsUserTable')..