The code is as follows
Copy Code
$con = mysql_connect ("localhost", "root", "222222");if (! $con){Die (' Could not connect: '. Mysql_error ());}echo "Success"Mysql_close ($con); Close connectionVar_dump ($row); Print outPrint_r ();
The IIS,PHP4 and MySQL packages are php-4.0.1pl2-win32.zip, Mysql-3.23.19-beta-win.zip.
Windows2000 (p) + IIS 5.O
1: Install MySQL
After the setup all ok but Run:c:mysqlinmysqld-nt.exe--install "Start" button, "program" = "management Tool" =
Introduction to Database Systems 51 pages of the Chinese version of the sixth edition, there is an example of "not EXISTS (b except A)", asking for "Find students who have selected all the courses offered by the biology department." Experimental
1. Query cache key is a SQL string, and requires exact matching: The case is not the same or more than one space, will result in cache miss
2. Query cache directly the user input of the original SQL as a key, not to parse or optimized after the SQL
For the locate function in MySQL, you can view the link: http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_locate For the Replace function in MySQL, you can view the link:
In the Linux world enjoys a high reputation of the MySQL database, with its small, powerful, full free and famous. However, for many users, it is sometimes necessary to browse and analyze the data in Windows, while under Windows, MySQL database
Method One, delete all binary logs:
When the Reset Master command is executed on MySQL, all mysql-bin.* logs are cleared and the log file name begins at mysql-bin.000001
Reset Master
To delete a portion of a log:
The code is as
1. Copy table structure and data to new table
CREATE Table New Table SELECT * from old tableThis method copies all the contents of the oldtable, and of course we can delete them with the delete from newtable.
But one of the worst aspects of this
The principle of master copy of database:The master-slave copy of the database is replicated from the master database to the slave database, and three threads are required to implement the entire replication between master and slave, of which two
Only under Windows, I won't Linux, hey
1,net stop MySQL stopped MySQL service
2, the implementation of Mysqld-nt--skip-grant-tables
This starts, does not need the MySQL database password to be able to enter the MySQL
3, at this time to open a
Take signed as an example, you can store -2147483648 to 2147483647 and take Unsigned as an example, you can save 0 to 4294967295, but in the operation of such fields, you must be careful to avoid the deletion of the overdo, but become full of blood
Tenth chapter (3) Upload multiple files and file download processingContinue: Used in a loop structure to skip the remaining code in this loop and start the next loop.For more information, see PHP video.
DatabaseQuery statement:SELECT field name
The reason is that many times, in order to secure, do not allow MySQL management tools to connect the formal environment on the line, in this case, you can not rely on the MySQL management tools to transform the code to solve the problem of Chinese
1, select the most applicable field properties MySQL can support large amount of data access, but generally speaking, the smaller the table in the database, the faster the query executed on it. Therefore, in order to achieve better performance
In MySql4.0.12, with the "CREATE TABLE Bak_name as SELECT * from Original_name" statement
, the generated Bak table does not have a primary key and the index, the use of the time to pay attention to. You can build a table structure that you want to
MySQL password We do not often modify, but sometimes we will forget the password needs to be modified, but also change the password for their own easier to remember! Here are two ways to change the MySQL password
Method One:
This method
Analysis issues Troubleshooting login MySQL view with show VARIABLES like ' character% ';
The default character set for Character_set_database and Character_set_server is latin1.
+--------------------------+----------------------------+|
I used apache in the past. Due to work needs, I had to configure the php environment of iis. I found some information on the Internet and configured it at once. In fact, I have experience with apache + php + mysql, this is easy to understand.Let's
Welcome to MyFreeWebs.net, your free hosting service provider. We provide:100% free hosting;100% no sub-choice or use your own domain name;200 MB space, 4 GB/month transfer;Real FTP access;PHP and MySQL access;Click install phpBB2 Forum;Phpmyadmin
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service