Welcome to 深ちゃんのホームページ
Prev	MySQL のインストールと基本的な設定	Next

MySQL で試しにテーブルを作る

では SQL 構文の用意をします。

# cat create_table.sql
CREATE TABLE domain (
  id  INT NOT NULL AUTO_INCREMENT,
  domainname char(64) DEFAULT '' NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE ml (
  id  INT NOT NULL AUTO_INCREMENT,
  domainname char(64) DEFAULT '' NOT NULL,
  mail_list  char(64) DEFAULT '' NOT NULL,
  maintainer char(64) DEFAULT '' NOT NULL,
  control_address char(64) DEFAULT '',
  PRIMARY KEY (id)
);

これを domain テーブルに突っ込んでみやう

# cat add_domain.sql
INSERT INTO domain (domainname)
VALUES ('fml.org')
# cat add_domain.sql | mysql ML
# mysqlshow -u root ML domain
Database: ML  Table: domain  Rows: 1
+------------+----------+------+-----+---------+----------------+
| Field      | Type     | Null | Key | Default | Extra          |
+------------+----------+------+-----+---------+----------------+
| id         | int(11)  |      | PRI | 0       | auto_increment |
| domainname | char(64) |      |     |         |                |
+------------+----------+------+-----+---------+----------------+

次に ml テーブルに突っ込んでみます。

# cat add_ml.sql
INSERT INTO ml (domainname, mail_list, maintainer, control_address)
VALUES ('fml.org', 'elena', 'elena-admin', 'elena-ctl'),
	('fml.org', 'mirei', 'mirei-admin', 'mirei-ctl')
# cat add_ml.sql |mysql ML
# mysqldump ML |tail -3
  PRIMARY KEY (id)
);

#
# Dumping data for table 'ml'
#

INSERT INTO ml VALUES (1,'fml.org','elena','elena-admin','elena-ctl');
INSERT INTO ml VALUES (2,'fml.org','mirei','mirei-admin','mirei-ctl');

そして、確かめる。

mysql> select * from ml
    -> go
+----+------------+-----------+-------------+-----------------+
| id | domainname | mail_list | maintainer  | control_address |
+----+------------+-----------+-------------+-----------------+
|  1 | fml.org    | elena     | elena-admin | elena-ctl       |
|  2 | fml.org    | mirei     | mirei-admin | mirei-ctl       |
+----+------------+-----------+-------------+-----------------+
2 rows in set (0.00 sec)

Prev	Home	Next
MySQL に新しいデータベース ML を作る	Up	libtransparency (透過モード用の関数)