Select ALL columns in MySQL with one column inside CAST function

Question

I basically want to select all columns of my MySQL table, but want to change the datatype of only one column namely Patient_Number using CAST function only. Here is a screenshot of my MySQL table

So as my output, I want a similar table as I have shown in the screenshot, just want to have the datatype of Patient_Number from INT to VARCHAR.

I tried executing the following queries:

select * cast(Patient_Number as varchar) from clinic_data;
select * from clinic_data cast(Patient_Number as varchar);

But only got the following error message:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'cast(Patient_Number as char)' at line 1

`SELECT *`is not a good idea. See https://stackoverflow.com/q/3639861/14853083 — Tangentially Perpendicular, Jul 01 '21 at 14:13

score 0 · Accepted Answer · edited Jul 02 '21 at 00:14

0

SELECT * is basically not a good idea

But you need a comma, between both statements

And it should be char for the cast

select *, cast(Patient_Number as char) from clinic_data;

db<>fiddle here

edited Jul 02 '21 at 00:14

Dušan Stokić

84
2
11

answered Jul 01 '21 at 14:18

nbk

31,930
6
24
40

Thanks a lot for answering, putting comma solved my problem – Sam Varghese Jul 01 '21 at 14:20

Select ALL columns in MySQL with one column inside CAST function

1 Answers1