Correct MySQL installation procedure

Source: Internet
Author: User
Tags mysql text

The following articles mainly introduce the correct operation steps of MySQL installation, I download is (indeed very small), direct MySQL database installation is actually a very simple thing, then download a client tool that is equivalent to the query analyzer NaviCat of mssql.

Basically, you can use it. The data storage path will be specified during installation. You can also modify it later.

1. Modify the Files of my. ini in the directory C: \ Program Files \ MySQL Server 5.0

  1. #Path to the database root  
  2. datadir="C:/Program Files/MySQL/MySQL Server 5.0/data"   

Change to your new path

2. Copy all the data directories to the new directory.

Since there have been many differences in MSSQL in the past, it is necessary to find it on the Internet:

1. MySQL supports enum, set, and SQL server.

2 MySQL does not support nchar, nvarchar, and ntext

3. the incremental Statement of MySQL is AUTO_INCREMENT, while that of mssql is identity)

4 msms by default, the default value of the statement for creating a table everywhere is (0), but it is not allowed to contain square brackets in MySQL.

5 MySQL needs to specify the storage type for the table

6. The mssql identifier is [] and [type], indicating that it is different from the keyword, but MySQL is ', that is, the symbol on the left of key 1.

7. mssql supports the getdate () method to obtain the current time and date. However, MySQL supports Date and Time types. The current date is cur_date (), and the current complete time is the now () function.

8 mssql does not support replace into statements, but in the latest sql20008, it also supports merge syntax

9 MySQL supports insert into table1 set t1 = '', t2 ='', but mssql does not support this write.

10 MySQL supports insert into tabl1 values)

11 mssql does not support limit statements. Unfortunately, it can only replace limt 0, N, row_number () over () with the top function to replace limit N, M

12 when creating a table, MySQL must specify a storage engine type for each table, while mssql only supports one storage engine.

13 MySQL does not support the datetime-type mssql statement of the current time by default.) in MySQL, the timestamp type is used.

14. Check whether the table exists in mssql and delete it again. You need:

  1. if exists (select * from dbo.sysobjects where id = object_id(N'uc_newpm') and OBJECTPROPERTY(id, N'IsUserTable') = 1)  

However, in MySQL, you only need

  1. DROP TABLE IF EXISTS cdb_forums; 

15 MySQL supports unsigned integers, so it can store up to twice the maximum number of unsigned mssql statements.

16 MySQL does not support the varchar (max) type that is very convenient in mssql. This type can be used in both general data storage and blob Data Storage in mssql.

17 to create a non-clustered index in MySQL, you only need to specify it as the key when creating the table. For example, KEY displayorder (fid, displayorder) must be:

  1. create unique nonclustered index index_uc_protectedmembers_username_appid on dbo.uc_protectedmembers  
  2. (username asc,appid asc)  

18 The MySQL text field type cannot have default values

The total field length of a table in 19MySQL cannot exceed 65XXX.

20 The obvious difference is that MySQL installation is very simple, and the file size is only 110M non-MySQL installation version). Compared with Microsoft, the installation progress is simply .....

There are several good 21 MySQL management tools, MySQL_front, and the official suite, but they are not easy to use SSMS, which is a major disadvantage of MySQL.

22MySQL stored procedures only appear in the latest version, and the stability and performance may be inferior to mssql.

23 with the same load pressure, MySQL consumes less CPU and memory, while mssql does consume a lot of resources.

24php connects to MySQL and mssql in similar ways. You only need to replace the MySQL function with mssql.

25MySQL supports date, time, and year types. Only date and time are supported by mssql to 2008.

Related Article

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.