Writing D:/inetpub/webs/vincenzodevivocom/wiki/data/cache/4/4db3eaaf22b0768053d73a3d38c710b8.i failed
Unable to save cache file. Hint: disk full; file permissions; safe_mode setting.
Writing D:/inetpub/webs/vincenzodevivocom/wiki/data/cache/4/4db3eaaf22b0768053d73a3d38c710b8.i failed
Unable to save cache file. Hint: disk full; file permissions; safe_mode setting.
Writing D:/inetpub/webs/vincenzodevivocom/wiki/data/cache/4/4db3eaaf22b0768053d73a3d38c710b8.xhtml failed

Empty a relational database schema

Execute:

SELECT concat('truncate ',table_schema,'.',table_name,';') AS sql_stmt
FROM information_schema.TABLES
WHERE table_schema = 'sakila'
AND table_type = 'base table';

Execute:

SET foreign_key_checks = 0;
<<Copy/Paste previous results>>
SET foreign_key_checks = 1;
 
code/sql/empty_a_relational_database_schema.txt · Last modified: 2014/07/17 10:12 by Vincenzo De Vivo
 
Recent changes RSS feed Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki