Home Database Mysql Tutorial 章节0:MySQl学前知识储备_MySQL

章节0:MySQl学前知识储备_MySQL

Jun 01, 2016 pm 01:28 PM
database Database management

bitsCN.com

一、数据库基础:

1、数据库(database):保存有组织的数据的容器(通常是一个文件或一组文件)。

2、数据库管理系统(DBMS):创建和操纵数据库的软件系统。

3、表(table):某种特定类型数据的结构化清单。

4、模式(schema):关于数据库和表的布局及特性的信息。

5、列(column):表中的一个字段。所有表都是由一个或多个列组成的。

6、数据类型(datatype):所允许的数据的类型。每个表列都有相应的数据类型,它限制(或允许)该列中存储的数据。

7、行(row):表中的一个记录。

8、主键(primary key):其值能唯一区分和标识表中每个行的一个列(或一组列)。

二、认识SQL:

SQL(发音sequel)是结构化查询语言(Structured Query Language)的缩写,是一种专门用来与数据库通信的语言。SQL是一种语言。

三、认识MySQL:

MySQL是一种DBMS,即它是一种数据库管理软件。具体来说它是一个基于客户机--服务器的数据库管理软件。

四、认识MySQL工具:

如前所述,MySQL是一个基于客户机--服务器的DBMS,因此,为了使用MySQl,你需要有一个客户机软件给MySQL提供要执行的命令。即你需要一个编写和测试MySQL脚本的工具。

1、MySQL命令行实用程序

MySQl安装后,即可使用此工具。登录方法如下:

【1】Ctrl+R运行cmd启动MS-DOC控制台;

【2】mysql –u用户名 [–h主机名或者IP地址] –p密码

image

2、Navicat for MySQL

Navicat for MySQL是一款强大的 MySQL 数据库管理和开发工具,它为专业开发者提供了一套强大的足够尖端的工具,且对于新用户易于学习。其支持大部份MySQL最新版本的功能,包括触发器、存储过程、函数、事件、检索、权限管理等等。

其官方网址:http://www.navicat.com

3、HeidiSQL

HeidiSQL 是一款用于简单化你的 MySQL 服务器和数据库管理的图形化界面。该软件允许你浏览你的数据库,管理表,浏览和编辑记录,管理用户权限等等。此外,你可以从文本文件导入数据,运行 SQL查询,在两个数据库之间同步表以及导出选择的表到其它数据库或者 SQL 脚本当中。HeidiSQL 提供了一个用于在数据库浏览之间切换 SQL 查询和标签带有语法突出显示的简单易用的界面。其它功能包括BLOB 和 MEMO 编辑,大型 SQL 脚本支持,用户进程管理等。

其官方网址:http://www.heidisql.com

4、MySQL Workbench

该工具由MySQL开发,是一个跨平台的可视化数据库设计工具。它是DBDesigner4项目备受期待的替代者,它是一个本地图形化工具,支持的操作系统包括Windows、Linux和OS X,具有多个不同的版本。

其官方网址:http://www.mysql.com/products/workbench/

5、phpMyAdmin

phpMyAdmin是一个免费软件工具,使用PHP语言编写,用于通过网络管理MySQL数据库。它支持大量MySQL数据库操作,其用户界面支持多数常用操作,诸如管理数据库、表、字段、关联、索引、用户、许可权限等,同时也可以直接执行SQL语句。

其官方网址:http://www.phpmyadmin.net/home_page/index.php

6、SQLyog

SQLyog是一个MySQL数据库全能管理工具。其社区版为自由及开源软件,遵循GPL许可协议。开发者在使用MySQL时所需的多数功能都可以通过简单的点击鼠标完成,通过标签界面可以查看查询结果集、查询分析器(query profiler)、服务器消息、表数据、表信息和查询历史等。另外,开发者可以轻松创建视图和存储过程。

其官方网址:https://www.webyog.com

以上介绍了几款常用的MySQL工具,当然还有很多工具可供选择。但这不是本教程的重点。在接下来的教程中我们更多的在使用Navicat for MySQL。但,若你选择了其他工具,一样可以阅读此系列教程。

bitsCN.com
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How to solve discuz database error How to solve discuz database error Nov 20, 2023 am 10:10 AM

The solutions to discuz database error are: 1. Check the database configuration; 2. Make sure the database server is running; 3. Check the database table status; 4. Back up the data; 5. Clear the cache; 6. Reinstall Discuz; 7. Check the server resources ; 8. Contact Discuz official support. Solving Discuz database errors requires starting from multiple aspects, gradually identifying the cause of the problem, and taking corresponding measures to repair it.

Leak reveals key specs of Intel Arrow Lake-U, -H, -HX and -S Leak reveals key specs of Intel Arrow Lake-U, -H, -HX and -S Jun 15, 2024 pm 09:49 PM

IntelArrowLakeisexpectedtobebasedonthesameprocessorarchitectureasLunarLake,meaningthatIntel'sbrandnewLionCoveperformancecoreswillbecombinedwiththeeconomicalSkymontefficiencycores.WhileLunarLakeisonlyavailableasava

How does the C++ function library perform database management? How does the C++ function library perform database management? Apr 18, 2024 pm 02:15 PM

The C++ function library can be used for database management. It provides a series of functions through header files to support operations such as connection, table creation, data insertion, query, and transaction processing. The library is suitable for managing common tasks of interacting with the database.

Can't drop database 'database_name'; database doesn't exist - How to solve MySQL error: Can't drop database, database doesn't exist Can't drop database 'database_name'; database doesn't exist - How to solve MySQL error: Can't drop database, database doesn't exist Oct 05, 2023 am 11:46 AM

How to solve MySQL error: Unable to delete database, database does not exist Overview: MySQL is a commonly used relational database management system. When using MySQL, we often need to manage the database, including creating databases, deleting databases and other operations. However, when deleting a database, sometimes you will encounter the error message "Can'tdropdatabase'database_name';databasedoesn'texist", that is, you cannot delete it.

Laravel development: How to use Laravel Nova to manage databases? Laravel development: How to use Laravel Nova to manage databases? Jun 13, 2023 pm 06:40 PM

Laravel development: How to use LaravelNova to manage databases? LaravelNova is a brand new management system officially launched by Laravel, which can easily manage your database, reduce the time developers spend dealing with the management interface, and speed up the development process. This article will introduce how to use LaravelNova for database management. 1. Install LaravelNova Before starting, we need to install LaravelNova first. in terminal

Can PHP be used to develop and manage databases? Can PHP be used to develop and manage databases? Sep 11, 2023 am 08:16 AM

Can PHP be used to develop and manage databases? With the development of the Internet, the importance of databases has become increasingly prominent. A database is a software system used to store and manage large amounts of data and can provide efficient data retrieval and management functions. The use of databases is very common in website and application development. PHP is a scripting language that is widely used in web development and has the ability to process data. Therefore, PHP can be used not only to develop web pages and applications, but also to manage and operate databases. In PHP, commonly used

How to use thinkorm to establish and manage database table relationships How to use thinkorm to establish and manage database table relationships Jul 28, 2023 pm 05:25 PM

How to use ThinkORM for relationship establishment and management of database tables Introduction: When developing web applications, the database is an indispensable part. The establishment and management of relationships between data tables is an important part of database design. ThinkORM is a powerful PHPORM library that provides a simple and intuitive operation interface that can help developers easily handle the relationships between database tables. This article will introduce how to use ThinkORM to establish and manage relationships between database tables, and attach relevant

How to use php to extend SQLite for lightweight database management How to use php to extend SQLite for lightweight database management Jul 31, 2023 pm 03:33 PM

How to use PHP to extend SQLite for lightweight database management Introduction: SQLite is a lightweight embedded database engine that supports the creation and management of databases locally or in memory. It does not require any server and is very convenient to use. In PHP, we can use SQLite extensions to operate SQLite databases. This article will introduce how to use PHP to extend SQLite for lightweight database management and provide some code examples. Part One: Installing the SQLite Extension and SQL

See all articles