Difference between revisions of "Creating Databases and Tables Using SQL Commands"
From Techotopia
(New page: In the previous chapter (Creating New Databases and Tables with MySQL Administrator) we created a new database and table using a graphical tool that did not rquire us to use any SQL co...) |
|||
| Line 1: | Line 1: | ||
In the previous chapter ([[Creating New Databases and Tables with MySQL Administrator]]) we created a new database and table using a graphical tool that did not rquire us to use any SQL commands. In this chapter we will learn how to create new databases and tables by issuing SQL commands using the ''mysql'' client. | In the previous chapter ([[Creating New Databases and Tables with MySQL Administrator]]) we created a new database and table using a graphical tool that did not rquire us to use any SQL commands. In this chapter we will learn how to create new databases and tables by issuing SQL commands using the ''mysql'' client. | ||
| − | This chapter assumes that the ''mysql'' tool is running and connected to the the MySQL database server. If this is not the case and you are unsure as to how to achieve this refer to [[The mysql Command-Line Tool]] chapter. | + | This chapter assumes that the ''mysql'' tool is running and connected to the the MySQL database server. If this is not the case and you are unsure as to how to achieve this refer to [[The mysql Command-Line Tool]] chapter. Alternatively, the SQL commands outlined in that chapter may be executed in the [[The MySQL Query Browser | MySQL Query Browser]] |
== Creating a New MySQL Database == | == Creating a New MySQL Database == | ||
Revision as of 15:47, 28 September 2007
In the previous chapter (Creating New Databases and Tables with MySQL Administrator) we created a new database and table using a graphical tool that did not rquire us to use any SQL commands. In this chapter we will learn how to create new databases and tables by issuing SQL commands using the mysql client.
This chapter assumes that the mysql tool is running and connected to the the MySQL database server. If this is not the case and you are unsure as to how to achieve this refer to The mysql Command-Line Tool chapter. Alternatively, the SQL commands outlined in that chapter may be executed in the MySQL Query Browser
