auto increment

Some of the Best Practices For Using MySQL Index

The table used in this case is a user subscription table. Generally this table keeps records of users’ subscription details: which topic they subscribed, when they last viewed their topics subscribed, who last replied a topic and when, when a default subscription will be expired (not used currently). Formerly we  wanted to use multiple tables. [...]

How to authenticate users against your Apache website by using MySQL

This tutorial will explain how to use a MySQL backend in order to authentication users against your Apache website. To achieve this we will use Apache2 and its auth_mysql module. Here, we will assume that you already have a website configured, up and running and that you also have access to a mysql server. The [...]

How to View Your MySQL Database’s Table Structure

The describe command gives you a list of all the data fields used in your database table. In the example, you can see that the table named test in the salesdata database keeps track of four fields: name, description, num, and date_modified.