Skip to content

Instantly share code, notes, and snippets.

@chobie
Created October 15, 2010 06:24
Show Gist options
  • Save chobie/627722 to your computer and use it in GitHub Desktop.
Save chobie/627722 to your computer and use it in GitHub Desktop.
Doctrine2のsandboxでMysqlにテーブルつくってGuilhermeを20件$em->flush()した時のMysqlのログ
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