Mysql Knowledge Points Summary

1. Create a database Mysqladmin

The following is a simple example of creating a database named YIIBAI_TUTORIALS1. D:\software\mysql-5.6. -winx64\bin> mysqladmin-u root-p create yiibaienter Password:< enter > or D:\software\ MySQL-5.6. -winx64\bin> mysql-u root-p Enter password:mysql>create database Yiibai;

Use PHP script to create Database mysql_query () bool mysql_query(SQL, Connection );

PHP$dbhost= ' localhost:3036 ';$dbuser= ' Root ';$dbpass= ' ';$conn=mysql_connect($dbhost,$dbuser,$dbpass);if(!$conn ){   die(' Could not connect: '.Mysql_error());}Echo' Connected successfully<br/> ';$sql= ' CREATE DATABASE yiibai ';$retval=mysql_query($sql,$conn );if(!$retval ){   die(' Could not create database: '.Mysql_error());}Echo"Database Yiibai created successfully\n";Mysql_close($conn);?>
</body>
2. Build tables CREATE TABLE table_name (column_name column_type);
CREATE TABLE emp (    int,    ename varchar (),    int ,    job varchar ());
2.
Mysql Knowledge Points Summary