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/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
