[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[EP-tech] MySQL query to update a column value
- Subject: [EP-tech] MySQL query to update a column value
- From: C.Eskriett at brighton.ac.uk (Claire Eskriett)
- Date: Thu, 20 Sep 2012 10:37:01 +0000
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>
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 Eskriett, Systems Librarian
(Days of work are Mon, Tues, Thurs & Fri)
University of Brighton
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...