On Sun, Mar 25, 2001 at 09:52:22PM -0800, Arne Claassen wrote:
>
> I've got a reproducable signal 11 death in mysqld using Innobase
> tables and range queries (at least reproducable on my machine,
> Redhat 6.2, mysql 3.23.35).
>
> Here's how it manifests itself: Create a table with at least 32
>
I've got a reproducable signal 11 death in mysqld using Innobase tables and
range queries (at least reproducable on my machine, Redhat 6.2, mysql
3.23.35).
Here's how it manifests itself: Create a table with at least 32 columns.
Then load a row or two into the table and try to do any query using
On Sun, Mar 25, 2001 at 10:47:41PM -0700, Michael Blood wrote:
>
> Is it possible to set a function as a default value for a column at
> all. I apologize if I come off a bit dumb about this but I come
> from an MSSQL background where you can set a default to a function.
You cannot.
--
Jeremy D.
Is it possible to set a function as a default value for a column at all.
I apologize if I come off a bit dumb about this but I come from an MSSQL
background where you can set a default to a function.
Thanks Again
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Sunday,
If you go through the rules wizard in outlook 2000, you should be able to see the to
or cc option, I was. If you need a screen shot, email me personally and I can send you
the images.
- Original Message -
From: Yiannis Manatos
To: 'David Brieck' ; 'Rolf Hopkins' ; [EMAIL PROTECTE
I posted that msg because I still cannot find any
"Where the To or CC line contains .." rule expr,
at Outlook 2000.
I had only a "Where the To line contains .." available.
Anyway, I will try to find an alternative.
Thank you both
-Original Message-
From: David Brieck [mail
We have had this discussion once before. There is no way to police it. It
is a matter of learning how use your e-mails filtering system properly.
- Original Message -
From: "Yiannis Manatos" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 26, 2001 11:32
Subject: Usage o
Hi guru type folks,
My system crashed over the weekend and I had to reinstall linux. I'm
currently running Mandrake 7.2. Now that I'm up and running again I find
that the output from a mysql query is not formatted properly. The tables
look as though they are wrapping round so that data does not
Just use this type of filter for outlook express
Apply this rule after the message arrives
Where the To or CC line contains '[EMAIL PROTECTED]'
Move it to the General folder
- Original Message -
From: Yiannis Manatos
To: [EMAIL PROTECTED]
Sent: Sunday, March 25, 2001 10:32
Hi,
I have 5 tables in mysql, each of same structure.
When some search word is given, I am creating 5 threads
to search in 5 tables. Now i need to order the search
results in the most suitable order.
For example, for a search word, the results from table 3
will be more suitable, where
I suggest everybody to put the '[EMAIL PROTECTED]' list's address to
the "TO" email field instead of the "CC" field, when posting messages to
this list.
This would allow several email clients (like Microsoft Outlook) to filter
better
the incoming messages and categorize them to specific folders
>Description:
The documentation says that I can do:
select * from table order by rand() limit 10
as an example, however it fails and there is no error message.
I *can* do:
select * from table order by rand()
which works fine. It just seems that adding the limit clause causes
something to break.
>
On Sunday 25 March 2001 16:27, you wrote:
> Found the problem with your signal 11 with strange traces from inside
> LinuxThreads. This was a hard concurrency bug - the problem was that a
> memory reference passed to pthread_create was getting invalidated by the
> thread that pthread_create was lau
Hi!
On Mar 25, Ovanes Manucharyan wrote:
> Hello,
>
> I am trying to search for 2 words which are close to each other..
> In fact, its a name so it should either occur as John, Doe or John Doe
> in my fulltext index.. (this particular table is full of emails)
>
> select id,message_subject from
Ðåãèñòðàöèÿ â 30 Ðîññèéñêèõ ïîèñêîâûõ ñèñòåìàõ è êàòàëîãàõ - 30$.
Ðåãèñòðàöèÿ â 20 ìåæäóíàðîäíûõ ïîèñêîâûõ ñèñòåìàõ è êàòàëîãàõ - 20$.
Ðåãèñòðàöèÿ ñàéòà â ïîèñêîâûõ ñèñòåìàõ Rambler.ru, Yandex.ru
ñ ïîÿâëåíèåì Âàøåãî ñàéòà íà ïåðâîé ñòðàíèöå çàïðîñà ïî Âàøèì êëþ÷åâûì
ñëîâàì - äîãîâîðíàÿ.
--
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 26, 2001 8:29
Subject: New MySQL install Help Please
> New MySQL install Help Please
>
> Is there a MySQL UseNet news group or User to User Forum anywhere?
This mailing list is it.
>
> Just inst
New MySQL install Help Please
Is there a MySQL UseNet news group or User to User Forum anywhere?
Just installed latest MySQL and tried to then install the latest MySQL ODBC
Following the main install I was surprised I didn't find any icons on my
desktop or in my Windows Start Programs listing,
BlankI don't think you can do that with a default value. You will need to
include the current date in your insert statement.
Cal
http://www.calevans.com
-Original Message-
From: Michael Blood [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 25, 2001 5:30 PM
To: MYSQL
Subject: De
Gotta say that this is a bad reason to choose one product vs.
another... because it lacks a GUI to build queries? Undertanding SQL
is all well and good, but I can tell you that I would give anything to
have a query builder that works like the one for MS SQL server. You may
enjoy writing incredibl
Title: Blank
I am trying to set the default value in a
date field to be the time that it was created
However I do not want the field to be a
timestamp because I want to update it to a different value later.
I have looked through the mysql
documentation and I can not seem to find anywhere t
Hi!
> "Heikki" == Heikki Tuuri <[EMAIL PROTECTED]> writes:
Heikki> Monty and Alex,
Heikki> maybe Monty discovered the source of the problem: Innobase indeed
Heikki> modifies the sigmask of the thread which does the database intialization.
Heikki> Maybe other threads then inherit the modifie
I am a college student trying to implement MySql with perl 5.6 on Windows 95.
My problem is I have not been able to find a suitable site to download the
DBI module from.
I am very wary of downloading any module which requires me to use a make
command (in what ever manifestation) and would pre
On Sun, Mar 25, 2001 at 12:56:15PM -0800, john lin wrote:
> I am a senior in Polytechnic University working on my
> senior project. I have chosen MySQL to be database in
> Red Hat linux 7.0. I writing a program to insert a
> value into the database in c language. The data
> changes so i have to
On Sun, 25 Mar 2001 12:56:15 -0800 (PST), john lin <[EMAIL PROTECTED]> wrote:
John,
I'm not a 'C' programmer, but I think you need to enclose your VALUE with single
quotes for a literal value: VALUES('test')
Atleast in Perl, it' done that way.
>>I am a senior in Polytechnic University work
I am a senior in Polytechnic University working on my
senior project. I have chosen MySQL to be database in
Red Hat linux 7.0. I writing a program to insert a
value into the database in c language. The data
changes so i have to insert the data as a variable,
but the database reports a error say
Hello,
I made a dump of a database, and I've got problrms when I try to insert it.
Mysql sop when there is such string as "L\'administrateur". It seems it does'nt
like the "'". Is there a special caracter to fix this.
Thank you,
--
Laurent Rathle
---
Hello,
I am trying to search for 2 words which are close to each other..
In fact, its a name so it should either occur as John, Doe or John Doe
in my fulltext index.. (this particular table is full of emails)
select id,message_subject from email WHERE
MATCH(message_body,message_subject) against
On Sun, Mar 25, 2001 at 10:21:04AM -0700, Brendin wrote:
>
> Lets say you have to mysql servers one is going to be a master and
> one a replication slave. The master is a very fast dual CPU machine
> with a SCSI raid array. The Slave is a fast single cpu machine with
> a 7200RPM UDMA 100 hard d
Hi...
I am new to MySql and I have a couple of questions.
First, I am assuming that one needs root priviledge to install the DB
Server on Solaris for example.
Second, I looked at the manual and searched for any recommendations
about the machine requirements for running the DBServer but couldn't
Lets say you have to mysql servers one is going to be a master and one a
replication slave. The master is a very fast dual CPU machine with a SCSI
raid array. The Slave is a fast single cpu machine with a 7200RPM UDMA 100
hard drive. The slaves purpose is to act as a backup for the master.
Wi
Hi!
I have completed the writing of the new Innobase manual. It will
also appear as a section in the MySQL manual.
Best regards,
Heikki Tuuri
Innobase Oy
-
Before posting, please check:
http://www.mysql.com/manual.php (t
Why is the table of columns off by 1 ?
The registration seems to bypass the privileges column.
Thanks
~~~jci~~~
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi
Since nobody at MySQL had a hand on the development of the Control Panel we
do not know. You should take this up with your hosting service.
At 13:48 25/03/2001 +, Jamal wrote:
>Hi,
>We are going to buy a cobalt req i4 server as a dedicated hosting server.
>It has MySQL software and a con
w. Terry Lincoln writes:
> I cannot get F1 to show any help on the main display. I cannot even
> determine why it does not. I have the help_file set in every variation
> of .cnf .ini and .opt file I can find. No luck.
>
> What is correct way to get help to be useable?
>
> TIA,
>
> W
I cannot get F1 to show any help on the main display. I cannot even
determine why it does not. I have the help_file set in every variation
of .cnf .ini and .opt file I can find. No luck.
What is correct way to get help to be useable?
TIA,
W. Terry Lincoln
Senior Engineer/Consultant
100 Court
Thanks,
this worked like a charm. Also on the 3.23.25
(declared stable) release. now i have another
problem: when is start the safe-mysqld i cannot
shut it down anymore.
#> mysqladmin -u root -p shutdown
or
#> safe-mysqld --log &
just do nothing and the terminal doesn't do
anything
Aidan McGuinness writes:
> Hello,
>
> I've encountered a problem with MySQL GUI 1.7.4.-1. I'm not quite sure what
> triggers the error - whenever its open Ive had a MySQL server (3.22)
> running, as well as Java Forte Editor (v2.0) and Internet Explorer (v5.5).
> The problem is fairly nasty
Monty and Alex,
maybe Monty discovered the source of the problem: Innobase indeed
modifies the sigmask of the thread which does the database intialization.
Maybe other threads then inherit the modified sigmask.
I had disabled the use of native Unix aio from Innobase, but forgot
the following seg
Hi,
We are going to buy a cobalt req i4 server as a dedicated hosting server. It has MySQL
software and a control panel. Do you know if this control panel can manage the MySQL
or not (For creating and removing DBs and tables not more)?
Thanks for your help.
J. Joubarani
--
On Fri, Mar 23, 2001 at 10:45:00AM -0800, Bryan Coon wrote:
> I have two machines which I am trying to set up replication on. I followed
> the howto as describe in the manual, and everything seemed to be okay (i.e.
> no errors), but it simply doesn't work.
>
> Heres what I did on the master:
> 1
test
-
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 PR
Feuere Deinen Boss !
Warum immer wieder für andere arbeiten,
wenn Sie DM 2.000,- pro Woche
für sich selbst haben können !
Weitere Informationen nur unter:
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mys
42 matches
Mail list logo
