CREATE TABLE


1 MySQL[ | ]

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[ | ]

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

3 같이 보기[ | ]

문서 댓글 ({{ doc_comments.length }})
{{ comment.name }} {{ comment.created | snstime }}