skip to main
|
skip to sidebar
Simple life, Complicated mind
Tuesday, January 5, 2010
add index
ALTER TABLE table_name DROP INDEX LatestTradeDate, ADD INDEX id_Key_LatestTradeDate USING BTREE(ID_KEY, LatestTradeDate);
ALTER TABLE table ADD INDEX LatestTradeDate USING BTREE(LatestTradeDate);
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Total Pageviews
Search This Blog
About Me
https://github.com/junxie6
https://stackoverflow.com/users/409319/jun-hsieh
https://blog.ijun.org/
Recommended Articles
CentOS and Red Hat 7: Install Linux, Apache MPM, MariaDB, PHP (LAMP) Stack
Install MySQL 5.7, Apache 2.4, PHP 7.1 on Ubuntu 16.04
Labels
Amazon Web Services
(9)
Android
(2)
AngularJS
(2)
Apache
(72)
Arduino
(1)
Assembly
(19)
Backup
(39)
Bash
(8)
Batch
(14)
Big Data
(1)
Book
(1)
Business Terminology
(9)
C
(58)
C# .NET
(71)
command
(71)
Computer Terminology
(27)
Data
(1)
Data mining
(1)
Debian
(1)
Debugging
(52)
Django
(7)
DNS
(5)
Docker
(12)
Drupal
(125)
Drupal 8
(12)
Elasticsearch
(1)
English Vocabulary
(56)
ERP
(3)
Excel
(4)
Exchange Server
(41)
FFmpeg
(4)
Financial Management
(1)
FreeBSD
(270)
Game
(1)
Git
(8)
golang
(54)
Golden Saying Quotation
(77)
Good Articles
(143)
Google Sheets
(1)
Hardware
(5)
Health
(8)
HTML/CSS
(46)
HTML5
(3)
IIS
(14)
ImageMagick
(3)
Internet of Things (IoT)
(3)
iPhone
(2)
Issue Tracker
(2)
IT Talk
(4)
Java
(1)
JavaScript
(79)
jQuery
(61)
jQWidgets
(2)
Linux
(111)
Load Balancing
(19)
Mac OS X
(15)
Magento
(70)
Magento 2
(13)
Mail
(17)
Math
(4)
Miscellaneous (Others)
(30)
Money
(11)
MongoDB
(2)
MySQL
(172)
Network
(13)
News
(4)
Nginx
(16)
Node.js
(3)
Performance
(31)
Perl
(12)
pfSense
(7)
PHP
(183)
PhpStorm
(3)
PHPUnit
(2)
Postfix
(3)
PostgreSQL
(2)
PowerShell
(5)
PrestaShop
(2)
Printer
(5)
Programming Talk
(152)
Prometheus
(1)
Proxy
(9)
Python
(19)
Raspberry PI
(4)
Redis
(3)
Redundancy
(8)
Regular Expression
(16)
Restaurant
(1)
Reverse Engineering
(1)
Revision Control
(32)
RouterOS
(1)
Ruby
(3)
Script
(8)
Security
(16)
Software Quality Assurance and Testing
(21)
SQL Injection
(11)
SQL Server
(77)
SSH
(5)
Storage
(3)
Symfony
(25)
tmp
(31)
ToDo
(181)
Tools
(156)
Two-factor Authentication
(3)
Ubuntu
(25)
Unicode
(32)
Unix-like Tips
(88)
VB .NET
(4)
VBScript
(66)
Video conferencing
(2)
vim
(101)
VirtualBox
(2)
Virtualization
(8)
VMware
(21)
VoIP
(1)
VPN
(14)
Vue
(3)
Web Development
(6)
Windows API
(1)
Windows MIS
(127)
Windows Mobile
(4)
WPF
(1)
X Window
(2)
Xen
(2)
XML
(6)
Zend Studio
(1)
Blog Archive
►
2019
(9)
►
June
(1)
►
April
(1)
►
March
(2)
►
February
(3)
►
January
(2)
►
2018
(49)
►
November
(2)
►
October
(4)
►
September
(13)
►
August
(3)
►
July
(2)
►
June
(1)
►
May
(6)
►
February
(8)
►
January
(10)
►
2017
(94)
►
December
(19)
►
November
(2)
►
October
(11)
►
September
(11)
►
July
(4)
►
June
(1)
►
May
(5)
►
April
(6)
►
March
(4)
►
February
(25)
►
January
(6)
►
2016
(196)
►
December
(10)
►
November
(11)
►
October
(17)
►
September
(5)
►
August
(3)
►
July
(9)
►
June
(15)
►
May
(14)
►
April
(35)
►
March
(49)
►
February
(10)
►
January
(18)
►
2015
(306)
►
December
(26)
►
November
(24)
►
October
(9)
►
September
(23)
►
August
(18)
►
July
(34)
►
June
(12)
►
May
(6)
►
April
(27)
►
March
(35)
►
February
(61)
►
January
(31)
►
2014
(220)
►
December
(23)
►
November
(53)
►
October
(4)
►
September
(7)
►
August
(17)
►
July
(35)
►
June
(18)
►
May
(2)
►
April
(20)
►
March
(10)
►
February
(20)
►
January
(11)
►
2013
(163)
►
December
(6)
►
November
(12)
►
October
(12)
►
September
(27)
►
August
(18)
►
July
(15)
►
June
(18)
►
May
(29)
►
April
(19)
►
March
(1)
►
January
(6)
►
2012
(131)
►
December
(22)
►
November
(11)
►
October
(6)
►
September
(2)
►
August
(1)
►
July
(5)
►
June
(13)
►
May
(16)
►
April
(8)
►
March
(7)
►
February
(9)
►
January
(31)
►
2011
(236)
►
December
(51)
►
November
(38)
►
October
(27)
►
September
(34)
►
August
(5)
►
July
(8)
►
June
(6)
►
May
(14)
►
April
(4)
►
March
(19)
►
February
(6)
►
January
(24)
▼
2010
(259)
►
December
(56)
►
November
(43)
►
October
(6)
►
September
(7)
►
August
(18)
►
July
(39)
►
June
(12)
►
May
(25)
►
April
(12)
►
March
(14)
►
February
(9)
▼
January
(18)
InnoDB Performance Tuning
InnoDB Performance Worksheet - Drupal Performance ...
promiscuous mode enabled
Here are some suggestions from Elements of Program...
MySQL Engines: InnoDB vs. MyISAM – A Comparison of...
CRLF line terminators makes shell script failed to...
修正 Apache Worker MPM 與 APC 設定
[Solved] Problem(IDE cable) adding Disk.
Only Non-English Character Matching
The In's and Out's of Fsck - Dealing with corrupt ...
MySQL Slaving featuring FreeBSD Snapshots
quickly Create large big dummy file on freebsd
Setting up a Layer 3 tunneling VPN with using OpenSSH
awstats php script
ACID (atomicity, consistency, isolation, durabilit...
add index
How do I grep (i.e. search for a string) recursive...
maatkit mk-table-sync note
►
2009
(742)
►
December
(58)
►
November
(143)
►
October
(55)
►
September
(48)
►
August
(35)
►
July
(31)
►
June
(40)
►
May
(25)
►
April
(95)
►
March
(99)
►
February
(42)
►
January
(71)
►
2008
(273)
►
December
(70)
►
November
(71)
►
October
(68)
►
September
(54)
►
August
(2)
►
July
(7)
►
June
(1)
Popular Posts
搬家愈多次,物質慾愈少?
Magento Get Add to Cart URL of any Product
寫程式是一種超能力
800a0004 Invalid algorithm specified / Invalid flags specified Persits ASP encryption
Volume Shadow Copy Failed to create the storage area association
NginX with FastCGI and C
Squid transparent SSL proxy on pfSense
simply accounting - How to connect to MySQL Server
Passing an argument to a Block View in Drupal 6
Backup FreeBSD
Recommend Sites
fcamel 技術隨手記
fcamel's blog
FourDollars Blog
Fred's Blog
Gea-Suan Lin's BLOG
SCRATCHING MY NEEDS
Think Exist
Thinker
一又@CROSS [ SSORC.tw ]
小惡魔 AppleBOY
Joey
No comments:
Post a Comment