For comparison between some simple commands of Oracle and mysql, refer to [group chart] _ MySQL

For comparison of some simple commands of Oracle and mysql, refer to [group chart] Comparison of some simple commands of Oracle and mysql.
Oracle mysql vs. Personal Oracle7 Release 7.3.4.0.0 mysql 3.22.34-ware-debug startup screen

Default installation directory C: ORAWIN95 C: directory where various MYSQL Utilities are located C: ORAWIN95BIN C: MYSQLBIN console tool SVRMGR. EXE
SVRMGR23.EXE mysqladmin.exe database boot program 0start73.exe screen mysqld-shareware.exe shut down database command ostop73.exe mysqladmin.exe-u root shutdown client program SQL * Plus mysql startup command c: orawin95insqlplus.exe c: mysqlinmysql.exe with user startup mode
(Direct database connection) c: orawin95insqlplus.exe system/manager @ TNS c: mysqlinmysql.exe test
C: mysqlinmysql.exe-u root test
System
Scott mysql
Test shows all users (databases) SQL> select * from all_users; C: mysqlin> mysqlshow
C: mysqlin> mysqlshow -- status
Mysql> show databases; exit command SQL> exit
SQL> quit mysql> exit
Mysql> quit changed the connection user (database) SQL> conn user name/password @ host string mysql> use database name to query all current tables SQL> select * from tab;
SQL> select * from cat; mysql> show tables;
C: mysqlin> mysqlshow database name display current connected user (database) SQL> show user mysql> connect view help SQL>? Mysql> help displays the table structure SQL> desc table name
SQL> describe table name mysql> desc table name;
Mysql> describe table name;
Mysql> show columns from table name;
C: mysqlin> mysqlshow database name table name date function SQL> select sysdate from dual; mysql> select now ();
Mysql> select sysdate ();
Mysql> select curdate ();
Mysql> select current_date;
Mysql> select curtime ();
Mysql> select current_time;
Date formatting SQL> select to_char (sysdate, ''yyyy-mm-dd'') from dual;
SQL> select to_char (sysdate, ''hh24-mi-S'') from dual;
Mysql> select date_format (now (), ''% Y-% m-% d '');
Mysql> select time_format (now (), ''% H-% I-% S '');