O'Reilly logo

MySQL Management and Administration with Navicat by Gokhan Ozar

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Entering data in tables

Now that we have built the basis for our database, we’d better enter some data in our tables. To open a table for data entry, simply double-click on it.

Navicat provides two ways of data entry in tables: one of them is using the Grid View, which is predictably the most common way of entering data just like you would do in a spreadsheet.

Just click on a cell to start entering the data, and when you’re done with it, you can press the Tab key to move on to the next cell or click on anywhere outside the active cell. Fields with foreign key constraints will contain a small square button for selecting data from a drop-down list, which will present data items from the field of the table to which it has reference(s). In our case, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required