How to insert value into table column which is having spaces php and mysql

Question

I have a table which name is data with column name First Name

I am trying to insert data in table but unable to do it as column name is with blank space.

INSERT INTO data(First Name) VALUES('Sample');

How can i do it, please explain.

update your query to INSERT INTO data(First Name) VALUES('Sample'); — Bhavik
– Bhavik, Commented Oct 25, 2016 at 6:24
Query should be like this: INSERT INTO data (FirstName) VALUES ('Sample'); — Mohammad Nurul Huda Rimon
– Mohammad Nurul Huda Rimon, Commented Oct 25, 2016 at 6:26

Professor Abronsius · Accepted Answer · 2016-10-25 06:24:10Z

5

You need to use backticks to encapsulate the field names

INSERT INTO data(`First Name`) VALUES('Sample');

answered Oct 25, 2016 at 6:24

33.9k5 gold badges36 silver badges49 bronze badges

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

Comments

Bharat · Accepted Answer · 2016-10-25 06:28:47Z

2

Remove space from you column name First Name should be FirstName.

INSERT INTO data(FirstName) VALUES('Sample');

Or your column contain space then you can use like

INSERT INTO data([First Name]) VALUES('Sample');

answered Oct 25, 2016 at 6:28

Bharat

2,4643 gold badges28 silver badges37 bronze badges