如何删除Mysql中的空白行? [英] How do I delete blank rows in Mysql?

问题描述

我确实有一个表，其中包含超过100000个数据元素，但是其中几乎有350个空白行.如何使用phpmyadmin删除此空白行?手动删除是一项繁琐的任务.

I do have a table with more than 100000 data elements, but there are almost 350 blank rows within. How do I delete this blank rows using phpmyadmin? Manually deleting is a tedious task.

推荐答案

一般答案是:

DELETE FROM table_name WHERE some_column = '';

或

DELETE FROM table_name WHERE some_column IS NULL;

请参阅: http://dev.mysql.com/doc/refman/5.0/en/delete.html

发布表格时的更多信息！〜

More info when you post your tables!~

此外，请务必这样做:

SELECT * FROM table_name WHERE some_column = '';

在删除之前，因此您可以看到要删除的行！我认为您甚至可以在phpMyAdmin中进行选择，然后全选"并删除，但是我不确定.这样会非常快，而且非常安全.

before you delete, so you can see which rows you are deleting! I think in phpMyAdmin you can even just do the select and then "select all" and delete, but I'm not sure. This would be pretty fast, and very safe.

这篇关于如何删除Mysql中的空白行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！