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
CentOS and Red Hat 7: Install Linux, Apache MPM, MariaDB, PHP (LAMP) Stack
Volume Shadow Copy Failed to create the storage area association
800a0004 Invalid algorithm specified / Invalid flags specified Persits ASP encryption
Using vim + xdebug to debug php On FreeBSD
Magento Get Add to Cart URL of any Product
NginX with FastCGI and C
vim edited files, then use utf-8 encoding as default when svn commit
搬家愈多次,物質慾愈少?
Passing an argument to a Block View in Drupal 6
Realtime File System Replication On 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