HOME | PHP Tutorial | CSS
facebook icon
AgerNic.com
WEB DEVELOPER SITE, HTML, CSS, PHP
HTML Tutorial

CSS Tutorial

SQL - CREATE Database


SQL CREATE DATABASE is used to create a new SQL database.

SQL CREATE DATABASE - example


Syntax: The basic syntax of the SQL CREATE DATABASE;
CREATE DATABASE YourDataBaseName;

Example 1: Your database named as Customers
CREATE DATABASE Customers;
GO
USE mydb;
GO
CREATE TABLE mydb.dbo.Customers
(
ID INT ,
FirstName VARCHAR(255) ,
LastName VARCHAR(255),
);

Note: Make sure you have admin privilege before creating any database, then, you can check it in the list of databases with the following SQL command: SHOW DATABASES;

sql create database, table, view, index, function, procedure SQL CREATE DATABASE - example - sql tutorial

3289. SQL create table primary key autoincrement, sql tutorial
SQL create table primary key autoincrement sql tutorial
https://www.agernic.com/sql-tutorial/sql-create-table-primary-key-autoincrement.html

2581. SQL ORDER BY - SQL Tutorial

http://www.sql-tutorial.net/SQL-ORDER-BY.asp

2575. SQL IN - SQL Tutorial

http://www.sql-tutorial.net/SQL-IN.asp

3293. SQL update - SQL update select, sql tutorial
SQL update - SQL update select sql tutorial
https://www.agernic.com/sql-tutorial/sql-update-sql-update-select.html

2564. SQL AND & OR - SQL Tutorial

http://www.sql-tutorial.net/SQL-AND-OR.asp

2565. SQL AVG - SQL Tutorial

http://www.sql-tutorial.net/SQL-AVG.asp

Your add here
How to get PHP errors to display?
How to prevent sql injection in php mysqli
How do I get PHP errors to display - PHP error_reporting()
mysql_query(): The mysql extension is deprecated and will be removed i
Function eregi_replace() is deprecated in php - How to fix
PHP delete an element from an array
Uncaught Error: Call to undefined function MYSQL_NUM_ROWS() in
Deprecated: mysql_connect() mysql extension is deprecated and will be
mysqli_fetch_array() expects parameter 1 to be mysqli_result boolean g
SQL IN Operator - example
SQL BETWEEN Operator
SQL like syntax and example
SQL WHERE AND & OR multiple conditions
SQL create table primary key autoincrement
PHP mysqli_connect () Function
SQL COUNT(), AVG() and SUM() Functions
Display data from SQL database with MySQLi into php - html table
SQL CREATE DATABASE - example
SQL mysql order by columns, by date, by asc, by desc, random with PHP
PHP mysqli_query() Function - mysqli query
SQL delete row - SQL delete table
SQL update - SQL update select
Insert into SQL - Insert into table SQL - Insert data in sql
Login in PHP - simple login script with PHP MYSQL