Home
PHP
MySQL
Laravel
WordPress
Magento 2
CodeIgniter
YII
HTML
CSS
JavaScript
jQuery
Python
Java
SQL
Interview Q

PHP Tutorial

PHP Tutorial Install PHP PHP Code PHP Echo PHP Print PHP Echo vs Print PHP Variable PHP Variable Scope PHP $ and $$ PHP Constants PHP Magic Constants PHP Data Types PHP Operators PHP Comments

Control Statement

PHP If else PHP Switch PHP For Loop PHP foreach loop PHP While Loop PHP Do While Loop PHP Break PHP Continue

PHP Programs

20 PHP Programs

PHP Functions

PHP Functions Parameterized Function PHP Call By Value PHP Call By Reference PHP Default Arguments PHP Variable Arguments PHP Recursive Function

PHP Arrays

PHP Array PHP Indexed Array PHP Associative Array Multidimensional Array PHP Array Functions

PHP Strings

PHP String PHP String Functions

PHP Math

PHP Math Functions

PHP Form

PHP Form: Get Post

PHP Include

PHP include & require

State Management

PHP Cookie PHP Session

PHP File

PHP File Handling PHP Open File PHP Read File PHP Write File PHP Append File PHP Delete File

Upload Download

PHP File Upload PHP Download File

PHP Misc

PHP Mail

PHP MySQLi

MySQLi CONNECT MySQLi CREATE DB MySQLi CREATE Table MySQLi INSERT MySQLi UPDATE MySQLi DELETE MySQLi SELECT MySQLi Order by

PHP JSON

PHP JSON Example

PHP OOPs Concepts

OOPs Concepts OOPs Abstract Class OOPs Abstraction OOPs Access Specifiers OOPs Const Keyword OOPs Constructor OOPs Destructor Abstract vs Class vs Interface Encapsulation Final Keyword OOPs Functions OOPs Inheritance OOPs Interface OOPs Overloading OOPs Type Hinting

PHP Topics

Compound Types PHP Float PHP Integer is_null() Function PHP Boolean Special Types Inheritance Task Special Types PHP Encryption Two-way Encryption Heredoc Syntax

PHP MCQ

Interview Questions

PHP Interview WordPress Interview Joomla Interview Drupal Interview

next → ← prev

PHP MySQL Create Table

PHP mysql_query() function is used to create table. Since PHP 5.5, mysql_query() function is deprecated. Now it is recommended to use one of the 2 alternatives.

mysqli_query()
PDO::__query()

PHP MySQLi Create Table Example

Example

<?php
$host = 'localhost:3306';
$user = '';
$pass = '';
$dbname = 'test';

$conn = mysqli_connect($host, $user, $pass,$dbname);
if(!$conn){
  die('Could not connect: '.mysqli_connect_error());
}
echo 'Connected successfully<br/>';

$sql = "create table emp5(id INT AUTO_INCREMENT,name VARCHAR(20) NOT NULL,
emp_salary INT NOT NULL,primary key (id))";
if(mysqli_query($conn, $sql)){
 echo "Table emp5 created successfully";
}else{
echo "Could not create table: ". mysqli_error($conn);
}

mysqli_close($conn);
?>

Output:

Connected successfully
Table emp5 created successfully

Next TopicPHP MySQL Insert Record

← prev next →

For Videos Join Our Youtube Channel: Join Now

Feedback

Send your Feedback to [email protected]

Help Others, Please Share

Learn Latest Tutorials

Splunk

SPSS

Swagger

Transact-SQL

Tumblr

ReactJS

Regex

Reinforcement Learning

R Programming

RxJS

React Native

Python Design Patterns

Python Pillow

Python Turtle

Keras

Preparation

Aptitude

Reasoning

Verbal Ability

Interview Questions

Company Questions

Trending Technologies

Artificial Intelligence

AWS

Selenium

Cloud Computing

Hadoop

ReactJS

Data Science

Angular 7

Blockchain

Git

Machine Learning

DevOps

B.Tech / MCA

DBMS

Data Structures

DAA

Operating System

Computer Network

Compiler Design

Computer Organization

Discrete Mathematics

Ethical Hacking

Computer Graphics

Software Engineering

Web Technology

Cyber Security

Automata

C Programming

C++

Java

.Net

Python

Programs

Control System

Data Mining

Data Warehouse

^{Like/Subscribe us for latest updates or newsletter}

Learn Tutorials

Learn Java Learn Data Structures Learn C Programming Learn C++ Tutorial Learn C# Tutorial Learn PHP Tutorial Learn HTML Tutorial Learn JavaScript Tutorial Learn jQuery Tutorial Learn Spring Tutorial

Interview Questions

Java Interview Questions SQL Interview Questions Python Interview Questions JavaScript Interview Questions Angular Interview Questions Selenium Interview Questions Spring Boot Interview Questions HR Interview Questions C++ Interview Questions Data Structure Interview Questions

About

Javatpoint is developed to help students on various technologies such as Artificial Intelligence, Machine Learning, C, C++, Python, Java, PHP, HTML, CSS, JavaScript, jQuery, ReactJS, Node.js, AngularJS, Bootstrap, XML, SQL, PL/SQL, MySQL etc.

Javatpoint provides tutorials with examples, code snippets, and practical insights, making it suitable for both beginners and experienced developers.

There are also many interview questions which will help students to get placed in the companies.

Contact

Address: G-13, 2nd Floor, Sec-3

Noida, UP, 201301, India

Contact No: 0120-4256464, 9990449935

PHP Tutorial

Control Statement

PHP Programs

PHP Functions

PHP Arrays

PHP Strings

PHP Math

PHP Form

PHP Include

State Management

PHP File

Upload Download

PHP Misc

PHP Mail

PHP MySQLi

PHP JSON

PHP OOPs Concepts

PHP Topics

PHP MCQ

Related Tutorials

Interview Questions

PHP MySQL Create Table

PHP MySQLi Create Table Example

Feedback

Help Others, Please Share

Learn Latest Tutorials

Preparation

Trending Technologies

B.Tech / MCA