What is the datatype for password in mysql?
Answer / Kum Anshu Gupta
In MySQL, the password field should typically be of type VARCHAR or BLOB. However, for storing hashed and salted passwords securely, it's recommended to use the blob type (such as BINARY(40) or BLOB) with a hashing algorithm like SHA-256.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the use of concat() in mysql?
How to copy data from one server to another using php?
How to show table structure mysql?
What is meant by sharding?
What are the technical specifications of mysql?
What are the two types of queries?
How to include numeric values in sql statements?
Is mysql an oracle product?
What does mysql workbench do?
What is a definer?
How many ways we can we find the current date using MySQL?
What are different TEXT data types in MySQL?
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)