MySQLi – Drop Table
It is very easy to drop an existing MySQL table, but you need to be very careful while deleting any existing table because the data lost will not be recovered…
MySQLi related blog…
MySQLi – Create Table
To begin with, the table creation command requires the following details − Name of the tableName of the fieldsDefinitions for each field Syntax Here is a generic SQL syntax to…
MySQLi – Select Database
Once you get connected with the MySQL server, it is required to select a database to work with. This is because there might be more than one database available with…
MySQLi – Drop Database
Drop a Database using mysqladmin You would need special privileges to create or to delete a MySQL database. So, assuming you have access to the root user, you can create…
MySQLi – Create Database
Create Database Using mysqladmin You would need special privileges to create or to delete a MySQL database. So assuming you have access to the root user, you can create any…
MySQLi – Connection
MySQL Connection Using MySQL Binary You can establish the MySQL database using the mysql binary at the command prompt. Example Here is a simple example to connect to the MySQL server from…
MySQLi – PHP Syntax
MySQL works very well in combination of various programming languages like PERL, C, C++, JAVA and PHP. Out of these languages, PHP is the most popular one because of its…
MySQLi – Introduction
MySQLi is an extension to MySQL API available in PHP and is introduced from PHP 5.0 onwards. It is also known as MySQL improved extension. Motivation behind MySQLi was to…