Hi,
Ape wrote:On SQL tab, I entered todays date March 12, 2021
What does that mean?
Ape wrote:I got an error #1064. It says refer to MariaDB version.
Error 1064 means you have an error in your SQL syntax. You didn't show us your SQL Syntax.
Besides from this it is a very poor error report you tried here.
Ape wrote:How should I type the date?
https://mariadb.com/kb/en/date-and-time-data-types/Ape wrote:I was also trying to find MySQL on command prompt but couldnt locate it.
There is no specific command prompt. MariaDB provides a CLI (command line interface) which can be used by the default windows command line cmd.exe
To use the Windows command line, you need to navigate first to the folder \xampp\mysql\bin\
The CLI is accessed by program mysql, so the usage: mysql [OPTIONS] [DATABADE]
Vor getting an impression of the commands type mysql --help
Instead of using the windows cmd you can use the XAMPP Shell too by clicking the Shell button in the XAMPP control panel. This opens the command line too, but sets some additional paths and settings so you can use the CLI without navigating to \xampp\mysql\bin\