Is there any way no manual bulk edit records on ph

问题:

Is there any way no manual bulk edit records on php MyAdmin?

Thanks

Hugo

回答1:

If you want to edit multiple rows in a database, you can click the select all checkbox in the "Browse" tab, and then click the edit (pencil icon). If you want to edit more than the default 30 rows which show at a time, enter a higher number in the # of rows to show textbox.

UPDATE: If you want to UPDATE a given column in a set of selected records, there are two ways to do this.

1. If they have something in common (e.g. Column_2 has the same value), you can do an UPDATE table SET Column_1 = X WHERE Column_2 = Y
2. If there's nothing the rows you want to change have in common, then you can get the WHERE clause by selecting their checkboxes and clicking the export button (it's a table icon to the right of the delete button). This will give you the WHERE clause. Copy that where clause and use it in an UPDATE query. UPDATE table set Column_1 = X WHERE [WHERECLAUSE]