List:General Discussion« Previous MessageNext Message »
From:Peter Bradley Date:October 10 2006 7:45am
Subject:Re: hello everyone
View as plain text  
You'll probably need to create a database first (to host the table).  
This can be done most easily from the GUI MySQL Administrator tool, or 
from phpMyAdmin if you have it, or from a mysql command line:

To create a table use the CREATE TABLE command in MySQL, either from a 
mysql command line or from the GUI MySQL Query Browser:, or from the GUI 
MySQL Administrator tool, or from phpMyAdmin:

To load the table with data use the INSERT command (either from the 
mysql command line, the Query Browser, or from php code using an 
explicit command string or a stored procedure):

To access it using an appropriate SELECT statement either passed as a 
string or a stored procedure, php has a full set of functions that start 
mysql_, or mysqli_.  You'll prefer the latter if you're into object 
orientation.  This page explains about the mysql_ fuctions and has links 
to all the individual ones:

This page is the equivalent one for mysqli



Ysgrifennodd alan:
> my name is alan madsen.
> while i am very well grounded in complex systems and database
> management that is archaic by today's standards, i am looking
> at a creating a server-side php/mysql environment for a very
> simple database application with only the experience of recent
> light reading and knowing that i've successfully installed a wamp
> serverkit on windows 2k (uniform server) that includes mysql5:
>     The Uniform Server is a lightweight server solution
>     for running a web server under the WindowsOS. 5.79MB!
>     It includes the latest versions of Apache2, Perl5, PHP5,
>     MySQL5, [and] phpMyAdmin
> running on a laptop, i've seen this installation's instance of
> apache serve web pages to the net.
> very nice.
> i'd like to create, load, and maintain, a mysql database table
> containing fewer than 8,000 records, each with 5 fields (rows?)
> - lengths ranging from 10 bytes to 80 bytes - of character data,
> one field of which would be used as data and as a isamkey (com-
> pound keys would be nice, but they are not necessary).
> assuming a working installation of mysql5 and that a csv data file
> exists, will someone outline what steps are necssary to: 1. create
> such a table, 2. load it, and 3. the mysql methodology to access it
> via php/mysql_isam?
> any comment would be appreciated.
> regards,
> --Using Opera's revolutionary e-mail client:
> --MySQL General Mailing List
> For list archives:
> To unsubscribe:    

Glitch in Query OptimizerRobert DiFalco3 Oct
  • RE: Glitch in Query OptimizerRobert DiFalco3 Oct
    • Re: RE: Glitch in Query OptimizerDan Buettner3 Oct
      • RE: RE: Glitch in Query OptimizerRobert DiFalco3 Oct
    • Re: Glitch in Query OptimizerChristian Hammers3 Oct
      • RE: Glitch in Query OptimizerRobert DiFalco4 Oct
        • Re: RE: Glitch in Query OptimizerDan Buettner4 Oct
  • Re: Glitch in Query OptimizerChris9 Oct
    • hello everyonealan10 Oct
      • Re: hello everyoneRolando Edwards10 Oct
    • hello everyonealan10 Oct
      • Re: hello everyonePeter Bradley10 Oct