mysql 常用操作

CREATE SCHEMA IF NOT EXISTS `name`;
CREATE DATABASE IF NOT EXISTS `name`;

CREATE SCHEMA `name`;
CREATE DATABASE `name`;

SHOW DATABASES;

USE `name`;

DROP DATABASE `name`;
DROP SCHEMA `name`;

CREATE TABLE IF NOT EXISTS `users`(
    `id` INT NOT NULL AUTO_INCREMENT,
    `keyname` VARCHAR(20) NOT NULL,
    `keyname` VARCHAR(10) NOT NULL,
    PRIMARY KEY(`id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

SHOW TABLES;

INSERT INTO `tablename` (`key`, `key`, `key`) VALUES (
    ‘value‘, ‘value‘, ‘value‘
);

DROP TABLE `tablename`;

-- 选中数据库
USE `dataname`;

ALTER TABLE `tablename` character set `[value]`;