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.
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
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:
http://ww
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)
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 then
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 n
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 ca
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
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 c:
> > > 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 fo
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
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
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
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 reinst
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
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 c
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.
- Original
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 mysqld-o
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
Let me quote from that link:
"The FOREIGN KEY, CHECK, and REFERENCES clauses don't actually do
anything. The syntax for them is provided only for compatibility, to
make it easier to port code from other SQL servers and to run
applications that create tables with references. See section 5.4
Functio
Hi!
It;s been a while since i used Access, so i can't remember exactly
what you mean. But for what you've said you probably have three
choises:
1) Create a primary key, try to insert a record with already
existing
key and fail. Failure means that record already exists. Nothing
special.
2)
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 don
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 jus
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 a
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)
http://lis
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-databa
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
unhelpfu
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
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
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 thre
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
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 -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
Steve
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 key
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
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 t
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 match
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 c
[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_timest
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]
-
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
Paul Schreiber writes:
> Sinisa Milivojevic wrote:
>
> 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,
stan gruszka writes:
> Hi
>
> I am attempting to run the compiled version of mysqlgui on RedHat 7.0
> The mysql.sock socket is located in /var/lib/mysql/mysql.sock on RedHat 7.0
> Whereis is mysqlgui trying to locate the socket.
>
> Thanks
>
> Stan
>
> --
> Stan Gruszka
> System Administrator
[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,
Do you have an index on metro_name in the usa_metro_ref table ?
Jocelyn Fournier
Presence-PC
www.presence-pc.com
- Original Message -
From: "S A" <[EMAIL PROTECTED]>
To: "List MySQL" <[EMAIL PROTECTED]>
Sent: Saturday, May 19, 2001 4:58 AM
Subject: ORDER BY slow down, bug ?
>
> I
44 matches
Mail list logo
