On 4/18/06, Jason Teagle wrote:
> > 1. Please always reply to the List.
>
> Who runs this list? Could it please be configured to send replies back to
> the list rather than the individual?
Please read the faq before rehashing issues that have been beaten to death.
Jochem
On 5/29/06, Cory wrote:
I have the following query that is running VERY slowly. Anyone have
any suggestions?
---
SELECT pnr.ID ID_pnr, pnr.reservationdatetime, pnr.conf_number,
pnr.created_by, GROUP_CONCAT(pp.name_last,', ',pp.name_first ORDER BY
name_last DESC SEPARATOR '') names, (SELECT SUM
On 5/29/06, Cory Robin wrote:
SELECT pnr.ID ID_pnr, pnr.reservationdatetime, pnr.conf_number,
pnr.created_by,
GROUP_CONCAT(pp.name_last,', ',pp.name_first ORDER BY name_last
DESC SEPARATOR '') names,
(SELECT SUM(pf.base_fare*(SELECT COUNT(1) FROM pnr_passengers pp
WHERE pp.ID_pnr
On 6/8/06, mos wrote:
At 08:15 PM 6/7/2006, you wrote:
I believe that if you are only using MySQL for your company's
internal needs, whether from a web server or for deployment to other
company-owned locations, you don't need a commercial license.
Unfortunately that's not what MySQL AB licensi
On 6/20/06, Stefan Hinz wrote:
The MySQL documentation team is looking for another technical writer.
For this we need the best and the most dedicated people around. You may
work from anywhere in the world as long as you have the necessary skills
and technical facilities to communicate across the
On 7/6/06, Ed Reed <[EMAIL PROTECTED]> wrote:
Anyone have an idea on this?
Upgrade. Or at least stop repeating the question.
Jochem
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 7/28/06, Dan Nelson wrote:
In the last episode (Jul 28), leo huang said:
So, the deleted rows' disk space in tablespace can't re-use when I
use Innodb, can it? And the tablespace is growing when we update the
tables, even the amount of rows do not increase.
It can be re-used after the tra
On 8/12/06, Miles Teg wrote:
Sun also has some awesome CoolThreads offerings (SPARC architecture), but I
haven't had a chance to benchmark one yet. With 32 concurrent threads on a
single 8 core 4 way threaded cpu, I'd like to see how MySQL's performance is
on those systems. Does anyone have an
On 8/19/06, Wai-Sun Chia wrote:
On 8/19/06, Jochem van Dieten wrote:
Tweakers.net did a benchmark comparing a trace of the queries
generated by their own website on a T1 to a dual Opteron. The article
is in Dutch, but the graphs speak for themselves:
http://tweakers.net/reviews/633/7
http
On 9/7/06, [EMAIL PROTECTED] wrote:
I need to know the number of rows that a query will return before
actually executing the query. So I am sending select count(*) before
sending select *. Actually I need to reject queries if the number of
records that it will return is huge, to avoid my server
On 10/2/06, Robert DiFalco wrote:
Is there a detailed source for when innodb creates row or table locks?
The sourcecode.
I have a situation where one thread is performing this in one
transaction:
UPDATE SomeTable SET WHERE SomeTable.id = N;
This is invoked after another thread
On 11/1/06, mos wrote:
Sure, I've thought of those too. But has anyone gotten Firebird to
store 700-800gb tables? Can you split Firebird's .gdb file across drives?
The main problem with tables of that size is maintaining the index. My
upper limit for MySQL is 100 million rows. After tha
On 11/1/06, mos wrote:
At 02:27 PM 11/1/2006, Jochem van Dieten wrote:
What is the big deal of a TB? Now, if you get past 20 TB you might
want to team up with one of the commercial PostgreSQL supporters
(Fujitsu, EnterpriseDB, Greenplum etc.), but Sun even sells appliances
for 100 TB
On 11/2/06, Leandro Guimarães Faria Corcete DUTRA wrote:
Em Wed, 01 Nov 2006 09:34:05 -0600, mos escreveu:
> Is there a better open source database out there for that amount of data?
Several. MySQL's own MaxDB, PostgreSQL, Firebird if you are into
Borland stuff, Ingres if you need XA
On 11/6/06, Leandro Guimarães Faria Corcete DUTRA wrote:
Em Thu, 02 Nov 2006 10:22:18 -0800, Jochem van Dieten escreveu:
PostgreSQL supports 2 phase commit. IIRC except for transaction
interleaving, join and suspend/resume it supports XA. I think that puts it
about on par with Ingres and
On 6/17/05, [EMAIL PROTECTED] wrote:
>
> There is one caveat: It is not currently possible to modify a table and select
> from the same table in a subquery.
That is not the only problem: there is no guarantee the subquery will
only return one record. So even if MySQL wouldn't have this limitation
On 6/21/05, Dan Bolser wrote:
>
> I am interested in the theoretical time / space complexity of SQL queries
> on indexed / non-indexed data.
I doubt this is the right list for theory.
> Specifically I want to know the complexity of a query that does a
> 'cross tabulation'
>
> SELECT
> X,
>
On 6/21/05, comex wrote:
> I have a table:
> create table example(time datetime, username varchar(255));
Please tell me you didn't actualy use "time" as identifier :)
> timeusername
> 2005-06-21 15:58:02 user1
> 2005-06-21 14:58:02 user1
> 2005-06-21 11:57:51 user2
> 2005-06-21 1
On 6/22/05, David Kagiri wrote:
> When i run the queries below they all work just fine
>
> SELECT sum(consultation)+ sum(laboratory) FROM nairobi,familymembers WHERE
> familymembers.dependantid = nairobi.memberid and familymembers.memberid =
> "AKI1"
>
> SELECT sum(consultation)+ sum(labora
On 6/21/05, Sebastian wrote:
> i never understand why people use datetime anyway.. unix timestamp is so
> much easier to work with.
Unix epoch is by definition UTC. Sometimes I want to work with dates
in some local timezone. In other databases that have a more complete
implementation of the SQL st
On 6/26/05, 2wsxdr5 wrote:
> Can someone tell me why this query works...
> SELECT UserKey
> FROM(
> SELECT UserKey, Count(GiftKey) Gifts
> FROM Gift
> Group BY UserKey
> ) GC
> WHERE GC.Gifts >= 3
Why this construction and not simply:
SELECT UserKey
FROM Gift
GROUP BY UserKey
HAVING Count(Gi
On 6/29/05, me you wrote:
>
> For the most part, the data entered is correct and uses the full -MM-DD
> format, however, I've got numerous dates that are incomplete. For example:
> an event happened in 1967, but the exact month and day are not known. I've
> been storing that data, in other fo
On 7/12/05, Gleb Paharenko wrote:
> auto_parser wrote:
>>
>> Would you be able to forward the following message to the mysql list. I
>> keep getting bounce-backs with the following:
>>
>> Recipient:
>> Reason:Mail from HELO priv-edtnes27.telusplanet.net rejected
>> because it does not a
On 7/14/05, Joerg Bruehe wrote:
> Rick Robinson wrote:
>
> However, the online manual is not cloned, so while we are building 5.0.9
> there can also be new text for 5.0.10 changes that gets integrated into
> the online manual, and this may become visible earlier than 5.0.9 gets
> published.
Why a
On 10/19/05, Martijn Tonies <[EMAIL PROTECTED]> wrote:
>>
>> First of all, is there any way of limiting the number of rows in a
>> table, referencing to the same element of another table? For example,
>> force a manager not to have more than 10 employees under his control.
>> In a way this can be s
On 10/19/05, Martijn Tonies <[EMAIL PROTECTED]> wrote:
>
First of all, is there any way of limiting the number of rows in a
table, referencing to the same element of another table? For example,
force a manager not to have more than 10 employees under his control.
In a way this c
On 10/20/05, Martijn Tonies wrote:
>>
>> That doesn't help: check constraints are evaluated only on insert and
>> update, not on delete. That's why you need an assertion.
>
> Hmmm, would that be SQL standard? Or implementation specific?
It is at the very least implied in the SQL standard.
> From
On 10/19/05, Peter Brawley wrote:
>>
>> I am having problems with the following query: I am
>> trying to join Tax_Bands and Property_Types to Properties
>> but the query seems to be joning Tax_Bands to Properties.
>
> That query generates no error in 5.0.13. There have been several cascading
> join
On 20 Oct 2005 10:13:56 +0200, Harald Fuchs wrote:
> Jochem van Dieten writes:
>>
>> Back in reality you don't enforce this using DDL. Apart from the fact
>> that I wouldn't know a single database that implements ASSERTIONs
>> according to the SQL standar
On 11/1/05, Kevin Burton wrote:
> MyISAM has a cool feature where it keeps track of the internal row
> count so that
>
> SELECT COUNT(*) FROM FOO executes in constant time. Usually 1ms or so.
>
> The same query on INNODB is O(logN) since it uses the btree to
> satisfy the query.
Are you sure? Fin
On 11/5/05, Ezra Taylor wrote:
> To Mysql users:
> Just to remind you all, Oracle is a
> business that expects to make money. As you all know, Mysql is a
> threat to the fat cats such as Oracle,DB2,MSSql and others. If you
> think Oracle is going to play fair with us
On 11/5/05, Mark wrote:
>
> Is there anyone who can shed some light on this without the anti-Orcacle
> hysteronics?
No.
Those who know have to go through proper channels. Oracle is a public
company and the disclosure of its future actions has to go through
proper channels or it will incur the wra
On 11/6/05, mos wrote:
>
> Sure but if people have commercial applications that use InnoDb, then what?
> Is there a surprise "tax" waiting for them next year?
Nothing changes for the licenses you already have. If you have an
application that is both incompatible with the GPL and depends on
InnoDB
On 11/7/05, mos wrote:
> Why isn't there a way to reference column aliases in the columns list or
> where clause?
Because the SQL standad says so. See chapter 7 of ISO/IEC 9075-2:2003.
> select if(score<50,-5,0) failing_score, if(score>50, 1, 0) passing_score,
> attendance/totaldays Percent_Atte
On 12/18/05, Andy Pieters <[EMAIL PROTECTED]> wrote:
>
> Is there any operator for mysql that behaves like "LIKE" but can act on
> numbers.
No. But with a bit of creativity you can use arithmetic to come to a
predictae that does the same:
SELECT *
FROM table
WHERE
floor(log10(floor(x / y))) <>
On 1/15/06, [EMAIL PROTECTED] wrote:
>
> Actually there is a table with columns a and b .
> So i want if a contains a particular word than a's value should return else
> 'b' value should return.
SELECT
CASE
WHEN a = 'Good' THEN a
ELSE b
END
FROM
table
Jochem
On 3/21/06, Robert DiFalco wrote:
> I apologize if this is a naive question but it appears through my
> testing that a RIGHT JOIN may out perform an INNER JOIN in those cases
> where they would produce identical result sets. i.e. there are no keys
> in the left table that do not exist in the right
On Fri, Dec 19, 2008 at 7:03 PM, Tompkins Neil wrote:
> Basically each product is listed in the master table, and can have a number
> of suppliers linked to it (ProductTB). The query above will show me a list
> of products for all suppliers for a particular product. However I want to
> be able to
a AS
SELECT
*
, (SELECT MAX(x) FROM y) AS z
FROM flight
This is not updatable because there is no sensible way to propagate
changes to the y base table.
Jochem
--
Jochem van Dieten
http://jochem.vandieten.net/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ro that assigns an alias to a select
statement, and when you reference that alias the select statement will
get substituted back in.
Jochem
--
Jochem van Dieten
http://jochem.vandieten.net/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
On Tue, Feb 10, 2009 at 1:47 PM, Steven Buehler wrote:
> From: Jochem van Dieten:
>> What the database will do for you behind the scenes is expand your
>> usage of the view. In effect, the database will replace "x" with its
>> definition. So your query SELECT a FROM
ine
to do a full text search on them surely is a limitation of that
database, not a conceptual disqualification of storing binary data in
a database.
Jochem
--
Jochem van Dieten
http://jochem.vandieten.net/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
On Aug 30, 2011 6:46 PM, "Brandon Phelps" wrote:
> SELECT
>sc.open_dt,
>sc.close_dt,
>sc.protocol,
>INET_NTOA( sc.src_address ) AS src_address,
>sc.src_port,
>INET_NTOA( sc.dst_address ) AS dst_address,
>sc.dst_port,
>sc.sent,
>
ual it is called "gap locking":
http://dev.mysql.com/doc/refman/5.5/en/innodb-record-level-locks.html
http://dev.mysql.com/doc/refman/5.5/en/innodb-next-key-locking.html
Jochem
--
Jochem van Dieten
http://jochem.vandieten.net/
--
MySQL General Mailing List
For list archives: http://li
On 10/21/07, Rob Wultsch wrote:
> I was previously on a list where the reply-to was setup as it is on the
> mysql list, with the originator receiving a response rather than list. It
> ended up that that setting was the default, and had not been changed when
> the list was setup.
>
> Is there a good
On Jan 17, 2008 2:22 PM, Kerry Frater wrote:
> Can someone please advise. I am looking to create a "multiuser" friendly way
> of getting a subset number of rows from a table into another whilst making a
> modification.
> create temporary table Ttable1 (select * from masterlist where ref='ABCDE');
On Jan 17, 2008 9:02 PM, Kerry Frater wrote:
> Thanks for the input Jochem.
If you wish to ignore my code and continue with your own code that of
course is fine with me. But why do you expect me to continue to help
you if you ignore me anyway?
Jochem
--
MySQL General Mailing List
For list archi
On Jan 30, 2008 12:50 PM, Dmitry E. Oboukhov wrote:
> Is it possible to add to the syntax of the INSERT operator appoximately
> in such way:
> SELECT list INSERT [IGNORE] INTO ... - an added one.
> SELECT list UPDATE - an added one.
> PS: I understand that adding the changes into a language i
On 11/10/06, [EMAIL PROTECTED] wrote:
Hello everybody
Can you explain me please how to get the entire row where ID is maximum per
given status_id
Mysql 4.0.xx
Have you checked the manual? There is an entire page specifically
about the group-wise maximum.
Jochem
--
MySQL General Mailing List
On 12/19/06, David Sparks wrote:
I noticed an interesting benchmark at tweakers.net that shows mysql not
scaling very well on hyperthreading and multicore cpus (see links at end
of email).
Does anyone know what engine they are using for their tests? (Innodb,
myisam, berkdb heheh)
InnoDB, the f
On 1/1/07, mos wrote:
Is there a problem with InnoDb scaling with multi-processor CPU's?
Apparently after reading the Tweakers.net article, with only 40
simultaneous users the performance of MySQL 5 will collapse.
http://www.mysqlperformanceblog.com/2006/11/30/interesting-mysql-and-postgresql-
On 1/1/07, mos wrote:
At 12:49 PM 1/1/2007, Jochem van Dieten wrote:
>On 1/1/07, mos wrote:
http://www.mysqlperformanceblog.com/2006/11/30/interesting-mysql-and-postgresql-benchmarks/
http://tweakers.net/reviews/649/6
Has this been fixed?
As the article on the MySQL Performance B
On 2/2/07, Jim C. <[EMAIL PROTECTED]> wrote:
I'm having to move some data from MySQL to Postgres. I used mysqldump
--compatible=postgresql, but the compatibility is extremely lacking.
It looks more like the person that designed the schema has payed very
little attention to the SQL standard. You
On 2/5/07, Jim C. wrote:
CREATE TABLE "credits" (
"person" integer NOT NULL default '0',
"chanid" int NOT NULL default '0',
"starttime" timestamp NOT NULL default '1970-01-01 00:00:00+00',
"role" VARCHAR NOT NULL,
CONSTRAINT role_check CHECK "role" IN
('actor','director','producer','ex
On 2/5/07, Jim C. wrote:
When I uncomment some of these statements I get an error in regards to a
comma. What I'm afraid of is that perhaps there is a compatibility
issue such that an INSERT command on Postgres can't take as many records
as MySQL.
What version are you running?
Jochem
--
MyS
On 3/27/07, Tim Lucia wrote:
> -Original Message-
> From: Maciej Dobrzanski
> Sent: Tuesday, March 27, 2007 6:46 AM
> To: mysql@lists.mysql.com
> Subject: Re: Why doesn't the InnoDB count() match table status?
>
> MyISAM and InnoDB (and there are plenty more). RDBMS is not an Office
> spr
On 7/8/07, Mogens Melander wrote:
On Fri, July 6, 2007 17:55, Michael Dykman wrote:
I have been on this list for a pretty long time but in the last few
months I have started to receive random 'confirm unsubscribe'
messages..They always seem to originate from a Roadrunner IP (I
have not thor
On 7/26/07, Andrew Armstrong wrote:
> * Table 1: 80,000,000 rows - 9.5 GB
> * Table 2: 1,000,000,000 rows - 8.9 GB
> This is a generic star schema design for data warehousing.
> I have read that it is better if perhaps partitioning is implemented, where
> new data is added to a partiti
On Wed, 23 Feb 2005 00:22:55 +0200, Heikki Tuuri wrote:
>
> a buggy fsync() in Linux is one of the possible reasons here. If an InnoDB
> tablespace gets corrupt in a power outage, it is most probably caused by a
> bad fsync() implementation or configuration in the operating system or
> hardware.
On Fri, 25 Feb 2005 11:21:26 -0600, mos wrote:
>
> http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/MySQL-PostgreSQL_features.html
There is a reason this page was removed from the MySQL site: some of
it was never correct in the first place, and the rest was severly
outdated.
Don't you thi
On Tue, 1 Mar 2005 18:09:37 -0600, Alfredo Cole wrote:
> El Mar 01 Mar 2005 17:32, Gary Richardson escribió:
>>
>> InnoDB uses transactions. If you are doing each row as a single
>> transaction (the default), it would probably take a lot longer.
>>
>> I assume you're doing your copying as a INSERT
On Tue, 15 Mar 2005 17:43:29 -0600, [EMAIL PROTECTED] wrote:
>
> I need to do this:
> From this table
> +--+
> |id|Data |
> |--|---|
> | 1|Something 1|
> | 2|Something 2|
> | 3|Something 3|
> | 4|Something 4|
> | 5|Something 5|
> | 6|Something 6|
> +--+
>
> G
On 4/26/05, Jigal van Hemert wrote:
> http://dev.mysql.com/doc/mysql/en/silent-column-changes.html
> mentions that "Columns that are part of a PRIMARY KEY are made NOT NULL even
> if not declared that way. "
>
> And http://dev.mysql.com/doc/mysql/en/create-table.html tells me that "A
> PRIMARY KEY
On 4/26/05, Jigal van Hemert wrote:
> From: "Jochem van Dieten"
>>> Why is this?
>>
>> Because the SQL standard says so.
>
> A true observation, but still no explanation or reason why ;-P
I consider it a good enough explanation of why MySQL doesn't
On 5/7/05, Dan Bolser wrote:
>
> Why are columns included in the join between two tables ambigious?
Because MySQL does not follow the SQL standard (ISO/IEC 9075-2:2003).
> select pk from a inner join b using (pk);
>
> ERROR 1052 (23000): Column 'pk' in field list is ambiguous!!!
>
> Is this a
On 5/7/05, Chris wrote:
> Somethign else to think about as well, look at this slight modification:
>
> select pk from a left join b using (pk);
>
>
> Now, it's not likely this is a valid query for your table structure
It is very likely it is. It is even an example in the MySQL manual.
> but,
On 5/7/05, Dan Bolser wrote:
> On Sat, 7 May 2005, Jochem van Dieten wrote:
>>On 5/7/05, Dan Bolser wrote:
>>
>>> select pk from a inner join b using (pk);
>>>
>>> ERROR 1052 (23000): Column 'pk' in field list is ambiguous!!!
>>>
>
On 5/9/05, Andreas Steichardt wrote:
>
> We are storing UTF-8 data in out mysql database and we need to get the
> length
> of the data. But length() doesn't return the number of characters but the
> pure number of bytes.
Look at OCTET_LENGTH() and CHAR_LENGTH(). (While OCTET_LENGTH() is a
synon
On 5/9/05, Kevin Burton wrote:
> So... it sounds like a lot of people here (Dathan and Greg) have had
> problems deploying MySQL on Opteron in a production environment.
To me it sounds more like a lot of people have had problems running
Linux on x86-64 systems.
Jochem
--
MySQL General Mailing
On 5/29/05, Philip George <[EMAIL PROTECTED]> wrote:
>
> +--++---+--+
> | quantity | name | price | subtotal |
> +--++---+--+
> |1 | orange | 0.97 | 0.97 |
> |3 | pear | 1.09 | 3.27 |
> +--++-
On 5/29/05, Lieven De Keyzer wrote:
> From: Chris
>> Lieven De Keyzer wrote:
>>>
>>> UPDATE account
>>> SET role_id = (SELECT role_id FROM role WHERE rolename = "admin")
>>> WHERE username = "test"
>>>
>>> This gives me an:
>>> ERROR 1064 (0): You have an error in your SQL syntax. Check the
On 5/28/05, Terence wrote:
>
> Master ID is used to distinguish multiple helpdesks. In this table there
> are 100k records, but only 10 distinct master_id's.
>
> ticket_id master_id
> 1 1
> 2 1
> 3 2
> 4 2
> 5 3
> ...
On 5/29/05, Philip George wrote:
> On May 29, 2005, at 1:41 AM, Jochem van Dieten wrote:
>>
>> http://dev.mysql.com/doc/mysql/en/group-by-modifiers.html
>
> already read that. the join in my example is more complicated than
> anything depicted on that page.
The join
On 5/29/05, Philip George wrote:
> On 5/29/05, Philip George wrote:
>> On 5/29/05, Jochem van Dieten wrote:
>>> http://dev.mysql.com/doc/mysql/en/group-by-modifiers.html
>>
>> already read that. the join in my example is more complicated than
>> anything
On 6/9/05, Kevin Burton wrote:
> Jeff Smelser wrote:
>>
>> Thats funny.. looks like it will be added to 5.1.. Dunno why they
think fixing
>> it is adding a feature..
>
> WOW! That's just insane! This seriously has to be fixed in 5.0 or sooner...
Chill out man. It is not like it is returning the
On 6/9/05, Jeremiah Gowdy wrote:
>
> I am proposing that when a query is received by MySQL, a timestamp could be
> taken immediately, and that timestamp could travel with the query until it is
> actually processed. For delayed inserts, the query would still sit in the
> insert queue, and it wo
On 6/9/05, Jeremiah Gowdy wrote:
> >
> > Does this seem to break SQL / application logic in some fashion?
>
> >Not worse then it is currently broken :)
> >
> >According to the SQL standard CURRENT_TIMESTAMP, which in MySQL is a
> >synonym for NOW(), is supposed to have a value that does not change
On 6/9/05, Keith Ivey wrote:
> I'm a little surprised that case-sensitivity is such a big deal. What sort of
> programmers randomly vary their capitalization from one occurrence of an
> identifier to the next
Inconsistencies in the capitalization aren't necessarily introduced by
a programmer. Esp
On 6/9/05, Roger B.A. Klorese wrote:
>
> If you're the first person this has bothered
He isn't, search the bugbase. (Including reports that are closed
because it is documented, without providing a fix, workaround or even
recategorizing as feauture request.)
> and if the limitations don't provid
On 6/9/05, Bartis, Robert M (Bob) wrote:
>
> Its an email alias. You're asking for help from people you don't even know.
> You should therefore present your needs clearly and concisely. You should
> expect there to be questions. You should expect to not always get timely
> information. you sho
On 6/9/05, Martijn Tonies wrote:
http://dev.mysql.com/doc/mysql/en/timestamp-4-1.html
> Absolutely brilliant document *g* ...
>
> So now, it makes a difference if it's the first TIMESTAMP column,
> if it's running in MaxDB mode, if it has a defaulf of NULL (which will
> be silently changed), if
On 6/9/05, [EMAIL PROTECTED] wrote:
>
> Okay, so I understand the idea about one field being the "creation" time, and
> the other being the "last modified" time (which a particularly pedantic
> application might regard as being one-and-the-same, at time of
> first-creation) and so I see you might
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')
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
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
>
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
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
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
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:
* 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
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
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
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
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 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
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
[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
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
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
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
1 - 100 of 171 matches
Mail list logo
