[phpMyAdmin Developers] altering a data type in existing database table
<[email protected]> Mon, 23 Sep 2019 16:06:11 +0100
| Newsgroups | gmane.comp.php.phpmyadmin.devel |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format. --===============8436436975425513655== Content-Type: multipart/alternative; boundary="__=_AltPart_949200763_424518894" This is a multi-part message in MIME format. --__=_AltPart_949200763_424518894 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable I am new to mysql/myphoadmin but have created a table in a database and inser= ted data via PHP This worked OK but one of the fields is truncated. It is one I set at decimal= instead of decimal(3.2) ie type 4.25; How can I use myphadmin to to alter just this item - it doesnt matter if this= disturbs the data since I have emptied the table BUT I dont know how to get = to the correct dialog to alter the datatype. Is there a troubleshhooting or m= aintenance manual somewhere which might contain this info. I realise this is = pretty basic but I cant find the solution. Help very much appreciated. Heki --__=_AltPart_949200763_424518894 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable I am new to mysql/myphoadmin but have created a table in a database and inser= ted data via PHP<br>This worked OK but one of the fields is truncated. I= t is one I set at decimal instead of decimal(3.2) ie type 4.25;<br>How can I = use myphadmin to to alter just this item - it doesnt matter if this disturbs = the data since I have emptied the table BUT I dont know how to get to the cor= rect dialog to alter the datatype. Is there a troubleshhooting or maintenance= manual somewhere which might contain this info. I realise this is pretty bas= ic but I cant find the solution.<br>Help very much appreciated.<br>Heki --__=_AltPart_949200763_424518894-- --===============8436436975425513655== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: inline X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KRGV2ZWxvcGVy cyBtYWlsaW5nIGxpc3QKRGV2ZWxvcGVyc0BwaHBteWFkbWluLm5ldApodHRwczovL2xpc3RzLnBo cG15YWRtaW4ubmV0L21haWxtYW4vbGlzdGluZm8vZGV2ZWxvcGVycwo= --===============8436436975425513655==--