Oracle/MySQL 관련 게시판

Oracle/MySQL 관련 게시판

2001/11/18(18:59) from 210.117.182.162
작성자 : 강줄기 (jkkang65@hanmail.net)	조회수 : 3545 , 줄수 : 21

[MySQL] CWS 통계프로그램 Table 자료형

mysql> create database accnt_db;

mysql> use accnt_db;

mysql> create table accnt (
   -> id INT NOT NULL AUTO_INCREMENT,
   -> user_name CHAR(20),
   -> date CHAR(10),
   -> cpu_time INT,
   -> network_time INT,
   -> PRIMARY KEY(id));

mysql> show tables;
mysql> show columns from accnt;

mysql> create table username (
   -> user_name CHAR(20));

mysql> show tables;
mysql> show columns from username;