thearchitectureofweb-basedapplications-資料下載頁
2024-09-29 19:55本頁面
【導(dǎo)讀】法操作資料庫，查詢排序等等…目前與MySQL完全相容。列出所有資料庫名稱。列出資料表的欄位設(shè)定。
【正文】 ++++ 1 row in set ( sec) mysql delete from test where birth=39。1985040439。 Query OK, 1 row affected ( sec) mysql select * from test。 Empty set ( sec) Using PHPMyAdmin ? A webbased utility to manage MySQL database ? Main functions – Create/Drop Database – Create/Modify/Drop Table – Execute SQL – Import/Export data ? Precondition: – An MySQL service is installed and up – An PHP enabled HTTP service is installed and up – An copy of PHPMyadmin is installed in an accessible web directory ? Usage: – Browsing to the PHPmyadmin directory – Click, click, and click Exercise 1 ? Install Apache, MySQL, PHP, and PhpMyAdmin in your puter ? Make a “Hello World” HTML page in the document root of Apache Exercise 2 ? Design necessary table(s) and fields to store the contact list of your classmates. ? Use PHPMyadmin to create a database with tables for the contact list ? Input some testing data (at least 5 records) ? Execute a selectwhere query by PhpMyadmin 資料匯出匯入 ? 使用 phpMyadmin 的資料匯出功能 , 將資料庫內(nèi)容匯出成 SQL檔 ? 使用 phpMyadmin 的資料匯入功能 , 將 SQL檔匯入出資料庫
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號-1