In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-26 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
Learning content
1. Software installation and server settings.
two。 (optional, but strongly recommended) use the graphical interface software Navicat for SQL
3. Basic knowledge of database
Database definition two-dimensional table row and row primary key foreign key in relational database
4.MySQL database management system
Database datasheet view stored procedure
Software installation
MySQL download link: MySQL
Download the first one, and then extract it.
My directory is in C:\ Users\ Public\ MySQL, and then configure my.ini in this folder
Next, start MySQL and operate in cmd
Cd C:\ Users\ Public\ MySQL\ binmysqld-- initialize-- console
Initial password after execution
... = 'class1' > 2019-03-31T01:49:30.418915Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: P7 Lhchocolate 6hEkl0.
P7Lh=6hEkl0! Is the initial password, and then the installation can be started.
Mysqld installnet start mysql
Now that the installation is successful, you can log in to MySQL.
Enter the following statement:
Mysql-h hostname-u user name-p
Parameter description:
-h: specify the MySQL hostname to which the client wants to log in. Login to the local machine (localhost or 127.0.0.1) this parameter can be omitted;-u: login user name;-p: tell the server that a password will be used to log in. If the user name password you want to log in is empty, you can ignore this option.
It is easier to log in to the native MySQL command:
Mysql-u root-p
Just enter the previous password. Welcome to the MySQL monitor.... will be displayed after success
Then the command prompt will always wait for the command to be entered with mysq > plus a flashing cursor, and type exit or quit to log out.
Change the default password first. Here are the statements for the new version of MySQL
Alter user user () identified by "123456"
Next we install navicat
Downloaded a trial version of Navicat on the official website.
After the installation is successful, you can play happily
Basic knowledge
Database definition: the term database is used in many ways, but from a SQL perspective, a database is a collection of data stored in some organized way. Or a container that holds organized data.
Relational database: to put it simply, a relational database is a database composed of multiple two-dimensional row and column tables that can be connected to each other.
Two-dimensional table: that is, data table. In the relational model, the data structure is represented as a two-dimensional table, and a relationship is a two-dimensional table. The first row in the table is usually called the attribute name, and each tuple and attribute in the table is inseparable, and the order of the tuples is irrelevant.
Rows: the data in the table is stored by row, and each saved record is stored in its own row. A row is a record in the table.
Columns: a table consists of columns. A column is a field in a table that stores information about a part of the table. All tables consist of one or more columns.
Primary key: a column (or set of columns) in a table whose values uniquely identify each row in the table. Without a primary key, it is extremely difficult to update or delete specific rows in the table.
Foreign key: a foreign key is a column in a table that contains the primary key value of another table and defines the relationship between the two tables.
View: a view is a virtual table. Unlike tables that contain data, views contain only queries that retrieve data dynamically when used. Use views to simplify complex SQL query statements.
Stored procedure: simply put, a stored procedure is one or more SQL statements saved for later use. They can be thought of as batch files, although their role is not limited to batch processing. Stored procedures can simplify operation, facilitate the management of changes, and so on.
The above is the introduction of MySQL from introduction to abandonment-installation and integration. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply you in time. Thank you very much for your support to the website!
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 276
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.