Question: to write an SQL query using insert statement

Ads

 
 
 

Share on Google+Share on Google+

renuka
to write an SQL query using insert statement
0 Answer(s)      5 years and 6 months ago
Posted in : SQL

I need to write an sql query for the below using InSERT command.pls help.

Insert 5-star ratings by James Cameron for all movies in the database. Leave the review date as NULL.

The table details are as follows:

Movie ( mID, title, year, director ) English: There is a movie with ID number mID, a title, a release year, and a director.

Reviewer ( rID, name ) English: The reviewer with ID number rID has a certain name.

Rating ( rID, mID, stars, ratingDate ) English: The reviewer rID gave the movie mID a number of stars rating (1-5) on a certain ratingDate.

Ads
View Answers
Ads









Related Tutorials/Questions & Answers:
to write an SQL query using insert statement
to write an SQL query using insert statement  I need to write an sql query for the below using InSERT command.pls help. Insert 5-star ratings by James Cameron for all movies in the database. Leave the review date as NULL
Write a query to insert a record into a table
Write a query to insert a record into a table  Write a query to insert a record into a table   Hi, The query string is as follows- Insert into employee values ('35','gyan','singh'); Thanks
Advertisements
SQL Backup query with where statement
SQL Backup query with where statement       SQL Backup query with where statement ... The Tutorial show you a example from 'SQL Backup query with where
SQL Backup query with where statement
SQL Backup query with where statement       SQL Backup query with where statement ... The Tutorial show you a example from 'SQL Backup query with where
The INSERT INTO Statement, SQL Tutorial
The INSERT INTO Statement       The INSERT INTO statement is used to insert or add a record of data into the table. To insert records into a table, just write the key word
syntax error in SQL Insert Statement - Java Beginners
syntax error in SQL Insert Statement  Dear Sir ,I have write... Access Driver] Syntax error in INSERT INTO statement. plz Help Me  Hi...: PreparedStatement stm1=con.prepareStatement("insert into newfresher(prn,date
PHP SQL Insert Statement
PHP SQL Insert Statement       PHP SQL Insert Statement show you the message when the records... The Tutorial illustrate an example from 'PHP SQL Insert Statement'. To understand
How to insert image in MySQL database using sql query?
Insert image in MySQL database using sql query  ... to insert image in MySQL database using sql query?": So, lets start... can insert the image into table using the insert into sql. Following
syntax error in SQL Insert Statement - Java Beginners
syntax error in SQL Insert Statement   private class ButtonListener...","",""); Statement stmt=con1.createStatement(); int i=stmt.executeUpdate("insert into newfresher(prn,date,lname,mname,dob,address,city
JDBC Batch Example With SQL Insert Statement
JDBC Batch Example With SQL Insert Statement: In this tutorial, we are discuss about insert SQL statement with the jdbc batch. First of all, we... SQL insert statement for save data in the datasource and add
insert into statement in sql using servlets
insert into statement in sql using servlets   ...() method of the request object. Pass a query to insert the values retrieved from... insert a value from a html form in the table stored in the database. 
Insert Date using Statement - Development process
Insert Date using Statement   Hi, plz send me code for Storing system date using statement instead of preparedstatement. Thanks Prakash  Hi Friend, Try the following code: Thanks
Write a query to display a row using index
Write a query to display a row using index  Write a query to display a row using index
PHP SQL Query Insert
PHP SQL Query Insert       This example illustrates how to execute insert query in php...). Now, queries can be executed using mysql_query() method to insert values
Php Sql Query Insert
Php Sql Query Insert  This example illustrates how to execute insert query with values in php application. In this example we create two mysql query for insert statement with separate values in the database table. The table before
SQL And Statement
SQL AND Statement      ... with Example The Tutorial illustrates an example from SQL AND Statement... Query The given SQL Query uses SQL AND Operator to fetch
Insert data in mysql database through jsp using prepared statement
Insert data in mysql database through jsp using prepared statement...; This is detailed jsp code that how to insert data into database by using prepared statement...; <HEAD> <TITLE>insert data using prepared statement </TITLE>
The INSERT INTO Statement
The INSERT INTO Statement       The INSERT INTO statement is used to insert or add a record of data into the table. To insert records into a table, just write the key word
How to insert image in sql database from user using servlet
How to insert image in sql database from user using servlet  pls tell me accept image from user and insert image in sql server 2005 database using servlet and jsp
sql query
sql query  two tables are emp,loc write a query to display all the emp information whose locname not equal to bangalore
Create table and insert data by sql query
Create table and insert data by sql query... to connect java application and execute sql query like create table in mysql database, insert some values and retrieve values from the table. Before running
SQL Query
SQL Query  Selecting the third highest salary of Employee without using any subquery?   Here is a query: SELECT salary FROM employee ORDER BY salary DESC LIMIT 2,1
Sql Query
Sql Query  Hi M Navjeet Ghai I want to know How to Show A name(Like Navjeet Ghai And Manpreet Singh Sodhi) of employees from a employee table as N.Ghai & M.S.Sodhi by using sql query
SQL QUERY
Gopal oracle C Now i need to write a query "which...SQL QUERY  am a having a table 'PROGRAMMER' with columns... C pascal Bhanu Sql
Execute database query by using sql tag of JSTL SQL library
Execute database query by using sql tag of JSTL SQL library... to create application that execute sql query given by user using JSTL SQL Library...  It specifies sql query statement
Sql Query
Sql Query  Is this query work in Db2 or not ? Select * from FORUM LIMIT 2
Sql Query
Sql Query  Is this query work in Db2 or not ? Select * from FORUM LIMIT 2
SQL PHP
is used to execute the statement using the mysql_query ( ) function... is used to execute the statement of mysql_query function. The server side script...=mysql_query($sql,$connection) or exit("Sql Error".mysql_error
error : not an sql expression statement
{ Connection conn = DatabaseManager.getConnection(); Statement stmt = conn.createStatement(); String query = "insert into dbo.guru VALUES...error : not an sql expression statement  hii I am gettin followin
The INSERT INTO Statements in SQL?
The INSERT INTO Statements in SQL?  The INSERT INTO Statements in SQL?   Hi, The INSERT INTO statement is used to insert a new row or multiple rows into a table. SQL INSERT INTO Syntax INSERT INTO table_name VALUES
JDBC Prepared Statement Insert
JDBC Prepared Statement Insert   ... Statement Insert. In this Tutorial  the code describe the include a class... the given below code, we declare String variable sql,that is used to hold the insert
Tutorials   
Java Spring Hibernate Struts Training How to Fetch Data using dropdown option How to get day from date in SQL? Example of sorting results in MySQL Distinct and Limit example in MySQL How to download install and use MySQL workbench? Example of Average, Sum, Min and Max functions in MySQL How to delete data from MySQL? Update SQL Query Example Order by example in MySQL AND and OR Operators in MySQL Query Where clause with query in MySQL How to use select Statement in MySQL? How to insert data into MySQL Table? Create Database and tables in MySQL example of before insert trigger in mysql Failed to Call Procedure MY Sql Query Error - Not able to Understand the issue which query will be run for previous(button) question How to access data yearly from DB in C# ? Fastest way to upload huge raw data in database - c#, Java or stored procedure DB Insert Nb hours between 2 time stamps meets specific criteria mysql select into table from another table example MySQLselect into new table Example code How to create a .mdf file from script (.sql) Please help me out fixing broken relational links in MySQL database after an upgrade How do I upgrade mysql? mysql 4.x to 5.x upgrade problem Upgrading a PHP/MYSQL application? upgrading sql query join phpmyadmin in whm whm php version update php cpanel cpanel mysql downgrade cpanel mysql version upgrade mysql whm upgrade mysql 4 5 cpanel upgrade mysql cpanel server Did my upgrade from mySQL 5.1 to 5.5 work Upgrade to MySQL 5.5 ? - cPanel Mem use upgrade from MySQL 5.1 to 5.5 - cPanel Upgrading MySQL from 5.0 to 5.1 or 5.5 - cPanel Mysql Upgrade on WHM (Mysql 5.1 to 5.5)cPanel Mysql Upgrade on WHM (Mysql 5.1 to 5.5) - cPanel Updating from MySQL 5.0 to 5.5 cPanel MySQL 5.1 upgrade to 5.5 error Charset problem upon publishing PHP + MySQL website MySQL issue: Table 'data_dictionary.CHARACTER_SETS' doesn't exist SQL Error Version 5.5.15

Ads

 
Advertisement null

Ads