1. In the MySQL database, "00:00:00" is converted to a long integer function:
Select unix_timstamp ("00:00:00") * 1000,
Note that the long integer in the MySQL database is less than the number of milliseconds after the second than the long
MySQL supports float, double, and decimal floating point types. Float values are used to represent single-precision floating point values, while double values are used to represent double-precision floating point values.
Like integers, these types
Error cause: packet for query is too large (1767212> 1048576), you can change this value on the server by setting the 'max _ allow_packet 'variable.
Solution: A MySQL system parameter: max_allowed_packet. The default value is 1048576 (1 m ),Query:
Open the context. xml file in the conf folder of Tomcat 6.0 and write it under the label.
And put the driver jar package in the Lib folder under Tomcat 6.0, and then use this section in the Java classCodeObtain:
Datasource DS = NULL; try {//
The old format of data has basically completed its historical mission. The new database files are migrated to the original database. To facilitate the transfer, the lengthy database insertion method is no longer used, instead, the ibdata file in
I found many problems when installing MySQL today? A common problem: counld not start the service MySQL. error: 0. this problem may be the most common problem. solution: 1. Use the command line to delete the myql service. cd c:/Windows/system32 and
In general, the best way to solve this problem is to force a new modification.Password,MethodAs follows:
/Etc/init. d/MySQL stop (Service mysqld stop)/Usr/bin/mysqld_safe -- skip-grant-tablesEnable another SSH connection[Root @ localhost ~] #
[Windows]
1. Stop MySQL service: Open the command line window CMD and net stop MySQL2. Start MySql in another way: Use mysqld-nt.exe to start MySql in the directory of the installation directory of mysqlin the command line:
Mysqld-NT --
1. Create the path to save the backup file/mysqldata # mkdir/bak/mysqlbak2, create/usr/sbin/bakmysql file # vi/usr/sbin/bakmysql. SH3. Write the following script:
NOTE: If your MySQL password contains special characters, such! @ #, You need to add ''
1. How to connect to MySQL
Use the command line.
My MySQL is installed in C:/MySQL
Enter: DOS environment.
C:/MySQL/bin> mysql-uroot-p-hlocalhostEnter Password :******
If the connection is successful, you will see: Welcome to the MySQL
1. Install MySQL
In Linux, the complete MySQL development requires the installation of the server side, if the installation of the client is nothing bad. Search for MySQL directly in the Software Center and select the client and server.
The server
Reprinted from: http://fengyongfa2006.blog.163.com/blog/static/36654659200942401542800/
Here we will not talk about the specific download of MySQL 6.0. Since it is free, it is certainly very easy to download. You can go to the official website or
First, modify the my. CNF file under the/etc/MySQL directory and set bind-address to your IP address. Assume It is 192.168.0.240.
[Bash]
Bind-address = 192.168.0.240
[/Bash]
My mysql version is as follows:
[Bash]
MySQL ver 14.14 distrib 5.5.31,
I. Basic Common commands for MySQL Databases1. Start and Stop a serviceNet stop MySQLNet start MySQL
2. log on to MySQLMysql-uroot-P press enter to enter the passwordNote: to connect to another machine, you need to add the parameter-H Machine ip110.1
Save the following code in the TXT text and change the extension to. bat.
When you need to start the MySQL service, double-click the. BAT file. Double-click it again when it is disabled.
@ Echo offfor/F "Skip = 3 tokens = 4" % I in ('SC query
If the wicked have their own wicked, if there is a problem with the data in the database, or someone is in trouble, or your old man is unhappy with this data, in addition, when you want to destroy evidence (in fact, there will always be traces), you
I checked Apache + PhP configurations today and found on the internet that this article was not available at the beginning.
Later, I found out that I had to configure the version strictly according to the version mentioned in the article. I would
When I installed MySQL today, I found that the service could not be started. After I checked it online, I found that MySQL was installed (I did install it). If the uninstallation is not clean, if MySQL is installed again, the service cannot be
Original article: http://blogold.chinaunix.net/u/29134/showart_264480.html
If you have any objection, you can add it later. I will update it at any time.
The following are some examples: (I hope you can add them)
1. Database Design
Try to
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:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.