Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
What Happens to MEMORY Tables When MySQL Server Is Stopped
What Happens to MEMORY Tables When MySQL Server Is Stopped? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB
✍: FYIcenter.com
If you have data rows stored in a table with the MEMORY storage engine, and the MySQL server has been shutdown by the DBA, all data rows will be removed. But the table structure will remain in the server.
The tutorial exercise below shows you a good example of using MEMORY tables:
>cd \mysql\bin\mysql -u dev -piyf fyi mysql> INSERT INTO fyi_memory (id) VALUES (-1); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO fyi_memory (id, count) VALUES (-2, 987); Query OK, 1 row affected (0.01 sec) mysql> SELECT * FROM fyi_memory; +----+-------+-------+ | id | title | count | +----+-------+-------+ | -1 | NULL | NULL | | -2 | NULL | 987 | +----+-------+-------+ 2 rows in set (0.00 sec) mysql> quit; >\mysql\bin\mysqladmin -u root -pretneciyf shutdown >\mysql\bin\mysqld-max >\mysql\bin\mysql -u dev -piyf fyi mysql> SELECT * FROM fyi_memory; Empty set (0.00 sec)
2007-05-10, 5148👍, 0💬
Popular Posts:
How to reduce the final size of an executable file? Size of the final execuatable can be reduced usi...
What will be printed as the result of the operation below: main() { char s1[]="Cisco"; char s2[]="sy...
How does multi-threading take place on a computer with a single CPU? The operating system's task sch...
How To Process Query Result in PL/SQL? - Oracle DBA FAQ - Introduction to PL/SQL You can run queries...
What is difference between SITP and UTP in testing ? UTP (Unit Test Plan) are done at smallest unit ...