On Wed, 11 Aug 2004 11:04:01 -0500, Josh Trutwin wrote:
> On Wed, 11 Aug 2004 17:20:45 +0200 Jochem van Dieten wrote:
>>
>> SHOW TABLES does not make sense. How are you going to join the
>> output of SHOW TABLES against the output of SHOW COLUMNS and SHOW
>> I
On Wed, 11 Aug 2004 10:00:32 -0500, Josh Trutwin wrote:
> On Tue, 10 Aug 2004 23:34:49 +0200 Jochem van Dieten wrote:
>> On Tue, 10 Aug 2004 16:00:12 -0500, Josh Trutwin wrote:
>>>
>>> MySQL's command line interface and programming API also are nicer
>>>
On Tue, 10 Aug 2004 16:49:26 -0400, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Well, since you admitted to being a newbie, I would suggest that you learn
> with MySQL. It supports several types of data storage (memory only, ISAM,
> full-relational) and both transacted and non-transacted executi
On Tue, 10 Aug 2004 16:00:12 -0500, Josh Trutwin wrote:
>
> One area where MySQL beat Postgres is in Windows installation. Installing postgres
> on Windohs is like pulling your fingernails off slowly.
It is more like following the manual. Not hard, you just have to take
it one step at a time.
On Tue, 10 Aug 2004 15:35:20 -0500, EWAGW <[EMAIL PROTECTED]> wrote:
> Hi all, mr.super newbie here, what is the best for cold fusion development?
The best depends on the requirements. You have not told us any
requirements, except that you work with ColdFusion. If that is
*really* the only conside
On Fri, 6 Aug 2004 16:26:53 +0300, DebugasRu <[EMAIL PROTECTED]> wrote:
>
> since SQL89 standard lot of things got standartized but still there
> are more things to unify. One of them is metadata (system tables that
> a given DBMS uses) processing. I want to ask if there is going to be any standar
On Tue, 03 Aug 2004 06:50:46 -0600, Martin Gainty wrote:
>
> Keep in mind that when you use LIKE you will NOT use an index but you will
> use a full table scan instead
> Also instead of using IN EXISTS uses Indexes on the master table query..if
> you have master-heavy or parent-heavy query use EXI
Ian Gibbons wrote:
>
> If someone else quotes your message in a reply ( which is considered best practice
> in all mailing list I have ever been a member of ) email addresses are displayed.
I quote you. Now where is an email address displayed?
> I understand that my address could have ( and is
On Fri, 9 Jul 2004 14:01:46 +0100, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
>
> Nearly always, but not absolutely always. I have a table with columns
> primary start
> primary finish
> secondary start
> secondary finish
>
> Since it is defined that the distance
On Fri, 9 Jul 2004 14:45:41 +0200, Jigal van Hemert <[EMAIL PROTECTED]> wrote:
> From: "Martijn Tonies" <[EMAIL PROTECTED]>
>> Design for understanding, logic and maintenance, not performance.
>>
>> If you need more performance, throw more hardware at it -
>> a larger cache (settings -> memory), fa
Michael Stassen wrote:
SELECT init FROM inits GROUP BY init ORDER BY init;
+--+
| init |
+--+
| A|
| B|
| C|
...
| X|
| Y|
| Z|
+--+
26 rows in set (0.39 sec)
SELECT init FROM inits GROUP BY init ORDER BY init DESC;
+--+
| init |
+--+
| Z|
| Y|
|
Michael Stassen wrote:
Jochem van Dieten wrote:
David Blomstrom wrote:
Suppose you have a list of dates in the proper format,
like this:
2004-02-04
2003-11-02
and you encounter a date with only the month and year,
like May 2002. How would you insert that
Not. Prompt the user for a full date.
That
David Blomstrom wrote:
Suppose you have a list of dates in the proper format,
like this:
2004-02-04
2003-11-02
and you encounter a date with only the month and year,
like May 2002. How would you insert that
Not. Prompt the user for a full date.
Jochem
--
MySQL General Mailing List
For list archives
Leandro Melo wrote:
So, is there a way to only check for the FKs
constraint at the end of the transaction, and not at
the rigth moment of the insert
Not in MySQL. Other databases have functionality named deferred
constraints, where constraint checking is deferred to transaction
commit, but My
David Blomstrom wrote:
I put a screenshot of my database organization online
at
http://www.geoworld.org/database.gif It features four
tables, focusing on Continents, Nations, States and
Counties. Notice that Continents and Nations share a
"CCode" (continent codes) column
So how are you going to pu
[EMAIL PROTECTED] wrote:
I don't see how you can possibly hope to satisfy two mutually dependent
constraints at the exact same time. It's a chicken-and-egg scenario. If you
can't create your vacancy record first (to get its PK value) you won't be
able to create the new record in your supervision ta
Daniel Ek wrote:
Jonas Oreland wrote:
Daniel Ek wrote:
I today have a database using 20GB storage, which actually means that
I should have at least 30GB (40GB recommended) ram using Mysql cluster.
This could be 40 boxes with 1G ram each.
But doesn't that increase the locking conflicts significantl
[EMAIL PROTECTED] wrote:
Eric, you are in the same boat I am in. I also have satellite offices
across WAN links that should keep functioning even if the WAN is down.
My , yet to be tested due to "office politics", workaround design was to
have each office (satellite and main) have their own "mini-
Paul DuBois wrote:
At 10:17 -0500 4/30/04, Josh Trutwin wrote:
On Fri, 30 Apr 2004 17:04:57 +0100
"joe collins" <[EMAIL PROTECTED]> wrote:
Are there any plans to have triggers introduced into MySQL?
version 5.1 - probably a ways off with 5.0 still alpha.
That's true, but if history is any guide, th
Ricardo wrote:
Which collation are you using in MS SQL Server? And
in MySQL?
MS SQL Server 8
Collation = Latin1_General_CI_AS
MySQL 4.0.16
character_set = latin1
The charset determines which characters can occur. The collation
determines the sort order. What is the collation in MySQL?
http://dev
Ricardo wrote:
The order should be:
fa
Fa
fá
Fá
fâ
Fâ
fã
Fã
As I get in MS-SQL Server.
Which collation are you using in MS SQL Server? And in MySQL?
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
--
MySQL General Mailing List
For list archives: http://lists.mysql.
Sp.Raja wrote:
=
700101 20:31:59 INNODB MONITOR OUTPUT
=
Per second averages calculated from the last 39 seconds
--
SEMAPHORES
--
OS WAIT ARRAY INFO: reservation count 139, signal count 139
Mutex spin waits 0, r
Peter J Milanese said:
>
> The lack of error checking on the server side means better
> performance in my opinion.
Does it? Or does client side error checking use server resources as well?
Lets suppose that we want to validate a new message that is entered
into a thread on a messageboard. Then we
Jeremy Smith said:
>
> A typical auction lasts around
> 90 minutes, and consists of a whole lot of furious refreshing of the
> auction board by the participants since each player only has a 2
> minute clock.
You might wish to look into using a different mechanism for this so
you can push the lates
Remi Mikalsen wrote:
Car
-
| ID | IDBrand | IDModel | Year | Price |
-
Characteristic
| ID | Description |
CarCharacteristics
| IDCar | IDCharac |
-
Stormblade said:
> Ok. Love MySQL and I will be using it for my personal use and
> recommending it to clients as a lower cost alternative. I've only
> been using it for a very short time but there one major gripe I have
> with it and I believe it's just a design thing.
>
> MySQL seems to put the bu
Leonardo Javier Belén wrote:
The staff on the other hand, is thinking in using ORACLE, and I need very solid arguments to beet them. Any ideas I can borrow?
If *you* don't know any arguments, then maybe Oracle is the best
solution.
Jochem
--
I don't get it
immigrants don't work
and steal our job
Tim Cutts wrote:
On 30 Mar 2004, at 09:05, Tim Cutts wrote:
SATA RAID devices aren't that bad, you know, and they are a lot
cheaper than equivalent amounts of SCSI storage. We've used NexSan
ATABoy devices, which are relatively cheap, and get you a lot of
storage in very little space (10GB in
Michael Stassen wrote:
Jochem van Dieten wrote:
However, I expect that would result in doing 2 rangescans and a
merge. It might be even faster to use:
SELECT * FROM sys
WHERE sectorID BETWEEN 1 AND 42
AND sectorID NOT BETWEEN 21 AND 29;
That would result in 1 rangescan and a filter. But a lot
Michael Stassen wrote:
SELECT * FROM sys
WHERE sectorID BETWEEN 1 AND 20
OR sectorID BETWEEN 30 AND 42;
If that's slow (the optimizer doesn't like ORs) and you are using at
least mysql 4.0.0, you can change this to
SELECT * FROM sys WHERE sectorID BETWEEN 1 AND 20
UNION
SELECT * FROM sys WHERE
[EMAIL PROTECTED] wrote:
I'd go with raid 1+0 ... Be a shame to have that much cpu power and become
I/O bound.. This way you've got 4 disks feeding the cpu's instead of 2..
Better performance than raid 5, and only 2 more disks than your current
config.
If you have 8 GB of RAM and 4 GB of database,
Saurabh Data wrote:
I am doing research on spatial data and how it can be used in open
source systems like mySQL.
Can someone give me some outline of problems in handling spatial data in
mySQL.
If you are specifically looking for problems you might find the
following interesting:
http://postgis.r
Vincent wrote:
all my mistake I deleted mysql.user this tablewhat can I do to
recover this ?
Restore from backup.
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:ht
Tim Hayes said:
> Can anyone offer advice?
>
> I have come across a MySQL database on Linux with duplicate table
> names - "Accounts" and "accounts". This seems fine on Linux, but
> does not transfer to the Windows environment - it is rejected
> because of the duplicate name. However I do see that
Heikki Tuuri wrote:
From: "Jochem van Dieten"
Sasha Pachev wrote:
In Java is it easy to write a program that wastes large amounts of
memory, which is worse than a leak. In C, you are full from the start,
and then you leak a drop at a time until you are empty. In Java , you
are empty from
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 programming', by
which I mean implementing anything with co
Carl Schéle, IT, Posten wrote:
I got a table, champions, looking like this:
id winner_1 winner_2
0carl mattias
1daniel carl
2er
Mark Russell wrote:
What began as a test database server for a web
developer in one department, has now become a tangled
web of production databases, test databases, and
abandoned databases for multiple departments. Of
course, the only documentation I have is a Post-It
note with the root password
Ian ORourke said:
> Is it possible to have a 'worked out value' in the WHERE clause. The
> problem I have is what I need to check for in the WHERE Clause is
> not a column:
>
> SELECT
> CONCAT_WS("-",DATE_FORMAT(EntryDate,'%c'),DATE_FORMAT(EntryDate,'%Y'))
> As mthyr
> From Blogs
> WHERE mthyr=1-20
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.
The PostgreSQL developers say that they are faster
than most com
Bengt Lindholm wrote:
In your example they would all be in the same group. You could say the
group delimiter is any gap between records that is 5 minutes or more. So
records would be in the same group even if the total timespan for the
group is more than 5 minutes, but all gaps between individua
Heikki Tuuri wrote:
I guess that 4-byte UTF8 characters are not needed. You can code 16 million
characters with 3 bytes.
Yes. But is that also the case if you use the UTF-8 encoding
scheme, or can that scheme code less characters with 3 bytes?
http://ln.hixie.ch/?start=1064324988&order=-1&count=1
Ian O'Rourke wrote:
Is anyone on the list using Coldfusion MX with MySql?
Yes.
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mark Matthews wrote:
Jochem van Dieten wrote:
rmck said:
I have "ip_address" and "ports" that I want to use in my table. I
was just going to make each one a varchar. But was wondering if
anyone has a better suggestion?
PostgreSQL ;-)
It has a native datatype for storing IP a
rmck said:
> I have "ip_address" and "ports" that I want to use in my table. I
> was just going to make each one a varchar. But was wondering if
> anyone has a better suggestion?
PostgreSQL ;-)
It has a native datatype for storing IP addresses. That means that
things like sorting and subnet inclu
Alex croes said:
> I have an question about the design of a database. What is the best
> way to design tables. Is it better to create many small tables, or
> create fewer big tables. Which of those two options will get the
> best performance?
Don't worry about performance. If performance is real
Roland Corbet said:
>
> However, although there are relatively few pieces of history we need
> to store before the year 1000 they are equally important. We are
> likely to have dates such as 0005-04-10 or even BC dates
> (-)3000-00-00.
> Alternatively, is there a better method which I could use?
Ian ORourke said:
> I want to order my articles in descending order on date, and for
> articles on the same date I want to order by ID in ASC. I've tried
> the following:
>
> ORDER BY EntryDate DESC, ID ASC
>
> But it does the EntryDate Order but nothing else.
http://www.catb.org/~esr/faqs/smart-q
Michael McTernan said:
>
> I'm using MySQL 4.0.15-standard-log, on RedHat 9.0 with InnoDb tables.
>
> Essentially I have two tables, one table is a list of integers,
> while the second is a table of integer pairs. e.g.
>
> +---+ +-+-+
> | A | | B.x | B.y |
> +---+ +-+-+
> | 1
Chuck Gadd said:
> Balazs Rauznitz wrote:
>
>> mysql> select count(*) from sex where id>459000 and id <=46
>> and sex = 'M'; +--+
>> | count(*) |
>> +--+
>> | 504 |
>> +--+
>> 1 row in set (5.09 sec)
>>
>> Any way to make this faster ?
>
> Well, MySql can only use 1
Yves Arsenault wrote:
SELECT *
FROM events
WHERE day(theDate) = '#dayVal#' and month(theDate) = '#session.month#'
and year(theDate) = '#session.year#'
Can the day() function be used in this way in the WHERE statement?
Yes, but only from version 4.1.1
Use DayOfMonth() or preferably Extract() (whic
Noamn wrote:
Judging by some of the comments posed on this list, I wonder whether the
following statements are true:
1. There is no point having an index on a field if that field can only have
a few values
Not for query speed reasons. There may be other reasons
(uniqueness for instance), but for
Ratna Rajesh Thangudu said:
my table looks like this :
code size
1n3j 14
1n3j 32
1n3j 37
1n9j 14
1n9j 32
1n9j 14
1nm4 14
1nm4 37
1nm4 32
1nmi14
1nmi14
1oo314
1oo314
1oo414
1oo414
I want to select those rows with 'size' 14, 32 an
Douglas Sims wrote:
You should check out: http://onlamp.com/ L.A.M.P.
(Linux/Apache/MySQL/Perl(or PHP)
Or Linux/Apache/Middleware/PostgreSQL ;-)
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
Mike Blezien said:
>
> I've been looking at this SQL query a dozen times or more, but keep
> getting a syntax error message, Query:
>
> SELECT ai.affilid,ai.create_date,CONCAT(ai.fname,' ',ai.lname) AS
> name,aw.siteid,ai.email,as.username,as.status
> FROM affiliate_info ai,affiliate_signup as,aff
Michael Satterwhite wrote:
On Monday 19 January 2004 16:30, Jochem van Dieten wrote:
Michael Satterwhite said:
On Monday 19 January 2004 15:38, Jochem van Dieten wrote:
So let's make it 2 fields:
SELECT
t1.*
FROM
table1 t1,
table2 t2 INNER JOIN table2 t3
ON (t2.rdid = t3.rdid AND t
[EMAIL PROTECTED] wrote:
DVD_Actor:
dvd_ID REFERENCES DVD
actor_ID REFERNCES Actor
Is this how you setup a join table ?
Yes.
what exactly is the references keyword ?
It indicates a foreign key. Full syntax is something like:
dvd_ID CONSTRAINT dvc_fk FOREIGN KEY REFERENCES DVD (dvd_ID)
Read the ma
Bjorn Barton-Pye wrote:
I am using a test database to teach myself MYSQL and am using my DVD
collection as the subject. I have 3 tables in this example:
Actresses
===
actr_id
name
Actors
==
acto_id
name
DVD
==
Title
acto_id
actr_id
The acto_id and actr_id in the DVD table indicates the
Michael Satterwhite said:
> On Monday 19 January 2004 15:38, Jochem van Dieten wrote:
>> So let's make it 2 fields:
>>
>> SELECT
>> t1.*
>> FROM
>> table1 t1,
>> table2 t2 INNER JOIN table2 t3
>>ON (t2.rdid = t3.rdid AND t2.vi
Lincoln Milner said:
> Or, if I'm not mistaken, you could do something like:
> SELECT t1.*
> FROM table1 t1, table2 t2
> WHERE t1.id = t2.rdid
>AND t2.vid IN (46, 554)
> ;
>
> That should work
No. You are back to square one where there should only be one record
in t2 with a vid of either 46
Michael Satterwhite said:
> On Monday 19 January 2004 13:17, sulewski wrote:
>> Okay, I think I'm missing something obvious. I have two tables
>>
>> Table 1 Table 2
>> ___ _
>> ID rdid vid
Stefaan Van Dooren wrote:
Since some days I don't get any mail from this list anymore.
After some investigation, I found that it's blacklisted and our mailserver
refuses any mail from it.
DNSBL/WARNING: bl.spamcop.net/213.136.52.31: IP is listed
Can this be fixed ?
Yes. Ask your mail admin.
Joc
Steve Folly said:
>
> However, I suspect this isn't the full story. Do you also want to
> see what components make up C003 and D003 in the same query? I
> think you're after a feature not yet implemented in MySQL - the
> 'CONNECT BY PRIOR' SELECT statement, just the ticket for
> hierarchical que
Roger Baklund wrote:
* Jochem van Dieten
Functionally, I believe it is much cleaner as it abstracts the
problem away from the developer. Especially around DST changes
this can be an important issue.
I agree again. But it doesn't answer my question... I suppose you can live
without time
Roger Baklund wrote:
* Jochem van Dieten
The proper way to program this would require MySQL to support the
AT TIME ZONE construct, but I haven't found it on the MySQL
roadmap yet.
Woudn't the "proper way" be the way that leads to a result you can live
with? Of course support
Roger Baklund wrote:
The date/time returned by the server is in the timezone of the server. If
you need to convert it to a different timezone, you must do this within your
application. It can be done directly in the SELECT statement. PHP example:
$usertimezone = get_user_prefs('timezone');
$res = m
Hassan Shaikh wrote:
How do I generate a GUID (Globally Unique Identifier) under MySQL on
Linux. I am doing it under Win32 using one of the documented Win32 API
but I want to do it on a Linux platform?
Do you need a GUID or would a UUID be alright too? (128 bit
identifier just like GUID, guarantee
Morten Gulbrandsen wrote:
http://www.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&q=MySQL+toy+marston
Subject: Re: Can MySQL table handle 3 million+ entries?
Newsgroups: comp.lang.php
Date: 2003-04-11 15:20:10 PST
MySQL is NOT a toy database - it is far superior to many I have used in my
long ca
Matthew Stuart said:
> I am on my first MySQL DB and it is very text heavy because it is a
> news site, therefore there is a great deal of use of the apostrophe
> or as MySQL would see it the single quote. I was hoping to be able
> to use double quotes to overcome the need to constantly have to
>
Ian ORourke said:
>
> In the near future we face making a decision for a database backend,
> and the logical choice for us is MSSQL as we have one server already
> for Great Plains - but it would seem MySQL is much cheaper.
Perhaps. But supporting 2 database servers sounds like the most
expensive
Ian O'Rourke wrote:
I'm very new to MySql and I'm having problems inserting dates into my tables
(via the Web using Coldfusion). The user can put the following in the field:
12/09/2003
But the data returned from the database is:
2012-09-20 03:00:00.0
INSERT INTO table (field)
VALUES ('2003-12-09')
101 - 171 of 171 matches
Mail list logo