Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

what if I delete information_schema database from mySQL?

Tags:

sql

mysql

I'm curious to know, "what if I delete information_schema database from mySQL?"

like image 912
PPShein Avatar asked Oct 20 '10 05:10

PPShein

1 Answers

Nothing. It is a bunch of views, not a real tables.

http://dev.mysql.com/doc/refman/5.1/en/information-schema.html

So you cannot use data modification queries on it.

like image 151
zerkms Avatar answered Oct 13 '22 14:10

zerkms
Sign in to Comment

Related questions

How to subtract 2 dates in oracle to get the result in hour and minute
'No database channel is available'
django: select_related() on an already-existing object?
How do I reconstruct a historical view?
Timeout Expired on SQL Azure; cannot be reproduced on-premise SQL Server [closed]
What's the difference between @CascadeOnDelete and CascadeType.REMOVE annotations?
Get rows product (multiplication)
MySQL Error Code: 1205. Lock wait timeout during update with inner join
CTE for parent child relation with multiple parent
Hibernate is 1000 times slower than sql query
SQL Server multiple REPLACE with #temp table
SQL View timing out used by .NET Application
Consuming web services from Oracle PL/SQL
What is the syntax to use a Select statement inside a PL/SQL Trigger?
How do i backup a SQL database using PHP?
Maintaining subclass integrity in a relational database
SSRS - Keep a table the same width when hiding columns dynamically?
Designing archive in database. Some patterns maybe?
How to know when to use indexes and which type?
Stop MySQL Reusing AUTO_INCREMENT IDs

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!