>>> factory (App\Models\UserAddress::class, 3)->create (['user_id' => 1]) 报错无法写入数据到 address 数据表?
报错如下:>>> factory(App\Models\UserAddress::class, 3)->create(['user_id' => 1])
Illuminate/Database/QueryException with message 'SQLSTATE[01000]: Warning: 1265 Data truncated for column 'zip' at row 1 (SQL: insert into user_addresses
(province
, city
, district
, address
, zip
, contact_name
, contact_phone
, user_id
, updated_at
, created_at
) values (广东省, 深圳市, 福田区, 第97街道第877号, 71238-9076, Miss Claudie Blick III, 1-448-595-2036 x8041, 1, 2018-08-01 02:03:42, 2018-08-01 02:03:42))'
修改了字段类型为zip 字段类型为bigint 可以写入数据了,
推荐文章: