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:

http://dev.mysql.com/doc/refman/5.0/en/create-database.html

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:

http://dev.mysql.com/doc/refman/5.0/en/create-table.html

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):

http://dev.mysql.com/doc/refman/5.0/en/insert.html

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:

http://dev.mysql.com/doc/refman/5.0/en/insert.html

This page is the equivalent one for mysqli

http://uk.php.net/manual/en/ref.mysqli.php

HTH


Peter


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
>
>     http://sourceforge.net/projects/miniserver/
>
> 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: http://www.opera.com/m2/
>
> --MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    
> http://lists.mysql.com/mysql?unsub=1
>
>

Thread
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