<div>
Update mydatabase<br />
set [My Project]=23<br />
where id=16;
</div>


<div>
I found the answer in an online article.
</div>


<div>
Officially the double quotes are name delimiters, so &quot;My Project&quot; could work. MySQL might have a different point of view, however.
</div>


<div>
<div class="content wysiwyg-content">
I have a field in a table in an mysql database which has been named My Project. &nbsp;I would like to know how to update that field as I get an error message because of the space between My and Project.<br />
<br />
Update mydatabase<br />
set My Project=23<br />
where id=16;<br />
<br />
I have tried single quotes, square brackets, hash marks etc but have had no luck. &nbsp;I cannot change the field name at this point.<br />
<br />
Can anyone help, please
</div>
</div>


I have a field in a table in an mysql database which has been named My Project.  I would like to know how to update that field as I get an error message because of the space between My and Project.

Update mydatabase
set My Project=23
where id=16;

I have tried single quotes, square brackets, hash marks etc but have had no luck.  I cannot change the field name at this point.

Can anyone help, please

Update mydatabase
set [My Project]=23
where id=16;

Officially the double quotes are name delimiters, so &quot;My Project&quot; could work. MySQL might have a different point of view, however.

How can I referece a field name which has a space in it

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.