Welcome to the most active Linux Forum on the web.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
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!


  Search this Thread
Old 10-23-2006, 02:41 PM   #1
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, 02:54 PM   #2
Registered: Oct 2005
Location: Annapolis
Distribution: Ubuntu
Posts: 278

Rep: Reputation: 41
Update Query

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

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

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


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

All times are GMT -5. The time now is 12:56 PM.

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