[删除前100条数据,肯定是首先需要排序,然后再删除前100条数据。
sql 语句格式为:
delete from table_name where 1=1 order by order_name limit 100;
其中table_name是你希望删除数据的所在表表名,order_name 是你希望按照哪个字段来进行排序的字段名,如果是用系统自动默认的排序,order by order_name 这部分可以不写。]
求取总记录数
select count(*) from tbl_name
删除部分记录
delete from tbl_name limit 总记录数-10
实际例子:
delete from schema_migrations limit(160);
Ruby mysql用法
1.Connect to a database:
client = Mysql2::Client.new(:host => “localhost”, :username => “root”)
实际例子:
client=Mysql2::Client.new(:host=>“xxx.xx.xx.xxx”,:username=>“root”,:password=>”oracle”,:database=>”dashboarddata”)2.Thenqueryit:results=client.query(“SELECT∗FROMusersWHEREgroup=′githubbers′”)实际例子://获取dashboarddata数据库里的所有数据库表defself.gettablestables=[]dd=
client.query(“SHOW TABLES”)
dd.each do |x|
tables << x[“Tables_in_dashboard_data”]
end
return tables
end
Mysql语句
最新推荐文章于 2023-07-05 16:14:02 发布