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.
Search Results » phpmyadmin
Setting composite primary key 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.
Apply foreign key in phpMyAdmin using database query
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
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:
Using CodeIgniter Transactions to Insert Records in Multiple Tables
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 Shared Hosting Reviews from a Real Experience
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.
3 Ways – Insert Record in Codeigniter If not exists Else Update
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.
55 WordPress Interview Questions and Answers for Experienced – Updated 2020
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.
Moving WordPress Site from Localhost to Live Server
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.
WordPress fix to blank screen or blank page or dashboard
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.
[ Page 1 of 2 ]