New to MySQL and I'm confused!

[Kvag]

Re: New to MySQL and I'm confused!

> Is there a good primer on the mechanics of how I'm supposed to actually[color=blue]
> interface with this program? Can I skip the whole command-line thing and
> just get a GUI? I imagine I'll still need to know about connecting and
> stuff with a GUI.[/color]

You should try MySQLCC (MySQL Control Center) which is GUI
administration client for the MySQL database server. Download it from
http://www.mysql.com/downloads/mysqlcc.html . Since you have the
experience from Access, you will be able to do a kick-start. Actually
it resambles more to MS SQL Server's GUI, a combination of "Enterprise
Manager" and "SQL Query Analyser". It is still in developement, the
latest version must be 0.9.something. It is really nice!
[color=blue]
>I'm an Access user, and I'm trying to learn MySQL and then PHP so I[/color]
can make[color=blue]
>some web databases. But it just isn't clicking.[/color]

The web-base thing is another story. You have to use PHP to access the
MySQL database and tables. See the PHP manual :"Function
Reference"->"LXIII. MySQL Functions" to check out the PHP commands, to
make things work the way you want it. Download the manual from

http://www.php.net

[Trent]

Re: New to MySQL and I'm confused!

"w_curtis" <anon@yahoo.com > wrote in message news:<u41Pb.200 27$zj7.19822@ne wsread1.news.pa s.earthlink.net >...[color=blue]
> I'm an Access user, and I'm trying to learn MySQL and then PHP so I can make
> some web databases. But it just isn't clicking.
>
> I've followed some tutorials, and picked up a book,[/color]

Out of curiosity, which book are you using? I'm a newbie to mySQL and
PHP, and am currently working with "PHP and MySQL Web Development" by
Welling and Thomson, and "Web Database Applications with PHP and
mySQL" by Williams and Lane. Amazon links:

http://www.amazon.com/exec/obidos/tg/detail/-/0596000413/104-2713549-7655935

http://www.amazon.com/exec/obidos/tg/detail/-/067232525X/104-2713549-7655935

[Trent]

Re: New to MySQL and I'm confused!

"w_curtis" <anon@yahoo.com > wrote in message news:<u41Pb.200 27$zj7.19822@ne wsread1.news.pa s.earthlink.net >...[color=blue]
> I'm an Access user, and I'm trying to learn MySQL and then PHP so I can make
> some web databases. But it just isn't clicking.
>
> I've followed some tutorials, and picked up a book,[/color]

Out of curiosity, which book are you using? I'm a newbie to mySQL and
PHP, and am currently working with "PHP and MySQL Web Development" by
Welling and Thomson, and "Web Database Applications with PHP and
mySQL" by Williams and Lane. Amazon links:

http://www.amazon.com/exec/obidos/tg/detail/-/0596000413/104-2713549-7655935

http://www.amazon.com/exec/obidos/tg/detail/-/067232525X/104-2713549-7655935

[Trent]

Re: New to MySQL and I'm confused!

"w_curtis" <anon@yahoo.com > wrote in message news:<u41Pb.200 27$zj7.19822@ne wsread1.news.pa s.earthlink.net >...[color=blue]
> I'm an Access user, and I'm trying to learn MySQL and then PHP so I can make
> some web databases. But it just isn't clicking.
>
> I've followed some tutorials, and picked up a book,[/color]

Out of curiosity, which book are you using? I'm a newbie to mySQL and
PHP, and am currently working with "PHP and MySQL Web Development" by
Welling and Thomson, and "Web Database Applications with PHP and
mySQL" by Williams and Lane. Amazon links:

http://www.amazon.com/exec/obidos/tg/detail/-/0596000413/104-2713549-7655935

http://www.amazon.com/exec/obidos/tg/detail/-/067232525X/104-2713549-7655935

[Karam Chand]

Re: New to MySQL and I'm confused!

You can try SQLyog at http://www.webyog.com/sqlyog

ibob17@yahoo.gr (Kvag) wrote in message news:<97d23207. 0401250318.dcb0 42c@posting.goo gle.com>...[color=blue][color=green]
> > Is there a good primer on the mechanics of how I'm supposed to actually
> > interface with this program? Can I skip the whole command-line thing and
> > just get a GUI? I imagine I'll still need to know about connecting and
> > stuff with a GUI.[/color]
>
> You should try MySQLCC (MySQL Control Center) which is GUI
> administration client for the MySQL database server. Download it from
> http://www.mysql.com/downloads/mysqlcc.html . Since you have the
> experience from Access, you will be able to do a kick-start. Actually
> it resambles more to MS SQL Server's GUI, a combination of "Enterprise
> Manager" and "SQL Query Analyser". It is still in developement, the
> latest version must be 0.9.something. It is really nice!
>[color=green]
> >I'm an Access user, and I'm trying to learn MySQL and then PHP so I[/color]
> can make[color=green]
> >some web databases. But it just isn't clicking.[/color]
>
> The web-base thing is another story. You have to use PHP to access the
> MySQL database and tables. See the PHP manual :"Function
> Reference"->"LXIII. MySQL Functions" to check out the PHP commands, to
> make things work the way you want it. Download the manual from
> http://www.php.net[/color]

[Karam Chand]

Re: New to MySQL and I'm confused!

You can try SQLyog at http://www.webyog.com/sqlyog

ibob17@yahoo.gr (Kvag) wrote in message news:<97d23207. 0401250318.dcb0 42c@posting.goo gle.com>...[color=blue][color=green]
> > Is there a good primer on the mechanics of how I'm supposed to actually
> > interface with this program? Can I skip the whole command-line thing and
> > just get a GUI? I imagine I'll still need to know about connecting and
> > stuff with a GUI.[/color]
>
> You should try MySQLCC (MySQL Control Center) which is GUI
> administration client for the MySQL database server. Download it from
> http://www.mysql.com/downloads/mysqlcc.html . Since you have the
> experience from Access, you will be able to do a kick-start. Actually
> it resambles more to MS SQL Server's GUI, a combination of "Enterprise
> Manager" and "SQL Query Analyser". It is still in developement, the
> latest version must be 0.9.something. It is really nice!
>[color=green]
> >I'm an Access user, and I'm trying to learn MySQL and then PHP so I[/color]
> can make[color=green]
> >some web databases. But it just isn't clicking.[/color]
>
> The web-base thing is another story. You have to use PHP to access the
> MySQL database and tables. See the PHP manual :"Function
> Reference"->"LXIII. MySQL Functions" to check out the PHP commands, to
> make things work the way you want it. Download the manual from
> http://www.php.net[/color]

[Karam Chand]

Re: New to MySQL and I'm confused!

You can try SQLyog at http://www.webyog.com/sqlyog

ibob17@yahoo.gr (Kvag) wrote in message news:<97d23207. 0401250318.dcb0 42c@posting.goo gle.com>...[color=blue][color=green]
> > Is there a good primer on the mechanics of how I'm supposed to actually
> > interface with this program? Can I skip the whole command-line thing and
> > just get a GUI? I imagine I'll still need to know about connecting and
> > stuff with a GUI.[/color]
>
> You should try MySQLCC (MySQL Control Center) which is GUI
> administration client for the MySQL database server. Download it from
> http://www.mysql.com/downloads/mysqlcc.html . Since you have the
> experience from Access, you will be able to do a kick-start. Actually
> it resambles more to MS SQL Server's GUI, a combination of "Enterprise
> Manager" and "SQL Query Analyser". It is still in developement, the
> latest version must be 0.9.something. It is really nice!
>[color=green]
> >I'm an Access user, and I'm trying to learn MySQL and then PHP so I[/color]
> can make[color=green]
> >some web databases. But it just isn't clicking.[/color]
>
> The web-base thing is another story. You have to use PHP to access the
> MySQL database and tables. See the PHP manual :"Function
> Reference"->"LXIII. MySQL Functions" to check out the PHP commands, to
> make things work the way you want it. Download the manual from
> http://www.php.net[/color]