It's also worth remembering that there is a console for mysql, so you can
enter commands directly. There are also tutorials at places like devshed
and webdev etc. that take you through all ofthe basic administrative stuff.
Search for something like "mysql tutorial" in google.
Miles
At 02:55 PM 7/19/01 +0100, Seb Frost wrote:
>Thanks Steve that's exactly the kind of 100% definate answers I needed :-)
>Hadn't seen nor heard of front ends for it, will look into them!
>
>- seb
>
>-----Original Message-----
>From: Steve Brett [mailto:[EMAIL PROTECTED]]
>Sent: 19 July 2001 14:27
>To: [EMAIL PROTECTED]
>Subject: [PHP] Re: Basic database questions.
>
>
>
>"Seb Frost" <[EMAIL PROTECTED]> wrote in message
>[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > Hi everyone, this is my first ever post on the list so please be gentle
>with
> > me ;-)
> >
> > OK I want to put a database on my website. Up until yesterday my
>knowledge
> > of databases was having created a very simple one when I was about 15 for
> > GCSE IT. Don't ask how, but I've always avoided them, learning c++ and
>all
> > the rest of it instead. SO, I'm pretty computer literate, but know
>nothing
> > about databases.
> >
> > SO I'm told I should use PHP and MySQL. Been learning PHP for the last
>day
> > or so, seems easy enough (so far!)
> >
> > But I'm confused.
> >
> > 1) Is MySQL just a set of instructions for querying a database or is it an
> > actual format for storing a database. Somehting I read suggested that
>MySQL
> > should be used to access Acess DB's - wtf?
> >
>
>mysql is a database management system that is relational to a certain extent
>(no flames).
>php has an abstraction layer that allows php to interface directly with
>mysql (and other 'better' databases such as postgresql) via a port (5432 in
>the case of postgresql).
>drop access from your mind altogether. you simply don't need to use it if
>you use mysql.
>
> > 2) OK so I can see how the mysql instructions will get data from a
>database
> > but how do I create the little bastard in the first place? SHOULD I be
> > using something like access? It makes no sense to me!
> >
>
>get mysql and install it. then get a front end editor like mysql-front or
>pg_admin for mysql.
>you can either use the front end to create your database or do it via the
>command line using SQL.
>
> > Sorry for the dumb questions, but I need soem dumb answers! It seems
> > everything about MySQL on the web is directed at people who have used
> > databases extensively.
> >
>
>to be hones that's true to a certain extent but i always thought of mysql
>being the access of open source dbs (just to cnfuse you further!!!) but it
>certainly isn't the case. not as robust as postgresql for 100's of
>concurrent users but feature rich and easy to use.
>
>time to jump off the micro$oft bandwaggon - you'll never look back !!
>
>Steve
> > thanks everyone,
> >
> > - seb
> >
>
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
