PrefaceJust now on the internet to inquire about the national provinces and Cities database, compared to the pit is a relatively comprehensive data, a comprehensive fee, the heart is very uncomfortable.But in the end, I got it. A slightly better national provincial and municipal database, and with left, simple spell, abbreviation, pinyin, Administrative Code,
Tags: var blog city style float null creat int arcNational provinces and Cities database, and with the left, simple spell, abbreviation, pinyin, Administrative Code, postcode, city three loadline data CREATE TABLE [dbo]. [Region] ([Id] [int] NULL, [Name] [nvarchar] ( +) NULL, [ParentID] [int] NULL, [shortname] [nvarchar] ( +) NULL, [LevelType] [int] NULL, [citycode] [varchar] ( -) NULL, [ZipCode] [varchar]
MYSQL5.6 database ZIP installation and precautions for use in VS bitsCN.com
First, mount the resource: http://download.softagency.net/mysql/downloads /.
Find MYSQL5.6. for the two versions, check the system and set them to 64-bit: http://download.softagency.net/mysql/downloads/mysq
For work reasons, a complete zip code database is required. The data on the Internet is relatively old and there is very little data. I really hope the post office can download the zip code for free, or you can have an interface. At last, I did not pay for it, and my eyes we
Tags: database Web site variable decompression word ADE means load system table1. download MySQL 5.6 Zip Download MySQL 5.6 Zip first (on the official website (http://www.mysql.com/downloads/) or any other site), then unzip it on your computer D:\java\
Tags: no nbsp ini root system version sed set calThe first step, download the database version you need from the official website, here I use the latest version of the 5.7.15;
Unzip the file you downloaded, I'll name it MySQL Server 5.7, I put it under D:\Program files\
You will find that the new MySQL root directory does not have the Data folder (p
1. Database download
MySQL official website: http://www.mysql.com/, database download address: http://www.mysql.com/downloads/. From the official website can find two kinds of packages, one is EXE installer, the other is a zip compression package. I like the refreshing way, so the download is a
Tags: get packet style Basedir exit Ted root directory Ges path1. Zip: Https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.20-winx64.zip 2. Official Document Location: Http://dev.mysql.com/doc/refman/5.7/en/installing.html 3. Extract the files to your favorite location, I extracted to the C: Packing directory 4.
The data folder is automatically created.
(3366mysqld.exe-nt-skip-grant-tables (Note: The Window does not respond)
D:\tools\developer\MySQL\mysql-5.7.17-winx64\bin>mysqld.exe -nt --skip-grant-tables
(4) Close the window directly and re-open dos (opened in the same administrator identity)
C: \ Users \ donald> mysql-u root Welcome to the
1. Unzip the ZIP package and configuration
First, the Mysql-5.5.25-winx64.zip to the d:/mysql-5.5.25 directory, and then according to the relevant information on the Internet, will be My-large.ini (of course, depending on the situation to choose the other INI configuration file) After the copy is renamed to My.ini, on
Label:Because the work needs to start studying MySQL recently (it seems that learning is forced out), I do not study MySQL, can say a small white. Let's start with the installation, although there are many things on the internet that need to be written down.1. Database downloadMySQL official website: http://www.mysql.com/, da
mysql-5.6.13-winx64.zip to D: \ mysql-5.6.13 \ directory.
2. clear the debugging files
Open this directory and find that there is basically no difference between the folders and files in it and a installed MySQL. You may be very depressed. this MySQL5.6.13 actually has 1.04 GB. If the suffix is. lib or. pdb, you can
Label:Original: MySQL green version of installation (Mysql-5.6.22-win32.zip)Because the work needs to start studying MySQL recently (it seems that learning is forced out), I do not study MySQL, can say a small white. Let's start with the installation, although there are many
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
and provide relevant evidence. A staff member will contact you within 5 working days.