+ 10

SQL sentences

I'am trying to make SQL sentences like: The company + company + budget is + budget + . But i can't seem to find out how 😕

20th Dec 2018, 7:00 PM
Arne Van Kerckvoorde
Arne Van Kerckvoorde - avatar
8 Réponses
+ 9
So I wrote and tested like this: SELECT "my name is" , name FROM table1 WHERE id=1 but return something like this: | my name is | pedro | two columns If you want to concat, use a function SELECT CONCAT ( str1, str2 ) arguments str1, str2 are strings
21st Dec 2018, 12:42 AM
Pedro H.J
Pedro H.J - avatar
+ 8
Its for school and the assignment says i cant use php.
20th Dec 2018, 8:38 PM
Arne Van Kerckvoorde
Arne Van Kerckvoorde - avatar
+ 8
Thanks Pedro it was concat i was looking for 😀
21st Dec 2018, 4:33 PM
Arne Van Kerckvoorde
Arne Van Kerckvoorde - avatar
+ 7
How is your database and table ? I guess that you need a select multiple tables.
20th Dec 2018, 7:29 PM
Pedro H.J
Pedro H.J - avatar
+ 7
And yes i normally use php too for this 😀
20th Dec 2018, 8:39 PM
Arne Van Kerckvoorde
Arne Van Kerckvoorde - avatar
+ 6
Pedro H.J Hi pedro. I just want to make a sentence with values from the database inside the sentence. Like: 'Hi my name is: ' + users.name Without using php 😀
20th Dec 2018, 7:34 PM
Arne Van Kerckvoorde
Arne Van Kerckvoorde - avatar
+ 6
I make this with PHP. Exemplo echo "my name is"; echo $var ; Where var is a variable SELECT result from MYSQL database.
20th Dec 2018, 7:39 PM
Pedro H.J
Pedro H.J - avatar
+ 1
whaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaat
1st Jan 2019, 12:56 AM
Sami Ibrahim
Sami Ibrahim - avatar