enum set null value

[vaskarbasak]

hi all,


I am using mysql db.The table structure is given below.

  +-----------------+---------------------------+------+-----+---------+-------+
  | Field           | Type                      | Null | Key | Default | Extra |
  +-----------------+---------------------------+------+-----+---------+-------+
  | bulk_invoice_no | varchar(50)               | NO   | PRI | pmk0    |       |
  | transid         | varchar(50)               | NO   | PRI | NULL    |       |
  | vendor_inv_no   | varchar(50)               | NO   |     | NULL    |       |
  | ats_no          | varchar(50)               | NO   |     | NULL    |       |
  | isbn            | varchar(50)               | NO   |     | NULL    |       |
  | order_qty       | int(10)                   | NO   |     | 0       |       |
  | cancel_qty      | int(10)                   | NO   |     | 0       |       |
  | ship_qty        | int(10)                   | NO   |     | 0       |       |
  | status          | enum('1','2','3','4','5') | NO   |     | 1       |       |
  +-----------------+---------------------------+------+-----+---------+-------+
   
  +-----------------+--------------+---------------+------------+---------------+-----------+------------+----------+--------+
  | bulk_invoice_no | transid      | vendor_inv_no | ats_no     | isbn          | order_qty | cancel_qty | ship_qty | status |
  +-----------------+--------------+---------------+------------+---------------+-----------+------------+----------+--------+
  | pmk-b-24        | 294518933002 |               |            | 9780072226010 |         1 |          0 |        0 |        |

I don’t understand why blank value is inserted in my table. How can I stop to update blank value.
Please help me to solve my problem.


thanks!

[Atli]

Hi.

I don't see how that could be.

Can you show us the CREATE TABLE, INSERT and SELECT statements you used to create, populate and select the data?

Also, knowing details about your server might help.
Like say, the MySQL version and OS.