[EP-tech] MySQL query to update a column value

[Claire Eskriett]

Hi all

I've edited eprints.pl to change the property of an eprint field from an integer to text but running update_database_structure has not updated the eprint table. I've been advised to update manually using MySQL and have come up with the following:

Use <database name>
Update eprint
Set type = text
Where field = num_pieces

I think this is ok - I've specified the table (eprint) and the field that I want to update (num_pieces) and the column that I want updating is 'type'. The current row in the table is as follows:
Field                             | Type         | Null | Key | Default | Extra
num_pieces            | int(11)      | YES  | MUL | NULL    |       |

Can anyone take pity on me and reassure me that this is ok? I ask as a MySQL novice.

Many thanks for any advice!

Claire


Claire Eskriett, Systems Librarian
(Days of work are Mon, Tues, Thurs & Fri)
Information Services
Cockcroft Building
University of Brighton
Lewes Road
Brighton BN2 4GJ
T: 01273 642766
E: C.Eskriett at brighton.ac.uk


___________________________________________________________
This email has been scanned by MessageLabs' Email Security
System on behalf of the University of Brighton.
For more information see http://www.brighton.ac.uk/is/spam/
___________________________________________________________
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20120920/a41e7bbd/attachment-0001.html