[EMAIL PROTECTED] writes:
I am intersted in your MySQL GUI. Any specs available ?
Will the software be at a cost ?
Are you looking for distributors ?
I am an independant consultant in France and enthused by free software field.
Yours truly,
Michel Demonfaucon
Ahimsa
Hi!
Paul Schreiber writes:
Sinisa Milivojevic wrote:
cut
Column start is of type TIME. The actual values are illustrated above in
the example.
Paul
Hi!
Then it is not a bug. As our manual clearly points out, date_format
can be used only on date and datetime column types.
Regards,
I use innodb and I want to set autocommit = 0 ( not autocommit ). I can do it on mysql
shell , mysqlfront , on but application that use myODBC I can't . I try to set on
my.cnf but mysqld-max say that don't have this variable to set ?
Thank you
Song
Hello mysql,
After checking the database myisamchk leave in data directory file
with extension tmm. That is it? I can't find in the documentation
nothing about this extension.
--
Best regards,
akul mailto:[EMAIL PROTECTED]
[EMAIL PROTECTED] writes:
Description:
The following line inputs the current UNIX time into a field -
date_start - with the date_stop filed defaulting to '0':
insert into contract_work (sess_id,email,date_start)
values('bde32bfde3ac89c7d510df573bb6bb88','Joe Bloggs',unix_timestamp())
On 18 May 2001 21:50:21 -0300, Siomara Pantarotto wrote:
Does anybody know a good PERL list
Does anybody have a simple example of a PERL code connecting to a MYSQL
database??
I just want the syntax
Use crash-me benchmarks supplied with MySQL as an example of using Perl.
Also check
Hello,
I have just downloaded version 4 of mySQL. Compiled it with ft_min_word_len
= 0.
However, my a query like select * from table_name where match(col)
against('asp')
returns nothing, when a similar like query returns several rows of data.
Also a
query like select * from table_name where
Excuse me if this is a dump question but I'm still new to linux and in need
of some help:
I installed mysql-3.23.38-pc-linux-gnu-i686.tar on a RedHat 7 server and
everything installed fine (or at least I think so). I created a test
database added some tables, etc without any problems. Now, I'm
Hi all,
I create a sample database using foreign keys. However, when I did a mysqldump of the
database, the creation scripts gave no indication of the foreign keys in the first
place!
I am using mysql 3.23.33 on a FreeBSD 4.0-2626-STABLE .
Would very much appreciate some feedback or some
RT-F***ING-M!
No foreign keys in mysql!
- Original Message -
From: Russell Teo Wee Liang [EMAIL PROTECTED]
To: mysql mailing list [EMAIL PROTECTED]
Sent: Saturday, May 19, 2001 8:03 PM
Subject: Foreign Key in creating tables
Hi all,
I create a sample database using foreign keys.
As far as I know mysql-xx-xx-xx-xx-xx-tar.gz comes with both mysqlclient and
mysqladmin, check where those
files are located (locate, find / -name name -print) and check that they are
in your path (/etc/profile for global settings). Then give it one more try or
hit the Doc's :)
Martin östlund
the FM clearly allows the use of a FOREIGN KEY clause in the CREATE TABLE
syntax
(http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#CR
EATE_TABLE). Personally, I don't think its a stretch to assume that
mysqldump would (might || should ) maintain this definition.
After
hallo!
how do i update my mysql-database to a new version?
-simon-
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
Actually it's RTFM
No need to get international !!!
B
- Original Message -
From: Artem Koutchine [EMAIL PROTECTED]
To: Russell Teo Wee Liang [EMAIL PROTECTED]; mysql mailing list
[EMAIL PROTECTED]
Sent: Saturday, May 19, 2001 5:20 PM
Subject: Re: Foreign Key in creating tables
it seems like my question has sparked some obscenities sacriligeous to this
mailing list. I implore those who intend to invoke RTFM again to stop as I
have already received my answer thru a kinder source.
To those who still intend to do so, here is something for you: GSMD
To the rest of you, my
the Foreign Key syntax is only for compatabilty with other DB syntax. it doesn't do
anything.
check out -
http://www.mysql.com/documentation/mysql/bychapter/manual_Compatibility.html#Missing_Foreign_Keys
some people need to reclaim the 5 seconds of their life they use to send useless
This depends on the method of install (tar ball source, RPM, etc) and
the distro you are running. Please provide a bit more information so
that we may assist you by giving you the appropriate response.
HTH
simon joas, vorstand/ceo: sjn AG wrote:
hallo!
how do i update my mysql-database to
I wish we maintained some ethics in writing. Knowledge shouldn't make us
arrogant.
RT-F***ING-M!
No foreign keys in mysql!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I'm converting an Access db to mySQL, and Access allows users to Insert
Records into a table AND call them as well in the FROM clause. This is
illeagal in ANSI SQL however and therefore illeagal in mySQL, but I don't
know really how to get around it. How can I insert only new records that
aren't
My appoligies. I probably was pissed off by the bunch of
newbie questions i got today. I'll try to not replay next time I
see something like that.
Anyhow, i wonder, how hard could it be to open your
favorite viewer/editor, load the manual in txt format in it
and look for 'foreign' keyword? Or
seems like he hasn't read the question properly, check out this answer that
I got, which is what I needed:
the FM clearly allows the use of a FOREIGN KEY clause in the CREATE TABLE
syntax
(http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#CR
EATE_TABLE).
Personally, I
To infer without actual proof or evidence is not of a scientist's ways. How
can u ever be sure? Unless you have experience.
- Original Message -
From: Artem Koutchine [EMAIL PROTECTED]
To: Russell Teo Wee Liang [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, May 20, 2001 1:51 AM
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Mysqld-max does not read my.ini config file
Description:
While i was using mysqld-opt my.ini file was working properly.
I am using c:\windows\my.ini file. in file i specified mysql work path.
It was working with
Oh those evil doc writer which want us all to remain ignorant
of the most brilliant features in the documented software
product. They write docs only for the purpose to mislead us all
and waste our time by providing us with cut-featured and
fuzzy docs.
Ok, jokes over. Let's work.
-
On Sat, May 19, 2001 at 10:01:38PM +0400, Artem Koutchine wrote:
Oh those evil doc writer which want us all to remain ignorant
of the most brilliant features in the documented software
product. They write docs only for the purpose to mislead us all
and waste our time by providing us with
I have 10 or so MySQL servers in the field, all writing data to a database
of the same name. I would like to set up replication from all masters back
to a single slave server and have each master write to a different database.
Is there an easy way to do this, short of running multiple instances
Hi,
I have been running an old version of the mySQL-nt server on my Windows 2000 box for
some time now. It was installed on C:\ , as suggested in the install instructions.
Now, I have a new disk, and so want to put the server on a partition, G:\ . After
removing the service - I tried to
James Cox wrote:
Hi,
I have been running an old version of the mySQL-nt server on my Windows 2000 box for
some time now. It was installed on C:\ , as suggested in the install instructions.
Now, I have a new disk, and so want to put the server on a partition, G:\ . After
removing the
Hi,
Assuming I have a INT type column named numeropost, is this faster to write a query
with WHERE numeropost=12 instead of WHERE numeropost='12', or is this exactly the
same speed ?
Thanks !
Jocelyn Fournier
Presence-PC
www.presence-pc.com
Hi,
I wonder how the optimizer works.
Here is what I obtain with two of my queries :
mysql EXPLAIN SELECT
titre,forumconthardwarefr7.numeropost,auteur,forumconthardwarefr7.icone,nbrep,maxnumrep,forumconthardwarefr7.date,vue,ouvert,lastauteur
FROM forumconthardwarefr7,threadhardwarefr7 WHERE
In order to save space in our database, we designed our tables to use
enumerated datatypes. For one column, we have about 2,800
different values,
each of which is about 30-40 text characters long. Now, all the MySQL
documentation I have read states that the limit for the number
I am trying to move my database (the directory) to another location, but
the symbolic link option described in the documentation isn't working for
me. I'm using the binary distribution of version 3.23.37.
I created a text file in the c:\mysql\data directory, called mydb.sym, with
the string
On Sat, 19 May 2001, Dave Carter wrote:
I'm converting an Access db to mySQL, and Access allows users to Insert
Records into a table AND call them as well in the FROM clause. This is
illeagal in ANSI SQL however and therefore illeagal in mySQL, but I don't
know really how to get around it.
On 19-May-01 Dave Carter wrote:
I'm converting an Access db to mySQL, and Access allows users to Insert
Records into a table AND call them as well in the FROM clause. This is
illeagal in ANSI SQL however and therefore illeagal in mySQL, but I don't
know really how to get around it. How can I
http://www.mysql.com/doc/F/u/Fulltext_Search.html
Search for the word MySQL produces no results in the above example. Word
MySQL is present in more than half of rows, and as such, is effectively
treated as a stopword (that is, with semantical value zero). It is, really,
the desired behavior - a
OK, let's say you've got the case where you construct an INSERT
statement to put a new entry into an existing table. But the
formatting is wrong (you're short one field in the entry).
What's the code in perl to catch that problem, assuming you've been using
perl to construct the string and
Hi!
I installed mysql 3.23 a while ago and all was well. Recently there was
some activity on my Windows ME computer, in which someone uninstalled mysql
and then tried putting it back and then (just for good measure. . .) managed
to get into privileges and eliminate localhost (or so it appears)
Regarding my previous message please ignore -- somehow I've gotten myself
back on track and MySql is allowing me access to my databases. Sorry for
the superfluous message!
-martin
-
Before posting, please check:
At 7:54 PM -0700 5/19/01, Cindy wrote:
OK, let's say you've got the case where you construct an INSERT
statement to put a new entry into an existing table. But the
formatting is wrong (you're short one field in the entry).
What's the code in perl to catch that problem, assuming you've been
I used the export script for MSAcess and got my text file, ya , there are
three
tables in it.
I have used LOAD DATA to import small single table info but how do I import
ones with more tables properly. Do I create the tables first or how do I
past into the monitor program.
Using Windows version.
40 matches
Mail list logo