regardless.
Thank you and have a great day!
Chris Stevenson
Hi, I'm trying to find a way to find the primary keys in a table and find
constraints on a table by sql. I would like to later issue these sql
statements through jdbc. hows this done in mysql?
Regards,
Sunil.
_
Lose those love
I'm working through a self study book and I am trying to learn how to do
a load data local infile. I downloaded a sample database and I have
the txt file but each time I type in the command LOAD DATA LOCAL INFILE
'member.txt' INTO TABLE member; I get the following message ERROR: File
'member.txt'
`
GROUP BY mycat;
then
SELECT myval, myotherrows, mycat
FROM `mytemptable`
LEFT JOIN mytest USING(myindex,mycat)
note: I haven't tested the above code, it's just an example of the theory
Chris
-Original Message-
From: Noah Spurrier [mailto:[EMAIL PROTECTED]
Sent: Wednesday
, it may not work as is.
SQL is really *meant* to have sub-queries, so the temp table solution is
just a work around until sub-queries make it into the production version of
MySQL. At least, that's how I understand it anyway.
Chris
-Original Message-
From: Noah Spurrier [mailto:[EMAIL
This is a PHP question, not MySQL.
http://www.php.net/mysql_data_seek
-Original Message-
From: Scott Swaim [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 21, 2004 2:47 PM
To: Mysql
Subject: re-using a results set
I have a form that does the following
? while
4.0.18 is the latest 4.0.x release.
4.0.3 4.0.9 4.0.10 4.0.18
4.0.3 != 4.0.30
-Original Message-
From: Lou Olsten [mailto:[EMAIL PROTECTED]
Sent: Monday, April 19, 2004 1:44 PM
To: [EMAIL PROTECTED]
Subject: Getting an older version of MySQL
Hi,
I'm currently running some
about integers, that's not all that hard, and far from black magic. But
I digress :)
Chris W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The answers are wide and varied:
* History - MySQL has been an open source product for longer
* Flexibility - MySQL's different table types are ideal for some situations
* Performance - MySQL is the fastest database on the planet for most tasks
* Support - There are massive amounts of software
GROUP_CONCAT() is in 4.1. :-)
Oh, so close yet so far. We're running 4.0.14 and my company has
no plans on upgrading in the near future. *sigh*
Thanks for the info, however!!
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
:
+--+---+
| name | attribute |
+--+---+
| Book | Thick |
| Book | Tall |
| Book | Green |
| Game | Narrow|
| Game | Yellow|
+--+---+
So my question, is it even possible to do what I'd like to do?
thnx,
Chris
--
MySQL General Mailing List
For list archives
to
how the data transfer itself works. It's rather annoying.
-Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, it says
nothing about whether or not the request thread tells the master to or
not to send certain tables/databases. I can't find anything related
anywhere sle in the replication documentation section about this,
either.
-Chris
--
MySQL General Mailing List
For list archives: http
-table or replicate-do-table), but those don't seem to
prevent the data from being sent to the slave, only whether or not the
slave decides to use it.
Thanks,
-Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hi Guys,
Iv got a script that iv been working on written in perl which interfaces to
mysql via the dbi module..
The script only does two selects within the entire script, so I didn't think
it would be too taxing on the machine.
Turns out that when the script is executed around 100 times a
In 4+ you can use SQL_CALC_FOUND_ROWS flag
http://www.mysql.com/doc/en/SELECT.html
-Original Message-
From: Steffan A. Cline [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 28, 2004 8:47 AM
To: MySql
Subject: Getting count(*) with LIMIT in SQL
I have been tinkering with finding the
that and see if anything improves,
but in the meantime, if anyone has any advice, please share :)
Thanks,
--
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Wed, Mar 24, 2004 at 01:23:53PM +, Chris Elsworth wrote:
I'm wondering if specifying LOW_PRIORITY disables concurrent inserts
explicitly, so I'll try removing that and see if anything improves,
but in the meantime, if anyone has any advice, please share :)
Ignore that bit. Found
Victor Medina wrote:
Hi!
On Wed, 2004-03-24 at 09:51, Yonah Russ wrote:
Hi,
I'm trying to compile mysql 4.0.18 with icc 8.0 on RH AS 3u1. I'm
8
GUAO! nice!, let us know how faster it is with the Intel compiler, just
curious! =)
An ad in one of the Linux magazines I leaf through on
I don't think he wants to return a Value of 'Tuesday', he wants to return
the value of the column NAMED Tuesday.
So instead of
SELECT Tuesday FROM inventoryRoom WHERE inventoryid='1';
He's trying to specify the Tuesday column with DAYNAME('2004-03-23');
I have no idea if that's possible.
and good and I'm fairly sure it'll all work, but
another interesting idea I was wondering over was - can I myisampack
the tables that I know won't be updated anymore, and still MERGE them,
with other unpacked-tables?
Sorry, this got a bit long and rambly :)
--
Chris
--
MySQL General Mailing List
On Mon, Mar 22, 2004 at 01:40:29PM -0600, Dan Nelson wrote:
In the last episode (Mar 22), Chris Elsworth said:
Now that's all well and good and I'm fairly sure it'll all work, but
another interesting idea I was wondering over was - can I myisampack
the tables that I know won't be updated
All you need to do is :
SELECT LAST_INSERT_ID();
The way it's written, you are doing the LAST_INSERT_ID() function call a
number to times equal to the amount of rows in arp3_cam
-Original Message-
From: Anderson [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 21, 2004 6:37 PM
To: [EMAIL
Lo everyone,
I'm *baffled* completely I've never seen something like this before.
: I tried this exact query from PHP, Perl, as well as the MySQL
thingy... They ALL give the same result - it must therefore be my table
mysql SELECT VERSION();
++
| VERSION() |
... That's what copy and pasting
code to save time does for you
--
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MyISAM out for heavy workloads. Many places have moved to InnoDB due to
concurrency issues of that type.
In summary, test test test!
Regards,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
is that you'll just need to tell
all of your applications and things that your computer is the database
server, by specifying localhost as the database server.
Chris
[EMAIL PROTECTED] wrote:
I wish to learn MySQL on my Linux box [SuSE 8.1]
Can I install MySQL on my hard drive and use it for learning
Lorderon wrote:
Chris Nolan [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Which version of MySQL?? The difference will be different (!!) depending
on the version in use.
In general, full text search uses a tree-structure. Doubling the number
of entries in the tree is likely
will be different (!!) depending
on the version in use.
In general, full text search uses a tree-structure. Doubling the number
of entries in the tree is likely to result in a time difference of not
very much at all!
Best regards,
Chris
--
MySQL General Mailing List
For list archives: http
Hola,
I made 4 changes and it worked. changed 3306 and mysql.sock for both client
and server, now it works fine. Those two options killed so much of my time.
I followed the instructions line by line and there was never any mention of
changing the default my.cnf file.
Gracias,
Chris
get this when i run scripts/mysql_install_db. also tried mysqld --skip-grant
and got the same thing. how do i fix?
mysql-standard-4.0.18-sun-solaris2.8-sparc binary on SunOS ipdev1 5.8
Generic_108528-06 sun4u sparc SUNW,Ultra-5_10.
[EMAIL PROTECTED]:/usr/local/mysql
$ scripts/mysql_install_db
)
- speedlink.MYD is 12GB, speedlink.MYI is 24GB
Some info on the server
- Quad Xeon 900MHz
- 4GB RAM
- DB is storage on an EMC Symmetrix storage system (fibre channel SAN)
Any/all assistance is appreciated.
Thanks.
Chris.
Why does it only use the one index?
Chris.
-Original Message-
From: Richard Davey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 09, 2004 11:00 AM
To: [EMAIL PROTECTED]
Subject: Re: Optimizing Queries
Hello Chris,
Tuesday, March 9, 2004, 4:38:00 PM, you wrote:
CF I'm trying
Rich,
Thanks for the email. I created a multi-field index using the fields that
are in the query and the query only took 0.91 seconds. That's better than 9
minutes and definitely under 30 seconds.
Thanks.
Chris.
-Original Message-
From: Richard Davey [mailto:[EMAIL PROTECTED]
Sent
Sasha Pachev wrote:
Cliff wrote:
The query is running dramatically slower than the MyISAM query,
sometimes
even causing mysql to freeze for a while. I searched this list and
found a
few people saying that on FreeBSD mysql should be compiled using linux
pthreads if you are using InnoDB or else
I want a list of table1.id not included in Table2 but i don't find the
solution!
I _*think*_ this will work for you. If I'm wrong, I'm sure someone
will come behind and correct me:
select table1.id from table1 left outer join table2 on table1.id = table2.id
where table2.id = NULL;
Chris
select table1.id from table1 left outer join table2 on table1.id =
table2.id
where table2.id = NULL;
Sorry, that last should be
where table2.id IS NULL;
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
It seems that each time we select into an OUTFILE that already exists
(re-use a name) the server crashes.
Anyone have any ideas if this is a setting or just a bug?
Thanks.
Chris.
If there's a bug in the optimiser, you'll find it's in the higher
levels of the codebase. InnoDB doesn't have any SQL optimisation code
in it, so any bugs in this area aren't in InnoDB.
Regards,
Chris
Dyego Souza Dantas Leal wrote:
The script of database are uploaded to:
support.mysql.com
tool style).
Anyone have any comments regarding the optimiser improvements in MySQL 5?
Regards,
Chris
Martijn Tonies wrote:
Hi,
I was wondering if there's a neat way to get the explain output
in a tree-like structure so it can be visualized in an easy way.
Is it possible to get it into a tree
I have a query that is admittedly inefficient in that it is doing
multiple OR clauses and joining multiple tables. However, the query
runs at an acceptable speed if I am in a terminal session and run the
query directly in the terminal. On the other hand, when PHP performs
the same query for
like CREATE VIEW in the least...
thnx,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I don't like your chances of successfully doing this. You could try
pulling the changesets out of the bitkeeper repository by hand but the
fact that 4.1.X was branched from an earlier version of the 4.0.x series
(I think), it might be a bit of a strugle.
Anyways, good luck! :-)
Regards,
Chris
that's been done, replication starts
working again, but after a few days I find some queries aren't updating any more and I
have to keep going back and manually intervening, but that's another story :)
Cheers,
Chris
'
AND p1a.first is not null
AND p1a.last is not null
AND a3.address is not null
AND ( a1.number_of_units='0003'
OR h1.dwelling_type='A' )
AND h1.home_property_indicator '2';
Any and all help is appreciated.
Thanks.
Chris.
23, 2004 11:42 AM
To: Chris Fossenier; [EMAIL PROTECTED]
Subject: Re: MySQL versus MS SQL
Hi Chris,
Chris Fossenier wrote:
This is a long post, my apologies.
Speaking for myself, I found the detail most helpful. Thanks!
See response at bottom.
...snip...
QUERY1
~~~
Indexed Fields
On Sat, 2004-02-21 at 20:39, Franz, Fa. PostDirekt MA wrote:
Hi,
this discussion is useless, object or procedure is not realy the question.
You need to know how to build a good programm, if you cannot create a good programm,
no matter what language.
Originally, I was asking Heikki's opinion
What is the best way to deal with white space in a mysql database?
What I'm talking about is trailing spaces in larger fields. We receive data
in fixed width format, so when you import it, you get a bunch of trailing
white spaces that take up space. Multiply these white spaces by 120million
see if this modification works for all 120million. So far it worked
for a 6mill sample.
Thanks.
Chris.
-Original Message-
From: Donny Simonton [mailto:[EMAIL PROTECTED]
Sent: Friday, February 20, 2004 3:04 PM
To: 'Dan Nelson'; 'Chris Fossenier'
Cc: [EMAIL PROTECTED]
Subject: RE: White
Sasha Pachev wrote:
C versus object-oriented lanuguages like C++/Java is a topic I have
discussed a lot with programmers. I believe that traditional procedural
approaches and languages, like C, are the best for 'systems
programming', by
which I mean implementing anything with complex data
Sasha Pachev wrote:
Jochem van Dieten wrote:
Sasha Pachev wrote:
Heikki Tuuri wrote:
C versus object-oriented lanuguages like C++/Java is a topic I have
discussed a lot with programmers. I believe that traditional
procedural
approaches and languages, like C, are the best for 'systems
Hmm...if there's lots of thrashing, it might be to do with
fragmentation. Have you tried running OPTIMIZE TABLE on the table in
question?
Does anyone on the list have anything to say about putting the MYD and
MYI files on seperate disks or using RAID MyISAM tables??
Regards,
Chris
Eric B
Can you send us the CREATE TABLE statement for this troublesome table?
Regards,
Chris
Eric B. wrote:
Sorry - forgot to mention it. I've already tried both an OPTIMIZE TABLE and
ANALYZE TABLE to try to improve performance, but with no result.
Any other ideas?
Thanks,
Eric
Chris Nolan [EMAIL
and stored procedure versions would
have basically identical performance regardless of the form used though.
Regards,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
. DELETE does specifically delete rows one by one, so actually
DROPing the table and reCREATE-ing it will be faster.
Regards,
Chris
At 03:21 PM 2/19/04, Jeff McKeon wrote:
Quick question...
What you drop a table are the indexes for that table dropped to?
I'm about to write a script to take
WHERE id 0;
Is pretty quick if id is indexed (or a PRIMARY KEY). I use the above
query to get a count of rows on an InnoDB table when my PRIMARY KEY is
an AUTO_INCREMENT column.
Regards,
Chris
[EMAIL PROTECTED] wrote:
I think count(*) is a special case: MyISAM holds a record count which
is to be seen by each currently running transaction.
Cheers,
Craig Robinson.
Regards,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.
I'm guessing it's probably not that simple. Any insight into this from
someone with experience would be appreciated.
Thanks.
Chris
workloads, MyISAM will be faster as it doesn't need to worry about
rolling things back or having multiple updates from different
connections to keep track of the state of to any large degree.
Regards,
Chris
Simon
- Original Message -
From: Ji Matjka [EMAIL PROTECTED]
To: [EMAIL
on the internet! :-)
Regards,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Sure! Just remember that your slave will have to be able to keep up with
all the UPDATE, INSERT and DELETE statements issued on the master servers.
Regards,
Chris
[EMAIL PROTECTED] wrote:
That looks like a good solution...
Do you know if i can replicate multiple databases from diferent
Hi!
You'll want to look through the MySQL C API docs. There are specific
calls for allocating certain structures that MySQL client software
should use (and routines for deallocating it as well).
Regards,
Chris
Sp.Raja wrote:
Hi List,
I want to use some other memory allocator routine other
!
Regards,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Server end? As in, writing code that will integrate with the MySQL
Server process? Or are you building UDFs?
Regards,
Chris
Sp.Raja wrote:
Thanks for your input. I'm trying to do is at the server end(mysqld), could you get some pointers?
Regards,
Sp.Raja
Original Message
I am currently building will also
contribute to both the commercial software world and the open source
community. The fact that you've achieved this with such success and that
you post to the MySQL mailing list so often is why I ask you these
questions.
Regards,
Chris
On Sat, 2004-02-14 at 08:13
Hi!
Next-key locking essentially doesn't work on rows - it works on indexes.
It ensures that phantom reads can't happen.
InnoDB does indeed do row-locking. In fact, it has one of the most
efficient representations of locks of any relational database.
Regards,
Chris
On Mon, 2004-02-16 at 23:43
this helps!
Regards,
Chris
On Tue, 2004-02-17 at 00:05, Andreas Pardeike wrote:
Hi List,
Can someone explain the results below? It seems that MySQL has a hard
time choosing keys for 'or' searches. The example here is very simple
but reflects the more complex cases where lots of rows or joins
Hello again!
Andreas Pardeike wrote:
On 2004-02-16, at 14.13, Chris Nolan wrote:
MySQL's optimizer has a slight problem. OR queries cause it to get very
confused.
Try the following to get the best performance:
Rewrite SELECT FROM table WHERE (condition1) OR (condition2);
As:
(SELECT FROM
open source work.
Regards,
Chris
Curtis Maurand wrote:
checkout http://www.dbmail.org
On Sun, 15 Feb 2004, Chris Nolan wrote:
Hi all,
I'm currently designing an open-source messaging server that will use
MySQL as the data store (in embedded form).
High performance is one of the goals
Yes, it does. Both of the following statements give you the locks you'd
expect:
SELECT * FROM table WHERE id BETWEEN 4 AND 20 FOR UPDATE;
SELECT * FROM table WHERE id BETWEEN 40 AND 50 LOCK IN SHARE MODE;
Regards,
Chris
James Kelty wrote:
Does it have exclusive and shared?
-James
You might be able to cheat and replicate the required database to the
local machine.
Regards,
Chris
Terence wrote:
you'll need to create temporary tables in one of the servers based on the
results of the other and then join.
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL
element of the test.
As I've said in other threads, I can't wait for MySQL AB to release
their new benchmarks - it will hopefully give us a simple, definitive
source for comparison across architectures, operating systems and access
methods.
Regards,
Chris
On Mon, 2004-02-16 at 15:08, Daniel Kasak
Basically, only error-free statements are replicated.to the slave, thus
ensuring that constraints are satisfied.
Regards,
Chris
David Griffiths wrote:
Thanks for the reply.
So InnoDB (and even MyISAM) use transactions (expected with InnoDB) and
slaves track their position in the binary log
Hmm
I'd check for hard disc problems (turn on SMART monitoring and look
through your kernel logs), RAM problems (look at memtest) and rootkits.
Regards,
Chris
On Sun, 2004-02-15 at 15:45, Juan E Suris wrote:
I just installed 4.0.16 linux (x86, libc6) rpms on a fresh RH7.3 installation. I
one thread per connection?
Regards,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
on the master.
Thanks,
David
Regards,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
,
Chris
This goes back to my original assumption that I thought the BLOB contents
would be stored outside of the normal column data, meaning that you have to
do an additional seek to retrieve a BLOB value, but that a BLOB column
doesn't inflate the data over which a table scan has to iterate and so
on the challenge or run
screaming in the other direction and have a somewhat easier year.
Regards,
Chris
Heikki Tuuri wrote:
Chris,
- Original Message -
From: Chris Nolan [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, February 12, 2004 2:45 AM
Subject: InnoDB Hot Backup
methods and anything else worthy of note
(forms of logical volume management, impatient users that reboot servers
because they can't look at www.insert terrible site here.com due to
proxy/firewall restrictions)?
Regards,
Chris
Schmuck, Michael wrote:
Hello
I've got a big problem. My MySQL
Hi!
You might want to keep your eye on MySQL Cluster - to be demonstrated at
the 2004 MySQL conference, where you might get a chance to swim with the
dolphins!
Regards,
Chris
Are Pedersen wrote:
Hello
I am looking for software/hardware solutions to provide loadbalancing
and redundancy
(date) predicate,
the query time drops to about 2 seconds.
Thanks,
Mike
You're welcome! I hope that this helps you out!
Regards,
Chris
-Original Message-
From: Chris Nolan [mailto:[EMAIL PROTECTED]
Sent: 12 February 2004 12:23
To: Michael McTernan
Cc: Benoit St-Jean; Mysql
Subject: Re
Hi!
For formatted text, you may be able to get away with using FULLTEXT
searches on MyISAM tables, depending on the definition of formatted.
Regards,
Chris
On Wed, 2004-02-11 at 18:55, Veysel Harun Sahin wrote:
Hello list,
What is the best way to store and search formatted text?
Thanks
On Wed, 2004-02-11 at 22:29, Jochem van Dieten wrote:
Chris Nolan wrote:
Martijn Tonies wrote:
Additionally, it is an accepted fact that MySQL is faster than the
mighty, mighty PostgreSQL.
No, it is not. It is an accepted fact that MySQL is faster than
PostgreSQL for certain tasks
because it only had one index) and my smallest table has 3
columns.
Thanks.
Chris.
Is the database being used?
- no. It's a Quad Xeon machine attached to an EMC fibre storage system. My
iostat indicates the disks are hardly moving and my top shows that very
little CPU is being used.
What version of MySQL?
- 4.0.17
Chris.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
system?
myisam_sort_buffer
- I have 8GB of RAM, what should I set this to?
- my machine is dedicated to MySQL
Thanks.
Chris.
-Original Message-
From: Peter Zaitsev [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 11, 2004 2:03 PM
To: Chris Fossenier
Cc: 'MySQL List'
Subject: Re
Can you provide a better explanation of these variables? I have yet to find
a thorough explanation of each one of them.
My myisam_max_sort_file_size = 3M
I am running the indexes with an ALTER TABLE ENABLE KEYS command after I
load the data into the tables.
Chris.
-Original Message
None of my individual tables are larger than 12GB, however, I have no idea
if MySQL creates a separate TMP file for each indexing job or if it creates
a new one for each instance.
Also, where would it create this file? In the tmp dir?
Chris.
-Original Message-
From: [EMAIL PROTECTED
nothing over 20mill for records.
Chris.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 11, 2004 5:47 PM
To: Chris Fossenier
Cc: 'Peter Zaitsev'; 'MySQL List'
Subject: RE: Indexing Woes
These files will be created in the /tmp directory or where
of an
insult. If one more of my clients calls me saying Help! Our medical
management software won't start! Help! and it turns out that a reindex
was attempted while someone was busy inserting pictures of fresh
incissions I'll be very annoyed (and charging accordingly).
Regards,
Chris
Ed Leafe
engine is required (thus requiring a few changes to the embedded lib
before compilation). A quick scan through the docs involved doesn't seem
to point me in the right direction for a definitive answer on this.
Regards,
Chris
--
MySQL General Mailing List
For list archives: http
Ed Leafe wrote:
On Feb 11, 2004, at 7:31 PM, Chris Nolan wrote:
Yes, we all know that Microsoft *bought* FoxPro's underlaying
technology, that is *FoxBASE*! Everything ever called FoxPro has been
a Microsoft product.
Sorry, you're off by a few years. FoxPro had been out for several
FoxPro, thus they are more
trustworthy than MS! :-)
13. You'll have my eternal gratitude if you use MySQL over MS SQL
Server...I'll send you a postcard.
Regards,
Chris
Martijn Tonies wrote:
Hi,
I have a software of insurance to do quotations directly on the web. It
uses
a SQL 2000
!).
Regards,
Chris
[EMAIL PROTECTED] wrote:
Hi,
I could not find the binary for SCO Unixware (Intel based) in download
section. I suppose mysql supports this environment too. May I know as to
where can I find this binary. Do I need to build this myself?
TIA
Regards,
Anup Mahansaria
--
MySQL
,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Martijn Tonies wrote:
Hi Chris,
It seems that whenever we both comment in a thread, you enlighten me
greatly!
;-) ... I'm learning more about MySQL with every post. Ok, maybe
not every post, but still ... *g*
I tend to be a critic sometimes, but I'm a really nice guy. Believe me
interest though.
* The compiler you use.
I'm pretty sure that Skunkware includes GCC 2.95.x . This is one of the
recommended compilers for building MySQL binaries. If you install this
and can get a clean compile, you'll probably be fine.
Regards,
Chris
[EMAIL PROTECTED] wrote:
Hi Chris,
I want
UPDATE EMAIL_TEST_LIST SET EMAIL_DATE = curdate();
-Original Message-
From: Ligaya Turmelle [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 08, 2004 10:42 PM
To: [EMAIL PROTECTED]
Subject: is it possible...
Is it possible to have an update statement that uses curdate()?
Example:
to move .MYD and .MYI files around and have
any mysqld use them; InnoDB seems a bit picky about that.
Does the new one-file-per-tablespace format change any of that? Is
there any actual advantage to using it?
Thanks for any replies,
--
Chris
--
MySQL General Mailing List
For list archives: http
|
+--+
--
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
901 - 1000 of 2034 matches
Mail list logo