How to use mysql through cmd
We can use the mysql through cmd by following the simple commands 1.First open the cmd/terminal and go to the root directory by using this
Category : Mysql
How to Connect php with mysql Database
Code for mysql connection with php <?php define('DB_SERVER','localhost'); define('DB_USER','root'); define('DB_PASS' ,''); define('DB_NAME', 'dbname'); $con = mysqli_connect(DB_SERVER,DB_USER,DB_PASS,DB_NAME); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect
MySQL Select Query
A SELECT query can return the data from multiple columns by including the required column names as a comma-separated list in the query. The syntax
MySQL Insert Into
Data can be inserted in to an existing database table with an INSERT INTO query that first specified the table name. The SQL VALUES keyword then
MySQL Altering tables
The format of an existing database table can be changed with an ALTER TABLE query . This query can make a single alteration or specify
MySQL Column Modifiers
Modifiers can optionally be used to further control column content. NOT NULL UNIQUE AUTO_INCREMENT DEFAULT PRIMARY_KEY NOT NULL Insists that each record must include a
MySQL Database and Tables
This tutorial demonstrates how to SQL statement that create MySQL database tables in which to store data. A simple database table look like this :
MySQL Data Type
Data types comes in several forma and sizes, allowing the programmer to create tables suited to the scope of the project. Data Type Description CHAR(size)
MySQLi Procedural Functions
MySQL Improved Extension (MySQLi) provides a Procedural Interface as well as an Object Oriented Interface. In this chapter, we will look into some of the
MySQL PHP Connections
PHP provides three ways to connect with MySQL: MySQL Extension, MySQLi Extension, and PDO. MySQL Extension This was the first method PHP provided to interact