LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 07-10-2004, 01:39 PM   #1
fibbi
Member
 
Registered: Sep 2003
Distribution: gentoo
Posts: 101

Rep: Reputation: 16
phpmyadmin (or regular mysql) batch column edit?


hey everyone, i have a wordpress blog, but the entries i imported from my old blog got imported as a different author, and so i have about 180 entries in the wp_posts table with author id 1, and about 180 with author id 3. Is there any way i can use phpmyadmin or mysql to change every entry in the table to have the same value for author id?

Thanks,
-fibbi
 
Old 07-10-2004, 02:06 PM   #2
Vookimedlo
Member
 
Registered: Jul 2004
Location: Czech Republic - Roudnice nad Labem
Distribution: Debian
Posts: 253

Rep: Reputation: 33
hi,


try: UPDATE wp_posts SET id=1;

thiss will change all values in ID column to 1 in table wp_posts
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
updating a column in MySQL mohtasham1983 Programming 1 10-28-2005 10:01 AM
mysql and phpmyadmin jungleking Linux - Newbie 1 09-17-2005 08:07 AM
How to delete a column in MySQL ? indian Linux - General 2 10-15-2004 01:02 PM
MySQL in batch mode ganninu Linux - General 1 11-20-2003 05:49 AM
Installing phpmyadmin with mysql?? chromelocust Linux - Software 0 04-07-2003 01:25 PM


All times are GMT -5. The time now is 09:13 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration