|
|
Welcome to the Computer Webmaster Gaming Console Graphics Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
| |||||||
| Database Database problems or need to ask a question? maybe something to do with sql injections or a database software question. Database topics cover MySQL, PostgreSQL, Oracle, SQL Server or anything else related to databases. |
 |
| | LinkBack | Thread Tools | Display Modes |
07-01-2007, 9:33 PM
| #1 | ||
 |
I have a field 'time_zone' which is wrong in all records of my table 'mdl_users' and I would like to set this field to a unique value '1.0' in all records... is ther a way to do it using phpmyadmin ? or should I use an sql command ? TFYH Joss | ||
     |
| Advertisements |
|
07-01-2007, 9:33 PM
| #2 | ||
| |
On Thu, 4 May 2006 00:01:03 +0200, Josselin wrote: > I have a field 'time_zone' which is wrong in all records of my table > 'mdl_users' and I would like to set this field to a unique value '1.0' > in all records... > is ther a way to do it using phpmyadmin ? or should I use an sql command ? sql command. -- The plural of datum is not "facts". A collection of facts is not "knowledge". | ||
| |
|
07-01-2007, 9:33 PM
| #3 | ||
| |
On 2006-05-04 01:12:02 +0200, "Peter H. Coffin" <hellsop@ninehells.com> said: > On Thu, 4 May 2006 00:01:03 +0200, Josselin wrote: >> I have a field 'time_zone' which is wrong in all records of my table >> 'mdl_users' and I would like to set this field to a unique value '1.0' >> in all records... >> is ther a way to do it using phpmyadmin ? or should I use an sql command ? > > sql command. thanks | ||
| |
| Featured Websites | ||||
|
|
| Tags: field, modify, records, table |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| libmysql.dll modify help | rplobue@yahoo.com | Database | 1 | 07-01-2007 7:37 PM |
| phantom records | TB | Database | 2 | 07-01-2007 7:32 PM |
| separate table vs. array-like list field | Rick | Database | 4 | 07-01-2007 7:30 PM |
| Need to modify <IMG> tags! Help! | Milan | PHP | 1 | 07-01-2007 5:24 PM |
| Delete from a table using entries in temp table | n00bie | Database | 2 | 06-10-2007 12:25 AM |
| Featured Websites | ||||
|
modify a field in all records of a table 
PacMan
Linear Mode
