Thank you to anyone who has already donated - your generous donations helped make three months of treatment possible.

My brother Nate continues to fight stage IV Hodgkin's lymphoma. He's just 31, with a wife and baby girl. They have no active income (since he's been unable to return to work), no insurance, and cannot afford the treatment he needs. Nate and his family need your help. Please consider a donation, every dollar helps. Thanks.

Read Nate's story Support Nate by buying an official Pastie t-shirt Hide this message

Document@2x
|
Chain_link@2x
|
Arrow_down@2x
|
Spiral_paper@2x
A A A

Ruby on Rails       Report abuse

connection 1 

1
2
3
4
5
6
7
8
9
10
11
12
13

mysql> create temporary table tmp_foo select * from users;
Query OK, 2 rows affected (0.08 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> select * from tmp_foo;
+---------+----------+---------------------+
| user_id | username | created_date        |
+---------+----------+---------------------+
|       1 | f00      | 2011-03-14 12:39:38 |
|       2 | bar      | 2011-03-14 12:39:38 |
+---------+----------+---------------------+
2 rows in set (0.00 sec)

connection 2 

1
2
3
4
5
6

mysql> select * from tmp_foo;
ERROR 1146 (42S02): Table 'foo_db.tmp_foo' doesn't exist
mysql> drop table tmp_foo;
ERROR 1051 (42S02): Unknown table 'tmp_foo'
mysql>