Why ProFreName values and "ProductFresh1" equivalent, the former would be an error?

CodePudding user response:

The name of the table don't add single quotation marks

CodePudding user response:

Any SQL syntax error, as long as the patchwork of SQL statements out and look at the execution, the be clear at a glance, don't want to code where the problem, directly from the results to find the problem

CodePudding user response:

What are you doing the single quotation marks of the second sentence is?

CodePudding user response:

The table name, can add []
The single quotes is mysql trying

CodePudding user response:

SQL syntax errors, check the SQL statement

CodePudding user response:

 
Select * from table 

Rather than

 
Select * from 'table' 

In the said.. The question what is the relationship between c # types you...

CodePudding user response:

String concatenation spell that

CodePudding user response:

Select * from ProductFresh1 where a='1'

This can be, the name of the table without when quotes, plus single quotation marks