Re: MySql runs on windows ME
I have 2 OS's. One is Linux and the other is WinME. MySql runs fine on BOTH systems (it is running just fine on Win ME right now). -w - Original Message - From: Doug V [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 09, 2001 2:24 PM Subject: windows ME Will mysql run on Microsoft's windows ME operating system ? Thank You, Doug V. - 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: MySql runs on windows ME
I have 2 OS's. One is Linux and the other is WinME. MySql runs fine on BOTH systems (it is running just fine on Win ME right now). -w - Original Message - From: Doug V [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 09, 2001 2:24 PM Subject: windows ME Will mysql run on Microsoft's windows ME operating system ? Thank You, Doug V. - 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: Data Entry Forms for MySql
Hello I often use an html editor to create forms, use PHP4 as a cgi and enter the data directly into MySql. This does not necessitate Microsoft, and has worked very well for me. -warren - Original Message - From: Stephen Reynolds [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 25, 2001 8:24 PM Subject: Data Entry Forms I've created a MySQL database and linked the tables to a MS Access front end so that I could build the data entry forms using MS Access. Is there a better way to create the data entry forms in a Windows environment without using Microsoft or proprietary solutions? What is are the most widely used methods for creating data entry forms for MySQL in a Windows environment? Regards, Steve == Stephen Reynolds - 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: MySQL too slow....
Hello! A lot of people use PHP4 or PERL or C++ and connect *directly using the script. PHP4 has MySql functions built right in for convenience. In PHP for example, just do this: MYSQL_CONNECT(localhost,yourID,yourPassword); mysql_select_db(yourDB); $maxi=mysql_query(select fieldname1, fieldname2, fieldname3 from tablename where ...); There are more examples from other languages in the archives, I believe. Cheers! -warren - Original Message - From: Muhammad Asif [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 2:19 AM Subject: Re: MySQL too slow I want to use MySQL in web based applications. Can u tell what other way i can go except ODBC if i have to query the database(MySQL) through some scripting language(ASP,ColdFusion,JSP,Servlet) and have to display results in a web browser... Thx in advance for your time - Original Message - From: Van [EMAIL PROTECTED] To: Muhammad Asif [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 1:00 PM Subject: Re: MySQL too slow Muhammad Asif wrote: i have a table with 1 records in MS Access and MySQL with no index in either database. I query both tables from ColdFusion using ODBC datasources and Data from Access took 13sec to display while Date from MySQL took 23sec to come up MySQL seems to be half way slow should i use index etc comments??? Muhammad: ODBC is slow in MySQL. Make sure you're using a current MyODBC driver. If that doesn't help, don't know what to tell you. Many people use straight network queries which avoid this overhead. Keep in mind, ODBC was a standard M$ put in place because their desktop OS is ubiquitous. Oracle wouldn't need an ODBC layer if M$ didn't have a monopoly on the desktop. There would be better db communications interfaces, instead. Indexing fields you query often is a given. But, you know this, I'm sure... Regards, Van -- = Linux rocks!!! http://www.dedserius.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 - 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: events that i can trigger on intervals.
Hi! Could this work, I wonder? Have a timestamp field that gets set whenever a person books a room. Then when people look at a room, if the current date is more than a certain amount of time after the timestamp showing, it is EXPIRED. This would be easy to code in PHP. Cheers! -Warren - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Hasan Niyaz [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, June 05, 2001 1:45 PM Subject: Re: events that i can trigger on intervals. On Tue, Jun 05, 2001 at 11:27:33PM +0500, Hasan Niyaz wrote: Hi, I have a room inventory. Clients can block rooms them but I want to release them after a specified time if they do not release them normally via the given link. I want to be able to trigger an event to release the rooms after the time limit. Is there any way I can do this with MySQL or PHP. You'll need to use a batch scheduler like cron (on Unix/Linux) to run a script that does it (or fetch a URL which runs a script that does it). MySQL doesn't have scheduling capabilities built into it (and probably doesn't need them), so simply need to use a tool that does. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 11 days, processed 68,753,894 queries (71/sec. avg) - 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
Re: Configuring PHP for MySQL
Wrong. As the MySQL Development Team suggested, this is a quesiton for PHP people. THe message Header files not found at ..has nothing to do with MySQL. This is a header that is being generated (HTML HEADERS). Therefore, at the TOP of a (PHP) script file you are saying something like include(../ip_address.php4); , it goes out and looks for the file specified (in this case ip_address.php4) and doesn't find it. This is a PHP problem and it is caused because you are promising a file that you are not giving it. SNIP === Sorry Jorge. I thought that the individuals on this list would be more qualified to answer a question regarding where a specific installation (3.23.38 RPM) of MySQL placed specific files ( header files? ) than would PHP users. Justin Pease - 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
storage and retrieval of blobs
Hi! I'm new too, but here are some things I've picked up from others on the List kind enough to advise: Regarding blobs, putting even large amounts of material into them is the same as using any other data type. Some considerations: http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:10632 http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:65635 regarding keywords index: http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:36147 I've personally used two ways of storing images and audio clips: binary storage as blobs and, (on advice from this list, since I'm pretty new to this) as separate files. In the case of separate files, the location is stored in the database and the files are stored wherever you wish.If you employed a keyword index, having sparate files for the articles seems like a recommended way to go - it keeps your tables small and the searches will likely be faster (see the first link, above).You will want to scan your configuration file for settings relating to the maximum size allowed (if the articles are to come from elsewhere or will go to users over the net) and settings of your server itself that affect size of any given piece of data allowed. Cheers! -Warren --- SNIP - Dear all, Please excuse a newbie question. I am interested in storing articles (up to 300k) in a database, and some may have formatting and contain graphics like a word document. Is it possible to do this in mySql and if so e.g. in a TEXT or BLOB field, how do I store an article and then retrieve it. I would have a separate column for an index to the article. Have I misunderstood and do I need a specialised front end client program (not Visual Basic as I am using Mac OS X ). Any help, pointers, examples would be greatly appreciated. Many thanks, Mark Bedish [EMAIL PROTECTED] - 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: mysql hosting?
Gary Huntress, who sometimes posts on this List, runs such a free system. It is found in his signature line, as follows: SNIP == FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org SNIP == - Original Message - From: B. van Ouwerkerk [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 26, 2001 1:11 AM Subject: Re: mysql hosting? read of a free hosting site a while ago if you are developing mysql sites. does anybody know about that? I can't find it anymore. Please I really need to host my test page as the server I had it one broke. Can anybody help me out Use your favorite searchengine. Bye, B. - 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
re: JAPANESE QUESTION: My Inept Translation Attempt
I'll try to translate this as best I can. The sender can likely understand the response in English, so fire away. If you send them English he'll probably try (and probably can use) English. If anyone on the list can do a better job of translating this, please feel free to correct me! Keep in mind that it is a while since I used a lot of Japanese. . . I'm sure I'm making some errors: SNIPLine-by-line == Good day!My name is Mr. Takeuchi. We have some Access 97 data in a database we made in Windows. We tried to export the Access 97 data into mySql but found it impossible to export the Chinese and Japanese characters correctly. We have a Linux terminal to which we are exporting the data (I THINK THIS IS WHAT THEY ARE SAYING!). They are exporting to EUC (and then they ask "Font?" ) and are using ODBC software to connect to MySQL. IN SHORT... In short if anyone knows how to export Access 97 data to mySql over ODBC (a Japanese version) so that the characters come out correctly they would like to hear from you. They seem to want to get the data from a Windows machine to a Linux machine using EUC. === Good luck! -Warren こんにちは、久し振りの投稿となります。たけうちです。 Access97 で作った名簿データを、MySQL 上へエクスポートしたのですが 「塚」「髙」の特定文字が入力できない問題が発生しました。 これらの文字は Linux のターミナル上でも入力不可だったので、もしか したら EUC上（フォント？）に存在しないのでしょうか？ 以下の構成で ODBC 接続しています。 サーバ：Linux MySQL(3.23.31) EUC クライアント：Windows Access97(EUC版ODBC 2.50.29-jp) -- [EMAIL PROTECTED] たけうち - 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
mySql on PhatLinux
Hi All! Has anyone got mySql running on PhatLinux? As I understand it, Phat is designed to run on a Windows partition - intel machine. If so, which binaries are used? (or which src file)I was thinking of trying the following distribution: Linux (Intel libc6 systems) [pc-linux-gnu-i686]Sound reasonable?? Many thanx! -Warren - 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
building a timer for controlled display of records
Hi! Has anyone a nice example of a timer that will run on a Win OS? It is to be a timed display in which a record is retrieved from a MySql database table and after 15 seconds the next record comes up for display. Since the application has to be responsive to user input during the "show" of records, a loop that causes the OS to be unresponsive until the next display of a record is to be avoided. I have exausted examples in the manuals for both MySql and PHP4. Any suggestions will be very much appreciated. Cheers! -Warren - 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
Is storing a whack of text in a binary format ok?
Hi,
I can store and retrieve binary data in the form of image or sound files.
However, I wanted to store up to say, 10,000 bytes of textual data. Since
varchar has a 255 byte ceiling I thought that mediumblob might be nice for
this. I can store the stuff as mediumblob without difficulty.
However, when I try to retrieve the mediumblob (just character data
originally) via PHP4, I tried this:
$sectionText1=mysql_query(" select sectionText from sectionbinaries where
TestID='$test' and section='$section' ");
$section1=mysql_fetch_row($sectionText1);
This section1 array gives me a raft of stuff, including a lot more than I
want. So I looked in the manual and found that:
"mysql_query() cannot be used for queries that contain binary data; you
should use mysql_real_query() instead. "
SO I switched to:
$sectionText1=mysql_real_query(" select sectionText from sectionbinaries
where TestID='$test' and section='$section' ");
$section1=mysql_fetch_row($sectionText1);
and received the following error:
Fatal error: Call to undefined function: mysql_real_query() in data.php3 on
line 210
Can anyone point me in the correct direction?
1. It is character data originally -- should I be using a mediumblob format
to get 10,000 bytes or so into storage?
2. What function might I use (and how can I use it) to correctly display
the data if stored as something other than varchar?
Thanks for your time!
-Warren
-
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
text stored as binary question posted earlier
Hi all! Regarding my earler question about storing text as binary - I found no problem storing the text as mediumtext or longtext, and then dragging it out with a normal "mysql_query ".This solves my problem. However, if anyone has other ideas I'd love to hear them! Thanks very much! -Warren - 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
having problems getting a distinct listing
Hi!
I have a tests database that has questions (one table is "questions" and a
field in this table is "uid" and another field is "question")
there is also a Testerator table in my tests database, which organizes
questions by section and keeps track of test number (as field "Quid")
SO I would like to obtain a list (with no repeats) of questions that are
found in the questions database, but which are NOT used in a particular
test.
I therefore set up $GlobalUsed which finds all questions which are used
somwhere in a particular test and shoves these into a temporary table, as
such:
$GlobalUsed=MYSQL_QUERY("CREATE TEMPORARY TABLE usedGlobal Select a.Quid,
b.question, b.uid from testerator a, questions b where (a.TestID='$uid') and
(a.Quid=b.uid)");
Next, $Global Unused is established, which finds all questions in the
questions table which are not found in the testerator table for the
particular test in which I am interested.
$GlobalUnused=MYSQL_QUERY("select * from questions, usedGlobal where
questions.uid != usedGlobal.uid ");
HOWEVER, when I use $row = mysql_fetch_array($GlobalUnused) in a while loop
to display all the unused questions, I get numerous repeats.
I have TWO questions for any gurus willing to share their guru-ness:
1. Can I do this in such a way as to get a DISTINCT unused question list (I
tried select * DISTINCT in both above statements, to no avail, and I tried
it with DISTINCT and then finished with and ORDER BY clause, but again these
didn't work for me -- I ended up getting no results ).
2. If I have to use the temporary table (because without sub-selects I'm
not sure how to get the same results) that is fine. But is there a way to
amalgamate both commands as one select statement and dispense entirely with
the temporary table?
Thanks so much!
-Warren
-
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
IGNORE previous temporary table problem posting
Hi All! I just posted a note about having problems creating temporary tables. However, I JUST realized (and empirically verified) that my problem of not being able to create temporary tables is that I didn't use an ID with the CREATE permission enabled. I am a bonehead. Thanks again! Cheers! -Warren - 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
RDBMS question on coding expanding series-like fields
Hi! I have a Test Questions database. Right now I have a hard-coded limit of 200 questions in it; I actually made a table with field names like Quest1, Quest2. . . Quest200. However, I know that I am not using the power of MySql in setting it up this way. This is more an example of my own ignorance than of the power of MySql! Can someone explain how to set up a table with a fieldname that 'expands' (maybe something like Quest[i] where "i" can be incremented as required). Is there more than one way of doing this? Is there a place where I might see some sample code? I did look up 'enum' and 'set' in the manual but I don't feel confident with my grasp of the limited explanations given of these. My feeling is that perhaps 'enum' would be a candidate for what I need, as 'set' has a limit on how big the set can get.I would like to have the possibility of data expansion as needed. Any tips whatever would be appreciated! Thanks very much! Cheers! -Warren - 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
modification of my last question
Hi! I just realised that the question I posed moments ago was not explained fully and therefore sounds even more silly than it perhaps is. My need is to have a number of fields that can be expanded and fit the form of field[i] where "i" can be expanded as desired. So I would like to know how to make a field, each entry of which contains the equivalent of an array. Is this possible? Hope this clarifies! Cheers! -Warren - 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
generic question re. image blobs in dbs
Hi! There is a consensus that blobs containing image files like .jpgs, .gifs, etc. might better be stored just as links in the database, with the actual files in a directory pointed to by the database links. Forgive my ignorance, but can someone explain a few of the more obvious reasons why this makes a difference? For example, if I avoid SELECT * when referring to a table with blobs it seems to be pretty fast. . .So I'd only refer to the heavyweight column when absolutely necessary. Does it take a lot longer to pull out the blob than it would to load the file contents into a browser? Thanks for any information you can impart! Cheers! -Warren - 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
