How to check if mysql database exists
If you just need to know if a db exists so you won’t get an error when you try to create it, simply use (From here):
mysql
select * from table where column = value ^ column2= value
The query would be – Or
How can I rebuild indexes and update stats in MySQL innoDB?
This is done with Read more about it here. ANALYZE TABLE analyzes and stores the key distribution for a table. During the analysis, the table is locked with a read lock for MyISAM, BDB, and InnoDB. This statement works with MyISAM, BDB, InnoDB, and NDB tables.
Dump all tables in CSV format using ‘mysqldump’
I need to dump all tables in MySQL in CSV format. Is there a command using mysqldump to just output every row for every table in CSV format?
mysql community server vs mysql installer
Both will install into same final setup. the web-community is online installer, you need to download to connect to the online server and installations files come from online while the community installer is an offline installer with full features. web-installer (online, need internet connection to complete the installation), community-installer(offline, full).
How to copy a row and insert in same table with a autoincrement field in MySQL?
Use INSERT … SELECT: where c1, c2, … are all the columns except id. If you want to explicitly insert with an id of 2 then include that in your INSERT column list and your SELECT: You’ll have to take care of a possible duplicate id of 2 in the second case of course.
MySQL: Can’t create table (errno: 150)
From the MySQL – FOREIGN KEY Constraints Documentation: If you re-create a table that was dropped, it must have a definition that conforms to the foreign key constraints referencing it. It must have the correct column names and types, and it must have indexes on the referenced keys, as stated earlier. If these are not satisfied, MySQL … Read more
How to delete from multiple tables in MySQL?
Use a JOIN in the DELETE statement. Alternatively you can use… …to delete only from pets_activities See this. For single table deletes, yet with referential integrity, there are other ways of doing with EXISTS, NOT EXISTS, IN, NOT IN and etc. But the one above where you specify from which tables to delete with an … Read more
importing a CSV into phpmyadmin
In phpMyAdmin, click the table, and then click the Import tab at the top of the page. Browse and open the csv file. Leave the charset as-is. Uncheck partial import unless you have a HUGE dataset (or slow server). The format should already have selected “CSV” after selecting your file, if not then select it … Read more
What is the easiest way to clear a database from the CLI with manage.py in Django?
If you don’t care about data: Best way would be to drop the database and run syncdb again. Or you can run: For Django >= 1.5 For Django < 1.5 (you can add –no-input to the end of the command for it to skip the interactive prompt.) If you do care about data: From the docs: syncdb will only … Read more