insert data from one table to another - Not Working - possible bug?

Question

I'm trying to insert data from one table to another, but I keep getting a weird SQL error. The following is my query along with the error.

insert into hs.hs (`field1`,`field2`,`field3`)  select cid,sid,'1' from `tmp1`;

now the error

1416 - Cannot get geometry object from data you send to the GEOMETRY field.

I don't understand why I'm getting a geometry error there is no geometry involved at all.

By the way my MySQL version is:

SELECT VERSION();  Result 5.7.16-log

I'm pretty sure I'm doing everything right; Can some one please tell me what I'm doing wrong? Could this be a bug?

Thanks I'm looking forward to some help.

Try this - insert into hs (field1,field2,field3) select cid , sid, '1' from tmp1; — Sheena Singla
– Sheena Singla, Commented Feb 23, 2018 at 11:52
Post the outputs off SHOW CREAtE TABLE hs and SHOW CREATE TABLE tmp1 — Raymond Nijland
– Raymond Nijland, Commented Feb 23, 2018 at 11:54
@RaymondNijland I just did a show create table all fields I'm querying are int. — Logical Nonsense
– Logical Nonsense, Commented Feb 23, 2018 at 12:05
Please mention all the columns contained in both the tables. Its working well for me, as my "hs" table contains 3 fields. If your "hs" table contains more fields then either you have to assign them values by fetching from other table or give them some default values — Sheena Singla
– Sheena Singla, Commented Feb 23, 2018 at 12:06

Sheena Singla · Accepted Answer · 2018-02-23 12:31:08Z

3

You can try this -

insert into hs (field1,field2,field3) select cid , sid, '1' from tmp1;

If this wont work then try please check the columns contained in both the tables. If your "hs" table contains more fields then either you have to assign them values by fetching from other table or give them some default values.

answered Feb 23, 2018 at 12:31

Sheena Singla

8268 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ankit Jindal · Accepted Answer · 2020-11-17 03:54:38Z

0

insert into hs (field1,field2,field3) select cid , sid, '1' from tmp1;

Below is the reason why the above query didn't worked

INSERT INTO SELECT requires that data types in source and target tables match
INSERT statement should contain all columns or they should have some default value assigned

edited Nov 17, 2020 at 3:54

answered Jun 15, 2020 at 14:26

Ankit Jindal

4,0963 gold badges32 silver badges41 bronze badges

Collectives™ on Stack Overflow

insert data from one table to another - Not Working - possible bug?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related