-
Recent Posts
Recent Comments
Archives
Categories
Meta
Category Archives: MySQL
MYSql copy tables
create table tablename_new like tablename; -> this will copy the structure… insert into tablename_new select * from tablename; -> this would copy all the data
Find and replace in MYSQL
Updating Data in MYSql update [table_name] set [field_name] = replace([field_name],’[string_to_find]‘,’[string_to_replace]‘); For moving wordpress installs to repair the guid UPDATE wp_posts SET guid = replace( guid, ‘web/’, ” ) ;
Posted in MySQL, Wordpress
Tagged data manipulation, data transfer, mysql, sql, wordpress
Comments Off
MySQL Remove whitespace
update your_table set your_field = trim(your_field)
Incrementing values in Mysql
As the saga continue manipulating data this comes in handy to increment all the id’s in a table UPDATE jos_content_old SET id = id + 50 WHERE (id = id) Keep in mind the resulting id being set must be … Continue reading
moving data in sql
So after searching around the web looking for code to get data from one table intop another I found this example posted on the mysl dev forum mysql> INSERT INTO orders (customer_cust_id, orderdatetime, message, taxrate, shippingprice) -> SELECT ’1′, NOW(), … Continue reading
