Created
October 15, 2010 06:24
-
-
Save chobie/627722 to your computer and use it in GitHub Desktop.
Doctrine2のsandboxでMysqlにテーブルつくってGuilhermeを20件$em->flush()した時のMysqlのログ
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
101015 15:23:10 104 Connect root@localhost on moemoe | |
104 Query CREATE TABLE addresses (id INT AUTO_INCREMENT NOT NULL, street VARCHAR(255) NOT NULL, PRIMARY KEY(id)) ENGINE = InnoDB | |
104 Query CREATE TABLE users (id INT AUTO_INCREMENT NOT NULL, address_id INT DEFAULT NULL, name VARCHAR(50) NOT NULL, UNIQUE INDEX users_address_id_uniq (address_id), PRIMARY KEY(id)) ENGINE = InnoDB | |
104 Query ALTER TABLE users ADD FOREIGN KEY (address_id) REFERENCES addresses(id) | |
104 Quit | |
101015 15:23:12 105 Connect root@localhost on moemoe | |
105 Query START TRANSACTION | |
105 Query INSERT INTO users (name, address_id) VALUES ('Guilherme', NULL) | |
105 Query INSERT INTO users (name, address_id) VALUES ('Guilherme', NULL) | |
105 Query INSERT INTO users (name, address_id) VALUES ('Guilherme', NULL) | |
105 Query INSERT INTO users (name, address_id) VALUES ('Guilherme', NULL) | |
105 Query INSERT INTO users (name, address_id) VALUES ('Guilherme', NULL) | |
105 Query INSERT INTO users (name, address_id) VALUES ('Guilherme', NULL) | |
105 Query INSERT INTO users (name, address_id) VALUES ('Guilherme', NULL) | |
105 Query INSERT INTO users (name, address_id) VALUES ('Guilherme', NULL) | |
105 Query INSERT INTO users (name, address_id) VALUES ('Guilherme', NULL) | |
105 Query INSERT INTO users (name, address_id) VALUES ('Guilherme', NULL) | |
105 Query INSERT INTO users (name, address_id) VALUES ('Guilherme', NULL) | |
105 Query INSERT INTO users (name, address_id) VALUES ('Guilherme', NULL) | |
105 Query INSERT INTO users (name, address_id) VALUES ('Guilherme', NULL) | |
105 Query INSERT INTO users (name, address_id) VALUES ('Guilherme', NULL) | |
105 Query INSERT INTO users (name, address_id) VALUES ('Guilherme', NULL) | |
105 Query INSERT INTO users (name, address_id) VALUES ('Guilherme', NULL) | |
105 Query INSERT INTO users (name, address_id) VALUES ('Guilherme', NULL) | |
105 Query INSERT INTO users (name, address_id) VALUES ('Guilherme', NULL) | |
105 Query INSERT INTO users (name, address_id) VALUES ('Guilherme', NULL) | |
105 Query INSERT INTO users (name, address_id) VALUES ('Guilherme', NULL) | |
105 Query commit | |
105 Quit |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment