DaDaBIK
This forum is devoted to the discussion about the software DaDaBIK database front-end
the PHP Database application generator for MySQL, PostgreSQL and SQLite; also available for Wordpress.

Welcome! Log In Create A New Profile

Advanced

text error in mysql

Posted by louise 
louise
text error in mysql
November 22, 2004 12:23PM
I've been updating a database and I wish to change a string of text to read something different. I don't want to go through all the records again and edit them individually. Does anyone know an easier way to do this either using mysql (phpadmin) or dadabik??
Thanks for your help.

Debbie S
Re: text error in mysql
November 22, 2004 08:56PM
Louise

On occasion, I've had to edit bulk data in a database table. What I found easiest was to export the database from phpMyAdmin, make my changes using Search/Replace in Notepad and then import the sql file back into the database. Of course, before importing the data back, you have to empty the database otherwise you'll get errors that tables exist.

Hope that helps!

Debbie
(Latest version of DaDaBIK when this message was posted: 3.1 Beta)
Sorry, only registered users may post in this forum.

Click here to login