Primary Key Question
I understood that MySQL didn't internally keep up with the relationships between tables... like MS Access... And that it was up to the programmer to referential integrity... But I noticed in phpMyAdmin that the offer the option of defining a column in a table as 'Primary' Am I confused on this or is this something that phpMyAdmin takes does ?? thanks for any help. tmb __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to xfr Windows MySQL db to Linux ?
Will MySQL/Windows db files work on a Linux box? I'm guessing they will, but then someone questioned me. I'm creating a MySQL/PHP db prototype on a Windows box running Apache... but it will end up on a Linux/Apache server some day. Thanks for any help. tmb __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to start use MySQL in Windows
1 - How do I start MySQL on a Windows box? I can do it from the command line in Linux. 2 - Once started can I create a db, tables, etc the same as if it were on a Linux machine? thanks for any help. tmb ps - I have phpMyAdmin running on the Windows machine, but I wanted to know how to do it directly from the DOS command line. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to start use MySQL in Windows
1 - How do I start MySQL on a Windows box? I can do it from the command line in Linux. 2 - Once started can I create a db, tables, etc the same as if it were on a Linux machine? thanks for any help. tmb ps - I have phpMyAdmin running on the Windows machine, but I wanted to know how to do it directly from the DOS command line. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
English version of EasyPHP ??
I want to install EasyPHP with Apache-MySQL-PHP on a Windows laptop for use over the holidays... I am a newbie at all this. I installed EasyPHP on an extra Windows Desktop here to try it and all the doc's are in French. (It also installed phpmyadmin... doc's for this also in French) 1 - Is there a version of EasyPHP in English? 2 - Is there an EasyPHP mail list or other online user to user support(in English) ? Thanks in advance for any help. tmb __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Where does MySQL store db files?
1 - On a Linux/Apache box, when you create a MySQL db with tables, etc, Where does MySQL store the files associated with the db? 2 - On subsiquent db's, does MySQL store those files in the same directory or each db in a seperate folder? thanks - tmb __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to see # of rec's in all tables
2 questions... My tutorial db has a number of tables in it... some with data... some with no records. 1 - How can I ask MySQL to tell me the number of records in my tables? ..a) all at once? Meaning one command to list... tbl_1 6 records tbl_2 3 records tbl_3 0 records etc ..b) one table at a time? Meaning one command per tbl 2 - How can I dump the contens of _all_ tables to the screen or to a text file? thanks for all the help - tmb __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Multiple MySQL db's on one machine
I was told that if you had multiple MySQL db's on a single machine... that actually it was really only one db with tables for for db1, db2, db3... ??? This doesn't sound right. I thought MySQL created a seperate directory for each db put each db's files in their respective folder... true or not ? thanks - tmb __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to Retreive Web Links from MySQL to HTML ???
I want to store some web links in a MySQL db... than later using PHP retreive them and put them on a web page... Does PHP have to do all the work here... 1 - fetch the url from the db 2 - fetch the link name from the db 3 - construct the html code to display it or is there a better way? thanks for any info - tmb __ Do you Yahoo!? Yahoo! Mail Plus Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to link tables in MySQL
1 - any way to search archives of MySQL list? 2 - In MS Access you have to graphically connect the table id fields to tell Access how the tables relate. How do you do this In MySQL... from the command line I'm sure... just a code snippit or reference to one would be nice... Thanks for any help - tmb __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to port MS Access to MySQL ??
Is there a tool for doing a quick port from MS Access to MySQL? Or must you manually create all the tables sql statements in MySQL and then export the MS Access data to a comma delimited file... then import it into MySQL? Thanks for any help - tmb __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How to port MS Access to MySQL ??
Alan, 1 - what is MySQLfront? 2 - where can I get it? 3 - does it run under Linux? 4 - is it open source /or free? 5 - or does it come with MySQL ?? thanks - tmb --- Alan McDonald [EMAIL PROTECTED] wrote: MySQLfront does it all -Original Message- From: tmb [mailto:topmailbox;yahoo.com] Sent: Friday, 8 November 2002 23:18 To: [EMAIL PROTECTED] Subject: How to port MS Access to MySQL ?? Is there a tool for doing a quick port from MS Access to MySQL? Or must you manually create all the tables sql statements in MySQL and then export the MS Access data to a comma delimited file... then import it into MySQL? Thanks for any help - tmb __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to port MS Access to MySQL ??
Petre, Where do I get MyOdbc ?? Does it run on linux? thanks - tmb --- Petre Agenbag [EMAIL PROTECTED] wrote: myodbc works fairly OK for me. On Fri, 2002-11-08 at 14:17, tmb wrote: Is there a tool for doing a quick port from MS Access to MySQL? Or must you manually create all the tables sql statements in MySQL and then export the MS Access data to a comma delimited file... then import it into MySQL? Thanks for any help - tmb __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Another Defining Relationships in MySQL Question
In MS Access you define relationships between Key ID fields by dragging a line on the screen from the parent table to the child table. So, if you are enforcing referential integrity you can not delete data that is referred to by another table or mess up the basic db structure... (think I have this about right :) When you first create a db in MySQL... how do you tell MySQL which Key field in table A is related to a field in table B? Thanks for any help - tmb __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Resubmit: How to Print field(s) to Printer ??
Sorry for the resubmission but I thought I would try again to get a tip on how to do this. I am a newbie, so thanks for any help. I'm Running RedHat Linux 7.3 - Apache - MySQL scripting with PHP on an Intel box... Question 1: I want to print a specified field or fields, in specified records of an mysql db to the line printer several times a day... Can anyone get me started on the PHP script to do this? Question 2: Is there a better place to post PHP MySQL questions? Thanks againf or any help.- tmb __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to Print field(s) to Printer ??
I'm a newbie, so thanks for any help. Running RedHat Linux 7.3 - Apache - MySQL scripting with PHP on an Intel box... Question 1: I want to print a specified field or fields, in specified records to the line printer several times a day... Can anyone get me started on the PHP script to do this? Question 2: Is there a better place to post PHP MySQL questions? Thanks againf or any help.- tmb __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Where are db files ??
HELP ! I'm a newbie to both Linux mySQL. I have a simple mySQL sample data base running on a Red Hat 7.3 machine. It was already setup when I got it. Now I want to find the data base files that mySQL creates so I can back them up... and for my education. I can't seem to get Linux to search the entire hard disk... and I'm really not sure of the data base file names... it comes up in a demo web page. 1 - Where does mySQL normally store it's data base files? 2 - Can you change the default directory for a data base? 3 - How do you get Linux to search the entire disk for a file? Thanks for any help... tmb __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL vs PostreSQL ??
How does PostreSQL compair to MySQL ? I'm sure each has it's own advantages disadvantages. What are some of the major ones? Which would be more capible in a large web base database where the database was very large and the hit rate very high? Thanks - tmb __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Will MySQL_Linux_Apache handle Yahoo level traffic data?
Jeremy, Thanks for the info. Do you happen to know how many actual hits a Yahoo or eBay or Google get each day? According to http://us.mediametrix.com/data/thetop.jsp Yahoo had about 60 million "unique visitors" in Feb Google had about 10 million eBay was in the middle Unique Visitor is the catch... I could visit Yahoo 5 times a day but I would count as only one unique visitor. I'm trying to determin the number of hits... or request by internet clients for web pages... to get an idea of the bandwidth requirments for very large internet sites. Thanks for any help - tmb --- "Jeremy D. Zawodny" [EMAIL PROTECTED] wrote: On Mon, Mar 19, 2001 at 06:05:47AM -0800, tmb wrote: I'm a newbie to the Linux-Apache+MySQL world. 1 - Will MySQL handle a data base as large as a Yahoo or Google or E-Bay ? Done properly, yes. 2 - Will MySQL running on a Linux/Apache system handle traffic that approaches that of a Yahoo, Google or E-Bay? Same answer. 3 - Does MySQL have an equilivant to "stored proceedures? Not today, no. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Will MySQL_Linux_Apache handle Yahoo level traffic data?
I'm a newbie to the Linux-Apache+MySQL world. 1 - Will MySQL handle a data base as large as a Yahoo or Google or E-Bay ? 2 - Will MySQL running on a Linux/Apache system handle traffic that approaches that of a Yahoo, Google or E-Bay? 3 - Does MySQL have an equilivant to "stored proceedures? Thanks - tmb __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php