// The following is top. js
Function kb_keepitinie (thename, thewanttop, thewantleft ){Therealtop = parseint (document. Body. scrolltop)Thetruetop = thewanttop + therealtopDocument. All [thename]. style. Top = thetruetopTherealleft = parseint
//
// SourceForge: breaking down the barriers to open source development
// Copyright 1999-2000 (c) The SourceForge crew
// Http://sourceforge.net
//
// $ ID: database. php, V 1.6 2000/04/11 14:17:13 CVS exp $
//
/// ETC/local. INC has des the
The front-end has been using PhP5, which is indeed very nice to use. Now, in order to be able to run on the machine's virtual host, I have to change it to PhP4. These library classes I used to send in phpchian, the address is http://www.phpchina.com/
System Requirements:
The hardware can start the operating system.
Win2k, WINXP, or win2003 Operating System
Preparations:List of required software: (this configuration includes the following software versions)1. APACHE_2.0.47-win32-x86-no_ssl
Absolute Originality
Test address: http://www.mlmm.cn/mypage? Name = ceshi
Test Page code:Copy codeThe Code is as follows: php + ajax dynamically generated drop-down menu {$ regionss (People's Republic of China)}
Regionss function
Common Errors!
1016 error: the file cannot be opened. Use the background or phpmyadmin to fix the problem.1044 error: the database user permissions are insufficient. Contact the Space Provider to solve the problem.1045 error: Incorrect database
The following query Selects all records whose date_col values are within the last 30 days.Mysql> SELECT something FROM tbl_nameWHERE TO_DAYS (NOW ()-TO_DAYS (date_col) DAYOFWEEK (date)Returns the week index of date (1 = Sunday, 2 = Monday,... 7 =
I have always adhered to one point: the information after I perform operations with my hands is the most reliable, so please do not just "read" when you refer to this article ", just looking at it, you can't get any real information ~~~Motto: the
Import failed at the beginning.
The generated SQL statement is incorrect.
SQL query:
Insert into 'CC _ present '. 'C _ City' ('A',' B ', 'C') VALUES (NULL, 1, 'city ')...
In this way, the column name is changed to A, B, and C.
There are two
Method 1: More detailedThe following articles mainly introduce the operation process of enabling remote connection for MySQL database. In fact, it is not difficult to start the actual operation steps of remote connection for MySQL database, today,
Use EXECL to convert TimestampThe formula is:Code:
=(xxxxxxxxxx+8*3600)/86400+70*365+19
Use a MYSQL statement to explain the timestampSyntax example:
Code:
SELECT FROM_UNIXTIME(1234567890, '%Y-%m-%d %H:%i:%S')
Appendix:In mysql, the storage type of
After MYSQL exports an SQL statement:DELIMITER $Drop trigger if exists 'updateegopriceondelete' $CREATETRIGGER 'updateegopriceondelete' after delete on 'mermerinfo'FOR EACH ROW BEGINDelete from egoprice WHERE customerId = OLD. customerId;END
Win7 + Navicat Lite 9 + VMware7
Install openSUSE11.x mysql5 Navicat Lite8 \ 9 in VMware
VMware network connection bridging (Bridged)
Two important settings
1) Firewall (if this is not set, the firewall will never be connected from other machines
Author: Yang xinqi
Recently, three projects were started on hand, and the other two started from the bottom layer. One was started for a while and developed by a small team in a small city, there are no dedicated DBAs for database design and
I onceUsed BACKUP methods include mysqldump, mysqlhotcopy, backup table, and select.OUTFILE, or binlog backup, or directly copy data files and related configuration files. MyISAMTables are saved as files, so they are relatively easy to back up. The
Desc table name;Show columns from table name;Describe table name;Show create table name;Use information_schemaSelect * from columns where table_name = 'table name ';By the way:Show databases;You can alsoUse information_schemaSelect table_schema,
Method 1:1: On a terminal or windows:Mysql-VYou can.It can be seen that the version is mysql Ver 14.14 Distrib 5.1.42, for Win32 (ia32), where 5.1.42 is the version.Type 2: in mysql:Mysql> status;This operation can be performed only after
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