SQL insert within MySQL hosted on a raspberry Pi

Question

I have created a database called fruits within it I have created a table called fruits_info.

With headings of fruits_name VARCHAR(25), fruits_description VARCHAR(75), fruits_price FLOAT.

When I try and insert values to the table I use this function.

INSERT INTO fruits.fruits_info VALUES(`Peaches`, `Fresh peaches from Bengal`, `1.90`);

I then get this error message.

Error 1054 (42s22):Unknown column peaches in field list

Using backticks denotes a column. Using quotes denotes a string. Also potentially a bad idea to use FLOAT for prices. — Jacob H
– Jacob H, Commented Jan 26, 2018 at 14:17

Ashley Medway · Accepted Answer · 2018-01-26 14:18:49Z

2

Instead of ` use '.

INSERT INTO fruits.fruits_info VALUES('Peaches', 'Fresh peaches from Bengal', '1.90');

The backtick (`) is for specifying a column.
The single quote (') is for a value.

answered Jan 26, 2018 at 14:18

Ashley Medway

7,3197 gold badges54 silver badges73 bronze badges

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

Comments

abbas · Accepted Answer · 2018-01-26 14:19:20Z

0

Use this

INSERT INTO fruits.fruits_info VALUES('Peaches', 'Fresh peaches from 
Bengal', '1.90');

answered Jan 26, 2018 at 14:19

abbas

2483 silver badges19 bronze badges