On Thu, Feb 06, 2003 at 09:52:11AM -0500, Brent Baisley wrote:
As long as the foreign keys are index it should be pretty quick. There
really is no way to get around processing every record in table data.
As that table grows, your query will get slower. But a 157K rows isn't
really a whole
On Wednesday 05 February 2003 02:07, aah at volunteermatch dot org wrote:
Description:
Multiple IS NULL tests in a WHERE clause appear to be broken
when testing NOT NULL date fields. Queries work fine against
varchar and int, probably(?) others.
How-To-Repeat:
Hi Hawk [EMAIL PROTECTED],
I'm not sure if you have checked the manual yet, but following
links seem to be somewhat related to your query:
* http://www.mysql.com/doc/en/Using_mSQL_tools.html
* http://www.mysql.com/doc/en/Using_InnoDB_tables.html
This was an automated response to
On 6 Feb 2003, at 8:58, Michael Boudreau wrote:
mysql select review into outfile '/tmp/MS55038rev1.txt' from
MsReviews where
msid=55038 and msreviewid=1;
Query OK, 1 row affected (0.00 sec)
mysql quit
Bye
The newline seems to have had a \ (backslash, octal 134)
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Guy --
...and then Defryn, Guy said...
%
% I was just reading through the Mysql manual section 3.32
% And came across a sentence that started like this
%
% Animal sex can be represented in a variety of ways
%
% My mother tongue is not English but
In the last episode (Feb 06), Michael Boudreau said:
Here's something weird: text strings containing newlines seem to have a
backslash character added when the data is exported from the database.
(MySQL 3.23.37 on Solaris--yes we're upgrading to .54)
However, when I read the data out to a
Ben Clewett wrote:
I was rather trying to find an IMAP server using MySQL. Ie, somewhere
to store my millions of email messages, from many execlent mailing
lists, and get at them fast...
What you want is the Courier-IMAP mail server which uses the Maildir
format to store its messages,
check the docs at www.mysql.com for the CORRECT command to create indexes.
=C=
* Cal Evans
* Stay plugged into your audience.
* http://www.christianperformer.com
-Original Message-
From: Hawk [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 06, 2003 9:03 AM
To: [EMAIL PROTECTED]
Hi [EMAIL PROTECTED],
I'm not sure if you have checked the manual yet, but following
links seem to be somewhat related to your query:
* http://www.mysql.com/doc/en/Replication.html
* http://www.mysql.com/doc/en/Replication_FAQ.html
*
At 04:13 PM 2/7/2003 +, you wrote:
We sell a data converter for this purpose check out www.bpenet.net
I'm not concern about transferring the data. I was having problems
creating the indexes.
thanks for the reply...
Michael Johnson
Managing Director
Humphrey Consulting Limited BPEnet
Hmm, I thought this question I posted last weekend was a pretty
good one, however, no replies have been posted :-(
I am new to MySQL and this mailing list, is the the proper place and format
for questions of this type?
Regards,
Bill
Hi all:
I am building a database containing usage
Hi,
I have a table Log described as such:
+--+---+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
+--+---+--+-+-+---+
| rec | int(1)| YES | | NULL| |
| time | int(10) | |
I've gotten some weird responses to this type of question before, but
I'd like some input anyway. We are getting a new dedicated database
server. Currently our load average is hovering above 2 and although
things work fine, that snappiness is fading as the load becomes higher.
We may be able to
Hi, I'm trying to learn a little about query optimization.. I have a query that is
pretty slow, and was wondering if there is an easy way to speed it up.
mysql EXPLAIN
- SELECT
- mailfrom,
- sum((msgsize)/100) as mb,
- count(id) as count,
- avg(hits) as hits
The best way is to import data from MS SQL Server to MySQL. SQLyog at
http://www.webyog.com/sqlyog/download.html has a DTS like ODBC Wizard.
Try it out and all you data will be imported.
Insane
- Original Message -
From: Hawk [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday,
Hi,
I have a database with 3 names in it. In each of these names is 5
categories that have numbers in them. I want to be able to do a select and
get the top number from each category for each name and display them from
most to least. I have checked all the docs on the select statement, but
Hi again,
After some struggling, I have managed to get the problem below 99% working,
the problem now is that I can't get them in descending order. Here is my
select statement.
$query = select manager.name, position, MAX(goals) from roster join
reference join manager where
Hi goth [EMAIL PROTECTED],
I'm not sure if you have checked the manual yet, but following
links seem to be somewhat related to your query:
* http://www.mysql.com/doc/en/Commands_out_of_sync.html
* http://www.mysql.com/doc/en/Replication.html
*
I don't know whetehr this is going to make any sense!
I have a query pulling records from MySQL tables that are joined. The join is
for a color_id to an item...
///
function showColor($item_id)
{
$query=select ref_colours.* from item_color
Description:
1. executing scripts/mysql_install_db gave a ton of warnings like the following:
19760:/usr/local/mysql/libexec/mysqld: /sbin/loader: Warning: Can't find strong symbol
for _ZN10field_real3st
dEP6Stringm
19760:/usr/local/mysql/libexec/mysqld: /sbin/loader: Warning: Can't find
Hi Varshavchick Alexander [EMAIL PROTECTED],
I'm not sure if you have checked the manual yet, but following
links seem to be somewhat related to your query:
* http://www.mysql.com/doc/en/JOIN.html
* http://www.mysql.com/doc/en/LEFT_JOIN_optimisation.html
*
Hi Doug Beyer [EMAIL PROTECTED],
I'm not sure if you have checked the manual yet, but following
links seem to be somewhat related to your query:
* http://www.mysql.com/doc/en/Problems_with_NULL.html
* http://www.mysql.com/doc/en/CREATE_TABLE.html
*
Doug Beyer wrote:
create table t1 ( id varchar(5) not null, name varchar(5) not null );
insert into t1 ( id ) values ( 1234 );
select count(*) from t1 where name is null; -- Result = 0
select count(*) from t1 where name = ; -- Result = 1
Questions:
1) Why did the insert succeed since the
I¹m having problems with a left join. I¹m not even sure if I should be using
a left join.
I have two tables; sites and site_service. Site_service contains service
dates for the sites. I¹m trying to write a query that will select each site
and the last service date for that site. A site may have
Pretty sure dbmail can use mysql.
www.dbmail.org
-Erik
--- Ben Clewett [EMAIL PROTECTED] wrote:
Paul DuBois wrote:
I believe the Horde IMP server uses MySQL:
http://www.horde.org
Thanks. Looking at this, I belive it's an IMAP
clinet. Unless the web
site is in error.
I
This thread is funny,
When I first read the phrase in question it made perfect sense in the
context in which it was written.
Is the next change to the manual going to remove the example in chapter
6.4.5 UPDATE Syntax which refers to age;
mysql UPDATE persondata SET age=age*2, age=age+1;
Can anyone tell me why I keep getting an ERROR 1064 with this command ?
I just would like to create a table with two fields, name and messages
for a
Simple guestbook but I want to store the data in a mysql database.
mysql CREATE TABLE info
- (
- name varchar(50)
- message
Can anyone tell me why I keep getting an ERROR 1064 with this command ?
I just would like to create a table with two fields, name and messages
for a
Simple guestbook but I want to store the data in a mysql database.
mysql CREATE TABLE info
- (
- name varchar(50)
- message
context ... I had proposed writing a new backend for mysql
tailored to read only very large and very wide (lots of columns)
tables (14G + )
in which queries never involved more than a small percentage
of the available columns (i.e. 5%) and often lacked WHERE
clauses.
A couple years ago I argued
Hi Insanely Great [EMAIL PROTECTED],
I'm not sure if you have checked the manual yet, but following
links seem to be somewhat related to your query:
* http://www.mysql.com/doc/en/Many_versions.html
This was an automated response to your email 'SQLyog 3.02 Released'.
Final search keyword
On Thu, Feb 06, 2003 at 10:03:18AM -0500, Hawk wrote:
Hi,
I am new to SQL. I am attempting to create a database that was created in
MS SQL to MySQL. The below SQL statements works with MS SQL.
MS SQL could refer to either Jet SQL or SQL Server SQL, but the SQL
below is obviously SQL
Not sure my other email got through, so here it is again, with an updated
description of the problem.
Hi,
I have a database with 3 names in it. In each of these names is 5
categories that have numbers in them. I want to be able to do a select and
total these numbers for each name, and then
Hi Oliver Schlag [EMAIL PROTECTED],
I'm not sure if you have checked the manual yet, but following
links seem to be somewhat related to your query:
* http://www.mysql.com/doc/en/Replication_FAQ.html
* http://www.mysql.com/doc/en/Replication.html
*
Dino,
to double click or run mysql.exe from the MS dos prompt. I get the
following message.
C:\mysql\binmysql
ERROR 2003: Can't connect to Mysql server on 'localhost' (10061)
Most probably your MySQL server isn't running.
Using Windows Explorer or a DOS window, cd to c:\mysql\bin and
Doug,
create table t1 ( id varchar(5) not null, name varchar(5) not null );
insert into t1 ( id ) values ( 1234 );
select count(*) from t1 where name = ;-- Result = 1
1) Why did the insert succeed since the name field is not null and I didn't
provide a value?
2) Why does
Lisi,
First, limiting the clicks: You didn't have any condition on click.date in
your suggested queries. You need to have one. Here's my suggestion,
somewhat modified. Note that the limit on click.date goes in the ON clause,
while the limit on display.date goes in the WHERE clause. Looks
Hawk [EMAIL PROTECTED],
Do you think the following links may help?
* http://www.mysql.com/doc/en/Using_mSQL_tools.html
* http://www.mysql.com/doc/en/Using_InnoDB_tables.html
This was an automated response to your email 'converting MS SQL to MySQL'.
Final search keyword used to
Take look at http://www.mysql.com/doc/en/CREATE_TABLE.html
[EMAIL PROTECTED] wrote:
Hi,
I am new to SQL. I am attempting to create a database that was
created in MS SQL to MySQL. The below SQL statements works with MS SQL.
I am executing the following:
CREATE TABLE 'Accounting'(
On Thursday 06 February 2003 17:05, Octavian Rasnita wrote:
Please tell me how can I sort a column and force placing the null values to
the end of list?
Something like:
SELECT ... ORDER BY IF(column_name IS NULL, 1, 0), column_name;
--
For technical support contracts, goto
Hi,
How can I fix an order by using numbers and letters ?
Id Town
56 Paris 1
60 Paris 10
7 Paris 11
262 Paris 12
8 Paris 13
16 Paris 14
22 Paris 15
6 Paris 3
57 Paris 4
51 Paris 6
5 Paris 7
61 Paris 8
59 Paris 9
I'd like to get :
56 Paris 1
6 Paris 3
57 Paris 4
51 Paris 6
5 Paris 7
61 Paris 8
Scott Wong [EMAIL PROTECTED],
Do you think the following links may help?
* http://www.mysql.com/doc/en/example-Foreign_keys.html
* http://www.mysql.com/doc/en/ANSI_diff_Foreign_Keys.html
* http://www.mysql.com/doc/en/ALTER_TABLE.html
*
41 matches
Mail list logo