[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&nbsp;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==--