Professional Web Applications Themes

modify a field in all records of a table - MySQL

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...

  1. #1

    Default modify a field in all records of a table

    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

    Josselin Guest

  2. #2

    Default Re: modify a field in all records of a table

    On 2006-05-04 01:12:02 +0200, "Peter H. Coffin" <hellsopninehells.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

    Josselin Guest

Similar Threads

  1. How to get All Records in Table A that don't havematching ID in Table B
    By Photoshare in forum Coldfusion Database Access
    Replies: 4
    Last Post: February 23rd, 10:46 PM
  2. Loss of Modify Table > Delete Row or Insert Row in 6.1
    By webwizzard webforumsuser@macromedia.com in forum Macromedia Dreamweaver
    Replies: 0
    Last Post: July 23rd, 11:19 PM
  3. modify existing records
    By Rick Brandt in forum Microsoft Access
    Replies: 0
    Last Post: July 21st, 03:26 PM
  4. To modify table through code SQL
    By Frank Dulk in forum Microsoft Access
    Replies: 0
    Last Post: July 14th, 12:01 PM
  5. Delete from one table with matching records in another table
    By Dale Fye in forum Microsoft SQL / MS SQL Server
    Replies: 4
    Last Post: July 1st, 01:28 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139