+ 1
in the statement "SELECT * FROM customers WHERE ID = 7;. what does this sign (*) mean?
i am having this doubt because earlier "column_list" was written instead of this (*)
6 Réponses
+ 13
if only one id is there whose id = 7, then using * will output the details of the corresponding id. But if more IDs are there where ID=7 then it will output all the details line by line. if you have made the ID as Primary Key, then you cannot have more than one IDs where ID = 7.
+ 6
wildcard symbol means "everything" (select everything from customers)
+ 3
*means all.... That means select all
+ 2
yes, "*" means "all" and actually means the same thing across many different languages.
so you select all from customers where ID=7
+ 2
* in this context means all fields. however, the where clause will restrict the returned records to only those that have the ID of 7, and if it is structured properly, and the ID is a primary key, this will just be one record.
+ 2
Select All From Customers Where ID=7