1 / 10

MySQL Quick Guide

MySQL Quick Guide. Start and End MySQL. MySQL is installed as a service. To start MySQL: Control Panel/Administrative Tools/Services/MySQL/ start MySQL Administrator MySQL Query Browser MySQL Command Line Client To stop MySQL: Control Panel/Administrative Tools/Services/MySQL/ Stop; Or

edith
Download Presentation

MySQL Quick Guide

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MySQL Quick Guide

  2. Start and End MySQL • MySQL is installed as a service. • To start MySQL: • Control Panel/Administrative Tools/Services/MySQL/ start • MySQL Administrator • MySQL Query Browser • MySQL Command Line Client • To stop MySQL: • Control Panel/Administrative Tools/Services/MySQL/ Stop; Or • MySQL Administrator/Services Control/Stop

  3. Creating and Use a Database • CREATE DATABASE mydb; • USE mydb

  4. Show • SHOW DATABASES • Show all databases • SHOW TABLES • List all tables in the default database • SHOW COLUMNS FROM tableName • List all columns in a given table.

  5. Editing SQL Commands • MySQL stores the most recent command. We can edit the command as follow: • Use the Up, Down arrow key to select and correct the command, then press Enter.

  6. Creating Command Files • Use a text editor to create a file with SQL commands and save it with extension .txt • To run the command file: • SOURCE commandFileName.txt • Ex: mysql> source c:\MySQLCommand.txt

  7. MySQL Query Browser • Schemata • Select a database schema to be the default database • To create/delete a schema: • Point to any schema and right click, then choose create/delete schema • To create a new script: • File/New Script Tab • To open a script: • File/New Script

  8. SQL Server Quick Guide

  9. To Start/End SQL Server • To start SQL Server service:SQL Server Configuration manager • All programs/MS SQL Server/Configuration tools/SQL Sever Configuration Manager/SQL Server 2005 Services/SQL Server • Login to the server: • All programs/MS SQL Server/SQL Server Management Studio Express

  10. Management Studio Express • Object Explorer • Databases • System databases • To create a new database: • Point to the Databases folder icon and right click, then choose New database • Tool Bar: • New Query • Available databases drop-down list

More Related