Export Database To export a database, open up the terminal, making sure that you are not logged into MySQL, and execute the below command with database details.
1 |
mysqldump -u [username] -p [database_name] > [database_name].sql |
Full Stack LAMP, MEAN, DevOps Consultant
Export Database To export a database, open up the terminal, making sure that you are not logged into MySQL, and execute the below command with database details.
1 |
mysqldump -u [username] -p [database_name] > [database_name].sql |
Today I would like to show you Ajax login functionality implementation using PHP and MySQL. We gonna use MySQL PDO driver in this tutorial. PDO has a much nicer interface, you will end up being more productive, and write […]
I this post I would like to write about sub queries. A Sub-query is also a query, which is defined under a main query and embedded within the WHERE clause . It always sends a value to its nearest main query. Sub-query […]
In this tutorial, you will learn how to use MySQL IF function. MySQL IF function is one of the MySQL control flow functions that returns a value based on a condition. The IF function is sometimes referred to as IF ELSE […]
You can use either the MySQL UPPER() or LOWER() functions to format columns in your SQL SELECT statements or you can use these functions in conjunction with the other functions to accomplish different types of formatting. […]
Yesterday someone asked me to make a tutorial about Connecting to Database in CodeIgniter Framework. In order to make connection to database in Ci , we need to do only few configuration changes in your database.php config […]
One of my new Project, I need to Display Latest Updates of last 3 days. With MySQL’s date_add we can achieve result, see the below example.
1 2 |
WHERE post_date >= DATE_ADD(CURDATE(), INTERVAL -3 DAY); //SELECT * FROM posts a where post_created >= DATE_ADD(CURDATE(), INTERVAL -3 DAY); |
Data retrieving is vital in Web Applications, so in this post i am going to write about Data Retrieving function in PHP From MySQL Database. There are several options are available to fetch data from MySQL Database Using […]
This post explains, how to prevent the duplicate occurrence in the table and how to deal with already existed duplicate records. we can private duplicate record occurrence in the table with the use of primary key and Unique […]
Today I am gonna write about Nested Menu Categories with Single MySQL Query, Here I will show you how to create a simple nested menu with single Query and Single Table. I am giving inline comments so that you can follow […]