数据库状态[42S01]:基表或视图已存在:1050表'fiat_withdrawals'已存在(SQL:创建表fiat_withdrawals
(id
bigint unsigned not null auto_increment primary key,user_id
bigint unsigned not null,bank_id
bigint unsigned not null,wallet_id
bigint unsigned not null,admin_id
bigint null,currency
varchar(30)not null,coin_amount
decimal(19,8)not null default '0',currency_amount
decimal(19,8)not null default '0',rate
decimal(19,8)not null default ' 0',fees
decimal(19,8)not null default '0',status
tinyint not null default ' 0',created_at
timestamp null,updated_at
timestamp null)default character set utf8mb4 collate 'utf8mb4_unicode_ci')
这就是我得到的错误。
下面是我解决方法:
DROP TABLE IF EXISTS fiat_withdrawals;
CREATE TABLE `fiat_withdrawals` (
`id` bigint unsigned not null auto_increment primary key,
`user_id` bigint unsigned not null,
`bank_id` bigint unsigned not null,
`wallet_id` bigint unsigned not null,
`admin_id` bigint null,
`currency` varchar(30) not null,
`coin_amount` decimal(19, 8) not null default '0',
`currency_amount` decimal(19, 8) not null default '0',
`rate` decimal(19, 8) not null default '0',
`fees` decimal(19, 8) not null default '0',
`status` tinyint not null default '0',
`created_at` timestamp null,
`updated_at` timestamp null
) default character set utf8mb4 collate 'utf8mb4_unicode_ci';
但是,我仍然得到同样的错误任何帮助,请?
1条答案
按热度按时间cbjzeqam1#
您可以使用以下代码:
将
your_table_name
替换为表的实际名称,将column1
、column2
、column3
等替换为表中要使用的实际列名和数据类型。