一条SQL语句搞定Sql2000 分页
1.所有记录的分页: SELECT TOP 页大小 * FROM Users WHERE (ID NOT IN (SELECT TOP (页大小*(页数-1)) ID FROM Users ORDER BY ID DESC)) //skip(页大小*(页数-1)) 条记录 ORDER BY ID D
1.所有记录的分页: SELECT TOP 页大小 * FROM Users WHERE (ID NOT IN (SELECT TOP (页大小*(页数-1)) ID FROM Users ORDER BY ID DESC)) //skip(页大小*(页数-1)) 条记录 ORDER BY ID D
如果 MySQL 正在运行,首先杀之: killall -TERM mysqld。启动 MySQL :/usr/bin/safe_mysqld --skip-grant-tables >flush privileges;重新杀 MySQL ,用正常方法启动 MySQL 。Redhat的safe
@echo off if exist ipconfig.txt del ipconfig.txt ipconfig /all >ipconfig.txt if exist phyaddr.txt del phyaddr.txt find "Physical Address" ipconfig.