Creating a database in MySQL is a relatively straightforward process. Using the MySQL Workbench GUI to create a databaseīefore creating any tables, you need a database for those tables, so I’ll spend a little time on databases first. All the examples were created in Workbench, which comes with the Community edition. As with the first article, I used the MySQL Community edition on a Windows computer to create the examples for this article. In this article, I focus primarily on how to create, alter, and drop tables, demonstrating how to use both SQL statements and the GUI features in MySQL Workbench. I recommend that you review the first article before launching into this one, if you haven’t done so already. This article is the second in a series on MySQL. Having a solid foundation in tables can also help you build more effective queries so that you’re retrieving the data you need (and only that data), without compromising database performance. The better you understand how to create and modify tables, the easier it will be to manage other database objects and the more effectively you can work with MySQL as a whole. Tables also help to ensure the integrity of that data. Tables lie at the heart of any MySQL database, providing a structure for how data is organized and accessed by other applications. Working with MySQL tables - Simple Talk Skip to content
0 Comments
Leave a Reply. |