---
title: "创建一张表的mysql 语句"
author: "XIAOLINJAVA"
date: "2010-04-22T15:33:14Z"
tags: []
categories: ["数据库"]
slug: "mysql"
draft: false
lastmod: "2010-05-14T17:35:57Z"
id: 650533
url: "https://xiaolinjava.iteye.com/blog/650533"
---

```java

CREATE TABLE `proxy` (
   `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
   `type` VARCHAR(30) COLLATE utf8_unicode_ci NOT NULL COMMENT '类型 ',
   `con` VARCHAR(30) COLLATE utf8_unicode_ci NOT NULL COMMENT 'host:port',
   `state` INT(1) NOT NULL COMMENT '1表示可以，0表示不可以',
   PRIMARY KEY  (`id`)
 ) ENGINE=MYISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci


```