Thread: mysql commands

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2000
    Posts
    7
    Rep Power
    0
    Is there any way to enter mySQL commands without a telnet account? I'm trying to do something simple like creating a table, but I can't find a PHP function for that.
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2000
    Posts
    7
    Rep Power
    0
    Would something like this work?

    $createTable = "CREATE TABLE cover ( ";
    $createTable .= "first_name VARCHAR (25), ";
    $createTable .= "last_name VARCHAR (25))";

    mysql_query($createTable);

    [This message has been edited by sonic (edited September 25, 2000).]
  4. #3
  5. No Profile Picture
    Viper_SB
    Guest
    Devshed Newbie (0 - 499 posts)
    Try it.

    If it works then it works. Yes I think it should work.

    BTW you can get a thing called phpMyAdmin from http://phpwizard.net/projects/phpMyAdmin/ and all you need to do is change a few settings in one file and it gives you easy access to mySQL

    ------------------
    Viper_SB
  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2000
    Posts
    7
    Rep Power
    0
    Hmm that apparently worked, but I obviously didn't get the list_tables function to work. I loaded phpmyadmin and it showed my cover..

    thanks for the recommendation of the script, this looks a lot easier than what I was trying to do...

    ------------------
    sonic junkie

Similar Threads

  1. Mysql problem.
    By Nik in forum MySQL Help
    Replies: 54
    Last Post: December 21st, 2006, 07:02 PM
  2. How do I use MySQL commands in VB
    By redstar in forum Visual Basic Programming
    Replies: 7
    Last Post: April 12th, 2004, 05:12 PM
  3. Upgrade from access to mysql
    By karib1 in forum ASP Programming
    Replies: 7
    Last Post: December 16th, 2003, 01:35 PM
  4. Upgrade from access to mysql
    By karib1 in forum MySQL Help
    Replies: 1
    Last Post: December 16th, 2003, 01:27 AM

IMN logo majestic logo threadwatch logo seochat tools logo