Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
the abc bank authority now wants to create a database for their customers so you are requested to modify your program of assignment a3 as followsthe
define sequencea sequence is a set of integers 1 2 3 that are generated in order on demand sequences are regularly used in databases because lots of
express types of information available in mysqlinformation as regards the result of queries this includes number of records affected by any select
define aggregate functions and what aggregate functions supported by the mysqlto calculate a summary value from a set of individual values and uses
why do you go for sorting your query resultssql select command to fetch data from mysql table whenever you select rows the mysql server is free to
provide examples of different types of time and date formats its most common store dates using a dash - as a colon and the delimiter as the time
which types of data supported by mysql for time and date formats mysql supports a number of time and date column formats some of them are1 date2
express the ways provided by mysql for pattern matchingmysql provides two kinds of pattern matching1 one is based on sql patterns2 regular
what are the kinds of strings -a binary string in mysql is one that mysql treats as case sensitive in comparisons-a non binary string in mysql is
express the properties of strings strings can be case sensitive or not which can change the outcome of string operations you can evaluate whole
explain the disadvantages of creating a temporary table if you have already created a temporary table with a shown name and attempting to create a
what is use of generating such tables how can you create temporary tableswhen you require a table only for a short time after that you want it to
what kind of advantages to copying records from one table to another- when an algorithm that modifies a table is used after that its safer to work
whenever the limit clause will be usedlimit is used for the following kinds of problems1 answering questions about first or last and largest or
how can you map null values to other values while displayif ifnull keywords are used to do so they are limit is used for the following kinds of
define various ways in which select statement can be used for record selection technology select gives you control over a number of aspects for
what are the ways of obtaining the connection parameters hardwire the parameters into the program ask for the parameters interactively get the
what are the benefits of prepared statements and place holders parameter binding operations automatically handle escaping of characters encourage
describe the two types of methods for retrieving rows in python fetchone- returns the next row as a sequence fetch all- returns the entire result
what are the differences among mysqlfetcharray mysqlfetchobject mysqlfetchrow mysqlfetchobject returns the result from the database like objects
define the categories of sql statements1 statements that dont return a result set this statement class includesinsert delete and update2statements
what is difference among mysqlconnect and mysqlpconnectmysqlconnect opens a new connection to the database while mysqlpconnect opens persistent
what are the three fundamental operations that are regular to mysql programsa establishing a connection to the mysql serverb choosing a databasec
describe the capabilities offered via mysql client apis bull checking for errors bull connecting to the mysql server selecting a database
describe the tools that are available for managing mysql servergiven below are the tools to manage mysql server mysqld - mysql server daemon this is