SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: Odbc

  1. #1
    SitePoint Enthusiast
    Join Date
    Jul 2001
    Location
    cheshire
    Posts
    83
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Odbc

    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:


    C:\WINDOWS\cd\
    C:\>cd apache\mysql\bin
    C:\apache\mysql\bin>mysqld --standalone
    C:\apache\mysql\bin>mysqlshow

    (little diagram of a table appears showing two database names - mysql and test)

    C:\apache\mysql\bin>mysql.exe
    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)
    mysql> exit;
    Bye

    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.
    Thanks
    David

  2. #2
    SitePoint Wizard
    Join Date
    Jul 2001
    Location
    The Netherlands
    Posts
    2,617
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    1. You created a MySQL Database.

    2. I am sorry, I am still not familiar with ODBC, I should start examining that one of these days.

    Anyway, I hoped this helped you a bit further on your way.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •