That was a really silly message to send. I hope that in 10 years when you've
experienced some stuff, you look upon this message and realize how silly it was
and learn not to send such silly stuff.
Try not to be so silly in a technical forum. The people in this list do some
technically useful
MYSQL: I have problems with importing data including characters like 'äöü'.
These characters where translated to some other unusable characters.
In the command line with a single insert statement the 'äöü' characters are
accepted!
Can help someone ?
Thanks
Enrico Kratter
Alpenblickstrasse 30
I know that there are binding that allow one to speak SQL to MySQL for:
* PHP
* Perl
* Java
...there must be more, all with their own idiosyncrancies, strong points
and weaknesses. Rather than having a holy war about which binding is
better (I prefer Perl but I certainly use PHP when it's
On Sun, Nov 10, 2002 at 07:33:37PM +1030, David Lloyd wrote:
I know that there are binding that allow one to speak SQL to MySQL for:
* PHP
* Perl
* Java
...there must be more, all with their own idiosyncrancies, strong points
and weaknesses. Rather than having a holy war about which
On Sun, Nov 10, 2002 at 05:51:43PM +1100, Greg Matthews wrote:
It would be a huge help to get hold of MySql 4.1.
What's shaken out mean? Is 4.1 still mid-development, or is it in
alpha, more or less finished, and needs debugging?
Is there anyway soon that someone could build and release
Hi,
It remains some bugs in MySQL 4.1 subselect implementation which are on the
way to be resolve. (take a look at the [EMAIL PROTECTED])
Also, support for IN subselect are not yet available (you can find the code
in reading the bk commit, but it's not yet push).
Lastly, subselect are not yet
Jeremy,
I'm not a C/C++ coder so couldn't really help unless a binary was available.
At the same time, I understand that you'd be wasting your time building
binaries unless you were happy that the code was at a certain level of
completion (with regard to 4.1 specific features).
Your call. If a
On Sun, Nov 10, 2002 at 09:29:52PM +1100, Greg Matthews wrote:
Jeremy,
I'm not a C/C++ coder so couldn't really help unless a binary was
available.
At the same time, I understand that you'd be wasting your time building
binaries unless you were happy that the code was at a certain level
ÄãºÃ£º
ÎÒ¹«Ë¾ÊÇÒÔ¾ÓªÌØÖÖÏ𽺡¢ÏðËÜ¡¢Ä¦²Á²ÄÁÏ¡¢Èó»¬ÓÍÌí¼Ó¼Á¡¢µçÀ²ÄÁÏ¡¢ÂÖÌ¥²ÄÁÏ¡¢Õ³ºÏ¼ÁΪÖ÷£¬ÏàÓ¦¼¼Êõ·þÎñΪ¸¨µÄ¶àÔª»¯¹«Ë¾¡£ÏÖÖ÷Òª¾ÓªÆ·ÅÆ£¨¶¡ëæ¡¢·ÛÄ©¶¡ëæ¡¢ÒºÌ嶡ëæ¡¢ÈýÔªÒÒ±û¡¢¹è½º¡¢·ú½º¡¢±ûÏ©Ëáõ¥¡¢
i am using crystal report 8 RDC with mysql in vb ,
following error occured when i show the report
command
CRViewer1.ViewReport
Error
server has yet not been open
connection is through ODBC ( MYODBC )
kindly help
thanks
lalit
__
Do you Yahoo!?
I have a query like this:
SELECT * FROM bc_posts WHERE MATCH (post_city, post_location, post_details,
post_message) AGAINST ('webster');
I get the results as follows:
webster hall
webster
webster hall club
How come the exact match (i.e. webster) does not get a higher relevance?
I remember
Hi!
What is the query, and what does EXPLAIN say ?
On Nov 08, Christian Sylvestre wrote:
I have 3 identical tables with approx 150,000 row each. These tables
have currently no indexes. If I do a specific query on each table it
takes approx 3 seconds per table. Doing the same query on the
Every time I start or restart the PC, the MySQL service doesn't come up,
so we have to start it manually with the command service mysql start.
I am a really newbie to Linux (2 weeks using Mandrake 9). Using drakconf
I checked that the service was scheduled to start at boot time, which it
is. By
Also, make sure you're running FLUSH PRIVILEGES after your grants and
revokes. (Did I spell that right?)
-Mike
Hi all.
My name is Mike.
I have a Linux RedHat 7.3 with Mysql ver 3.23.49.
I want to grant access to databases and tables to users,but only to a certin
databases and tables.
I
Hello
The follwing bug was reported against the Debian libmysqlclient10
package. Can you comment on this?
The mentioned /usr/share/doc/ copyright file includes a copy of
http://www.mysql.com/doc/C/o/Copyright.html
bye,
-christian-
On Sun, Nov 10, 2002 at 05:03:06PM +0100, Andreas Metzler
Hi,
If 'webster' can be found in more than a half of the records from the
database, it is considered a stop word and it is ignored.
The solution is to force searching for that word by placing a '+' sign
before it like '+webster'
I guess this should be the problem, but if it is not the case, ...
Can't you use the DBI module to access more kind of databases with their
corresponding DBD modules, like DBD::mysql, for example?
It is pretty easy in Perl also.
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
Hello
The following bug was reported against the Debian mysql package bug
seems to be a generall problem.
bye,
-christian-
On Sun, Nov 10, 2002 at 02:32:08PM +0100, Luca Barbieri wrote:
Package: libmysqlclient10
Version: 3.23.53-3
Severity: important
One or more programs or libraries in
Paul:
Not sure why my post didn't cc to the list, originally. I think I picked up on
your tone, but the one thing I had intended to add was the dynamic that the more
I do this stuff, the more I find myself just having to get over some of the
more ugly and cludged implementations due to
Sorry for such a newbie question...:-) I was hoping someone on this
list could tell me if there is an SNMP MIB for the standard install of
MySQL. If so, where can I get a copy of the MIB file to load into my
NMS system?? Thanks.
-Patrick
i have installed redhat 8 and slackware linux and been trying to get mysql
to run. when i get to the console and type 'mysql' i get, error 2002; cant
connect to local mysql server through socket '/var/lib/mysql/mysql.sock' i
have tried to run mysqld through the console but says it cant find the
Bonjour,
I just would like to know if there is a way to upload and store a file via query
into a
BLOB field...
Anyone ?
Cordiales salutations,
--
---
Jean-Yves Besserer
Dial / Taskers Art Designers
http://Taskers.ovh.org
Dial on IRCnet amigafr, #artbas, #bigboss
ICQ #51667972
I agree mostly,... but why is ASP worthless?
Alan
-Original Message-
From: [EMAIL PROTECTED] [mailto:vanboers;why.dedserius.com]On
Behalf Of Van
Sent: Monday, 11 November 2002 6:21
To: Paul DuBois
Cc: MySQL
Subject: Re: PHP bias (Way OT)
Paul:
Not sure why my post didn't cc
Alan:
ASP only runs on Windows. Windows2000 and beyond mandate the Supplemental EULA
(as of SP3 on Win2K) that grants M$ blanket authority to modify your machine in
any way M$ sees fit.
For this reason (because you no longer have full control over your machine) you
can't do the following:
C3
asp can do allot of client side possibly security risky stuff where php cant
-Original Message-
From: Alan McDonald [mailto:alan;meta.com.au]
Sent: Monday, November 11, 2002 7:49 AM
To: [EMAIL PROTECTED]; Paul DuBois
Cc: MySQL
Subject: RE: PHP bias (Way OT)
I agree mostly,... but why is
My experience of MySQL is very recent. I only started using it a few weeks
ago. I got great support from the list (Thanks !) when I had an initial
problem specific to MySQL VARCHARand it's not just Perl and PHP that
work. After I had my database created in the command line I downloaded the
ever heard of chilliasp ? its been cross platform portable , its hooked in
via java
-Original Message-
From: [EMAIL PROTECTED] [mailto:vanboers;why.dedserius.com]On
Behalf Of Van
Sent: Monday, November 11, 2002 8:01 AM
To: MySQL
Subject: Re: PHP bias (Way OT)
Alan:
ASP only runs on
Make sure the service is started. If no, enter the command:
console service mysql start
Adolfo
On Sun, 2002-11-10 at 16:44, Stick Dragon wrote:
i have installed redhat 8 and slackware linux and been trying to get mysql
to run. when i get to the console and type 'mysql' i get, error
Hi there -- I'm relatively new to LINUX (I have RedHat 8.0 on my system)
and I just downloaded MySQL-GUI and can't seem to get it working. It
keeps telling me that it cannot connect through the socket (111). Can
someone tell me what I'm doing wrong? I tried to set the path using a
shell
Why don't you simply convert these queries to ordinary JOINs?
...because we've already got a 90% finished application (75 tables/150 jsp
pages).
I was toying around with the idea last night of using a JOIN instead of
EXISTS but i'd have to change the way the persistence layer works. I'm not
Hello guys!
Would you please somebody clarify my replication problem?
I have master with
mysqld_safe ...stuff... \
--log-bin=master-binlog \
-O binlog_cache_size=102400 \
--server-id=91 \
...
And slave with
mysqld_safe ...stuff... \
--master-host=ip-addr here \
Try Apache::ASP -- ASP syntax with mod_perl on Apache.
http://www.nodeworks.com/asp/
We run a pretty busy database-driven web site with Apache::ASP and MySQL.
I'm quite happy with it, as it gives us access to the massive collection of
Perl modules, and enables us to use a single language for
Hello John
On 10/11/2002, you wrote:
Here's some example code from PHP
if (strlen(trim($strPicture)) 0 strlen(trim($strPicFieldName)) 0) {
$fp = fopen($strPicture,rb);
$bArray = fread($fp,$strFileSize);
fclose($fp);
$strQuery = UPDATE . $tableName .
Make sure that your mysql daemon is running, if not, start it. Also, make
sure the mysql.sock file is present in /var/lib/mysql.
Bhavin.
- Original Message -
From: Stick Dragon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, November 10, 2002 3:44 PM
Subject: starting Mysql on linux
From: A. J. Maclean [EMAIL PROTECTED]
I have a query like this:
SELECT * FROM bc_posts WHERE MATCH (post_city, post_location, post_details,
post_message) AGAINST ('webster');
I get the results as follows:
webster hall
webster
webster hall club
How come the exact match (i.e. webster) does not
From: Van [EMAIL PROTECTED]
I _realize_ Perl is fast, and powerful... But, it's
ugly...
In a perfect world, everyone would use
C/C++...
Boy, talk about trolling!
My vote for the most beautiful language is Smalltalk, followed by Objective C.
Having experienced the real thing in OOP, I find
Van wrote:
ASP only runs on Windows.
This is not actually true; ASP will work with Chilisoft's ASP software
for Apache. It is commercial and closed-source and I don't recommend
using ASP, but this will allow it to run on Linux at least (and perhaps
BSD's as well?)
Windows2000 and
Greg Matthews wrote:
clause) instead of EXISTS -- seems like a tail wagging the dog strategy.
Isn't EXISTS a lot more efficient than an inner join?
Well, its more efficient if it exists, I guess ... but if it doesn't
exist on your platform (MySQL), then its pretty inefficient, really.
We're
With the efficiency comment below, I was using the strategy that I'd prefer
to wait for 4.1's impending (?) release rather than rewrite SQL in a
workaround way. It's a tradeoff based on our specific project and relating
to time factors, etc, and the amount of SQL I'd have to rewrite.
Yes i'm
will 4.1 hopefully have stored procedure functionality ?
= Original Message From Greg Matthews [EMAIL PROTECTED] =
With the efficiency comment below, I was using the strategy that I'd prefer
to wait for 4.1's impending (?) release rather than rewrite SQL in a
workaround way. It's a
-Original Message-
From: [EMAIL PROTECTED] [mailto:mysql;lists.mysql.com]
Sent: Sunday, November 10, 2002 6:53 PM
To: John Meyer
Subject: Re: 4.0 as a production relese?
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the
Hi has anyone seen a workaround for the following error:
Thanks in advance,
Drew.
Environment: Solaris 9 u1 (Kernel: 112233-02)
All GNU compilers tools installed. output as follows:
gcc -DMYSQL_SERVER
-DDEFAULT_MYSQL_HOME=\/usr/local/mysql\
-DDATADIR=\/usr/local/mysql/var\
You said that old relay logs are automatically deleted. But on what
condition?
log file size? time? or anything else?
I'd asked about when the relay logs are deleted but got no answers, so
I'm asking
again.
--
Chung Ha-nyung alita@[neowiz.com|kldp.org]
Sayclub http://www.sayclub.com
Chip Shabazian wrote:
$dvd_time_result = mysql_query($dvd_time_query);
echo td class=mfont size = -1b.$dvd_time_result./b/td;
?
I'm not going to bother answering the question, but the answer is in
those two lines (more specifically, the lack of another needed line).
Go read the PHP docs
On 11/10/02 1:50 PM, Allan J Horwitz [EMAIL PROTECTED] wrote:
Hi there -- I'm relatively new to LINUX (I have RedHat 8.0 on my system)
and I just downloaded MySQL-GUI and can't seem to get it working. It
keeps telling me that it cannot connect through the socket (111). Can
someone tell me
hello:
i am using a Perl-Tk program to access data in a mysql database. the start of
the program is as below:
--- start ---
#!/usr/bin/perl -w
use DBI ;
use DBD::mysql ;
use Tk ;
require Tk::TableMatrix ;
use Tk::widgets qw/Dialog/;
use subs qw/file_menuitems
running on localhost using the socket connection (as supposed to
tcp/ip ).
what are you saying that mysql can connect another way other than through
mysql.sock ?
= Original Message From R. Hannes Niedner [EMAIL PROTECTED]
=
On 11/10/02 1:50 PM, Allan J Horwitz [EMAIL PROTECTED] wrote:
On 11/10/02 9:14 PM, daniel [EMAIL PROTECTED] wrote:
running on localhost using the socket connection (as supposed to
tcp/ip ).
what are you saying that mysql can connect another way other than through
mysql.sock ?
If I am not mistaken the socket works only for a connection between server
i've made connections to a remote mysql from one server to our main one and
the main one is running socket connections ?
= Original Message From R. Hannes Niedner [EMAIL PROTECTED]
=
On 11/10/02 9:14 PM, daniel [EMAIL PROTECTED] wrote:
running on localhost using the socket connection
Pada Fri, 8 Nov 2002 15:43:52 +0700
Fajar Priyanto [EMAIL PROTECTED] menulis:
Hello All...
How to remove MySQL installed using tar.gz?
after you extract it from tar.gz, you usually move / copy it to somewhere else.
so just delete the directory of mysql extraction (or mysql base dir) ...
but
On 11/10/02 9:42 PM, daniel [EMAIL PROTECTED] wrote:
i've made connections to a remote mysql from one server to our main one and
the main one is running socket connections ?
I guess I lost you.
All I wanted to say is this:
If you run mysql (client) and mysqld (server) on the same computer you
Pada Mon, 11 Nov 2002 01:04:10 +0300
Mike Blazer [EMAIL PROTECTED] menulis:
And replication... well, it kinda works, I see that voy88-relay-bin.001
grows - but it does not change my tables. So, I'm assuming that it does
not understand replicate-do-table rules.
BTW - it seems very strange to
Hi all,
I'm compiling DBD-mysql-2.1020 on a Solaris 2.6 machine with mysql version
4.0.1-alpha-log. Without making any changes to Makefile.PL and Makefile, I
get the following at 'make' time:
cc -c -I/usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/auto/DBI
-I'/usr/local/mysql/include/mysql'
Good morning to all
On mysql 4,0,4 running under W2K SP3, when I run the command SLAVE STOP;
the
command it is not execute and it remain pending (the prompt of mysql
doesn't
return); instead all is normal under 3.53.
Which is the problem ?
tks regards
From: Jan Steinman [mailto:Jan;Bytesmiths.com]
Sent: Sunday, November 10, 2002 6:37 PM
To: [EMAIL PROTECTED]
Subject: Re: one word fulltext matching problem...
Without ORDER BY clause, results of a SELECT are in arbitrary order. That's
just the way SQL works -- there is no relevance ranking
55 matches
Mail list logo