[Record] mysql subtotals by week

2010-11-04  来源:本站原创  分类:Database  人气:95 

select distinct DATE_FORMAT (per_time, '% X-% V') from performance_l1_table;

select distinct DATE_FORMAT (per_time, '% x-% v') from performance_l1_table;

Be the first record, a time to the case

相关文章
  • [Record] mysql subtotals by week 2010-11-04

    select distinct DATE_FORMAT (per_time, '% X-% V') from performance_l1_table; select distinct DATE_FORMAT (per_time, '% x-% v') from performance_l1_table; Be the first record, a time to the case

  • [Record] mysql command-line remote access 2010-12-07

    ./mysql -h 192.168.0.46 -u root -p

  • Record mysql client using the tee all the operations 2011-06-13

    Method one, the configuration file on the server / etc / my.cnf in the [client] to join tee = / tmp / client_mysql.log can. Method Two, the command line 1.mysql-uroot - tee = / tmp / client_mysql.log 2 This function is similar to the spool sqlplus, y

  • MySQL user permissions problem 2010-05-01

    <script type="text/javascript"> </ script> scriptz Fred Zhu's script for work and life. Project Home Downloads Wiki Issues Source Search <script type="text/javascript"> </ script> <! - IE -> Updated Feb 04

  • centos install Mysql 2010-04-01

    Install Mysql 1, download the installation files to install MySQL MySQL needs the following two files: MySQL-server-5.1.7-0.i386.rpm Download address: http://dev.mysql.com/downloads/mysql/5.1.html , open this page, scroll down page to find "Linux x86

  • routine maintenance operations based on the command mysql 2010-03-20

    The daily maintenance of the main MySQL command-line manner, for other database operations used to the users, Zhe Yang's command-line operation, is a relative inconvenient, and Although MySQL, there are some more of the UI operation tool, but use the

  • Learning MySQL entry (b) Basic operation 2010-02-09

    From: http://www.bccn.net/Article/sjk/mysql/jc/200505/443.html Learning articles Learn some basic operation command, let us learn how to create a database and database table. 1, using the SHOW statement to find out what currently exists in the server

  • mysql timestamp to use in 2010-03-15

    mysql timestamp to use in mysql> CREATE TABLE t1 ( -> Id mediumint (9) NOT NULL auto_increment, -> Name char (11) default NULL, -> Rq timestamp default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -> PRIMARY KEY (id) - "); Query OK,

  • MySQL command Collection (change) 2010-04-13

    First, connect MYSQL. Format: mysql-h host address-u username-p password 1, connected to the machine on MYSQL. First, open the DOS window, then enter the directory mysql \ bin, then type the command mysql-u root-p, a carriage return after the prompt

  • Basic use of mysql database 2010-04-14

    First, connect MYSQL. Format: mysql-h host address-u username-p password 1, connected to the machine on MYSQL. First, open the DOS window, then enter the directory mysql \ bin, then type the command mysql-u root-p, you lose the password prompt after

  • Install Mysql Database Linux 2010-05-02

    First, install the 1, download the installation files to install MySQL MySQL needs the following two files: MySQL-server-4.0.16-0.i386.rpm MySQL-client-4.0.16-0.i386.rpm Download address: http://www.mysql.com/downloads/mysql-4.0.html, open this page,

  • mysql command Collection 2010-05-07

    Test environment: mysql 5.0.45 [Note: in mysql through mysql> SELECT VERSION (); to see the database version] Order: leo First, connect MYSQL. Format: mysql-h host address-u username-p password 1, connected to the machine on MYSQL. First, open the DO

  • MySQL general index. The only index and main index 2010-05-11

    1, General Index General index (defined by the keyword KEY or INDEX index) only mission is to accelerate the data access speed. Therefore, it should be only for those who most frequently appear in the query (WHEREcolumn =) or sorting conditions (ORDE

  • mysql commands memoranda Collection 2010-05-22

    Test environment: mysql 5.0.45 [Note: in mysql through mysql> SELECT VERSION (); to see the database version] Order: leo First, connect MYSQL. Format: mysql-h host address-u username-p password 1, connected to the machine on MYSQL. First, open the DO

  • Steps to install mysql centos 2010-05-28

    Reprinted from http://zym820910.javaeye.com/blog/671566 First, download MySQL5.0 and related perl package 1. Official website [url] http://dev.mysql.com/downloads/mysql/5.0.html [/ url] download MySQL5.0 version, It should be noted that the system CP

  • MySql commands commonly used 2010-06-08

    MySQL basic operation of common operations, the following are MySQL5.0 tested by first description, remember the end of each command with; (semicolon) 1. Export the entire database mysqldump-u username-p - default-character-set = latin1 database name

  • Under linux mysql (rpm) Installation Manual 2010-06-22

    Contains address: http://dev.mysql.com/downloads/mysql/5.1.html , open this page, scroll down page to find "Linux x86 generic RPM (statically linked against glibc 2.2.5) downloads" items found " Server "and" Client programs "

  • Analysis of the principle of authority MySQL database! 2010-06-25

    Here we will discuss the principles of MySQL database license, which is related to the safety of the general SME database. MySQL is a cross-platform open-source relational database management systems is our most affordable common database, because of

  • Under LINUX MYSQL Installation Guide (zz) 2010-06-28

    Install Mysql 1, download MySQL's installation files need to view the LINUX version [Root @ server database] # lsb_release-a LSB Version:: core-3.1-amd64: core-3.1-ia32: core-3.1-noarch: graphics-3.1-amdh Distributor ID: RedHatEnterpriseServer Descri

  • MySQL frequently used commands (landing) and basic operations summary (reproduced) 2010-07-09

    Keywords: mysql MySQL basic operation of common operations, the following are MySQL5.0 tested by first description, remember the end of each command with; (semicolon) 1. Export the entire database mysqldump-u username-p - default-character-set = lati