search

catfan / Medoo

The lightweight PHP database framework to accelerate the development.
https://medoo.in
MIT License
4.83k stars 1.15k forks source link

Can't insert only one row with empty string #653

Closed KaikePing closed 3 years ago

KaikePing commented 6 years ago

if you insert empty string into some column on only one row, this won't be inserted into database: $medoo->insert("drug_auditrail", [ 'drugid'=>'12', 'new'=>'' ]);

But if you insert more than two row, this would be successfully inserted into database: $medoo->insert("drug_auditrail", [ ['drugid'=>'12', 'new'=>''], ['drugid'=>'13', 'new'=>''] ]);

catfan commented 6 years ago

I tested it. It's OK.

What's your new column setting? And what's your database, version?