Step‑by‑Step Guide to Creating Databases and Tables in Navicat
This tutorial walks you through logging into Navicat, creating a MySQL database, designing a table with fields and a primary key, inserting sample data, and running a simple SELECT query, all illustrated with screenshots for clear, hands‑on learning.
First, log into Navicat and connect to the MySQL server (example IP 192.168.255.131).
Right‑click the server, choose “New Database”, set the name (e.g., scrapyspider ), charset utf8 , collation utf8_general_ci , and confirm.
The new database appears; open it, right‑click “Tables”, and select “Create New Table”.
In the table designer, add fields by specifying name, type, length, decimals, and nullability; click “Add Field” for additional columns.
Example fields: time (datetime), name (varchar), id (int) set as the primary key.
Press Ctrl+S , enter the table name (e.g., article ), and save.
The table now shows the defined columns.
To insert data, open the table’s data grid, fill values for each field (e.g., time, name, id=1), and save with Ctrl+S .
Open the “Query” tab, create a new query, write SQL such as SELECT * FROM article;, and run to view results.
The query result appears in the same window.
Additional right‑click options on the table (e.g., export, modify) are available.
This tutorial demonstrates how to create a database, define a table, insert data, and perform a simple query using Navicat.
Signed-in readers can open the original source through BestHub's protected redirect.
This article has been distilled and summarized from source material, then republished for learning and reference. If you believe it infringes your rights, please contactand we will review it promptly.
Python Crawling & Data Mining
Life's short, I code in Python. This channel shares Python web crawling, data mining, analysis, processing, visualization, automated testing, DevOps, big data, AI, cloud computing, machine learning tools, resources, news, technical articles, tutorial videos and learning materials. Join us!
How this landed with the community
Was this worth your time?
0 Comments
Thoughtful readers leave field notes, pushback, and hard-won operational detail here.