SELECT 'CREATING DATABASE STRUCTURE' as 'INFO';

Question

Just curious, what does this do?
SELECT 'CREATING DATABASE STRUCTURE' as 'INFO';

Answer 1

Hi Mohamed!
Thanks for reaching out.

This query will create a column named INFO and its content will be the string
'CREATING DATABASE STRUCTURE'.

Hope this helps.
Best,
Tsvetelin

Answer 2

I want a help please whey the employees table only have data and other tables in the database didnt have

Answer 3

@Naglaa Kamel Abd Elhaseeb They All Have Data Make sure the file executed Successfully also try Droping the employee database then re-create and wait untill it finishes.

SELECT 'CREATING DATABASE STRUCTURE' as 'INFO';

Submit an answer

related questions