LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 10-23-2006, 01:41 PM   #1
ShuggsRR
LQ Newbie
 
Registered: Oct 2006
Location: Ft Worth, Texas
Posts: 1

Rep: Reputation: 0
How do I Bulk Edit One Field in a db Table in phpMyAdmin??


Make a long story short... I imported my users and posts from one program to another. Now in my user table thier birthdays are all set to 00-00-0000 and therefore no one can log in. All I need to do is put in any logical value like 01-01-1980 and it will work again. It is takeing me FOREVER to do each user individually.

I logged into phpMyAdmin and went to my database. From there I went to the table and I see the 1000 users listed that need thier birthdays changed.

How do I change them in bulk? Im so lost!

Thanks to anyone that can help me.
 
Old 10-23-2006, 01:54 PM   #2
Dragineez
Member
 
Registered: Oct 2005
Location: Annapolis
Distribution: Ubuntu
Posts: 275

Rep: Reputation: 32
Update Query

I'm not positive on the exact syntax, but an update query should do the trick.

Quote:
UPDATE [tablename] SET [fieldname] = #01-01-1980#

Last edited by Dragineez; 10-23-2006 at 02:03 PM.
 
  


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
Can not insert word file into mysql table (in blob field) prabhatsoni Linux - Software 2 07-21-2006 05:01 AM
caps sensitivity in mysql table/field name Swakoo Linux - General 0 11-14-2005 01:16 AM
How to insert same text in one field for 10,000 records table edhan Linux - Newbie 6 06-13-2005 03:48 AM
How can I encrypt a db field using phpmyadmin? skidrash Linux - Software 0 02-23-2005 09:10 AM
phpmyadmin (or regular mysql) batch column edit? fibbi Linux - Software 1 07-10-2004 02:06 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 08:05 PM.

Main Menu
Advertisement
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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration