How do I find out what version of MySQL I am running?
Use the command:
mysql>select version();
+———–+
| version() |
+———–+
| 5.0.45 |
+———–+
1 row in set (0.00 sec)
Golden question:
Why I went for mysql version?
I was suppose to give ‘TRUNCATE’ privilege to a table that time i found one fact. i.e. there is not any TRUNCATE privilege ![]()
“The DROP privilege enables you to drop (remove) existing databases, tables, and views. Beginning with MySQL 5.1.10, the DROP privilege is also required in order to use the statement ALTER TABLE … DROP PARTITION on a partitioned table. Beginning with MySQL 5.1.16, the DROP privilege is required for TRUNCATE TABLE (before that, TRUNCATE TABLE requires the DELETE privilege).”
I Betty W. Kirk I am a New User of A computer Can You Help Me get threw the question that SQL has wrote to me thanks Betty W. Kirk
go ahead…