Information mandatory field

[webjoel]

In the results of query part "fields" not return information for mandatory field join others information of field.

[dougwilson]

I'm not sure what you're asking for. The fields is an array of field packets. Which column are you talking about in the the packet (see http://dev.mysql.com/doc/internals/en/com-query-response.html#column-definition)?

[webjoel]

Sorry, I would like to know if you know whether a field accepts null or not. In this case this information would need to come together with other field information in the information fields result.

[dougwilson]

I would like to know if you know whether a field accepts null or not.

which column would this be in the packet I linked to?

In this case this information would need to come together with other field information in the information fields result.

I'm not sure what this means.

[webjoel]

Sorry for my english...

In "Protocol::ColumnDefinition41", there is the possibility of whether a field accepts null values​​? By Not Null option.

[webjoel]

By example:

With SQL command "SHOW COLUMNS FROM tablename" I can get the information if the field accepts null values ​​or not.

[dougwilson]

Gotcha. Yes, you can tell:

connection.query('SELECT col1 FROM my_table', function(err, rows, fields){
  if (err) throw err;
  var nullable = !(fields[0].flags & 0x01);
  console.log('col1 can' + (nullable ? '' : ' not') + ' be null');
});

It should probably be easier, or at the very least, not require you to know that the first bit of the flag means the field it not nullable.

[webjoel]

ok.

Thank´s!