In MySQL we might need to auto increment a non primary key field or column in a database table. This might require particularly in cases where we have already set a combination of columns as primary key. So here are steps with images to let you understand how can we make a column as auto increment non primary key column in phpMyAdmin.
Even wonder how to set mix of two or more MySQL database columns/fields as primary key in phpMyAdmin as there is no direct link during creation of table. This articles with tell you the way to setting composite primary key in phpMyAdmin.
If you already have database tables and you just want to apply foreign keys for record on those table then you can apply foreign key in phpMyAdmin using database query also.
I have already written a tutorial ‘Setting up foreign key in phpMyAdmin‘ with example images and I prefer to write database query to set up foreign key in existing database tables as queries allow me to accomplish all required steps in once go.
Setting up foreign key in phpMyAdmin is quite easy. With help of this step by step pictured tutorial, you will be able to set foreign keys within your tables.
Here in the example we have three tables. ‘products’, ‘category’ and ‘product_category’. You can see structures of these tables in the picture below:
There are times when you want to insert records in multiple tables. At the same time, you also want to ensure consistency. CodeIgniter simplifies MySQL transactions to perform Database operations on either all or none basis.
Hostinger is one among a few reputed web hosting companies worldwide. Does Hostinger shared hosting really worth it and should you host your website on their platform? Here, I would like to share my experience and real reviews as I’ve used their product.
There’re 3 ways to insert record in Codeigniter if it doesn’t exist else update the record if it exists. Here we’re using Active Record as well as Query Binding features in Codeigniter to insert or update a record.
This consistently updated series of WordPress Interview Questions and Answers is here. These questions are asked generally from a WordPress developer having around 3 or 5 or more years of experience. However, freshers can also take their expertise at an advanced level with help of these WordPress Interview Questions and Answers.
It’s a good idea to develop a WordPress site locally as it can boost up the speed of development. Moving WordPress site from localhost to live server after finishing the development on localhost isn’t a hard work. This article involves steps to transfer WordPress to web server.
Getting a blank screen or blank page or dashboard under your WordPress powered website? Relax! You are not the single person to face the issue and I have sum up all the possible solutions which will sure help you out to solve the issue.