15、sql語句集，Linux 下PHP查詢mysql

最後更新：2015-08-28 來源：互聯網

上載者：User

創建阿里雲帳戶，並獲得超過 40 款產品的免費試用版；而企業帳戶則可以享有總值 $1200 的免費試用版。立即註冊！

標籤：

一、mysql 建立資料庫

mysql密碼，預設沒有

如果想更改的話， mysqladmin -uroot   password root123

登入   ： [[email protected] root]#   mysql    -uroot    -proot123

1、建立book資料庫

mysql>   create   database   book;
Query OK, 1 row affected (0.08 sec)

2、授權給 lili 使用者

mysql> grant   all   on   book.*   to   [email protected]   identified   by   "lili123";
Query OK, 0 rows affected (0.06 sec)

mysql> exit
Bye

3、lili登入

建立lili使用者

[[email protected] html]#   mysql   -u   lili    -p
Enter password:       （這裡輸密碼）
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 3.23.54

Type ‘help;‘ or ‘\h‘ for help. Type ‘\c‘ to clear the buffer.

mysql>

4、建立book表，添加資料

mysql> use book;    （先確定要操作的資料庫）
Database changed

5、建立book表

mysql> create   table   book(
    -> id   int   not   null,
    -> name   char(20)   not   null,
    -> primary   key(id)
    -> );
Query OK, 0 rows affected (0.08 sec)

6、添加資料

mysql> insert   into   book   values

    -> (1,"語文"),
    -> (2,"數學"),
    -> (3,"英語");
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0

（注意：上面操作也可以用sql語句集來執行： (好處是，去別的機子也可以執行sql語句集就行，不用從頭打過)

[[email protected] html]# cat > lili.sql
use   book;
create   table   book(
    id   int   not   null,
    name   char(20)   not null,
    primary   key(id)
    );
insert   into book values
     (1,"語文",),
     (2,"數學"),
     (3,"英語");

[[email protected] html]# vi root.sql
create   database   book;
grant   all   on   book.*   to   [email protected]   identified   by   "lili123" ;

[[email protected] html]# mysql   -u   root   -p   <   root.sql
Enter password:

[[email protected] html]# mysql   -u   lili   -p   <   lili.sql
Enter password:

）

7、查詢表

mysql> select   *   from   book;
+----+--------+
| id | name   |
+----+--------+
| 1 | 語文 |
| 2 | 數學 |
| 3 | 英語 |
+----+--------+

退出mysql
mysql> exit;
Bye

二、在 /var/www/html 中建立index.php

[[email protected] html]# vi index.php

<h1><?php   mysql_connect(NULL,"lili","lili123","localhost");   mysql_selectdb("book");   $sql="select * from book";   $res=mysql_query($sql);   while($row=mysql_fetch_row($res)){      print "$row[0] $row[1]<br/>";              }      $a=array("陽光","沙灘","海浪","仙人掌");      for($i=0;$i<4;$i++){        print "$a[$i]<br/>";              }?></h1>

在瀏覽器輸入 http://192.168.170.3/ , 結果如下：

如果想要網格線

<html><title></title><body><h1><?php   mysql_connect(NULL,"lili","lili123","localhost");   mysql_selectdb("book");   $sql="select * from book";   $res=mysql_query($sql);   print (‘<table border=1>‘);   while($row=mysql_fetch_row($res)){     print (‘<tr>‘);     for($i=0;$i<3;$i++){        print "<td>$row[$i]</td>";      }    print (‘</tr>‘);              }     print (‘</table>‘);      $a=array("陽光","沙灘","海浪","仙人掌");       for($i=0;$i<4;$i++){              print "$a[$i]<br/>";                 }?></h1></body></html>

效果如下：

15、sql語句集，Linux 下PHP查詢mysql

本文章原先以中文撰寫並發佈於 aliyun.com，亦設英文版本，僅作資訊用途。本網站不對文章的準確性，完整性或可靠性或其任何翻譯作出任何明示或暗示的陳述或保證。如對該文章有任何疑慮或投訴，請傳送電郵至 info-contact@alibabacloud.com 並提供相關疑慮或投訴的詳細說明。職員會於 5 個工作天內與您聯絡，一經驗證之後，即會刪除該侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

Sales Support

1 on 1 presale consultation

Chat Contact Sales
After-Sales Support

24/7 Technical Support 6 Free Tickets per Quarter Faster Response

Open a Ticket
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

Learn More

15、sql語句集，Linux 下PHP查詢mysql

聯繫我們

A Free Trial That Lets You Build Big!

Sales Support

After-Sales Support