Example UDF for anyone interested
If anyone's looking for another nice user-defined function example, I've just set one up at work and am happy to share the wealth :). They're really quite cool, and this one is a good deal simpler than udf_example.cc. The function is at: http://www.adamhooper.com:4242/ccode/project_view.php?project=mysql_stripchars It's a useful function that can take the place of a dozen REPLACE()'s -- it can be run either like Perl's tr/// or as a simple thing that just removes single characters from the string (its primary use is for removing gibberish characters such as - or #). It's all in the README linked there. Really it's more for example purposes than anything else -- I woulda liked having more than one example to refer to when I was coding it. Do whatever you want with it but sell it, and most of all have fun :). Hope it helps someone out. Adam Hooper [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: Problem with User Account - access denied
Isnt it GRANT ALL ON college.* TO someuser identified BY somepassword; -Original Message- From: J [mailto:[EMAIL PROTECTED]] Sent: Sunday, 28 April 2002 2:22 AM To: [EMAIL PROTECTED] Subject: Problem with User Account - access denied I created and user, like below, using mysql on my Linux machine (Linux-Mandrake 8.1) to access a database called college: GRANT ALL ON college.* TO someuser BY somepassword; But I'm denied access even from localhost. I tried the following too: GRANT ALL ON college.* TO someuser@% BY somepassword; But MySQL gives me an error message. I need to be able to access the database, from anywhere, including localhost. Anyone can help me out? Thanks __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.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 - 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: character
Hi,
Almost all machines who work with CPU know about ASCII character set
(http://www.asciitable.com/).
This character is ENTER(in ASCII - carriage return) or NEW LINE (in ASCII -
linefeed) and is NON-PRINTABLE. Don't have graphical representation.
Using LOAD DATA ..., MySQL accept all the characters , including
NON-PRINTABLE.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Rosyna [EMAIL PROTECTED]
To: Gelu [EMAIL PROTECTED]; Alex Pilson [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, April 27, 2002 8:51 AM
Subject: Re: character
What does this have to do with ? (Trademark symbol) The mac line
ending is \r...
Ack, at 4/25/02, Gelu said:
MySQL not encode characters.In your .txt file are NON-PRINTABLE characters
which mark the end of line.If you have a HEX editor, you can see in the
.txt
file at the end of every line '0Dh' and '0Ah'.This mean ENTER('\r) and NEW
LINE(\n').If you have a C/C++ manual you can find the list of escape
sequence.
--
Sincerely,
Rosyna Keller
Technical Support/Holy Knight/Always needs a hug
Unsanity: Unsane Tools for Insanely Great People
---
Please include any previous correspondence in replies, it helps me
remember what we were talking about. Thanks.
-
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
Using multi-byte character set
Hi, I am using double byte character set (big5) under mandrake linux with MySQL everything seemed ok after building the DB and tables after some time of testing I found some characters cannot be inserted, like those characters include the back slash '\'. it was simply disappeared as MySQL treat it as an invalid escape sequence. I can tackle the problem to add another back slash to the string when I am doing sth using C API. e.g. try to insert 1234\po, then I modify the string to 1234\\po then 1234\po can be retrieved from DB. But it seemed difficult to do using ODBC since I am using ASP and VB for the front end. So I am searching for a one time solution for the problem. Is it necesary for me to add big5 to the character set? but I don't need the to sort any double byte character field. what should I do? thanks for reading Borus - 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: Keeping track of db structure changes
It's really not all that different that source code. For each application I build, I tend to put the source code in our CVS repository long with the $foo.sql file(s) to reconstruct the tables. Just as there's nothing preventing me from deploying a new release of an application before checking all my changes into CVS, the same is true of your database structures. Ouch, why haven't I thought of that? I already use CVS and by putting the structure into CVS as well, I can just take the diff. Thanks a lot! Jens - 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: character
This character is a trademark character it looks like (TM) but as one superscript character. Ack, at 4/28/02, Gelu said: Almost all machines who work with CPU know about ASCII character set (http://www.asciitable.com/). This character is ENTER(in ASCII - carriage return) or NEW LINE (in ASCII - linefeed) and is NON-PRINTABLE. Don't have graphical representation. Using LOAD DATA ..., MySQL accept all the characters , including NON-PRINTABLE. -- Sincerely, Rosyna Keller Technical Support/Holy Knight/Always needs a hug Unsanity: Unsane Tools for Insanely Great People --- Please include any previous correspondence in replies, it helps me remember what we were talking about. Thanks. - 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
Fw: WHERE ignored
Corrupt index, hmm? I'll check that in a moment - thanks. Probably a sensible idea to limit the query too - I think I'll order by date desc too just to make sure that recent mail gets sent. Cheers --Mike - Original Message - From: Benjamin Pflugmann [EMAIL PROTECTED] To: Mike Hall [EMAIL PROTECTED] Cc: Michael Bacarella [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, April 27, 2002 9:23 PM Subject: Re: WHERE ignored Hi. First a praticial hint to prevent further harm: I presume you can set an upper limit for how many rows should be returned (say 1000?). If there are more, complain and refuse to do anything in your script. Or also select the sent value and compare in your script that it is 0 before sending mail. I doubt you would really get a wrong value in the selected column, too. What you describe sounds like a corrupt index or something alike. It is not uncommon that _if_ an index is corrupted, you get far more or less results than expected. So check your tables. I don't think that getting too many rows for a hardcoded query is possible by an error in your script. But to be sure: From what you said, you seem to have the query log. Check that the log really contains what should be there for the time window in question. I.e. that the hardcoded query was sent undamaged to MySQL and so on. Bye, Benjamin. On Fri, Apr 26, 2002 at 11:04:00PM +0100, [EMAIL PROTECTED] wrote: Is there any chance at all that a field name is appearing in your WHERE clause? For example: UPDATE foo SET flag = 0 WHERE foo_id = foo_id; foo_id = foo_id of course matches all. No, the query is hard coded to WHERE Sent = 0. Not much room for that kind of error in this example, but perhaps in other scripts that deal with the table in question? No other scripts perform UPDATEs on that table, only INSERTs. But MySQL returned the correct data at 8:55 and again at 9:05. It was only when it ran at 9am that it appeared to ignore the WHERE. According to my binary log, the Mail table wasn't changed at all during this time - so the results of all three queries should have been identical. -- [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
Changing field size
I've a VARCHAR(4) field that I want to change to a VARCHAR(6) field. What would happen to the existing data in MySQL db? Thanks! Tony ([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
parse errors when compiling clients using gcc 2.96
I receive the following parse errors when attempting to compile a client program on a Linux box using gcc 2.96: gcc -c -DMYSQL -I/var/src/mysql-3.23.49/include checkhttpd.c In file included from checkhttpd.c:9: /var/src/mysql-3.23.49/include/mysql.h:175: parse error before `1' /var/src/mysql-3.23.49/include/mysql.h:188: parse error before `1' /var/src/mysql-3.23.49/include/mysql.h:188: warning: no semicolon at end of stru ct or union /var/src/mysql-3.23.49/include/mysql.h:190: parse error before `}' /var/src/mysql-3.23.49/include/mysql.h:190: warning: data definition has no type or storage class /var/src/mysql-3.23.49/include/mysql.h:195: parse error before `*' /var/src/mysql-3.23.49/include/mysql.h:196: parse error before `*' /var/src/mysql-3.23.49/include/mysql.h:197: parse error before `*' /var/src/mysql-3.23.49/include/mysql.h:198: parse error before `*' /var/src/mysql-3.23.49/include/mysql.h:200: parse error before `*' /var/src/mysql-3.23.49/include/mysql.h:201: parse error before `*' /var/src/mysql-3.23.49/include/mysql.h:202: parse error before `*' /var/src/mysql-3.23.49/include/mysql.h:204: parse error before `1' When I look at the mysql.h header, everything looks ok. Any clues? Pat... [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
SV: WHERE ignored
-Oprindelig meddelelse-
Fra: Mike Hall [mailto:[EMAIL PROTECTED]]
Sendt: 28. april 2002 12:28
Til: [EMAIL PROTECTED]
Emne: Fw: WHERE ignored
Corrupt index, hmm? I'll check that in a moment - thanks.
After looking at your fault-free script, my best bet would also be a
corrupted index. Do you have myisamchk scheduled to run periodically (eg.
just after 09.00)? Because that would explain, why the error only occurs
once. Consider this scenario
08.55: The mailscript runs fine
Between 08.55 and 09.00: Something corrupts the index (perhaps the script
running af 08.55?)
09.00: The mailscript runs, but because of the faulty index, you send to
many mails
09.02: myisamchk is run and automatically repairs the index.
09.05: The mailscript runs fine
It might sound a bit far off, but I don't know your setup :-)
Probably a sensible idea to limit the query too - I think I'll
order by date
desc too just to make sure that recent mail gets sent.
Don't limit the query, instead do a conditional check in php, eg.
if ($db-recordcount 100) {
// send mail to yourself that something is wrong, log the number of
records and immediately do an extra query: EXPLAIN SELECT MailID, MailFrom,
MailTo, Subject, Body, Headers FROM
Mail WHERE Sent = 0
// Write the EXPLAIN result to a logfile.
exit;
}
This way you're able to diagnose the error when it hits again, which it
probably will.
Ask yourself, what could have caused a corrupt index? Power glitch?
- Carsten
-
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 /bin directory
Greetings, I am new to mysql. I have performed a fresh Red Hat install (7.2) with all packages available. In an attempt to become more familiar with mysql (performing numerous tutorials) there are many mentions of a /usr/local/mysql/bin directory. Since everything was installed via RPM this directory does not exist. My question is: Where should mysql data files go when no bin directory exists? I have manually created a /usr/local/mysql/bin but this does not seem to work. Thanks for any help with my ignorant new guy question. Regards, J. Flechtner - 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
Can't start mysql-service on Win XP
Hello, for the first time I installed Mysql 3.23.49 on win XP professional. I installed it with admin privileges, installed the service -so far everything seemed to be ok. But when I tried to start the service, it didn't start (failure number 1067). I don't have any idea, what that failure number means, where to find something about it (who raised it: win or mysql?) and where to search for the reasons. I already searched for this failure in the mysql ref manual and in the win help system. I'll be grateful for any tip! Thanks in advance Sabine Richter - 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 /bin directory
J. Flechnter, Here are some paths from an rpm install that I did with RedHat. /usr/share/mysql/ /etc/my.cnf /var/lib/mysql/ Mike J. Flechtner wrote: Greetings, I am new to mysql. I have performed a fresh Red Hat install (7.2) with all packages available. In an attempt to become more familiar with mysql (performing numerous tutorials) there are many mentions of a /usr/local/mysql/bin directory. Since everything was installed via RPM this directory does not exist. My question is: Where should mysql data files go when no bin directory exists? I have manually created a /usr/local/mysql/bin but this does not seem to work. Thanks for any help with my ignorant new guy question. Regards, J. Flechtner - 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 -- Mike - 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: Can't start mysql-service on Win XP
Hi Sabine (again ;-) ) I suppose you already tried this: http://www.mysql.com/doc/N/T/NT_start.html This could be problems w/ your path or your my.ini (overwritten my mysqladmin). If it won't start anyway, put mysqladmin.exe to your autostart. regards, (Grüße) Jan - Original Message - From: Sabine Richter [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, April 28, 2002 4:25 PM Subject: Can't start mysql-service on Win XP Hello, for the first time I installed Mysql 3.23.49 on win XP professional. I installed it with admin privileges, installed the service -so far everything seemed to be ok. But when I tried to start the service, it didn't start (failure number 1067). I don't have any idea, what that failure number means, where to find something about it (who raised it: win or mysql?) and where to search for the reasons. I already searched for this failure in the mysql ref manual and in the win help system. I'll be grateful for any tip! Thanks in advance Sabine Richter - 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
IBM docs server and mysql manual
Hi, just a short note for the documentation: IBM moved their AIX documentation, and did not find it necessary to redirect this properly. The link in: http://www.mysql.com/doc/I/B/IBM-AIX.html refering to the uname command, should go from: http://www.rs6000.ibm.com/doc_link/en_US/a_doc_lib/cmds/aixcmds5/uname.htm to: http://publib.boulder.ibm.com/doc_link/en_US/a_doc_lib/cmds/aixcmds5/uname.htm Best regards, Melvyn Sopacua WebMaster IDG.nl _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ If it applies, where it applies - this email is a personal contribution and does not reflect the views of my employer IDG.nl. \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\ - 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: Changing field size
To my knowledge, nothing would happen to the existing data, since you would be performing a widening conversion. Michael On Sun, 28 Apr 2002, Anthony Rodriguez wrote: I've a VARCHAR(4) field that I want to change to a VARCHAR(6) field. What would happen to the existing data in MySQL db? Thanks! Tony ([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 -- /*-- * It might look like I'm doing nothing, but at the cellular level * I'm really quite busy. * ---anonymous * * * -BEGIN GEEK CODE BLOCK- * Version: 3.1 * GCS/P/H/L/O d- s-:-- a26 C++(+++) UL+++$ P++ L+++ !E W+++ N- o? K- * w--(---) !O M+ !V PS+ PE- Y-- PGP- t+ 5-(--) X(-) R* tv b+ DI-- D-- G e+++ * h+ r* y-- * --END GEEK CODE BLOCK-- --*/ - 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 server question
Hi, all, Two questions . . . 1. Windows is giving me the 1067 error, which states that the MySQL server is terminating unexpectedly. I guess I'm going to have to reinstall it, unless there's some way to troubleshoot what's wrong and then fix the problem. Has anyone ever encountered this? Could this be just a Windows problem, a MySQL problem, or both? 2. Connected with the first question, if in the future, I should encounter this problem again, how would I be able to access the data that's in the database? This time around, I fortunately didn't insert any data and haven't been using it in a production environment. But, I'll be doing that in the future and want to know how to access the data other than the obvious route of making sure to backup all data each night and then accessing it that way. Thanks, Tim Keefe __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.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: Can't start mysql-service on Win XP
Hi Jan, I suppose you already tried this: http://www.mysql.com/doc/N/T/NT_start.html I did! This could be problems w/ your path or your my.ini (overwritten my mysqladmin). mysqld-nt --help has the correct basedir (.\mysql\) Oh, what's that? In my.ini I just wrote basedir=mysql -without the last backslash! Can that be a reason? And how to change it? The same for datadir! telnet localhost 3306 says: Verbindungsaufbau zu localhost... Es konnte keine Verbindung mit dem Host hergestellt werden, auf Port 3306. Es konnte nicht, da der Zielcomputer die Verbindung verweigerte. (perhaps incorrect translation: connection to localhost on port 3306 wasn't possible. The computer didn't allow the connection) If it won't start anyway, put mysqladmin.exe to your autostart. I don't understand that. I thought that mysqladmin requires an already started server service. Isn't that right? However, I tried start mysqladmin/host=localhost It says that it needs mysqld running and tells me to check it with telnet. What I did. See above. I have no debug-version of mysqld-nt. Any other idea?? best regards Sabine - 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 get the columns that are between an interval?
Hi, How can I get the columns between a given time interval? Something like: The patients admitted between january 25, 2000 and january 30, 2001 ?? I'm new to MySql and would like a suggestion from you... Best Regards Silvia - 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 get the columns that are between an interval?
Should we assume that your tables have an existing column of type timestamp or date? On Sunday 28 April 2002 11:47 am, Dra. Silvia Andreasi wrote: Hi, How can I get the columns between a given time interval? Something like: The patients admitted between january 25, 2000 and january 30, 2001 ?? I'm new to MySql and would like a suggestion from you... Best Regards Silvia - 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: How get the columns that are between an interval?
Dra. Silvia Andreasi, SELECT * FROM table WHERE begin_date_column =2000-01-25 and 2001-01-30= end_date_column; begin_date_column and end_date_column have to be date type columns. Mike sql,mysql Dra. Silvia Andreasi wrote: Hi, How can I get the columns between a given time interval? Something like: The patients admitted between january 25, 2000 and january 30, 2001 ?? I'm new to MySql and would like a suggestion from you... Best Regards Silvia - 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 -- Mike - 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
InnoDB's inner workings and checkpoints
Hello (Heikki), I have read up on checkpoint activity and innodb and there are still a few points I don't understand: -what is the chronological sequence of events for a write into the innodb tablespace? -Is it: 1. An insert sql statement is issued from a mysql client. 2. The record is stored in the log buffer. (no disk access here) 3. The record is stored in the innodb log and in the buffer pool simultaneously. (1st disk accesss) (checkpoint) 4. The record finally makes it to the innodb tablespace and is saved to disk. (2nd disk access) Can you please correct the above if it is wrong. Thanks in advance, Balteo. - 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
Update a table with data from another table?
I'm wondering if there's a way to use the results of a SELECT in an UPDATE operation, the way that it's possible to do so with INSERT and REPLACE. This seems like it should be possible, but as far as I can tell, it's not. This comes up for me repeatedly, but the problem at hand is identifying the parent message for a table containing discussion meta-data. I can query to find the earliest occurrence of each subject, but the only way I seem to be able to update the records with this data in a parent message field is to retrieve them programmatically and do updates. Anything that I can do within MySQL is much, much faster, so I'm trying to avoid that. I could create a temporary table with all of the columns, including the updated one, then do a replace back into the original one, but that seems to be a lot of overhead for what should be an update, rather than a replace. Any suggestions? Nick -- [EMAIL PROTECTED] (408) 904-7198 - 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 make the Win target from source?
I downloaded mysql-3.23.49-win-src.zip. There are various files missing (e.g. Makefile) that would enable compiling with gcc. Has anyone out there made mysql from source on Win platform with gcc? I had been trying to compile my own client but was getting a lot of undefines at link time - the instructions said that mysql should be remade from source to solve this problem. I am stuck trying to do that.
RE: How to make the Win target from source?
Hi !! -Original Message- From: Dennis George [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 28, 2002 11:10 AM To: MySQL List Subject: How to make the Win target from source? I downloaded mysql-3.23.49-win-src.zip. There are various files missing (e.g. Makefile) that would enable compiling with gcc. Has anyone out there made mysql from source on Win platform with gcc? I had been trying to compile my own client but was getting a lot of undefines at link time - the instructions said that mysql should be remade from source to solve this problem. I am stuck trying to do that. If you want to build the server from source on Windows, there are two ways: 1. Using VC Project: Download the VC project(s)(the above one) and extract the files to a desired folder. Once extracted, load the 'mysql' workspace to VC Editor and start building. If you encounter any problems, just post the error message, then we can guide you how to proceed further. 2. Using cygwin Environment: Through this is not a recommended way, you can give a try. Download the linux source and extract it to a folder and start building it in the normal way by configuring or by using any of the scripts from BUILD/ which suites your needs. We don't recommend the build process on Windows except if you want to debug. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.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: Update a table with data from another table?
Hi. You have analyzied the situation correctly. AFAIK, there is no way to do this with one query until sub-selects are going to be supported, and you have to use one of the work-arounds you described. Bye, Benjamin. On Sun, Apr 28, 2002 at 10:13:49AM -0700, [EMAIL PROTECTED] wrote: I'm wondering if there's a way to use the results of a SELECT in an UPDATE operation, the way that it's possible to do so with INSERT and REPLACE. This seems like it should be possible, but as far as I can tell, it's not. This comes up for me repeatedly, but the problem at hand is identifying the parent message for a table containing discussion meta-data. I can query to find the earliest occurrence of each subject, but the only way I seem to be able to update the records with this data in a parent message field is to retrieve them programmatically and do updates. Anything that I can do within MySQL is much, much faster, so I'm trying to avoid that. I could create a temporary table with all of the columns, including the updated one, then do a replace back into the original one, but that seems to be a lot of overhead for what should be an update, rather than a replace. Any suggestions? Nick -- [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
docs for mysql rpms
Dear Mysql folks, If you install mysql-3.23.49 using a source tarball and compile it with gcc, the package contains documentation directories and manual directories. If you install mysql-3.23.49a using an rpm then there don't seem to be doc directories that come with the installation. I can't find them in /usr/share/mysql or /usr/share/doc. I also tried looking on the UK mirror site for a separate tarfile or rpm for documentation but all I could find was a manual tarfile which was for 4.0.0 alpha. If you are using an rpm, you could also untar the source tarball and extract the docs man and test directories and throwaway the rest. This seems a bit silly. What is the proper way to get the documentation for rpm installation. I installed the server,client,development thing, anything else I could find and then installed dbd and dbi. Suggestions please. Michael Fothergill _ Send and receive Hotmail on your mobile device: http://mobile.msn.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
Php query from sql
Hello everybody, I'm quite new with all this php mysql cooperation thing but somehow I already managed to set up mysql database and I'm able to also make query's based on any keyword... Now I wonder how to add to this basic query also option to select some concrete data. For example in the database I have section Languages, where people can choose is their English laguage skill 'poor', 'good', 'very good'. Now I would like to add to the general query additional field where it could be possible to select only data of persons with very good English language skills. For example I would like to be displayed only persons who are living in London (this will be keyword) and are speaking English very well... Please can anyone help me? Best regards, Eva - 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
ANNOUNCE: moodss-15.13
### CHANGES ### --- version 15.13 --- - added tool bar with nice icons (borrowed from KDE) - added View/Tool Bar menu to show or hide the tool bar - saved tool bar visibility state in moodss preferences save file - in HTML documentation, updated screen shots, documented module tables minimizing feature, new values viewer and tool bar - File/Save menus are disabled when no there are no loaded modules - menu dynamic help on Windows now works right - in main window, Control-N binding was wrong ### README ### This is moodss (Modular Object Oriented Dynamic SpreadSheet) version 15.13. Moodss won in the Best System Admin Technology category (Tcl Tips and Tricks, Valuable Real World Programming Examples) at the O'Reilly Tcl/Tk 1999 Conference. Linux Magazine calls it a lifesaver. Tucows gives it 5 stars (cows or penguins :-). Moodss is a modular application. It displays data described and updated in one or more modules, which can be specified in the command line or dynamically loaded or unloaded while the application is running. Data is originally displayed in tables. Graphical views (graph, bar, 3D pie charts, ...), summary tables (with current, average, minimum and maximum values) and free text viewers can be created from any number of table cells, originating from any of the displayed viewers. Thresholds can be set on any number of cells. Moomps (shipped with moodss) is a monitoring daemon which works using configuration files created by moodss. Thresholds, when crossed, create messages in the system log, and eventually trigger the sending of email alert messages. Specific modules can easily be developed in the Tcl, Perl and Python scripting languages or in C. A thorough and intuitive drag'n'drop scheme is used for most viewer editing tasks: creation, modification, type mutation, destruction, ... and thresholds creation. Table rows can be sorted in increasing or decreasing order by clicking on column titles. The current configuration (modules, tables and viewers geometry, ...) can be saved in a file at any time, and later reused through a command line switch, thus achieving a dashboard functionality. The module code is the link between the moodss core and the data to be displayed. All the specific code is kept in the module package. Since module data access is entirely customizable (through C code, Tcl, Perl, Python, HTTP, ...) and since several modules can be loaded at once, applications for moodss become limitless. For example, thoroughly monitor a dynamic web server on a single dashboard with graphs, using the Apache, MySQL, ODBC, cpustats, memstats, ... modules. If you have replicated servers, dynamically add them to your view, even load the snmp module on the fly and let your imagination take over... Along with a core trace module, arp, cpustats, diskstats, interrupts, kernmods, memstats, minimal, mounts, netdev, pci, ps, random, route, sensors, system modules for Linux, MySQL (myerrorlog, myhealth, myprocs, myquery, myreplication, mystatus, myvars), odbcquery, ping, snmp, snmptrap for UNIX, apache and apachex, Minimal and Random Perl modules, minipy and randpy Python modules are included. Running wish moodss ps cpustats memstats mimics the top application with a graphic edge and remote monitoring capability. Thorough help is provided through menus, widget tips, a message area, a module help window and a global help window with a complete HTML documentation. Moodss is multi-langual thanks to Tcl internationalization capabilities. So far only English and partially French are supported. Help with other languages will be very warmly welcomed. Development of moodss is continuing and as more features are added in future versions, backward module code compatibility will be maintained. I cannot thank the authors of the tkTable, BLT, MIME/SMTP and the HTML libraries enough for their great work. In order to run moodss, you need to install the following packages (unless you can use the rpm utility, see below): Tcl/Tk 8.3.1 or above, at (or at a mirror near you) http://dev.scriptics.com/ or ftp://ftp.scriptics.com/ the latest tkTable widget library at: http://tktable.sourceforge.net/ the latest BLT library at: ftp://tcltk.sourceforge.net/pub/tcltk/blt/ eventually the latest tclperl library for writing modules in Perl, or the latest tclpython library for writing modules in Python at: http://jfontain.free.fr/ (see the INSTALL file for complete instructions, for UNIX and also Windows platforms). You also have the option of using the moodss rpm file (also in my homepage), if you are using a Redhat Linux system (6.0 or above). You can find the required tcl, tk, tktable, blt, tcpperl and other rpms at: http://jfontain.free.fr/ Whether you like it (or hate it), please let me know. I would like to hear about bugs and improvements you would like to see. I will correct the bugs quickly, especially if you send me a test script (module code with a data trace would be best). Jean-Luc Fontaine
help / MySQL 3.23.49 vs. BerkeleyDB 4.0.14? (fwd)
hi all, i've built mysql-3.23.49 on MacOSX Server 10.1.4, as well as Sleepycat's BerkeleyDB 4.0.14. i note the --with-berkeley-db options in configure, but am stumped as to if/how to allow support for the bdb 4.0.14 version. mysql (in configure, acinclude.m4 aclocal.m4) seems to limit to bdb-3.x.x support. also, i've read that a patched bdb is required in the manual, and that use of a NON-patched bdb will not work . fyi, InnoDB support seems to work fine as an alternative .. comments on status/implementation? thanks! richard - 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: Can't start mysql-service on Win XP
If a trailing slash were required, mine would not work: [mysqld] basedir=d:/mysql datadir=d:/mysql/data language=d:/mysql/share/english skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 set-variable = lower_case_table_names=1 [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key=16M - Original Message - From: Sabine Richter [EMAIL PROTECTED] To: Jan Peuker [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, April 28, 2002 10:31 AM Subject: Re: Can't start mysql-service on Win XP Hi Jan, I suppose you already tried this: http://www.mysql.com/doc/N/T/NT_start.html I did! This could be problems w/ your path or your my.ini (overwritten my mysqladmin). mysqld-nt --help has the correct basedir (.\mysql\) Oh, what's that? In my.ini I just wrote basedir=mysql -without the last backslash! Can that be a reason? And how to change it? The same for datadir! telnet localhost 3306 says: Verbindungsaufbau zu localhost... Es konnte keine Verbindung mit dem Host hergestellt werden, auf Port 3306. Es konnte nicht, da der Zielcomputer die Verbindung verweigerte. (perhaps incorrect translation: connection to localhost on port 3306 wasn't possible. The computer didn't allow the connection) If it won't start anyway, put mysqladmin.exe to your autostart. I don't understand that. I thought that mysqladmin requires an already started server service. Isn't that right? However, I tried start mysqladmin/host=localhost It says that it needs mysqld running and tells me to check it with telnet. What I did. See above. I have no debug-version of mysqld-nt. Any other idea?? best regards Sabine - 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: mysql server question
What Operating System (WinNT / 2K / 98 / etc.) are you using? - Original Message - From: Timothy Keefe [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, April 28, 2002 10:18 AM Subject: mysql server question Hi, all, Two questions . . . 1. Windows is giving me the 1067 error, which states that the MySQL server is terminating unexpectedly. I guess I'm going to have to reinstall it, unless there's some way to troubleshoot what's wrong and then fix the problem. Has anyone ever encountered this? Could this be just a Windows problem, a MySQL problem, or both? 2. Connected with the first question, if in the future, I should encounter this problem again, how would I be able to access the data that's in the database? This time around, I fortunately didn't insert any data and haven't been using it in a production environment. But, I'll be doing that in the future and want to know how to access the data other than the obvious route of making sure to backup all data each night and then accessing it that way. Thanks, Tim Keefe __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.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 - 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 server question
What Operating System (WinNT / 2K / 98 / etc.) are you using? - Original Message - From: Timothy Keefe [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, April 28, 2002 10:18 AM Subject: mysql server question Hi, all, Two questions . . . 1. Windows is giving me the 1067 error, which states that the MySQL server is terminating unexpectedly. I guess I'm going to have to reinstall it, unless there's some way to troubleshoot what's wrong and then fix the problem. Has anyone ever encountered this? Could this be just a Windows problem, a MySQL problem, or both? 2. Connected with the first question, if in the future, I should encounter this problem again, how would I be able to access the data that's in the database? This time around, I fortunately didn't insert any data and haven't been using it in a production environment. But, I'll be doing that in the future and want to know how to access the data other than the obvious route of making sure to backup all data each night and then accessing it that way. Thanks, Tim Keefe __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.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 - 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 time zone problem
I am trying to get my time zone setup correctly with mySQL on a RedHat 7.2 box, so the select now(); query returns the correct time. The show variable command show that the time zone is being updated with the different values I enter, but the time is still coming up 4 hours off. I am trying to set it to US - Central. I have tried entries for :US/Central, Central, America/Central, and America/Chicago, but none of these have worked. Thanks in advance for your suggestion. Scott --- Scott Seidl Secretary of the Isaar Trail Riders Snowmobile Club Seymour, Wisconsin Email: [EMAIL PROTECTED] Web Address: www.isaartrailriders.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
View warning messages?
I'm getting several warnings when populating a table with data from a file. Some records are skipped as well, and I haven't been able to figure out why. Is it possible to view these warnings? I searched the list archive and saw that as of April 2000 this feature of MySQL hadn't been implemented, but it seems that surely this must be possible, at least by now. I mean, what good are warnings if you can't view them? Thanks. -- Jared Breland [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
[Fwd: How get the columns that are between an interval?]
oops, i've just sent it to mike. Sabine Richter wrote: Hello Mike, hello Silvia, I think, the statement you suggest, Mike, isn't right. It gives you only patients who are over 1 year in hospital. That means, who came before (or at) 2000-01-25 and left after (or at) 2001-01-30. I think, you didn't mean that, Silvia? I understood, you wanted the persons who came to hospital between 2000-01-25 and 2001-01-30 and that it doesn't matter when they left. That will be: SELECT * FROM table WHERE begin_date/admission_date =2000-01-25 and begin_date/admission_date = 2001-01-30; I'm not familiar with mysql this moment, but perhaps, if admission_date is a timestamp, you have to extract the dateportion of the column. Admission date can be 2001-01-30-13h:23m:45s and that may be interpreted as greater than 2001-01-30. (I don't know if that's a problem in mysql, in other backends it is). Best regards Sabine mike wrote: Dra. Silvia Andreasi, SELECT * FROM table WHERE begin_date_column =2000-01-25 and 2001-01-30= end_date_column; begin_date_column and end_date_column have to be date type columns. Mike sql,mysql Dra. Silvia Andreasi wrote: Hi, How can I get the columns between a given time interval? Something like: The patients admitted between january 25, 2000 and january 30, 2001 ?? I'm new to MySql and would like a suggestion from you... Best Regards Silvia - 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
% of relevance in results
Hi. I am working on a project using Perl and the DBI (which is irrelevant to the question) and I would like to get a percenteage of how relevant the results are to the query I've made. I have tried the Fulltext and match() methods, but they only give back a number from 1.6 to 3.8 (so far). So, there is no way to turn that into a %. Anybody now how this can be done, as I only have a couple of days left to work this out? Thanx, Alex - 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
help / MySQL 3.23.49 vs. BerkeleyDB 4.0.14?
hi all, i've built mysql-3.23.49 on MacOSX Server 10.1.4, as well as Sleepycat's BerkeleyDB 4.0.14. i note the --with-berkeley-db options in configure, but am stumped as to if/how to allow support for the bdb 4.0.14 version. mysql (in configure, acinclude.m4 aclocal.m4) seems to limit to bdb-3.x.x support. also, i've read that a patched bdb is required in the manual, and that use of a NON-patched bdb will not work . fyi, InnoDB support seems to work fine as an alternative .. comments on status/implementation? thanks! richard -- R Blake [EMAIL PROTECTED] http://homepage.mac.com/blakers -- - 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
Finding relevance in results
Hi. I am working on a project using Perl and the DBI (which is irrelevant to the question) and I would like to get a percenteage of how relevant the results are to the query I've made. I have tried the Fulltext and match() methods, but they only give back a number from 1.6 to 3.8 (so far). So, there is no way to turn that into a %. Anybody now how this can be done, as I only have a couple of days left to work this out? Thanx, Alex - 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
Using multi-byte character set
Hi, I am using double byte character set (big5) under mandrake linux with MySQL everything seemed ok after building the DB and tables after some time of testing I found some characters cannot be inserted, like those characters include the back slash '\'. it was simply disappeared as MySQL treat it as an invalid escape sequence. I can tackle the problem to add another back slash to the string when I am doing sth using C API. e.g. try to insert 1234\po, then I modify the string to 1234\\po then 1234\po can be retrieved from DB. But it seemed difficult to do using ODBC since I am using ASP and VB for the front end. So I am searching for a one time solution for the problem. Is it necesary for me to add big5 to the character set? but I don't need the to sort any double byte character field. what should I do? thanks for reading Borus - 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
FW: keymappings - PHP or MySQL?
Hi, At the moment im getting a difference in keymappings between what is typed into a field and what is stored in the database. I have an html form that gets a text string called $email and this is inserted into a VARCHAR database feild via php, the problem is when special characters are included in the email address. For example [EMAIL PROTECTED] gets stored in the database as baldey\[EMAIL PROTECTED] Has anyone seen this before? Is this a PHP, mysql or just sql issue? Do i have to set special options to use a UK keymap or something like that? If anyone has any links to docs that deal with this sort of thing i'd really appreciate them!! Cheers From baldey_uk - 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
myisamchk: error: Found key at page 2472960 that points to record outside datafile ...
Hi all, Can someone tell me what this error mean ? myisamchk: MyISAM file /var/lib/mysql/radius/radacct.MYI myisamchk: warning: 1 clients is using or hasn't closed the table properly myisamchk: error: Found key at page 2472960 that points to record outside datafile myisamchk: error: Keypointers and record positions doesn't match MyISAM-table '/var/lib/mysql/radius/radacct.MYI' is corrupted Fix it using switch -r or -o With 'check table', it does not found any error ... mysql check table radacct; ++---+--+--+ | Table | Op| Msg_type | Msg_text | ++---+--+--+ | radius.radacct | check | status | OK | ++---+--+--+ 1 row in set (7.63 sec) mysql Bye With myisamchk -r, it results : tanalahy:~# myisamchk --silent -r /var/lib/mysql/radius/radacct.MYI Found link that points at 35017460 (outside data file) at 35009348 tanalahy:~# Regards, @+ -- DouRiX - 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
Select records from remote machine.
Hello all, In mysql how can i select or execute any command in the remote machine Thanx i advance. -- Regards, Charitha. - 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
Select records from remote machine.
Hello all, In mysql how can i select or execute any command in the remote machine Thanx i advance. -- Regards, Charitha. - 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: Select records from remote machine.
You can do this by normal execution but with the -h parameter specfying the host mysql -u mysql -p -h ip address of remote mysql server - Original Message - From: Charitha To: [EMAIL PROTECTED] Sent: Monday, April 29, 2002 3:47 PM Subject: Select records from remote machine. Hello all, In mysql how can i select or execute any command in the remote machine Thanx i advance. -- Regards, Charitha. - 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
