Explain the difference between BOOL, TINYINT and BIT?
Answer / amith
Prior to MySQL 5.0.3: those are all synonyms. After MySQL
5.0.3: BIT data type can store 8 bytes of data and should
be used for binary data.
| Is This Answer Correct ? | 5 Yes | 0 No |
Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products
What is csv?
What is a tinyint in mysql?
What is key in mysql?
How do you index just the first four bytes of the column?
What is a delimiter in mysql?
What are the difference between and myisam and innodb?
Is mysql and sql are same?
Is there an object-oriented version of MySQL library functions?
Where is the mysql data directory?
Is SET Command is SQL Statement..?
What is mysql sleep process?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)