Thanks for that Mark - very helpful. Could I just sneek in one last question. I have created a database called 'friends' via mysql> in a console window having started from a DOS prompt - below is the code:
(little diagram of a table appears showing two database names - mysql and test)
Welcome to the Mysql monitor. Commands end with ; or \g.
Your Mysql connection id is 4 to server version: 3.23.32_debug
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql> CREATE DATABASE friends;
Query OK, 1 row affected (0.05 sec)
mysql> use friends;
mysql> CREATE TABLE students (surname CHAR(30) DEFAULT'' NOT NULL, firstname CHAR(25) DEFAULT'' );
Query OK, 0 rows affected (0.17 sec)
mysql> INSERT INTO students VALUES ('Lawrence', 'David'), ('Conrad', 'Joseph');
Query OK, 2 rows affected (0.05 sec)
Records: 2 Duplicates: 0 Warnings 0
mysql> SELECT * FROM students;
(little diagram of my table + contained data)
2 rows in set (0.11 sec)
My questions are:
1.What type of datadase have I just created, is it an access database, a mysql database or what?
2.Presumably there must be some advantage in creating an ODBC for my friends database. Briefly, what do I gain by doing this?
Sorry for asking such low IQ type questions but I'm struggling to get my head round all these new concepts.