hi guys, just wanna ask further questions about this.. im new in c#-MySQL integration..

i already created some tables and columns.. my problem now is how to create something like this:

if dbColumn in not exist
then create
else
do nothing..

i already tried some examples in the net and tried to modify it but it seems doesnt have effect at all.. all i can find is not exist and exist through database and tables but not in columns.. thanks in advance ^_^

use ALTER TABLE ADD COLUMN

^

ok thanks i'll try that =)


ooppss i missed some info in my question

it should be like this..

if dbRow is not exist
then create dbRow

im trying to insert a VALUE/data to column=)

am i correct? the data inside the columns were called rows? =)

sorry for noob question =)

column, row...

i am totally confused

maybe you can show using sample data?

also, it is a good idea if you would please do a SHOW CREATE TABLE for me

^_^

im sorry =)

i was about to INSERT data to columns wherein those who already inputted will be ignored and those who are not, will create datas, inside the specific column =)


about the SHOW CREATE TABLE, theres an error

im using mysql 5.1...

could i achieve this by applying unique value in my columns? how can i manage to put them directly when i already created lots of tables and columns.. thanks =)

..sorry double post...