Query all columns (attributes) for every row in the CITY table.

Query all columns (attributes) for every row in the CITY table. Input FormatThe CITY table is described as follows: Ansewer Explanation The SELECT statement is used to retrieve records from one or more tables in your SQL database. If we want to retrieve all data, use * ( The asterisk or star symbol ( * ) means all columns). BrijBrijpal Sharma is … Read more

[Solved] Error: Apache Shutdown Unexpectedly

Error Apache Shutdown Unexpectedly

Friends, this error often comes while using XAMPP. So that we are not able to open XAMPP and the database is not accessible. In this post, I am going to share a simple method that always helps me and I hope that will help you. Step 1: Rename mysql/data First, you have to rename the … Read more

Fix XAMPP server error Xampp-control.ini Access is denied

In this blog, we fix XAMPP server error xampp-control.ini Access is denied in an easy method. This issue arrives when you want to close your XAMPP serve mostly. but if you open your XAMPP serve as an administrator this issue will not arrive. so in this blog post we learn how to set XAMPP as … Read more

Import Large CSV file into MySQL PHP [load data infile mysql]

Import Large CSV file into MySQL

In this blog, we Import a Large CSV file into MySQL by PHP using load data Infile MySQL. some time we required to upload large files such as up to 100MB. So this is a very simple load data in file method to import a large CSV file data into the database. I use here PHP language … Read more