Running SQL queries on a database with phpMyAdminThis video assumes you've already logged in to phpMyAdmin.Now let's learn how to run SQL queries on a database.First, select the database you want to run a query on...As demonstrated in another video, you can delete (or drop) a field from a table by selecting it...... then clicking the Drop icon.In this video however, we're going to demonstrate how to delete this field using pure SQL commands.Click the database name, then click the SQL tab.Type the SQL command to delete the address field, then click Go.That's it! The SQL command has been executed successfully.The address field is no longer in our database table.You can also click the SQL tab directly from the table view (instead of from the database view which is what we did).Doing so presents an SQL query window that is partially filled in.For more information on learning about SQL query syntax, visit the MySQL documentation page.This is the end of the tutorial. You now know how to run SQL queries on a database with phpMyAdmin.
Searching through a database with phpMyAdminThis video assumes you've already logged in to phpMyAdmin.Now let's learn how to use the search feature.First, select the database you want to search...... then click the Search tab.Let's search the name field for the name John, using the percent sign (%) before and after our search term, as a wildcard.This means that phpMyAdmin will search for any data containing the word john, even if it has text before or after it.When ready, click Go.That's it! Our search query returned one result, and the term we searched for is highlighted here.From here we can edit, copy or delete the data... whatever the reason was that we needed to search for teh data in the first place.This is the end of the tutorial. You now know how to use the search feature in phpMyAdmin.
Creating a table in a database with phpMyAdminThis video assumes you've already logged in to phpMyAdmin.Now let's learn how to create a table within a database.First, select the database in which you want to create a table.Enter a name for the table.Enter the number of fields this table is to have, then click Go.Next, enter the details for each field including a name and field type.Let's make this first field the Primary Key, and we'll click here to make it Auto_Increment.The remaining fields will be character fields. Be sure the length is set long enough to accomodate the field values.When finished, click Save.That's it! Our new table has been created within our database.This is the end of the tutorial. You now know how to create database tables with phpMyAdmin.
Netway Tutorial วีดิโอแนะนำผลิตภัณฑ์ phpMyAdmin เพื่อช่วยตอบทุกข้อสงสัย และแนะนำวิธีการใช้ที่ง่ายเพื่อความสะดวกรวดเร็วสำหรับคุณ หากท่านต้องการสอบถามข้อมูลเพิ่มเติมด้านผลิตภัณฑ์สามารถติดต่อได้ที่ 02-055-1095หรืออีเมล support@netway.co.th
Becoming familiar with databases and phpMyAdminThis video assumes you've already logged in to phpMyAdmin.Now let's familiarize ourselves with databases and phpMyAdmin.phpMyAdmin allows us to have complete access to the MySQL databases in our account.The databases are listed here in the left pane.Databases consist of one or more tables, and it is within these tables that database information (or data) is stored.This particular database has one table, and it's called details.When we click on a database name in the left pane, we can see more information about the tables within the database in the right pane.We can browse a table to see the individual records...... we can see the structure of a table and perform certain actions...... we can search through a table for specific keywords...... we can insert new rows (or fields) into a table...... we can delete the contents of a table...... or we can delete (or drop) an entire table altogether.We can alternatively click the Structure tab to view the database structure...... click the SQL tab if we want to enter direct queries to the database...... click the Search tab to perform a search...... Import or export databases or tables...... and several other operations.Now let's take a closer look at the details table. Click the table name in the left pane, then click the Structure tab.The structure of a table lists all teh table's fields, along with the type of fields and other information.We can also see which field within the table is the Primary Key field.If you ever need additional help, you can access either phpMyAdmin or MySQL documention by clicking the appropriate help icon here.Click the Home icon to return to the home page of your phpMyAdmin.This is the end of the tutorial. You should now be more familiar with databases, and how to use phpMyAdmin to access them.
Netway Tutorial วีดิโอแนะนำผลิตภัณฑ์ phpMyAdmin เพื่อช่วยตอบทุกข้อสงสัย และแนะนำวิธีการใช้ที่ง่ายเพื่อความสะดวกรวดเร็วสำหรับคุณ หากท่านต้องการสอบถามข้อมูลเพิ่มเติมด้านผลิตภัณฑ์สามารถติดต่อได้ที่ 02-055-1095หรืออีเมล support@netway.co.th
Inserting fields into database tables with phpMyAdminThis video assumes you've already logged in to phpMyAdmin.Now let's learn how to insert fields in a database table.First, select the database where the table exists...... then click the table where you want to insert the new field.Click the Structure tab.Choose how many fields to add, and where in the table they should be added.Click Go.Enter the name, type and length of the new field, then click Save.That's it! Our table now has a new field in it, as you can see here.This is the end of the tutorial. You now know how to insert new fields into database tables with phpMyAdmin.
Netway Tutorial วีดิโอแนะนำผลิตภัณฑ์ phpMyAdmin เพื่อช่วยตอบทุกข้อสงสัย และแนะนำวิธีการใช้ที่ง่ายเพื่อความสะดวกรวดเร็วสำหรับคุณ หากท่านต้องการสอบถามข้อมูลเพิ่มเติมด้านผลิตภัณฑ์สามารถติดต่อได้ที่ 02-055-1095หรืออีเมล support@netway.co.th
.png "Microsoft Visio")
.png "VMware")
