0

what is de real sintaxis from SELECT

SELECT OR SELECT* (i dont understand)

9th Jan 2019, 4:10 AM
Sugei Sandoval
Sugei Sandoval - avatar
3 odpowiedzi
+ 1
SELECT [fields] FROM [table] Fields are coma separated or asterisk for all // Get just name & Age SELECT name,age FROM person; // Get all columns SELECT * FROM person;
9th Jan 2019, 4:47 AM
voidneo
+ 1
Say suppose 3 columns are there in a database table such as NAME , ID , MOBILE NUMBER. if you want to select name from the table You write query as Select NAME from Table_name If you want to display all the columns Then instead of mentioning all the column names,we can say simply, Select * from table_name
9th Jan 2019, 4:53 AM
Mohammed Suhail
Mohammed Suhail - avatar
0
The SELECT statement is used to select data from a database SELECT column1, column2, ... FROM table_name; If you want to select all the fields available in the table, use the following syntax: SELECT * FROM table_name;
9th Jan 2019, 12:42 PM
Akwin Lopez
Akwin Lopez - avatar