Re: How do i replace table names?
| From: | zhuravlev alexander | Date: | Mon, 03 Nov 2003 15:43:06 +0000 |
| Subject: | Re: How do i replace table names? | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-168397@lists.php.net to get a copy of this message | ||
On Mon, Nov 03, 2003 at 04:37:41PM +0100, Bas wrote:
> OKAY, I WANT TO REPLACE IN THE TABLENAME THE TEXT BAS_ WITH DUMMY_
>
> SUCH LIKE THAT "CREATE TABLE BAS_DATA" BECOMES "CREATE TABLE DUMMY_DATA"
>
> I AM NOT THAT DUMB... I JUST WANT TO REPLACE 1 TABLE PREFIX BY ANOTHER!!!
sed -i.bak -e s'/BAS_/DUMMY_/g' your_sql_file.sql
-- zhuravlev alexander
u l s t u n o c