There are 19 posts in the MySQL category. Displaying posts 1 through 10:

CSV to MySQL Queries PHP Function

This function lets you take giant CSV files that are too big for phpMyAdmin and break them up into a manageable size so that they can be processed. » View Post

Log in to MySQL via SSH

Linux | MySQL
How to access your MySQL database from the command line if you're using a shared host. » View Post

Increase phpMyAdmin Upload Size

Detailed steps showing how to modify php.ini so that you can upload bigger files into MySQL through phpMyAdmin. » View Post

Import MySQL Queries from a File Too Big for phpMyAdmin

This PHP script will process queries exported by phpMyAdmin (or any other source) from a file that exceeds your maximum file upload size. » View Post

Countries, States, Provinces, and Oceans MySQL Dump

Data Dumps | MySQL
A MySQL data dump of tables containing all countries, U.S. states, Canadian provinces, Mexican states, and oceans. » View Post

Convert State and Country Abbreviations to Names Function

This PHP function makes it super easy and quick to go from an abbreviation to a full state or country name. We include the MySQL data tables you need too. » View Post

All Countries MySQL Database Table

Data Dumps | MySQL
A data dump of the world's countries in MySQL format. Includes names, 2-digit abbreviations, and 3-digit abbreviations. » View Post

Title Sort MySQL Results

Shows you how to sort MySQL results by title, ignoring indefinite and definite articles (a, an, the). » View Post

Convert an Entire MySQL Table to UTF-8

A PHP function (with lots of comments) that converts a MySQL table and its data to UTF-8. It updates the collation of the table itself and of each text-based column. Additionally, it goes through each row and updates existing data automatically. » View Post

List of Latitudes and Longitudes for Every State

Data Dumps | Maps | MySQL
A list of the center latitude and longitude for all fifty of the United States (generated by taking the average latitude and longitude from each zip code within the state). In both HTML table and MySQL format. » View Post
» Next · End · Categories