mysql path conflict_mysql ON CONFLICT IGNORE(mysql ON CONFLICT IGNORE)

I started with sqlite3 and now have to make the switch to mysql. My create table code structure for sqlite3 is

CREATE TABLE IF NOT EXISTS players(

"Name" TEXT,

"B/T" TEXT,

"Ht" TEXT,

"Wt" TEXT,

"DOB" TEXT,

UNIQUE (Name, DOB) ON CONFLICT IGNORE);

I am using a python script I have that appends from a data_frame to the db.table. The UNIQUE, ON CONFLICT IGNORE works the way i need it to for never appending duplicates. My issue is I cannot seem to get it to work in mysql. I have been searching for any ideas on how I can get the same result from that one line in mysql. My current mysql line that errors:

CREATE TABLE IF NOT EXISTS players(

Name VARCHAR(30),

`B/T` VARCHAR(5),

Ht VARCHAR(5),

Wt VARCHAR(5),

DOB VARCHAR(11),

UNIQUE (Name, DOB) ON CONFLICT IGNORE);

Any solution or criticism much appreciated!

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值