Skip to content

Instantly share code, notes, and snippets.

@123Daoxyz

123Daoxyz/mysql

Last active February 11, 2017 06:45
Show Gist options
  • Save 123Daoxyz/716b59957ce85b61ae64a0c0cfdcb75d to your computer and use it in GitHub Desktop.
Save 123Daoxyz/716b59957ce85b61ae64a0c0cfdcb75d to your computer and use it in GitHub Desktop.
Download ZIP
create database
Raw
mysql
CREATE DATABASE mydatabase CHARACTER SET utf8 COLLATE utf8_general_ci;
### add new column
ALTER TABLE material ADD COLUMN is_synchronized tinyint default '1' NOT NULL COMMENT '0代表未同步到微信，1代表已同步到微信';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment