Shulou(Shulou.com)06/01 Report--

Http://www.w3school.com.cn/sql/index.asp

Self-study is a bumpy thing for sql, and it needs to be persisted. If you have a problem, you don't know how to do it! I made a mistake. I don't know how to find it. Here's how I learned the sql language from w3cschool. The first step is to build a platform that supports the sql language.

There are three softwares used

1windows environment preparation

Mysql database: mysql-5.5.22.7z (the green version is installation-free here)

Database modeling tool: Navicat Data Modeler

Database connection tool: Navicat Premium (of course, you don't have to use this, or you can use cmd. Of course, cmd doesn't work).

Link: http://pan.baidu.com/s/1eSCGDs2

1.1

The installation software starts the mysql database startup method, see the installation instructions.

1.2

Try to use the database client to connect to Navicat Premium and Data Modeler. These two tools are suitable for most databases.

(oci.dll inconsistencies between oracle databases 32 and 64 and local clients need to be consistent

ORA-28547:connection to server failed,probable Oracle Net admin error

Under the Oracle installation directory (such as D:\ app\ Administrator\ product\ 11.2.0\ client_1\ BIN), find the replacement of oci.dll to the Navicat installation directory (such as D:\ Program Files\ PremiumSoft\ Navicat Premium\ instantclient_10_2)

1.3

Create models, create table creation conditions. Create indexes, a lot of internal and external keys and so on!

1.4

Select the type of database. Choose Mysql here.

1.5

Synchronously create the created model for the database

1.6

According to the client tool, we can now see the table we have created, and we can learn.

2.1

Open http://www.w3school.com.cn/sql/index.asp and start learning step by step.

2.2 not everything goes well and mistakes will be reported. Start your own chapter of looking for mistakes.

[SQL] UPDATE Person SET FirstName = 'Fred' WHERE LastName =' Wilson'

[Err] 1146-Table 'test.person' doesn't exist

Self-study is really difficult. I hope everyone can get through it. When there is no solution (1. Can Baidu, 2 keep trying)

Be sure to try first and then ask the master. It will be very memorable. I hope writing this article will be a little help to the brothers on the road of self-study!

Baidu Cloud connection password of the software used: (mblq)

The software comes from the Internet.

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.