Data truncated for column 'category'

Asked Jun 25 '19 at 17:49

Active Jun 26 '19 at 22:45

Viewed 119 times

I am inserting data in WAMP server but following data is not inserting why? It gives an error #1265 - Data truncated for column 'category'

INSERT INTO ecommerce.products (name, category) values ('pencil_box', 'stationery');

edited Jun 26 '19 at 22:45

Dharman

asked Jun 25 '19 at 17:49

mZos

1

Possible duplicate of [Data truncated for column?](https://stackoverflow.com/questions/18089240/data-truncated-for-column) – Sasha Kondrashov Jun 25 '19 at 17:57
"data truncated" means that you are inserting values for the column that don't fit in the column, for example if your column is char(10) and you insert a string of more than 10 characters. take a look at some of the similar questions – Sasha Kondrashov Jun 25 '19 at 17:58
1

ideally you should tag a database product like MySQL, MariaDB, SQLite, PostgreSQL or SQL Server (MSSQL).. As the SQL tag is about ANSI/ISO SQL standard .. Looking into the error message i belive you are using MySQL or MariaDB. – Raymond Nijland Jun 25 '19 at 18:08

0 Answers0