Hello Benjamin.
Thanks a lot. Yes, you are right. It is a search engine. But I can?t get
rid of the OR expressions, cause it is implemented in the search formular
mask. So the User can choose any search criteria, which he wants. Neverthe-
less I will follow your hint and check out these queries m
I'll add my voice especially on the local file. many times I have wanted to
be able to skip creating the file on the server, then having to scp it to my
local box.
On Tuesday 11 December 2001 02:09 pm, you wrote:
> Hi,
>
> I would like to request the addition of the following features to the
>
I am running MySQL (version 3.23.46a)on a Windows 2000 server.
The server has suddenly stopped serving out requests. It appears that
localhost is refusing connections, even though the passwords appear to be
correct.
I am pretty new to MySQL so any suggestions of where to look are
appreciated.
Im running MySQL on my Win98 Desktop and Ive created a new user and only
granted access to one database, but when I use myPhpAdmin the user can still
see all the databases. What can I do so that each user only see the
databases they have access too.
"Always an Email Away"
Kevin Campbell
Ch
hi all,
mysqldump is not generating references. how can i get it.
regards,
sreedhar
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
I am having problems with this nested inner join statement:
SELECT tblMethodType.MethodType, tblMethodParm.MethodName,
tblParm.ParmName, tblParm.Label, tblParm.Value, tblParm.Unit, tblParm.Tip
FROM tblMethodType INNER JOIN (tblMethod INNER JOIN (tblParm INNER JOIN
tblMethodParm
ON tblParm.idParm
On Wed, Dec 12, 2001 at 11:26:05AM +0800, TH Leung wrote:
> Hi,
>
> I use the MySQLManager and enter a SQL statement with a "in" keyword, but an
> error message of syntax error occurs, I verify the SQL by plugging it to MS
> SQL Server 2000, it works without error, so I would like to know if the
Hi,
It would help if you can post the statement and the error message that you
get.
Regards
Quentin
-Original Message-
From: TH Leung [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 12 December 2001 4:26 p.m.
To: '[EMAIL PROTECTED]'
Subject: Problem in using "in" keyword
Hi,
I use the M
Hi,
I use the MySQLManager and enter a SQL statement with a "in" keyword, but an
error message of syntax error occurs, I verify the SQL by plugging it to MS
SQL Server 2000, it works without error, so I would like to know if the "in"
keyword only functions on the Linux platform but not on the Win
Is it possible to export a database from mysql so MS Access can read
it as its own? I am not able to install MyODBC on the windows box
(not admin)
--
Sincerely,
Rosyna Keller
Technical Support/Holy Knight/Always needs a hug
Unsanity: Unsane Tools for Insane People
-
I had to post this short note of Thank You to Monty Widenius..
I had struggled for over 6 months and several versions of MySQL
trying to get the source to compile without errors on Caldera 2.3
or 2.4. I continued to fail.
I upgraded Libc libraries and gcc makes but still failed.
Yeah, I got a c
I'll make you a promise. READ THIS E-MAIL TO THE END! - follow what it says to the
letter and you will not worry whether a RECESSION is
coming or not, who is President, or whether you keep your current job or not. Yes, I
know what you are thinking. I never responded to one of
these before ei
Greetings,
We modified our db, host, and user tables (in mysql db) in order to have
bigger db names, users... Just 16 characters is really not enough for us.
Now the problem: Some of our users use myODBC to connect to their databases.
And that driver does not accept db names with more than 16
Does MySQL support Db2 Version 5.0
Kumud Advani
Sears Canada Inc
Architect Council - Corporate Data WareHouse
Tel : (416) 510 - 6217
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
h
This is a peculiar thing that I've seen before on this machine. The
update doesn't work always (from mysql, I hope this isn't happening from
the perl scripts as well).
mysql> select iHasPhoto,iNumPhotos from tblListing where iListingID =
10014061;
+---++
| iHasPhoto | iNumPh
On Tue, Dec 11, 2001 at 04:24:40PM -0600, Dave Burgess wrote:
: Obvious stupid question:
:
: What happens when you specify the value as 16777216? Since you
: are running on a SPARC, I'm sure you will end up with
: the correct value (1) in the space. If that works, there is
: definitely an endis
Obvious stupid question:
What happens when you specify the value as 16777216? Since you are running on a
SPARC, I'm sure you will end up with
the correct value (1) in the space. If that works, there is definitely an endism
problem.
Dave
Philip Molter wrote:
> >Description:
>
> When I do th
Hello,
The original question from Michael is:
Is there a SQL function available for finding the median value from a
column of numbers? I see AVG() but no reference to medians. Thanks.
Does the sql AVG() skip ruled out values by some non-parametric test? Every
SQL description of AVG() at my dis
>Description:
When I do this:
mysql>create table test_default ( testint int not null default 1 );
mysql>desc test_default;
I get:
+-+-+--+-+--+---+
| Field | Type| Null | Key | Default | Extra |
+-+-+--+-+--+-
Hi,
I seem to be experiencing similair problems to what Sam Lam
reported earlier this month (Subject: tables locked during long
compound INSERT/DELETE?).
What I've observed is that when I'm issuing an UPDATE on a table
that also has SELECT queries being executed on it, everything seems
to clog u
Quentin Bennett wrote:
>
> Shell escape
>
> mysql> !rm /tmp/data.txt
> mysql> select col into outfile '/tmp/data.txt' from table;
>
>
>
> mysql> select col into local outfile '/tmp/data.txt' from table
>
>
>
> Would these options prove useful to others?
Yes. Especially the local outfil
Hi,
The output of mysqlbug might be useful, so we can see what platform etc you
are on.
Quentin
-Original Message-
From: Philip Molter [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 12 December 2001 9:08 a.m.
To: Nathan
Cc: [EMAIL PROTECTED]
Subject: Re: Default 1 == Default 16777216 ?
O
Hi,
I would like to request the addition of the following features to the
command line client:
Shell escape
mysql> !rm /tmp/data.txt
mysql> select col into outfile '/tmp/data.txt' from table;
The command is run on the client. It would all SQL scripts to be run more
simply that constructing a s
Hi.
On Mon, Dec 10, 2001 at 02:06:41PM +0100, [EMAIL PROTECTED] wrote:
> ---
[...]
> # Time: 011210 13:40:23
> # User@Host: eff21[eff21] @ localhost []
> # Query_time: 25 Lock_time: 0 Rows_sent: 20 Rows_examined: 596309
>
> S
Hi.
On Mon, Dec 10, 2001 at 06:30:47PM +0530, [EMAIL PROTECTED] wrote:
[...]
> here shortname is varchar and pcallid is integer. i need shortname and
> pcallid as ' callno' of length 6. pcallid starts from 1 .. 999.
>
> to get effect like for callnumber 'xxx001' i plan to add pcallid by 1000 and
The solution we took was to write a global configuration file and share
connection data as need. This way it only needs to be changed in one place.
Furthermore, if you connect as follows:
dbi:mysql:host=db_01;database=
and then on your client machine, either via bind or the /etc/hosts file,
poin
Is there any way to bind something other than the hostname to a MySQL
instance?
I'm going to be moving a database from one server to another, and would
like the scripts that reference that data to simply talk to
"db.mydomain.com", rather than have to reconfigure things during launch.
Is this poss
On Mon, Dec 10, 2001 at 02:55:04PM -0700, Nathan wrote:
: Dave Burgess had a good suggestion; I suppose you could specify the default in
:hex...
: (default = 0x1) - as long as this is NOT in quotes it will input the hex value 1.
I compiled a 3.23.46 last night and I have the same problem. I
tr
Dear
Dose anyone know, if i install MySql in NFS, are there any problem? and is
that a good idea? why?
lei shen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
In article <[EMAIL PROTECTED]>, Sinisa
Milivojevic <[EMAIL PROTECTED]> writes
>MattJ wrote:
>> It's still possible in the mysql client to request the creation
>>of an index with indexlength NULL on TEXT fields. This apparently
>>works okay on creation of the index, insert and select opera
Hi. I've been testing some querys with this two versions of mysql and
found weird results. First we try with 3.23.32:
(foo)-/usr/local/mysql_3.23.32/bin# ./mysql -uroot publish
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 3.23.32-lo
Can you provide your table description?
You have two set colums? One called res_skills and one called
res_skills_ma ?
Etienne
Wiliam Stephens wrote:
>
> Hi
>
> Can anyone tell me what is wrong with the MySQL FIND_IN_SET function? Well,
> I'm using the following:
>
> ELECT * FROM gd_
At 08:27 AM 12/11/2001 +0200, you wrote:
>Hi!
>
>I do not understand how replacing just the executable mysqld can make your
>'mysql start' (or is it 'mysql.server start'?) script or safe_mysqld script
>to search the executable from a different directory than it did before.
I do not understand it
At 17:23 11/12/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 the
Hi
Can anyone tell me what is wrong with the MySQL FIND_IN_SET function? Well,
I'm using the following:
ELECT * FROM gd_records WHERE res_skills & 3 AND res_skills_ma & 3;
And it returns the most weird results. It completely ignores the AND
statement, and returns results even if the
[ob. filter faker: mysql]
For what it's worth, here's an algorithm I use to write my own rounding
function.
To round to the nearest N number of places.
1) divide the number by N
2) add .5 (for negative numbers subtract .5)
3) truncate the result (take integer part)
4) multiply result by N
Exam
Gill, Vern writes:
> # uname -a
> Linux linuxbox 2.4.16 #2 Wed Nov 28 12:24:51 PST 2001 i586 unknown
> # rpm -qa | grep -i libc
> glibc-2.2.4-20
> glibc-devel-2.2.4-20
> compat-glibc-6.2-2.1.3.2
> glibc-common-2.2.4-20
> # /usr/bin/gcc -v
> Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.1
# uname -a
Linux linuxbox 2.4.16 #2 Wed Nov 28 12:24:51 PST 2001 i586 unknown
# rpm -qa | grep -i libc
glibc-2.2.4-20
glibc-devel-2.2.4-20
compat-glibc-6.2-2.1.3.2
glibc-common-2.2.4-20
# /usr/bin/gcc -v
Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.1/specs
Configured with: ../configure
Hi all,
I've got the mysql-3.23.46-dec-osf5.1-alphaev6 binary, but can't get it to
work on a DS10 Alpha Server. It hangs on the "Installing all prepared
tables" part of the mysql_install_db script
'sizer -implver' reports that the system chip is indeed an 'EV6', so I
would have thought thi
From: <[EMAIL PROTECTED]>
> I have a similar problem...
Just to be sure, it's helpful if you could send us the message that your getting when
you see the connection problem, but this sounds like the same thing.
> Can this sovle my sleeplessness problem?
Probably. Anytime I can't sleep, I jus
I have read the documentation thoroughly, however there are still some
things unclear to me, and others that I want opinions on.
I am dismayed at what I see as a fundamental lack of "server
administration" documentation. Much of the docs focus on the SQL aspects of
MySQL. There is only a minor
At 03:23 PM 12/10/01 -0700, you wrote:
>From: Dan <[EMAIL PROTECTED]>
>
>> I can connect... on the same computer
>> ...different machine it won't work.
I have a similar problem but let explain better may be i don't get what Dan
was talking about. From my local computer i can use LOAD command to s
Have you had a look at The Exchange Project?
www.theexchangeproject.org
Kevin
On Wednesday 05 December 2001 22:07, rory o'connor wrote:
> I'm looking for a new commerce package, something run of a MySQL database.
> it's gotta have bulletproof (well, as close as you can get) session
> management.
Define "unusable".
Did you copy them as root so 'mysql' no longer owns them?
Did you copy them while the server was running?
Michael Migal wrote:
> Hi,
>
> I have a little problem, and hope that someone can help me with it.
>
> I am trying to copy MySQL data files for a certain database from o
What permissions do you need to have to issue a show slave status
command?
Thanks,
database,sql,query,table
--
Michael Eklund
System Administrator
Netmechanic, Inc.
[EMAIL PROTECTED]
http://www.netmechanic.com
-
Before po
Bonjour,
BA> But I forgot the "-d" ... and here is what I found : There are some
BA> "\r" at the end of some symbols !
I corrected everything with one query :
mysql> UPDATE historique_AMS set symbole=TRIM(TRAILING '\r' FROM symbole);
These '\r' may come from a program a colleague did.
Bonjour Sinisa,
SM> There were some bug fixes with packed keys.
SM> 3.23.47 will soon be out and it would be fine if you could test your
SM> case with it again.
I tried to do
>alter table historique_AMS PACK_KEYS=0;
But it did not correct the problem.
Then I wanted check if the PA
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: my
Hi,
My environmment is next
WindowsNT 4.0(SP5)
Tomcat 3.2.3
MySql-max 3.23.46
Driver MySql: mm.mysql-2.0.8-bin.jar or gweMysql.jar
Poolman 2.0.4
It works fine.
I will attach my SimpleServet and poolman.xml for testing connection
to Database below.
I think PoolMan2.1.-
Bonjour Richard,
RE> Have you checked your table with myisamchk? Sounds like a corrupt
RE> index to me.
I did "check" and "repair" table from mysql console.
And from the documentation :
"CHECK TABLE only works on MyISAM tables. On MyISAM tables it's the
same thing as running myisamchk
If you plan on using MySQL a lot I suggest you buy the book MySQL written
by Paul DuBois. You might start by reading information on www.devshed.com
(click on MySQL, click on PHP) and www.php.net (click links)
Bye,
B.
-
Bef
On Monday 10 December 2001 07:00 pm, Petro wrote:
> >?On Monday 10 December 2001 05:45 pm, you wrote:
> >?> root@dbacp01d-red:/usr/local/mysql/bin# ./resolve_stack_dump -s /tmp/a
> >?> -n /tmp/b
> >?> 0x807b75f handle_segfault__Fi + 383
> >?> 0x812bcaa pthread_sighandler + 154
> >?> 0x815059c chun
BAUMEISTER Alexandre writes:
> Bonjour,
>
> I have a table :
>
[skip]
> Any idea ?
>
> Regards,
> Alex.
There were some bug fixes with packed keys.
3.23.47 will soon be out and it would be fine if you could test your
case with it again.
--
Regards,
__ ___ ___ __
/
Gill, Vern writes:
> Still need help with this one
>
> Anyone, anyone?
>
> trying to compile mysql-3.23.46, getting this error. Can't find any
> reference to it anywhere.
> Please help;
>
> kgcc -O3 -DDBUG_OFF -O9 -rdynamic -o isamchk isamchk.o sort.o libnisam.a
> ../mysys/libmysys.a ../dbu
Hi,
Please tell about your environment.
What is MySQL(-max) version?
What is PoolMan version?
Thanks.
GABRIELMORENO wrote:
>
> My problem was the next:
> I'm using Poolman to create a conecction pool in Tomcat 4 to access a
> MySql database, the driver that I'm using is org.gjt.mm.mysql
OK! Now it works. I've just didn't create the database.
I thought tha it was created automatically by the GRANT command, but in fact
it sets up the user and the privileges but don't create the database.
So only thing left was:
CREATE DATABASE phpbook;
and after that populate it with tables, etc.
- Original Message -
From: "Kevin Donnelly" <[EMAIL PROTECTED]>
To: "josep" <[EMAIL PROTECTED]>
Sent: Tuesday, December 11, 2001 11:27 AM
Subject: Re: PHP+MYSQL: unable to select database
> Hi Josep
>
> > It is a php guestbook (called phpBook) with mysql downloaded from
> > www.netone.a
Try doing this
mysql> use databasename
mysql> select * from tablename;
You haven't selected any database from which to retrieve info.
-Original Message-
From: Carl Troein [mailto:[EMAIL PROTECTED]]
Sent: 11 December 2001 10:26
To: [EMAIL PROTECTED]
Subject: Re: unknown data base
josep
Hello Josep
Your command seems to be wrong in accessing the db
$mysql -u jupshoes -p phpbook
Password:
>
What you actually are doing is trying to access the "jupshoes" database;^)
which infact is your password.
HTH
Norman
-Original Message-
From: josep <[EMAIL PROTECTED]>
To: [EMAIL PR
josep writes:
> mysql>select* from phpbook;
> No data base selected
Hmm.. unless you typed that in rather than copied & pasted,
there's something really odd going on. Anyway, it looks like
you're trying to select stuff from the table phpbook, but
you haven't selected a database yet. Maybe you'r
Bonjour,
I have a table :
[11:09am]> mysqldump -d cotations historique_AMS
# MySQL dump 8.16
#
# Host: localhostDatabase: cotations
#
# Server version3.23.45
#
# Table structure for table 'historique_AMS'
#
CREATE TABLE hist
Thanks Brent,
Yes, I too can import with LOAD DATA and mysqlimport, but the thing that's
irritating is that I have to create the tables first in order to import the
data in either case.
With a 'regular' import from a dumped table, mysql should be able to read
the SQL statements within the dump f
I'm new to mysql, but going on ...
I've set up user jupshoes to the data base phpbook with the GRANT command:
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
ON phpbook.*
TO jupshoes@localhost
IDENTIFIED BY 'jupshoes';
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DRO
63 matches
Mail list logo