Author Archives

MySQL – Select Query

The SQL SELECT command is used to fetch data from the MySQL database. You can use this command at...

MySQL – Select Query

The SQL SELECT command is used to fetch data from the MySQL database. You can use this command at...

Create MySQL Tables

To begin with, the table creation command requires the following details − Name of the table Name of the...

Create MySQL Tables

To begin with, the table creation command requires the following details − Name of the table Name of the...

Drop MySQL Tables

It is very easy to drop an existing MySQL table, but you need to be very careful while deleting...

Drop MySQL Tables

It is very easy to drop an existing MySQL table, but you need to be very careful while deleting...

MySQL – Insert Query

To insert data into a MySQL table, you would need to use the SQL INSERT INTO command. You can...

MySQL – Insert Query

To insert data into a MySQL table, you would need to use the SQL INSERT INTO command. You can...

MySQL – Data Types

Properly defining the fields in a table is important to the overall optimization of your database. You should use...

MySQL – Data Types

Properly defining the fields in a table is important to the overall optimization of your database. You should use...

Selecting MySQL Database

Once you get connected with the MySQL server, it is required to select a database to work with. This...

Selecting MySQL Database

Once you get connected with the MySQL server, it is required to select a database to work with. This...

Drop MySQL Database

Drop a Database using mysqladmin You would need special privileges to create or to delete a MySQL database. So,...

Drop MySQL Database

Drop a Database using mysqladmin You would need special privileges to create or to delete a MySQL database. So,...

MySQL – Create Database

Create Database Using mysqladmin You would need special privileges to create or to delete a MySQL database. So assuming...

MySQL – Create Database

Create Database Using mysqladmin You would need special privileges to create or to delete a MySQL database. So assuming...

MySQL – Connection

MySQL Connection Using MySQL Binary You can establish the MySQL database using the mysql binary at the command prompt....

MySQL – Connection

MySQL Connection Using MySQL Binary You can establish the MySQL database using the mysql binary at the command prompt....

MySQL – PHP Syntax

MySQL works very well in combination of various programming languages like PERL, C, C++, JAVA and PHP. Out of...

MySQL – PHP Syntax

MySQL works very well in combination of various programming languages like PERL, C, C++, JAVA and PHP. Out of...