CREATE TABLE

1 MySQL[ | ]

MySQL CREATE TABLE 문서를 참고하십시오.

CREATE TABLE dept (
  dept_id INT(11) unsigned NOT NULL,
  dept_name VARCHAR(32) NOT NULL
);

CREATE TABLE dept (
  dept_id INT(11) unsigned NOT NULL,
  dept_name VARCHAR(32) NOT NULL,
  PRIMARY KEY (dept_id)
);

CREATE TABLE temperature (
  station_id INT(11) unsigned NOT NULL,
  event_time DATETIME NOT NULL,
  temperature FLOAT,
  PRIMARY KEY (station_id, event_time)
);

CREATE TABLE temperature (
  id INT(11) unsigned NOT NULL AUTO_INCREMENT,
  station_id INT(11) unsigned NOT NULL,
  event_time DATETIME NOT NULL,
  temperature FLOAT,
  PRIMARY KEY (id),
  UNIQUE KEY station_event (station_id, event_time)
);

2 SQLite[ | ]

SQLite CREATE TABLE 문서를 참고하십시오.

CREATE TABLE dept (
  dept_id INT(11) NOT NULL,
  dept_name VARCHAR(32) NOT NULL
);

3 같이 보기[ | ]