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 |
What is difference between mysql_connect and mysql_pconnect?
I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.
How can we encrypt and decrypt a data presented in a table using mysql?
How big is a blob mysql?
What is mysql_connect?
Is foreign key indexed mysql?
Is mysqli secure?
Which software is used for mysql?
Can foreign key have duplicate values?
How do we use % when performing a search query?
What is int mysql?
What is default schema in mysql?
Oracle (3259)
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)