mysql时间字段加索引后如何生效

MySQL中为时间字段添加索引后，需要重建表才能使索引生效，可以使用ALTER TABLE命令来重建表。此外，如果想更好地提升时间字段的查询效率，还可以尝试使用MySQL的Partition功能来分区表，以加快查询的速度。

c:\>ipconfig

Windows 2000 IP Configuration

Ethernet adapter 本地连接:

Connection-specific DNS Suffix . :

IP Address. . . . . . . . . . . . : 192.168.0.98

Subnet Mask . . . . . . . . . . . : 255.255.255.0

IP Address. . . . . . . . . . . . : 192.168.0.100

Subnet Mask . . . . . . . . . . . : 255.255.255.0

Default Gateway . . . . . . . . . : 192.168.0.1

c:\>mysql -uroot -p

Enter password: ********

Welcome to the MySQL monitor. Commands end with or \g.

Your MySQL connection id is 172 to server version: 4.0.17-max-debug

Type 'help' or '\h' for help. Type '\c' to clear the buffer.

mysql>grant all on *.* to dbuser@"%" identified by '123456'

Query OK, 0 rows affected (0.03 sec)

mysql>exit

Bye

c:\>mysql -udbuser -p

Enter password: ******

Welcome to the MySQL monitor. Commands end with or \g.

Your MySQL connection id is 174 to server version: 4.0.17-max-debug

Type 'help' or '\h' for help. Type '\c' to clear the buffer.

mysql>

---