aliceblue F0F8FF aliceblue aliceblue aliceblue aliceblue antiquewhite FAEBD7 antiquewhite antiquewhite antiquewhite antiquewhite aqua 00FFFF aqua aqua aqua aqua aquamarine 7FFFD4 aquamarine aquamarine aquamarine aquamarine azure F0FFFF azure azure azure azure…
mysql> show databases; MySQL Export:-------------mysqldump -u root -p --databases myschema > /var/www/html/myschema/backup_db/MySchema_20101228.sqlMySQL Import:-------------mysql -u root -p --database myschema < /home/nista/myschema_temp/MySchema_20101228_1458.sqlMySQL Export just the schema:------------------------------mysqldump -u root -p --no-data myschema >…
MySQL data types: CHAR( ) A fixed section from 0 to 255 characters long.VARCHAR( ) A variable section from 0 to 255 characters long.TINYTEXT A string with a maximum length…
To create an heterogenous database link (to another database):1) set an odbc connection named testdb and in advanced put username/password (admin/admin)2) put inittestdb.ora in D:\oracle\product\10.2.0\db_1\hs\admin (* see below)3) put tnsnames.ora…
The statement below clears the cache, so you can run benchmarks against SQL execution: alter system flush buffer_cache