Ufdjrw

Why does Deadpool say "You're welcome, Canada," after shooting Ryan Reynolds in the end credits?

How to generate globally unique ids for different tables of the same database?

Instead of Universal Basic Income, why not Universal Basic NEEDS?

What is IP squat space

Know when to turn notes upside-down(eighth notes, sixteen notes, etc.)

Why must traveling waves have the same amplitude to form a standing wave?

Can hydraulic brake levers get hot when brakes overheat?

Can anyone tell me why this program fails?

How to explain that I do not want to visit a country due to personal safety concern?

Should we release the security issues we found in our product as CVE or we can just update those on weekly release notes?

Identifying the interval from A♭ to D♯

Co-worker team leader wants to inject his friend's awful software into our development. What should I say to our common boss?

Life insurance that covers only simultaneous/dual deaths

Old race car problem/puzzle

Is it true that real estate prices mainly go up?

Make a transparent 448*448 image

Russian cases: A few examples, I'm really confused

Replacing Windows 7 security updates with anti-virus?

Font with correct density?

Does the statement `int val = (++i > ++j) ? ++i : ++j;` invoke undefined behavior?

How Did the Space Junk Stay in Orbit in Wall-E?

How to answer questions about my characters?

Official degrees of earth’s rotation per day

What options are left, if Britain cannot decide?

Aurora MySQL - Able to insert into enum field via mysqlclient but unable to insert using pymysql - How can this be done?

0

Consider the following schema on Aurora MySQL 5.6:

create table temp_table (
 `id` bigint,
 `term_frequency` enum('Weekly','Monthly','Fortnightly','Quarterly') NOT NULL,
 PRIMARY KEY(id)
);

The sql_mode parameter is set to empty, hence, it is possible to have the term_frequency field as and empty quote ''.

Hence, the following query works when executed from a mysql client.

insert into temp_table values (1, '');

However, while I am using a pymysql connector, through python3, I am unable to do the same.

import pymysql

connection = pymysql.connect(host, pass, database)
cursor = connection.cursor()

cursor.execute('''insert into temp_table values (1, '');''')
connection.commit()

This throws the following error:

(1265, "Data truncated for column 'term_frequency' at row 1")

Why is this happening and how can I resolve this in pymysql?

python mysql sql pymysql aurora

share|improve this question

asked Mar 6 at 18:36

Sathyasarathi GunasekaranSathyasarathi Gunasekaran

9010

add a comment | 

0

Consider the following schema on Aurora MySQL 5.6:

create table temp_table (
 `id` bigint,
 `term_frequency` enum('Weekly','Monthly','Fortnightly','Quarterly') NOT NULL,
 PRIMARY KEY(id)
);

The sql_mode parameter is set to empty, hence, it is possible to have the term_frequency field as and empty quote ''.

Hence, the following query works when executed from a mysql client.

insert into temp_table values (1, '');

However, while I am using a pymysql connector, through python3, I am unable to do the same.

import pymysql

connection = pymysql.connect(host, pass, database)
cursor = connection.cursor()

cursor.execute('''insert into temp_table values (1, '');''')
connection.commit()

This throws the following error:

(1265, "Data truncated for column 'term_frequency' at row 1")

Why is this happening and how can I resolve this in pymysql?

python mysql sql pymysql aurora

share|improve this question

asked Mar 6 at 18:36

Sathyasarathi GunasekaranSathyasarathi Gunasekaran

9010

add a comment | 

Consider the following schema on Aurora MySQL 5.6:

create table temp_table (
 `id` bigint,
 `term_frequency` enum('Weekly','Monthly','Fortnightly','Quarterly') NOT NULL,
 PRIMARY KEY(id)
);

The sql_mode parameter is set to empty, hence, it is possible to have the term_frequency field as and empty quote ''.

Hence, the following query works when executed from a mysql client.

insert into temp_table values (1, '');

However, while I am using a pymysql connector, through python3, I am unable to do the same.

import pymysql

connection = pymysql.connect(host, pass, database)
cursor = connection.cursor()

cursor.execute('''insert into temp_table values (1, '');''')
connection.commit()

This throws the following error:

(1265, "Data truncated for column 'term_frequency' at row 1")

Why is this happening and how can I resolve this in pymysql?

python mysql sql pymysql aurora

share|improve this question

asked Mar 6 at 18:36

Sathyasarathi GunasekaranSathyasarathi Gunasekaran

9010

create table temp_table (
 `id` bigint,
 `term_frequency` enum('Weekly','Monthly','Fortnightly','Quarterly') NOT NULL,
 PRIMARY KEY(id)
);

insert into temp_table values (1, '');

import pymysql

connection = pymysql.connect(host, pass, database)
cursor = connection.cursor()

cursor.execute('''insert into temp_table values (1, '');''')
connection.commit()

(1265, "Data truncated for column 'term_frequency' at row 1")

share|improve this question

asked Mar 6 at 18:36

Sathyasarathi GunasekaranSathyasarathi Gunasekaran

9010

share|improve this question

asked Mar 6 at 18:36

Sathyasarathi GunasekaranSathyasarathi Gunasekaran

9010

asked Mar 6 at 18:36

Sathyasarathi GunasekaranSathyasarathi Gunasekaran

9010

asked Mar 6 at 18:36

Sathyasarathi GunasekaranSathyasarathi Gunasekaran

9010