![]() Â The first thing you need to do is give your table a name. In order to create a table in your schema you need to click the Create Table button after you have selected the schema you want to work with (see Figure 4). Do this and click OK and you will have an empty schema ready for you to add tables. When you select this a small window will appear asking you to enter a name for your new schema. In order to create a new schema right-click inside of that pane and select Create Schema. In this pane you will see a listing of your current schemata. When the catalogs listing opens (see Figure 3) take a look at the lower left pane. To open up the catalogs window double click on the Catalogs listing in the left pane. The catalogs window is a listing of your current schemata (database collection). In order to create a new schemata you need to first open up the Catalogs window. This window will immediately give you plenty of information about your MySQL connection as well as all the tools you need to work with MySQL. ![]() ![]() ![]() When the connection is made you will find yourself in the MySQL Administrator main window (see Figure 2). Once you enter the information click the Connect button to establish your connection. So the information you need to enter will be similar to what you see in Figure 1. ![]() For this article we will focus on a local connection. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
May 2023
Categories |