Free Universal Space provides:1. Support html,asp,asp.net,php,cgi, such as in addition to JSP almost all the format;2. The website supports the forum procedure, but because this item compares occupies the resource, does not recommend the use;3.Web
10g/php/mysql/ftp//domain Foreign Master Space1.VG of Free Network hostSee 1.VG GB of free storage space for your homepage. You can install, thanks to PHP and support in the 1.VG MySQL database, any standard scripts for your site, such as blogs,
Like what:
The code is as follows
Copy Code
TRUNCATE TABLE table1
TRUNCATE table table1 (table name) or this can also be:
The code is as follows
Copy Code
ALTER TABLE table_name
We've seen MySQL's like pattern matching and ... % MySQL supports another type of pattern-matching operation based on regular expressions and regexp operators. If you know PHP or Perl, it's very simple, because these scripts have very similar
MySQL randomly query out a record
The code is as follows
Copy Code
$sql = "SELECT * from Pinglun WHERE ID >= (select MAX (ID) from Pinglun)-(select MIN (ID) from Pinglun) * RAND () + (SEL ECT MIN (ID) from Pinglun) LIMIT
1. Open
The global variable Event_scheduler is used to set whether the server side runs the execution plan task, which has the following three kinds of values:OFF: The scheduled task is in a stopped state and the event Scheduler thread is not
MySQL group BY, sorting the largest record of time in each record
Here is the test table, which tests the SQL
CREATE TABLE IF not EXISTS ' test ' (' ID ' int (a) unsigned not NULL auto_increment,' Install ' int (a) unsigned not NULL,' Day ' int (a)
Look at my example first.
Error resolution for character set
The problems that arise:Mysql> Update Users-> set username= ' Guan Yu '-> where userid=2;ERROR 1366 (HY000): Incorrect string value: ' Xb9xd8xd3xf0 ' for column ' UsernAme ' at row 1
An
Mysqldump Export Command Base usage
The code is as follows
Copy Code
Mysqldump-u username-P [--opt] DATABASENAME [Table] > Export SQL file name
The default mysqldump exported SQL file contains not only the
On Weibo, see @ Jinshan mentions a performance problem in MySQL,
The code is as follows
Copy Code
Select ID from table where ID > M ID
Which is faster?
There are three kinds of query conditions here:
The code is as follows
Copy Code
Mysql> SELECT something from tableWHERE To_days (now ())-To_days (Date_col) DayOfWeek (date)
Returns the week index of date (1= Sunday, 2 = Monday, ...). 7= Saturday). These index values
We often use unique numbers in database applications. The Auto_increment property of the field can be generated automatically in MySQL. MySQL supports a variety of data tables, each of which has a different self added attribute.
ISAM Table
If you
In general, to make a slower select ... where it is faster, you should first check to see if you can add an index. References between different tables are usually done by index. You can use the explain statement to determine which indexes the SELECT
In the process of website migration, apart from packaging and transferring website files, the biggest headache is MySQL export and import. If the database is not large, it is very convenient to import and export PHPMyAdmin. Once the database is
Free space: free php mysql applicationNo advertisementAre you a free and host place where their ads exceed your website? Most people agree! Go to PutSpace for free and get no ads on your website!Permit proxyYes! You heard it! With China's
Free hosting of ** 1 GB space-1 9% GB bandwidth-ph p m y SQL-fast and 99. Normal run timeGet Top free Web hosting and some terrible features all freeFast and reliable serverFTPPHP MySQL1 GB space1 GB bandwidthMore100% free hosting 1000 (1 GB) MB
When an error occurs during the running of the program, the entire table is no longer displayed, and the backup has not been completed before! It hurts. This is a production server. Can the data in it be lost! I am not familiar with the linux
Change the website file directoryIf you are using the lnmp installation package of June, the default virtual host configuration environment is in the/usr/local/nginx/conf/vhost/Directory. Modify:Vi/usr/local/nginx/conf/vhost/domain name. confYou can
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