+ 1
Select *from people where city='Boston'.
it S not workout but which have ans tell me
5 Answers
+ 2
You should write it properly... It is recommended that you write each command on a new line to avoid getting confused
i.e write it as:
SELECT*
FROM [People]
WHERE [City] = 'Boston'
0
is there a space missing between * and from
0
You do need enough whitespace (spaces, new lines, etc) between the keywords for the computer to know what you mean. In this case, you don't have a space between * and from. It's okay to put city='Boston' like that because the = tells it you're doing a WHERE clause condition, but the keyword FROM needs to have whitespace around it. It's good practice to use whitespace even if you technically don't need it for the query to run, that way other programmers know what your code does without spending too much time reading it.
You should end up with:
SELECT * FROM people
WHERE city = 'Boston';
0
A whitespace is needed between * and the keyword From. For instead:
Select * From people
Where city = 'Boston';
0
You need spaces between words buddy