I think some databases will see a blank '' as null (Oracle does, for sure)

that is definitely "messed" up (as well as non-standard)

r937
—
2014-07-29T17:36:18Z —
#7

shail_arya said:

My table has 60columns, do i need to write all?

of course

shail_arya
—
2014-07-29T17:40:11Z —
#8

r937 said:

of course

then m dead.. no array option here?

SpacePhoenix
—
2014-07-29T18:21:05Z —
#9

Might be easier to have whatever server side language you're using fire off a SELECT query to get the table then loop through each row of the result set and have oit loop through each field of result set to look for null or empty fields and do whatever you need to do with the fields. Then once a row of the result set has been dealt with, if any changes have been made, fire off an UPDATE query to write the changes to the database.

shail_arya
—
2014-07-29T18:49:47Z —
#10

SpacePhoenix said:

Might be easier to have whatever server side language you're using fire off a SELECT query to get the table then loop through each row of the result set and have oit loop through each field of result set to look for null or empty fields and do whatever you need to do with the fields. Then once a row of the result set has been dealt with, if any changes have been made, fire off an UPDATE query to write the changes to the database.

Hey hi.. I m using PHp..when a user will login in, it will check his profile data and if any field is empty , will give a update message to him. But i don't know how to use array in that.

WolfShade
—
2014-07-29T19:05:51Z —
#11

The requirement is that ALL 60 COLUMNS must be filled with data? 60???