MySql Tutorials, Guides & Tools

Toad for MySQL – Database Management and Development tool

Toad for MySQL is a Database Management and Development tool. Toad for MySQL is used to quickly and efficiently create and execute queries, automate database object management, and develop SQL code. Toad MySQL provides utilities to compare, extract, and search for objects. The MySQL tool also enables you to record and play back keyboard commands, […]

How to import a database using PHPMyAdmin

How to import a database using PHPMyAdmin, before importing database you need to have database file which will be imported in other web server. First create a database and select that database, after that you can see list of tabs on top, click on import under “File to Import:” select the sql file or compressed […]

How to export a database using PHPMyAdmin

How to export a database using PHPMyAdmin, If you are using PHPMyAdmin and want to export a database then navigate to PHPMyAdmin in hosting control panel or in localhost. Login to PHPMyAdmin and select the database which you want to export from left side column, after selecting database then it will show all the tables. […]

Get the last insert query id in PHP

Get the last insert query id in PHP after performing a query on a table, this is useful if you want to insert one form data into two different tables and want to reference the first table id in second table. first we will insert in one table and after that we will get the […]

Creating Multistep form processing using PHP

Here we are Creating Multistep form processing using PHP. We are Creating Multistep form processing using PHP by using the sessions, in each step we are storing the data in sessions. We are generating sql query directly from data that is stored in sessions.

Import CSV File Data Using MySql And PHP

This is simple code to Import CSV file data using MySql and PHP, Here we are taking the data from the CSV file and inserting it into the database. This is the beginner level code.

How to Import large sql database files into MySql using command line

How to Import large sql database files into MySql, PhpMyAdmin allows us to import sql files into MySQL database, but it has a restriction of up-to 2 Mega Bytes in localhost, what if you want to import an 125 Mega Bytes of SQL file. That’s a huge file but once i have to upload the […]

Archive