標籤：could int mysql資料庫 nbsp column roo error 資料 log
1.建立資料庫 mysqladmin
下面是一個簡單的例子，建立名為 yiibai_tutorials1 的資料庫。D:\software\mysql-5.6.25-winx64\bin> mysqladmin -u root -p create yiibaiEnter password:<斷行符號>或D:\software\mysql-5.6.25-winx64\bin> mysql -u root -p Enter password: mysql>create database yiibai;
使用PHP指令碼建立資料庫 mysql_query() bool mysql_query( sql, connection );
<html><head><title>建立MySQL資料庫</title></head><body><?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>
</html>
2.建表 CREATE TABLE table_name (column_name column_type);
create table emp( id int, ename varchar(30), age int, job varchar(20));
2.
Mysql 知識點總結
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
