Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
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
how can you terminate the mysql servertyping the following in command prompt will shut down the server completely as root user mysqladmin -u root -p
how can you start mysql serverto start the mysql program type it is name in the command- line prompt after starting mysql program just displaya
how can you connect to the mysql serverin order to connect to the mysql server it is necessary to give the username and password so this be able to
why do so various organizations use mysqladvantages open source highly efficient offers a high scalability in terms of size and connectivity highly
what is mysqlmysql is a relational database management system which has eleven million installations it can be used for both linux and window
what are the ways in which signal can be generateda signal might be generated in many ways such as a signal is result of particular physical