Articles in the MySQL Category
Here are step-by-step commands about installing apache, php, mysql, and phpmyadmin on ubuntu. 1) Open Terminal – Press: CTRL + ALT + T
This article shows:- – How to add column to mysql database table after the table has already been created – How to delete column from mysql database table after the table has already been created
Some definitions of foreign key:- A FOREIGN KEY in one table points to a PRIMARY KEY in another table. A foreign key is a field in a relational table that matches the primary key of another table. The foreign key can be used to cross-reference tables. A table may have multiple foreign keys, and each [...]
The JOIN keyword is used in an SQL statement to query data from two or more tables, based on a relationship between certain columns in these tables. [@via w3schools] A SQL JOIN clause combines records from two or more tables in a database. It creates a set that can be saved as a table or [...]
Suppose, you have a product collection and you want to filter it by category. Suppose, you want to filter it by more than one category. You can use addCategoryFilter if you have only one category. But, what if you want to filter by more than one category? Category ids are stored for product in a [...]
Before I had posted an article to add, edit, delete, and display contents. I had also included sessions there. There was the facility to login and register users too. But i got feedback that it was a bit complex for novice users of PHP (users who have just started PHPing). It was a kind of [...]
Problem: Concatenate and fetch data from two fields of database and then break it again. Solution:
Here is a simple and complete tutorial to add, edit, delete, login, and register in PHP with MySQL database. The description is present in the code, in comments. I hope those comments are sufficient to describe the code. The database part is in the sql file named ‘database.sql’.
This article shows how to backup and restore single & multiple databases and tables in MySQL. 1) Backup single database mysqldump -h hostname –u username –p password database_name > /path/backup.sql
Problem: “Fails to start the service. Please wait 30 seconds to try again.” I faced this problem 2 years back when I was a newbie to MySQL. I was just starting to learn PHP and MySQL at that time.
Problem: can’t create pid file: no such file or directory I had this problem and had a very tough and frustrating time with it. While I was installing a fresh copy of MySQL 5 in Windows XP, I got this problem. (I was installing it from the installer i.e. setup file.) The server was not [...]