Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL SET and SELECT

Have Programming Question? Ask it here!
 
 
 


samar
SET and SELECT
1 Answer(s)      3 years and 10 months ago
Posted in : SQL


hello,

What is difference between SET & SELECT in sql????


Advertisement
View Answers

October 29, 2010 at 11:43 AM


hii,

SET : The set statement is used to the update query.

SELECT : The select statement is used to display the all data's in the table.



Related Tutorials/Questions & Answers:
SET and SELECT
SET and SELECT  hello, What is difference between SET & SELECT in sql????   hii, SET : The set statement is used to the update query. SELECT : The select statement is used to display the all data's in the table
PHP SQL Select
PHP SQL Select       PHP SQL Select is used to execute mysql select query in the php application. The PHP SQL Select uses mysql_select_db () function that set the active MySQL
Advertisements
select query
select query  how to retrieve a single image from mysql table using $row[] value
select query
select query  how to write select query with where clause having multiple variables. example: i want to select the data from DB in which i want to check againest two variable in where cluase. String sql = "select * from
Column select
Column select   How i fetch Experience wise resume?   ... or no. Then using the query select * from resumes where experience='yes', fetch all the data...("jdbc:mysql://localhost:3306/test", "root", "root"); String query = "select * from
Select from select list + display
Select from select list + display  i have a select list containing... select EmpCode from the select list, the corresponding EmpName and DeptName should...;/div> <tr><td><b>Select:</b></td><td><
how I do select from select in hql
how I do select from select in hql  select RN from ( select rownum RN, dbid from ( select * from profile p where type = 1912 and name like... doesn't work select RN from ( select rownum RN, DBId from ( select distinct p
select clause in hibernate
select clause in hibernate  Example of select clause of hibernate?   Select clause is used for selection of records from a database. It picks up objects and properties and returns it in a query set. Here is your
Select Clause in hibernate.
Select Clause in hibernate.  Example of select clause of hibernate
struts2 select tag multiple
struts2 select tag multiple  struts2 select tag multiple
validate select option jquery
validate select option jquery  How to Validate select option in JQuery
select query in mysql
select query in mysql  Select query in mysql. Can anyone
Select Clause in hibernate.
Select Clause in hibernate.  Example of select clause of hibernate
Select Clause in hibernate.
Select Clause in hibernate.  Example of select clause of hibernate
html:select in struts - Struts
html select in struts  What is the HTML select in struts default value
multiple select values
multiple select values   can you provide an example for multiple select values for html:select tag
Set interface
Set interface  hello,, What is the Set interface?   hii, The Set interface provides methods for accessing the elements of a finite... is the example of Set Interface in Java. import java.util.*; public class
select option - JDBC
select option  how to dynamically generate the select option values from database
select tag multiple values
select tag multiple values   I want to insert multiple values in database which i have selected from select tag
Validate <select> tag Items
Validate select tag Items  Hi, How to validate addition of two numbers of two different "select" tag items in JavaScript..? Thanks in advance
Validate <select> tag Items
Validate select tag Items  Hi, How to validate addition of two numbers of two different "select" tag items in JavaScript..? Thanks in advance
About Select tag
About Select tag  hello Sir I am using select tag in jsp page and i want to change the background color of label which I have given to the select... in select tag please give me the solution my code as follows : <s
general syntax for a SELECT statements
general syntax for a SELECT statements  Write down the general syntax for a SELECT statements covering all the options   Hi, The general syntax of a select statement covering all the options is as follows, this syntax
select with preparedstatement in java
select with preparedstatement in java  How to write code example for select with preparedstatement in java? Thanks   Hi, Following code...("select id from keyworduniquetable where keyword=?"); pstmt.setString(1, keyword
select date in desired format
select date in desired format  how to select date from the database in DD/MM/YYYY format, because if i am trying select data from the database i am getting value in yyyy/mm/dd and time format like below "2012-05-07 00:00:00.0
Select today's date sql
Select today's date sql   I wanted to show the data from database according to the current date. So, can anyone give me the select today's date sql query? Thanks!   select current date in mysql query select * from
select box and text box validations
select box and text box validations  hi, any one please tell me how to set validations for select box and text boxes using bean classes? thank you   Please visit the following link: http://www.roseindia.net/jsp/user
MySQL Nested Select Example
Clause. The Nested Select returns you the set of records from table based...: The Query select will return the set of records from table 'mytable... MySQL Nested Select Example     
Mysql Nested Select
Mysql Nested Select       Mysql Nested Select is a SELECT query that is nested within a Select, Update... illustrate an example from 'MySQL Nested Select'. To understand and elaborate example
query regarding multiple select
query regarding multiple select  i have a select in jsp with multiple options.When i select multiple values i am not able to insert it into database and how do i retrieve them..please help me with an example code
select the foreground color for a label
select the foreground color for a label  (Using JScrollBar) Write a program that uses scroll bars to select the foreground color for a label, Three horizontal scroll bars are used for selecting the red, green, and blue components
about select tag
about select tag  Hi, i have a doubt regarding the usage of select tag,that is,suppose i am having two dropdown boxes,based on the selection of one dropdown item another dropdown item will be displayed without interacting
select query using hibernate
select query using hibernate  Hi, can any one tell me to select records from table using hibernate. Thanks   Please visit the following link: Hibernate Tutorials The above link will provide you different
Proplem with select data - Struts
Proplem with select data  Hi , Please can u give me a example for display all data from the database (Access or MySql) using Struts
Hibernate Select Query
This tutorial contain the explanation of Select clause
struts <html:select> - Struts
=db.getDbConnection(); PreparedStatement ps=con.prepareStatement("select Dealer_Code from op... attribute. This attribute should be set to the fully qualified (full package
Dynamic select box - Ajax
Dynamic select box  Hi, I Have almost completed the task... select boxes in my page.. One is "Select a Country" and other one is "Select... in the other select box automatically.. The city details must be extracted from
mysql select statement - SQL
mysql select statement  i want to select id,name,age values from database.i created the following coding to select values from the table according to the id value which is selected by the user.pls help me select id,name,age from
Select Box question
Select Box question   hello guys, i want to display data in a select box using foreign key,those data will come from other table which which is parent, that form will be in HTML(web ). i use oracle as database and i want using
where clause in select statement
where clause in select statement  In Mysql,I write the following query: select * from emp where designation = "MANAGER" But the actual value in the table is "manager" Will the above query retrieve any records? According to me
The select tag
In this section, you will learn about the select tag of Spring form tag library
Select DropDown Default
Select DropDown Default  Hi there, i have a program in JSP where i..., i.e if the user select PAGE 1 in the dropdown menu, it will display all.... the problem is if the user select "View ALL Pages" it will dislay nothing. what
Multiple select box
Multiple select box  Hi, I need help in code for multiple select box. The multiple select box should be populated with the db values.The selection done in the multiple select box is to be moved to the text area provided a add
dynamic select box
dynamic select box  thank u my dear friend.but i have a code like...> <select name="city"> <option>city</option>...) die("access failed"); $select=mysql_select_db("vtigercrm530"); if(!$select
Input type select
Input type select  This block of code shows 4 countries even when the size of the SELECT element specified is 2. Why is it so? Select a Country: <select name="country" size="2"> <option name="Australia" value
dynamic select box
dynamic select box  hello friends i created a form and details of city & locations have to be come from database. if city hyderabad chosen then locations of hyderabad only appear in location selectbox.plz send code it is more
nested select tag
nested select tag  My requirement is as follows suppose combobox to select country whenever i select a country it will show corresponding states...; </head> <body> <select name='country
select option value
select option value  if i select a value of any drop down then that value should be used in a select query of the next dropdown in jsp????  ...;/head> <body> <select name='country' onchange="showState
select option value
select option value  if i select a value of any drop down then that value should be used in a select query of the next dropdown in jsp on same page...; </head> <body> <select name='country
Help with SELECT/JOIN statement
Help with SELECT/JOIN statement  I have two tables (t1 and t2) that each have the same columns. t1 has data and t2 has changes to the data. I want a select statement that will return me all rows of t1 but, when t1.id = t2.id, I
Advertisements
 

 

 

DMCA.com