good morning every one, please i need help
when I try to create columns it dosent add to my sql database and showen this error :-
and this my componant
please i need help, thanks all.
please i need help, thanks all.
Which extension are you using? Any link?
Usually to create a column in a MySQL table you not only have to provide the column name but also the datatype… check the documentation…
Taifun
1 Like
mr.taifun thank you for answer, I use this extention TableView Extension Versions 3 and 4 by @Ken - Extensions - MIT App Inventor Community
So what exactly is the purpose of your MySqlDatabase Create Columns block?
Are you using a MySql database?
Taifun
Mr. Taifun thank for answer. I use my sql and phpmyadmin in web site (000webhost.com)
So I want to add column in the phpmy admin but it dosent create or add
and this is myphpAdmin
please could you learn me how I fix the problem.
by the way I used create table before that and it is work successfully, but create column dose not work.
it does not look like you read my previous answer and its link…
there does not exist a Create Column statement in SQL, you have to use ALTER TABLE…
ALTER TABLE my_table ADD COLUMN new_field TinyInt(1) DEFAULT 0;
Taifun
Excause me Mr. Taifun I Have read you’r link but I dont understand any thing, and here too I don’t understand what you mean? Could you please expline if you dont mind? Thank you Mr.taifun.
In the command Sql Insert Into Values, you put less or more values than the number of existing fields in your table.
