6 messages in com.mysql.lists.win32Re: Correct install?| From | Sent On | Attachments |
|---|---|---|
| Ron Smith | 08 Apr 2005 10:47 | |
| Joseph Connolly | 08 Apr 2005 11:05 | |
| Berman, Mikhail | 08 Apr 2005 11:14 | |
| SGr...@unimin.com | 08 Apr 2005 11:20 | |
| Joseph Connolly | 08 Apr 2005 11:37 | |
| Ron Smith | 08 Apr 2005 13:27 |
| Subject: | Re: Correct install? |
|---|---|
| From: | SGr...@unimin.com (SGr...@unimin.com) |
| Date: | 04/08/2005 11:20:15 AM |
| List: | com.mysql.lists.win32 |
Joseph Connolly <joz...@gmail.com> wrote on 04/08/2005 02:05:35 PM:
google it.
www.google.com/search?q=MySQL+tutorial
There are a ton of books on MySQL and various other things associated with it. There are also client helper applications with MySQL which you can get from www.mysql.com including an administrative GUI and a query helper. As far as everything else the BEST place to start is www.mysql.com/doc Is has everything you need to know.
as far as populating it....there are a few ways to do this. PHPMyAdmin seems like the most common interfaces to DL for noobs like you and I. It
can be found at http://www.phpmyadmin.net. You can also create forms to input data using PHP. You can create text files of code and import them or you can just enter it right from the command prompt. The possibilities are endless. Good luck. (HTH!) jozef
Ron Smith wrote:
I'm totally new to MySQL and databases in general. I've done an
install of MySQL running on a Windows XP Professional laptop. But I'm a little confused as to how to populate the database. The service is running, the Command Line Client works and '\s' gives the following info after I log in. I'm wondering if this is a typical status report. I also have installed the online documentation, but am wondering where I should start reading.
TIA ron
mysql> \s
-------------- C:\Program Files\MySQL\MySQL Server 4.1\bin\mysql.exe Ver 14.7 Distrib 4.1.11, for Win32 (ia32) Connection id: 2 Current database: Current user: root@localhost SSL: Not in use Using delimiter: ; Server version: 4.1.11-nt Protocol version: 10 Connection: Named pipe: mysql Server characterset: latin1 Db characterset: latin1 Client characterset: latin1 Conn. characterset: latin1 UNIX socket: mysql Uptime: 29 min 37 sec Threads: 1 Questions: 22 Slow queries: 0 Opens: 16 Flush tables: 1 Open tables: 0 Queries per second avg: 0.012
-------------- mysql>
oops!! Maybe you missed the part where he said he was on XP. No Apache or PHP there. PHPmyAdmin is not a good fit for him.
PLEASE DO RTFM - I highly recommend Reading The Fine Manual (there is a good tutorial section, I think it's chapter 3) and look for other online tutorials. Any good walkthrough will help you get your feet wet while explaining what is going on.
What you need to figure out is how to do things in small steps (how to create a table, how to add records to the table, how to write a query, how to change an existing record, etc.) Start small and work your way up. Each step builds on the others. The FULL and DETAILED explanations are also in the book but if you learn to skim through all of the extra details until you find just the part you need, you will be well on your way.
If you have any questions and can't find the answers on your own (you will learn more and learn faster if you TRY to find the answer than if you are always given the answer first) you are invited and encouraged to ask the list. We can all remember the first time we logged into a database and how particular computers are about spelling and punctuation. The majority of your early mistakes will be in translation. You think in one language but the database only understands SQL and sometimes it can be rather picky about how you ask it to do things.... ;-)
Best Wishes!!
Shawn Green Database Administrator Unimin Corporation - Spruce Pine