Hi!
I believe NuSphere does not distribute MySQL-Max-3.23.
Tergat MySQL Studio contains MySQL-Max-3.23.47. Do you literally need an
'off-the-shelf' product? Tergat is available as a downloadable version for
$66. The physical boxset version is not available yet, I think.
...
http://www.mysqls
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Demirchyan Oganes-AOD098 declared
> Would someone know of off-the-self MySQL product that will contain
latest MySQL server in it? Something like 3.23.46a max-nt and above. I
don't care what it's bundled with, PHP or perl. I just need t
Hi,
It would be time consuming to understand why the server crashed and then
repair the server, as u say it is a mission crtical one , the quickest way
to get it up and running would be to back up the database (copy the ur
database directory completely under the data directory) reinstall MySQL
cle
hello~
When I try to "Using a stack trace" there's no "mysqld.sym.gz" on our
server . Can we always find "mysqld.sym.gz" on any operating system? Our
operating system is Linux 7.0 . I would like to mail you our error log to
see if you can tell us what's wrong with our MySQL which always c
I need some help, this is a mission critical server and it has
CRASHED!
Details:FreeBSD on INTEL, MySQL v3.23.36 (FreeBSD Port)
The server had to be rebooted, and when it came back up, my MySQL
server died. It's been working flawlessly for months (5 or 6), but
all the sudden mysqld will not start
Hi Michael,
On Wed, 2002-02-20 at 13:29, Michael Mitchell wrote:
> We are considering using MySQL in an application involving recording and
> processing analog signal inputs from various electric powerplant
> instrumentation.
Interesting application!
It is always nice to hear where MySQL is bein
hello~
When I try to "Using a stack trace" there's no "mysqld.sym.gz" on our
server . Can we always find "mysqld.sym.gz" on any operating system? Our
operating system is Linux 7.0 . I would like to mail you our error log to
see if you can tell us what's wrong with our MySQL which always crash
Hello,
We are considering using MySQL in an application involving recording and
processing analog signal inputs from various electric powerplant
instrumentation. Some (but not a majority) of these signals will take and
need to record and discrete measurements at a frequency from 360 to 1000 or
s
Hi JC
I know you said stunnel is not an option but how about SSLwrap?
http://www.quiltaholic.com/rickk/sslwrap/
james
At 18:49 19/02/2002 -0800, JC wrote:
>-BEGIN PGP SIGNED MESSAGE-
>Hash: SHA1
>
>Hi All,
>
>Need:
>Communicate securely using PKI from a DBI perl script to MySQL where
>
You did not setting privilege for yourself to use MySQL access. See
something about Security issue in MySQL manual (online or donwload). If
you need the tools to setup MySQL instead of MySQL command prompt try
PHPMyAdmin (web based) or MySQLFront (windows based).
SF
At 16:01 19/2/2002 -0800
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi All,
Need:
Communicate securely using PKI from a DBI perl script to MySQL where
dozens of clients connect from multiple sites around the country
(stunnel is not an option :(
If I issue a grant command like such
GRANT ALL PRIVILEGES ON test.* TO
- Original Message -
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
To: "Tony Wu" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, February 19, 2002 8:38 PM
Subject: Re: would you send me the mysql distribution which can support big5
> On Tue, 19 Feb 2002 12:43:04 +0800
> "Ton
Hi gurus,
Here's my problem:
After installing binary version of mysql on sun, I try
to add a new user and a new database, namely `dbuser' and `mydb', such
that dbuser can access mydb but nothing else.
However I found that if I do not grant dbuser 'select' privilege in
mysql.user, dbuser cannot
>Description:
When I run a ./configure --prefix=/usr/local/mysql --with-libwrap the configure
completes but the make fails.
Making all in sql
make[2]: Entering directory `/usr/local/src/mysql-3.23.49/sql'
Making all in share
make[3]: Entering directory `/usr/local/src/mysql-3.23.49/sql/share'
ma
> somewhat that exceptions aren't thread-safe in egcs. Still, it would be
> worth trying out with gcc 2.95.x or gcc 3.x.
I used 2.95.3 to compile mysql, it is fine, just because it accepts those
flags. I didnot try to switch those flags off and compile.
>
> > I am using orcc to compile mysq
Hi Felix (or anyone),
I'm giving this a go but as a Linux newbie running Red hat 7.2 I have a
question to ask
Do I need to alter anything in Cron for it to run the logrotate script?
What would I need to put into the hourly cron folder to make things happen
more often to check they are work
On Tuesday 19 February 2002 4:56 pm, Peng Zhao wrote:
> Thanks for your reply. But You can find something from
> http://www.mysql.com/doc/I/B/IBM-AIX.html :
Thanks, I hadn't noticed that.
> "If you are using gcc or egcs to compile MySQL, you must use the
> -fno-exceptions flag, as the exception
I seem to have forgotten how to get into MySQL and work.
(It's been a while but I'm starting up again. I get these
errors:
bob@sfpetard:~> mysqladmin create library
mysqladmin: CREATE DATABASE failed; error: 'Access denied
for user: '@localhost' to database 'library''
and:
bob@sfpetard:~> mysq
Thanks for your reply. But You can find something from
http://www.mysql.com/doc/I/B/IBM-AIX.html :
"If you are using gcc or egcs to compile MySQL, you must use the
-fno-exceptions flag, as the exception handling in gcc/egcs is not thread
safe! (This is tested with egcs 1.1.)" And it also says
On Tuesday 19 February 2002 4:31 pm, Peng Zhao wrote:
> Can somebody tell me why these 3 flags must be added when I
> compile mysql from source code? I am trying to use another compiler
I see no reason that these should be required.
-fno-implicit-templates simply requires all templates to be exp
Can somebody tell me why these 3 flags must be added when I
compile mysql from source code? I am trying to use another compiler
instead gcc to compile mysql. But it doesnot accept these three flags.
>From the readme, it seems to me that these flags (especially
-fno-exceptions must be u
Hi Guys
According to documentation from MYSQL the query
Select * from test where test=5 FOR UPDATE
Should lock the row which satisfies the above condition. But this is not
working for me. I tried this query with InnoDB table. Does anybody knows
what could be a possible cause for this.
Rajneesh
Hello everyone,
Would someone know of off-the-self MySQL product that will contain latest MySQL server
in it? Something like 3.23.46a max-nt and above. I don't care what it's bundled
with, PHP or perl. I just need to use the features of MySQL only. The reason I need
it, is for FDA (Food an
Has anyone connected to a mysql database using ASP.NET
If so can you point me in the right direction.
I can't find anything on that
query, Table, SQL
Roger Karnouk
-
Before posting, please check:
http://www.mysql.com/manua
Hi Noel,
On Tue, 2002-02-19 at 13:40, [EMAIL PROTECTED] wrote:
> I'm wondering about row level privilages - being able to restrict what
> people see and can update etc on a row level as well as a column/table
> level.
As others mentioned, having VIEWs wouldn't necessarily be of any help,
since
I am having problems flushing via jdbc. I have already granted the
administrator reload permissions, and I am passing the query "flush
tables;", which seems to work in the command line. I am using MySQL version
3.23.47, mm.mysql-2.0.9, and JDBC 3.0. Has anyone ever had
this type of problem?
-
I am having problems flushing via jdbc. I have already granted the
administrator reload permissions, but maybe I need to do something else. I
am using MySQL version 3.23.47 and I am using JDBC 3.0. Has anyone ever had
this type of problem?
-
>Description:
Followed steps to install binary distribution, including adding mysql user to
group mysql. The user exists. When you run bin/safe_mysqld --user=mysql & or if you
run bin/mysqld --user=mysql & or if you run bin/mysqld --user=#UID & then it gives
this error. No error if y
Thank you all so much for helping me with this query. It works! Best of
all, now I understand how to join tables and such! Thanks again!
- Original Message -
From: "Rick Emery" <[EMAIL PROTECTED]>
To: "'Dean Householder'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, February
After MySQL 3.23.49 was release the other day, I upgraded my server as
usual. After a while I noticed something odd. All datetimes that were
entered into the database after I upgraded the server to 3.23.49 were 5
hours ahead. I am located in Upstate NY, which I think is -5 hours from
GMT. When
Your welcome Alexander!
OK the value for table_cache is 8572 * 3 = 25716 file descriptors,
how big is kern.maxfiles and kern.maxfilesproc? These need to be set
above 26000 to allow all those tables to be opened! I know I have
missed this sometime, or not reset them after a kernel compile.
Also
i compiled it right into apache , it is working but using clear text
passwords. Its 2.20, i found a 3.20 also but it wont compile at all, ive
looked all over the web and noone else seems to have a problem , im at a
loss
here is my .htaccess that works
AuthName "Your Login is Required"
AuthType
You're very close:
mysql> select p1.lname, p1.fname, p2.lname as engaged_lname, p2.fname as
engaged_fname from members p1, members p2 where p1.id = p2.engagedto;
but the REAL question is "What do you want out of the query"?
-Original Message-
From: Dean Householder [mailto:[EMAIL PROTEC
Hopefully someone out there can help me as I haven't been able to find any
documentation on this that applies.
I am running MySQL version 3.22.32 on a FreeBSD v4.4 machine. I am getting
"Error 2013: Lost connection to MySQL server during query" when I run the
following query:
select distinct
Okay, so I do this and all I end up with is
+-+---+-+---+
| id | lname | fname | engagedto |
+-+---+-+---+
| 131 | Hallows | Samuel | 131 |
| 273 | Simmons | Maria | 273 |
| 221 | Papa | Sha
you will have to join the table with itself
and reference it as if it is two tables.
this might be slow however so you might want to make some
specific indexes to speed it up.
This Query will return all the people who are engaged
and a picture of their fiancé:
select p1.lname, p1.fname, p1.pic,
I have two InnoDB tables using a pool of space (the combined size of the
data files may change). I want to limit each to using half the amount
of space (or split it in some manner .. 60%/40%, etc). So far I've done
this with a daemon that runs all the time deleting appropriate rows when
the tabl
On Tue, 19 Feb 2002 13:10:01 -0500, "John Lord" <[EMAIL PROTECTED]> wrote:
>>
>>HAS anyone every used this Module to access mysql before , i have it
>>working with clear text passwords just fine but when i took the
>>encrypted ones from my old .htpasswd file and put them in my mysql table
>>apa
I'm running MySQL on a RedHat 6.2 linux box (kernel 2.2.20).
The MySQL-shared-3.23.49-1.i386.rpm package does not install since
it's compiled using GLIBC 2.2.
I've tried to build binary packages from MySQL-3.23.49-1.src.rpm
as suggested. The compilation fails:
creating libmysqlclient.la
(cd .lib
>From the manual:
In MySQL Version 3.23, you can use the TEMPORARY keyword...
Sorry, mate, you are SOL until you upgrade
-Original Message-
From: Brian Warn [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 12:09 PM
To: 'MySQL List'
Subject: v3.22.32 and temp tables
Hi,
I wan
> select id, lname, fname, pic from database where engagedto=id;
Sorry, mate, that won't work. That will find folks who are engaged to
themselves, i.e., narcissists
-Original Message-
From: Oliver Heinisch [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 11:30 AM
To: [EMAIL
HAS anyone every used this Module to access mysql before , i have it
working with clear text passwords just fine but when i took the
encrypted ones from my old .htpasswd file and put them in my mysql table
apache cant read them
John Lord([EMAIL PROTECTED])
Network Administrator
Studio for Publica
Problem is solved ... customer had his server configured so any new services
being installed were automatically disabled! That is why the service would
not start.
We have installed MySQL on about a dozen Win2K Advanced servers ... this is
the first time we have encountered this issue.
Thank you
do you need to search on it? If not, perhaps storing these files separately
with a pointer storedd in the database. This will improve searching speed I
understand.
-Original Message-
From: Lee [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 10:29 AM
To: MySQL
Subject: approp
assuming that engaedto refers to an id, your query might be:
SELECT a.lname,a.fname,b.engagedto FROM mydata a LEFT JOIN mydata b
ON(a.id=b.engagedto);
-Original Message-
From: Dean Householder [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 11:22 AM
To: [EMAIL PROTECTED]
Subj
At 11:14 -0600 2/19/02, Sterling J. Anderson wrote:
>I am going to be copying some tables from one DB to another and was
>wondering if it is possible to have MySQL output the SQL Create Table
>syntax?
>I know there are products that will do that (ie. MyPHPAdmin) but can
>MySQL do it? I'd rather no
At 19.02.2002 10:22, you wrote:
>I'm fairly new to MySQL, so if anyone could help me I'd really appreciate
>it!
>
>What I'm trying to do is join two pictures in a database to each other. My
>database holds info about people with variables:
>
>id, lname, fname, engagedto, pic
Try this, even if I´
Hi,
I want to build a temp table which I can query to sum values. If I try
"create temporary table tbl_name select some_query_here", then I get an
error that tells me that I have an error with my sql syntax near 'temporary
table tbl_name select some_query_here'. Am I correct in thinking that thi
At 07:49 19/02/2002 -0600, Gerald Jensen wrote:
Hi!
Did you tried to put the datadir variable too in the my.cnf file ?
Anyway, when the service is failing try to start it as console:
mysqld-nt --standalone --console
In this way you should see the messages errors, also you can see them
in the \
I've upgraded a database server from:
2 x pIII 700MHZ 784Mb
to
2 x pIII 1ghz 2gig ecc reg
and have been having some sick database lockups since.
9:10pm up 6:11, 3 users, load average: 167.29, 108.42, 49.33 -
unbelieveable load average.
top shows 137 mysql 'threads?'
CPU0 states:
Mark,
Tuesday, February 19, 2002, 6:31:26 PM, you wrote:
MS> I am relatively new to MySQL I need to edit my db variables.
MS> How is this done ? From the command line or by editing a file?
MS> My OS is Windows.
If you mean mysql options you can set variables by editing
my.cnf(my.ini) file or b
At 10:51 19/02/2002 -0500, Martin Filteau wrote:
Hi,
>Is it possible to port MySql on a Dos Computer ?
Sorry no. You need at least a 32 bit OS.
Regards,
Miguel
>
>Computer : 486DX66
>OS : DR-DOS 7.03
>Ram : 64 Mo
>HD : 1 Go
>
>Martin
>
>-
Take a look at mysqldump
John
On Tuesday 19 February 2002 12:14, Sterling J. Anderson wrote:
> I am going to be copying some tables from one DB to another and was
> wondering if it is possible to have MySQL output the SQL Create Table
> syntax?
> I know there are products that will do that (ie.
»Philip Mak« sagte am 2002-02-19 um 10:25:38 -0500 :
> One thing's been bothering me for a while: When I create a user and
> database in MySQL, the user always ends up with an extra entry with
> host='%' and password=''. How is this happening? This is how I create
> a new database and user:
>
> m
I have a written a Windows client that accesses a MySQL server (Linux)
via the MySQL C API. Stored in the MySQL database are large files
(larger than a Mbyte). The C API makes it very easy for the client to
query and alter the database. However, I have some special needs that
don't appear to be
On Tue, 2002-02-19 at 00:46, Gregory Junker wrote:
> For reasons of the end-arounds you note it really has to be in the
> server. As mentioned views are a possibility, but could end up being
> just as messy as a middle tier. It sounds like what you want is
> integrated (with the OS) security (as i
Again, thanks to all, who helped.
None of your advices gave the desired pair combination >single row preis/
lfd<, but
just looking at the first row, gave the correct answer as I grouped by
preis, lfd. I was irritated by the results, the command-line gave me.
Even as I wanted the quantity of retu
I'm fairly new to MySQL, so if anyone could help me I'd really appreciate
it!
What I'm trying to do is join two pictures in a database to each other. My
database holds info about people with variables:
id, lname, fname, engagedto, pic
The engagedto field contains the id of the person they are
See mysqldump utility, it does exactly what you ask.
Alexander Varshavchick, Metrocom Joint Stock Company
Phone: (812)118-3322, 118-3115(fax)
On Tue, 19 Feb 2002, Sterling J. Anderson wrote:
> Date: Tue, 19 Feb 2002 11:14:11 -0600
> From: Sterling J. Anderson <[EMAIL PROTECTED]>
> To: [EMAIL P
I am going to be copying some tables from one DB to another and was
wondering if it is possible to have MySQL output the SQL Create Table
syntax?
I know there are products that will do that (ie. MyPHPAdmin) but can
MySQL do it? I'd rather not put anything extra on my server. Thanks.
_
I am having trouble convincing my SQL admin at the hosting company that
something is wrong with the server / speed. It is really odd, but in
myPhpAdmin for example, on the left hand side the list of databases
comes
out properly for about 95% of the list, then it starts dumping HTML into
the
fram
Thanks a lot for the advices. The value for table_cache is 8572, and I'm
indeed accessing a lot of tables. So as I gather it the main effect should
be expected from transfering to MySQL 4.0.1 compiled with LINUX_THREADS
and using innodb tables, true? Now what can you say about reliability
issue, a
In this case you have to omit GROUP BY from your query.
Peter
On Tue, 19 Feb 2002, CreaCtion wrote:
> At 19.02.2002 10:20, you wrote:
> >What would you expect the database to return
> Thanks to all so far,
> The query should give the smallest price MIN(preis) and the according "lfd"
> num
Hi,
I wonder if someone could offer me some advice. One of the requirements
for my database is that it must store (in one field) the contents of a
text file (never exceeding 1MB). The data is obviously plain text
format, and is in the following format:
.010 .1083649E+03 .2186
I am relatively new to MySQL I need to edit my db variables.
How is this done ? From the command line or by editing a file?
My OS is Windows.
Thanks
Mark
-
Before posting, please check:
http://www.mysql.com/manual.php
At 19.02.2002 10:20, you wrote:
>What would you expect the database to return
Thanks to all so far,
The query should give the smallest price MIN(preis) and the according "lfd"
number of this record.
so the answer should only be one pair f.e.: 15200,00 | 41 . I think this
should work, as thi
Hi Robert -
The only way I have found to get this sort of stuff (as well as security
info) out is to use mysql_query (or mysql_real_query) and issue the query
just like you would at the mysql client.
Then you can interpret the results that are returned.
I am having to do that with column level
Is it possible to port MySql on a Dos Computer ?
Computer : 486DX66
OS : DR-DOS 7.03
Ram : 64 Mo
HD : 1 Go
Martin
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Is it possible to port MySql on a Dos Computer ?
Computer : 486DX66
OS : DR-DOS 7.03
Ram : 64 Mo
HD : 1 Go
Martin
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
On Monday, February 18, 2002, at 11:26 PM, Benjamin Pflugmann wrote:
> So, if you want to use data from a MySQL database and transfer it via
> XML and the other way around (i.e. XML as an transport layer for
> relational data), I see no particular problem for you to write a
> client that accomp
On Tue, Feb 19, 2002 at 04:39:10PM +0100, Peter Banik wrote:
> you should explicitly specify host/password in the GRANT statement, like
> this:
>
> GRANT ALL ON xxx.* TO user@'localhost' IDENTIFIED BY 'password';
> FLUSH PRIVILEGES;
>
> This way the user will only granted access from the specifi
Philip,
you should explicitly specify host/password in the GRANT statement, like
this:
GRANT ALL ON xxx.* TO user@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
This way the user will only granted access from the specified host, you
don't need to manually INSERT into the user table.
On Tuesday 19 February 2002 00:48, Todd Goldenbaum wrote:
> hi,
>
> I'm wondering if anyone knows if it's possible to do a double-outer join in
> mysql. by that I mean outer-joining on two tables instead of one (both
> from the same original table). in other words, whereas a normal outer join
>
One thing's been bothering me for a while: When I create a user and
database in MySQL, the user always ends up with an extra entry with
host='%' and password=''. How is this happening? This is how I create
a new database and user:
mysql> create database xxx;
Query OK, 1 row affected (0.01 sec)
m
Oliver,
>
> select min(preis),lfd from database where marke='marke'
> and typ not like 'R%'
> and typ not like 'X%'
> and typ not like 'C%'
> group by preis
>
> this doesn´t bring the expected pair "preis / lfd" but all available
> "preis/lfd" grouped ascending.
>
you're grouping by the same
On Tuesday 19 February 2002 10:07, Oliver Heinisch wrote:
What would you expect the database to return
You asked it to GROUP all the records with the same preis, that means it has
to choose a value for each column of the record that is the result of each
grouping, correct? So which of the
Hi Simon,
A couple of things, unless you have compiled WITH_LINUX_THREADS
from the /usr/ports/databases then adding more processors will be
unlikely to help. The native threads lib on FreeBSD runs a threaded
app on 1 processor currently, use the LINUX_THREADS option in the
ports to get aroun
Hi Folks,
now sitting here for 5 hours trying to get these stupid sql-request
running, I decide to ask
the list.
structual information of the database:
database.preis = decimal(12,2),
database.lfd=int(11),
database.typ=varchar(30),
database.marke=varchar(50)
The following requests works
select
If you are on a Windows box, you can create a batch job for it.
If you are on Linux/Unix run a cron job
-Original Message-
From: Che WaiSam [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 8:19 AM
To: [EMAIL PROTECTED]
Subject: Re: About Regular Backup on MySQL
Dear Sir/Ma
At 04:08 2/19/02 +0100, 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:
>
>sql,query
>
>If you just reply to this message, and include the entire te
Hello,
I am trying to install MySQL in Solaris 7. I download this version of Mysql
(mysql-3.23.48-sun-solaris2.7-sparc.tar.gz). After I ran the gunzip and
these instruction
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /usr/local
shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz |
Dear Sir/Madam:
I'd like to know how I can have regular backup in
mysql database that is carried out by the system
itself, instead of typing in the backup command in the
DOS mode everytime.
Thanks for your attention & looking forwards to your
reply.
Regards,
Polly
Hello,
Sergey, thanks for the patch, I applied it for 4.0.1 and seems like
mentioned bug closed.
But I found new bug :)
Strange, but the query WORKS AS EXPECTED without fulltext index!
The results for 4.0.1 with latest fulltext patch applied:
If you need full testcase, please conteact me.
We are trying to install MySQL on a Windows 2000 Server, but are getting
'error 1058' when we try to start the service.
The MySQL version is 3.23.47-nt. The MySQL drive is F:, and c:\my.cnf is:
[mysqld]
port=3306
big-tables
skip-locking
set-variable = key_b
Here is the hardware:
8x U160 SCA IBM UltraStar 36LZX Discovery 4MB cache 1 rpm 18.2GB,
Adaptec 3200S 64MB Cache 32/64 bit PCI RAID U160 SCSI,
FreeBSD says when booting:
ADAPTEC RAID-50 370F Fixed Direct Access SCSI-2 device
Tell me please if any other info is needed.
Alexander Va
What disk drive have you got?
We have found that this can help.
Simon
-Original Message-
From: Varshavchick Alexander [mailto:[EMAIL PROTECTED]]
Sent: 19 February 2002 13:14
To: [EMAIL PROTECTED]
Subject: Mysql performance question
Hi people,
May be anybody can advice from the persona
Hi people,
May be anybody can advice from the personal experience tweeking which
options both in the mysql configuration and server hardware can help in
increasing mysql performance speed? As it is now, mysql is configured to
occupy about 600M RAM, and queries per second avg goes up to about 100,
Anyone here know if there is a limit of the number of query I can do in
a Do While of a VB program ?
---
Pascal Richer
[EMAIL PROTECTED]
Étudiant en Informatique et Génie Logiciel
Université du Québec à Montréal
-
Hi!
On Feb 02, Alexander Belyaev wrote:
> Hello,
>
> I have found a bug( or bad feature? :) ) in 4.0.1
> boolean fulltext search
>
> Please help...
>
> --
> select id,txt from test.logo_text where match(txt) against ('+desig*
> +service' in boolean mode)
> --
> 2 rows i
Søren Neigaard wrote:
>
> HS> To see if there are correct permissions check the db table ind Database
> HS> MySQL - there you find Database specififc persmissions for each user.
>
> Yes in db the homebrew user did not have any permissions, so I change
> them manually, and now it all works. But
Mohamed,
Tuesday, February 19, 2002, 9:50:57 AM, you wrote:
MAESM> mysql> insert into table1 select distinct field1 , MIN(field2) from table2
MAESM> where field2 >="2001-12-01 00:00:00" group by field2 ;
MAESM> mysql> ERROR 1114: The table 'SQLb73d_0' is full
MAESM> please help to fix this erro
sreedhar,
Saturday, February 16, 2002, 7:03:31 AM, you wrote:
s> Hi all,
s> How can i acheive 'Triggers' in MySQL. or equivalent to 'Triggers'.
MySQL doesn't currently support triggers, look at:
http://www.mysql.com/doc/T/O/TODO_sometime.html
http://www.mysql.com/doc/A/N/ANSI_diff_
Mark,
Tuesday, February 19, 2002, 5:34:34 AM, you wrote:
MS> Anyone know what causes "overhead" on a MySQL table?
MS> I wrote a JSP application using MySQL that uses updates and Inserts and have
MS> found that a lot of "overhead" exists.
MS> Of course if the table is optimized - the overhead is
> I'd also love any suggestions/criticisms of the above architecture. I'm
> trying to address what is a potentially significant performance issue for
us
> (we hope to allow the main table to grow to tens to hundreds of millions
of
> rows before pruning it down), but there might be a much simple
I'm curious about what guarantees MySQL (and the SQL standard) provide with
regard to multiple calls to NOW() within the same statement. If the
statement takes a long time to execute, will NOW() be consistent across all
invocations?
The trivial example of this is if you're updating a large set of
guo,
Tuesday, February 19, 2002, 1:49:50 AM, you wrote:
gl> Dear Sir/Madam,
gl> I install mysql on my computer but it did not work. after installing the
gl> rpms, I use gnorpm to verify the installtion, and it's OK. but I couldn't
gl> start my server, after I ran "mysql_install_db" and "safe_mys
>Description:
When i execute the following query on my database:
SELECT retaillastdone_.* FROM retaillastdone_ WHERE
(retaillastdone_.source_="mercury" AND retaillastdone_.timestamp_ BETWEEN
97864920 AND 978735599099) ORDER BY
retaillastdone_.owner_,retaillastdone_.timestamp_ ASC ;
On Tue, Feb 19, 2002 at 09:50:57AM +0200, Mohamed Abd El-Samei Mohamed wrote:
> mysql> insert into table1 select distinct field1 , MIN(field2) from table2
> where field2 >="2001-12-01 00:00:00" group by field2 ;
> ERROR 1114: The table 'SQLb73d_0' is full
> mysql>
>
I've seen this when MySQL use
hello~
When I try to "Using a stack trace" there's no "mysqld.sym.gz" on our
server . Can we always find "mysqld.sym.gz" on any operating system? Our
operating system is Linux 7.0 . I would like to mail you our error log to
see if you can tell us what's wrong with our MySQL which always crash
u
99 matches
Mail list logo
