At 08:00 AM 6/16/01 +, you wrote:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
database,sql,query,table
If you just reply to this message, and include
On Fri, Jun 15, 2001 at 10:03:57PM -0500, Dan Nelson wrote:
30 seconds of cscope browsing on the mysql source shows the follwing
comments right before calls to create_tmp_table():
/* Create a tmp table if distinct or if the sort is too complicated */
/* group data to new table */
So
Hello Matthew,
Thursday, June 14, 2001, 12:18:08 AM, you wrote:
MR Try this: update your ports, then build the mysql port with
MR WITH_LINUXTHREADS=1. This should result in a FreeBSD native binary
MR linked against linuxthreads instead of libc_r, so it should use multiple
MR processors.
Hm.. I
count() gives 0 but count(distinct) gives 1. is this correct or
a bug or is there something wrong with my SELECT?
mysql create table t1 (f1 int);
mysql insert into t1 values (1);
mysql create table t2 (f1 int,f2 int);
mysql select t1.f1,count(t2.f2) from t1
- left join t2 on t1.f1=t2.f1
Tim Williams writes:
I've downloaded the mysql++ api and I'm trying to compile the examples
but I keep getting these warnings I don't understand. When I compile ,
using the Makefile provided I get the following warnings:
custom1.cc:8:1 : warning: pasting ~ and stock does not give a
Pablo Prado writes:
Hi all,
I downloaded the both
mysql-3.23.39-sun-solaris2.7-sparc.tar.gz
mysqlgui-solaris-2.7-sparc-static-1.6
a few days ago.
While the sql server is running fine, I cannot get the gui to work.
I gunziped it and made it executable using chmod u+x filename. After
In order to add data to mysql, using LOAD INTO, am I right in thinking
that this file has to be local to the machine. Therefore I have to ftp
the file I want inserted to the machine running the MySQL server;
Correct?
Thanks lots
David Ayliffe ([EMAIL PROTECTED])
sir,
i have a problem.can u please tell me the
process how i can transfer my database from MSSQL to
MYSQL.Is there any Wizard like import,export im MSSQL.
Please send me the details.
__
Do You Yahoo!?
Spot the hottest trends in
Mark W. de Raad writes:
Good afternoon,
We have an not-so-unusual problem where people are accessing a database from
different countries (in this example, Germany and the UK). One of the search
terms commonly used is: gehäuse (housing), which the UK types in as gehause
and Germany (rightly
[EMAIL PROTECTED] writes:
count() gives 0 but count(distinct) gives 1. is this correct or
a bug or is there something wrong with my SELECT?
mysql create table t1 (f1 int);
mysql insert into t1 values (1);
mysql create table t2 (f1 int,f2 int);
mysql select t1.f1,count(t2.f2) from t1
On Fri, 15 Jun 2001, Dan Nelson wrote:
30 seconds of cscope browsing on the mysql source shows the follwing
^^
What is cscope? Where can I get it? =)
Sincerely,
Jan
--
Mr. Jan-Aage Bruvoll IT Project Manager
20 Min Holding, Thurgauerstrasse 40, CH-8050 Zurich
A better tool is Source Navigator,
available at Red Hat site.
It's Cscope on steroids!
Kevin
[EMAIL PROTECTED] wrote:
On Fri, 15 Jun 2001, Dan Nelson wrote:
30 seconds of cscope browsing on the mysql source shows the follwing
^^
What
The answer to ALL your 'where can I get it' questions is -
1) Freshmeat. www.freshmeat.net (Search for 'cscope'.)
2) Google. www.google.com (Repeat search)
Seaarch 1 results in this url: http://freshmeat.net/projects/cscope/
-Sander
-Original Message-
From: [EMAIL PROTECTED]
I would like to note that bug reports should only be sent out if you are
using the latest version, which now is 3.23.39.
--On Friday, June 15, 2001 17:37 -0600 Chris Bolt [EMAIL PROTECTED]
wrote:
After creating a new database, I ran:
update user set password = 'SomeJunk' where user =
- Original Message -
In the last episode (Jun 15), SDiZ Cheng said:
When i use mysqldump,
seems that MySQL will open all the tables in the database.
But, what i have is: a database will over 10,000 tables ..
I get a Too much opened file error on this..
I think increasing
I have installed mysql-3.23.38-hp-hpux10.20-hppa1.1 on an hpux10.20 Unix
machine. I also have PHP 4.0.5 installed. When I run mysql through PHP
on my web server, I get a Can't connect to MySQL server warning error
once every ten times I try to access a database. Is there something I
need
Greetings All!
I'm looking for a code which will find the shortest route between 2 cities, with
data
being stored in SQL tables listed below. Anyone has coded such a task ever?
I'm including the structure of tables used.
CREATE TABLE Cities (
cityID int(4) unsigned NOT NULL auto_increment,
In the last episode (Jun 16), Jeremy Zawodny said:
Ah, thanks. The funny thing is that I *did* think to check the source
code for a different problem I ran into severl minutes later.
I'll have to poke at this some more. I just restarted with a 64MB
maximum and one of my more common queries
Here is the text of an email that I googled (eeek! its a verb!)
The algorithm you need is called single-source, shortest path, also
known as Dijkstra's algorithm. Here's one way to implement it, in
pseudo-code.
Shortest route on graph of locations in Inform
Yes the server must be able to open the file. I dont know how you would
write a file path that accesses another machine heh.
ryan
In order to add data to mysql, using LOAD INTO, am I right in thinking
that this file has to be local to the machine. Therefore I have to ftp
the file I want
Yeah I know, I'm googling and yahooing and etc for the last 3 days
but my math knowledge is still insufficient to write a PHP code for
this. Any kind soul who can stop my pain?
Vahan
Gary Huntress wrote:
Here is the text of an email that I googled (eeek! its a verb!)
The algorithm you
Is it 'exactly' once every 10 times ??
You should check to make sure it's not an 'external' issue.
- Do you have a 'series' of DNS servers (like 10) that you use to lookup
system names (and 1 of them isn't working properly ?)
Try some other service (like 'pinging' the MySQL server from the
How do I make an error display, but still continue the script? The error
subroutine does not exit, but the original subroutine that calls it doesn't
continue
after the error message, it just quits.
=Dawn H
http://www.rdcss.com/ - RD Computer Solutions
http://wow.cooncheese.com/ -
I'm using Perl
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of
MikemickaloBlezien
Sent: Saturday, June 16, 2001 2:06 PM
To: Dawn H
Cc: [EMAIL PROTECTED]
Subject: Re: Display error but continue script
On Sat, 16 Jun 2001 13:47:29 -0500, Dawn H [EMAIL
On 16-Jun-01 Dawn H wrote:
How do I make an error display, but still continue the script? The error
subroutine does not exit, but the original subroutine that calls it doesn't
continue
after the error message, it just quits.
A look at the code that does that would help ...
but:
Hi,
I just installed Mysql from source for Linux. When I type the following command:
mysqladmin -u root password mysql
I got this error:
mysqladmin:connect to server@localhost' failed
error:'access denied for user:'root@localhost'(using password:NO)'
Can some tell me how to correct this
Ah. The subroutine bail_out() that I'm using is using die. Aha! :-)
Thanks,
=Dawn
-Original Message-
From: Don Read [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 16, 2001 2:39 PM
To: Dawn H
Cc: MySQL Email List
Subject: RE: Display error but continue script
On 16-Jun-01 Dawn H
On Sat, 16 Jun 2001 14:33:44 -0500 (CDT), Don Read [EMAIL PROTECTED] wrote:
A heck of alot easier with Perl!(Just my opinion) :) Just disable RaiseError and
enable PrintError when using DBI
On 16-Jun-01 Dawn H wrote:
How do I make an error display, but still continue the script? The error
On Sat, Jun 16, 2001 at 12:35:52PM -0500, Dan Nelson wrote:
In the last episode (Jun 16), Jeremy Zawodny said:
Ah, thanks. The funny thing is that I *did* think to check the source
code for a different problem I ran into severl minutes later.
I'll have to poke at this some more. I just
Hello,
Has anyone managed to compile the BETA version of MySQL 4 for Windows?
I have downloaded the source however, it appears to be for LINUX or UNIX.
*
* Visit http://www.computerstaff.net - Computer Jobs at all LEVELS *
My application needs to insert between 200-500k rows about once a day...
When using MyISAM tables I determined the best way to get this done (while
still allowing users to perform select statements from the table) was to use
mysqlimport with --low-priority. This way all the inserts get bundled up
Tobias Kjær Tobiasen wrote:
Hello
I have installed 2.23.32 from source - and I want to upgrade to the
latest *rpm* (redhat 6.2@intel). How to do this? The database is in
production so downtime should be avoided.. Can I do this:
1) Install the rpm on top of the source installation (I
Hello. I installed on my computer Red Hat Linux 7.0. After that I started configuring
mysql. I upgraded mysql, added all necessary packages and I wanted to run mysql
server.
Whenever I type mysql it gives me such an error message: ERROR 2002: Can't connect to
MYSQL server through socket
Malkhaz Mangoshvili [EMAIL PROTECTED] writes:
Hello. I installed on my computer Red Hat Linux 7.0. After that I started
configuring
mysql. I upgraded mysql, added all necessary packages and I wanted to run mysql
server.
Whenever I type mysql it gives me such an error message: ERROR
I'm new to mysql.
I developed a unix korn shell script that performs three queries on our
database. Our DBA found corruption problems coincidental to my script
development. Is it possible that I could have corrupted the data with three
SELECT queries?
We are pretty fast-and-loose with security
At 6:23 PM -0400 6/16/01, Malkhaz Mangoshvili wrote:
Hello. I installed on my computer Red Hat Linux 7.0. After that I
started configuring
mysql. I upgraded mysql, added all necessary packages and I wanted
to run mysql server.
Are you using RedHat's MySQL RPMs? If so, you should uninstall
Hi there,
For some reason, this query doesn't work:
PHP4 mysql_query(select * from user where username='myname' and passwd =
password('mypass'));
WHILE this one does work:
PHP4 mysql_query(select * from user where username='myname' and
password('mypass'));
Notice the lack of passwd = in the
In the last episode (Jun 16), Jeremy Zawodny said:
Err, I forgot to mention that there's a Using filesort in the
output as well. That makes me believe it wants to write to disk (even
if there may be sufficient RAM).
I'm not sure Using filesort actually means it is going to create a
file. The
At 8:49 PM -0400 6/16/01, William Wong wrote:
Hi there,
For some reason, this query doesn't work:
PHP4 mysql_query(select * from user where username='myname' and passwd =
password('mypass'));
Define doesn't work. Fails to return rows? PHP generates an error message?
WHILE this one does
PHP4 mysql_query(select * from user where username='myname' and passwd
=
password('mypass'));
Define doesn't work. Fails to return rows? PHP generates an error
message?
Hi Paul,
Sorry bout that. Yes it doesn't return any rows despite the fact that the
correct username and password are
At 12:29 PM +0100 6/15/01, Michael Garthwaite wrote:
I'm new to mysql and relatively new to java. I've downloaded a type
4 driver from mm.mysql. I've put the folder containing the driver in
my classpath and included the driver in my code as per the
instructions as follows:
try{
I think the problem goes here:
PHP4 $result = mysql_query(insert into user values ('$username',
password('$password'), '$email'));
Please ensure $password is correct, and with no problem..
( eg. space/CRLF at the enter of the string ... etc.. )
Looks correct to me. Try running this query from the mysql program
to verify that you're really matching the password of some entry:
mysql SELECT *, password('mypass') FROM user;
Hi guys,
I've solved the problem, but it was something related to the password
function.
In my user table, my
hello,
i have some files from a Cd that are .dump files, how do i get these
db into mysql? (is it possible using phpMyAdmin).
again, these are .dump files, not .sql files.
thank you.
-
Before posting, please check:
What format are they in? Please paste a few sample lines.
hello,
i have some files from a Cd that are .dump files, how do i get these
db into mysql? (is it possible using phpMyAdmin).
again, these are .dump files, not .sql files.
45 matches
Mail list logo