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