Essays /

Writing Sql Statement Essay

Essay preview

MySQL – Creating Databases and Tables
1. 2. Select Start -> MySQL -> MySQL Server 5.1 -> MySQL Command Line Client. Enter password to access the MySQL server. The password is specified when MySQL is installed. 3. Type CREATE DATABASE mydatabase to create the database.


Type USE mydatabase; to inform the system that all SQL commands that follow is using mydatabase. If database is found, the system will respond with: Database changed

5. 6. 7.

Copy the create_table.sql script file to c:\script. Open the file in text editor to view the sql statement. Type source c:\script\create_table.sql to create the ...

Read more


0 0.08 1 111123a 2 3 333123c 4 5 5.1 6 7 8 91112345 91234123 91234564 access address affect ang answer c chang check client column column1 column2 column3 command condit copi correct creat create_table.sql data databas describ detail differ display easi editor end enter error explain field file first fname follow form found friend general get id incorrect inform insert insert_friends.sql instal kio last life like line make mani mei mio mydatabas mysql name need null number ok open oper order otherwis password pathnam phone popul queri record rememb respond retriev road row run script sec select separ server set sourc specifi sql start statement system tabl tan text tri type updat use valu value1 value2 value3 view whose write wrong