Collections:
Data Removed in MEMORY Tables in MySQL
What Happens to MEMORY Tables When MySQL Server Is Stopped in MySQL?
✍: FYIcenter.com
If you have data rows stored in a table with the MEMORY storage engine, and the MySQL server has been shut down 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)
⇒ Show Storage Engines Supported in MySQL in MySQL
⇐ Tables Using MEMORY Storage Engine in MySQL
2017-08-08, 1408🔥, 0💬
Popular Posts:
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...