This MySQL cheat sheet is designed to act as a reminder and reference sheet, listing useful information about MySQL. It includes a list of the available functions in MySQL, as well as data types. It also includes a list of MySQL functions available in PHP, and a list of useful sample queries to select data [...]
This is a fast, easy-to-use Mac database management application for working with MySQL databases. Whether you are a Mac Web Developer, Programmer or Software Developer your workflow will be streamlined with a native Mac OS X application! This application gives you direct access to your MySQL databases on local and remote servers. Sequel Pro is [...]
If you often run into the problem where MySQL database that you are trying to import is just too large to import via the PHPMyAdmin web interface and you get script execution timeout then this is the solution for you. This simple to use script imports only a small part of the huge dump file [...]
This Apache database solution is the right choice when you need scalability and high availability without compromising performance. Linear scalability and proven fault-tolerance on commodity hardware or cloud infrastructure make it the perfect platform for mission-critical data. Cassandra’s support for replicating across multiple datacenters is best-in-class, providing lower latency for your users and the peace [...]
MySQL is the world’s most popular open source database. This is a useful list of handy MySQL commands for everyday use. Connect to SQL server: Create a new SQL database:
How to convert MySQL tables to utf8 encoding format? Solution: If you already have MySQL database dump containing characters written in some other character encoding type the solution would be this: This forces MySQL to convert the binary format into varchar using character set utf8.