On Sunday 04 July 2004 11:36 pm, bruce wrote:
hi...
i'm trying to figure out how to deal with joins
(left/right)..
i have the following test tbls...
create table universityTBL(
name varchar(50) not null default '',
ID int(10) not null auto_increment,
primary key
Hi,
I would like to use logrotate to manage the log files generated by MySQL.
I used the command mysqladmin flush-logs to close the log file. However,
the sql command displayed on the query log is Refresh.
According to the information from this forum, command flush logs should
be used instead
Hi,
I try to create with MySQL 4.0.18 a database with unicode as default character
set. So I use the command:
CREATE DATABASE db_name DEFAULT CHARACTER SET utf8;
I receive the message when i try this command:
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds
At 13:56 +0200 7/5/04, Pascal Francq wrote:
Hi,
I try to create with MySQL 4.0.18 a database with unicode as default character
set. So I use the command:
CREATE DATABASE db_name DEFAULT CHARACTER SET utf8;
I receive the message when i try this command:
ERROR 1064: You have an error in your SQL
Heikki Tuuri wrote:
Mitch,
please send the FULL .err log to me.
Hey Heikki,
Not sure you want that, the file is 44MB uncompressed, and only talks
about the errors reading communication packets. Makes for some really
boring reading ;) The InnoDB error I managed to figure out - I once
upped
Mitch,
- Alkuperinen viesti -
Lhettj: Mitch Pirtle [EMAIL PROTECTED]
Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED]
Kopio: [EMAIL PROTECTED]
Lhetetty: Monday, July 05, 2004 4:26 PM
Aihe: Re: InnoDB and long semaphore waits
Heikki Tuuri wrote:
Mitch,
please send the FULL .err log
Heikki Tuuri wrote:
Not sure you want that, the file is 44MB uncompressed, and only talks
about the errors reading communication packets. Makes for some really
boring reading ;) The InnoDB error I managed to figure out - I once
upped max_connections without doing the math, and the machine was
Hi people
I'm facing a (not huge) problem with mysqlimport.
The mysql version I'm using is MySQL
4.0.11a-gamma'-Max'
For updating a #29000 records table from fixed-lenght
ASCII file, I'm using a php script that gets a record
and executes and UPDATE for each one: pretty SLOW.
SO I read carefully
Hi
We have changed all our tables to InnoDB and now the server is not able to
handle the load, even when we are not running the SELECTs statements against
these tables yet.
As I mentioned in my email we make a lots of INSERTS and UPDATES in these
tables (more than 3000 per second). So far using
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
To MySQL staff and developer's team:
At
http://www.ngn.euro6ix.org/IPv6/mysql
you will find a patch to make the last stable version on MySQL, (4.0.8)
ready to run on the new protocol IPv6.
Far from forking the main line of MySQL development,
my test tbls
cattbl dogtbl birdtbl
namename name
id --- catid --- dogid
id id
so
dogtbl.catid = cattbl.id
birdtbl.dogid = dogtbl.id
my question is how i can use left joins to produce the results set with the names of
all three
At 12:03 -0300 7/5/04, j llarens wrote:
Hi people
I'm facing a (not huge) problem with mysqlimport.
The mysql version I'm using is MySQL
4.0.11a-gamma'-Max'
For updating a #29000 records table from fixed-lenght
ASCII file, I'm using a php script that gets a record
and executes and UPDATE for each
On Monday 05 July 2004 12:28 pm, bruce wrote:
my test tbls
cattbl dogtbl birdtbl
namename name
id --- catid --- dogid
id id
so
dogtbl.catid = cattbl.id
birdtbl.dogid = dogtbl.id
my question is how i can use left joins to
Hello all,
I have a datatype question.
When there is column named ID, users are able to give it either char(11)
or int(11).
Please advise, which type is better such as more secure, save space,
etc? Or it dose not matter at all?
Kind regards,
Ying
--
MySQL General Mailing List
For list
On Mon, 5 Jul 2004 16:07:58 +0100 , Javier Diaz [EMAIL PROTECTED] wrote:
We have changed all our tables to InnoDB and now the server is not able to
handle the load, even when we are not running the SELECTs statements against
these tables yet.
As I mentioned in my email we make a lots of
You only need to specify from tabel on the first table. Like this.
select
cattbl.name as cat, dogtbl.name as dog, birdtbl.name as bird
from dogtbl
left join cattbl on cattbl.id=dogtbl.catid
left join birdtbl on birdtbl.dogid=dogtbl.id;
-Eric
On Mon, 5 Jul 2004 09:28:02 -0700, bruce [EMAIL
Hi
I really don't like the idea to set innodb_flush_log_at_trx_commit to 2, the
information in these tables is important. On the other hand there is nothing
I can do from the point of view of the number of transactions. Each process
run its own set of INSERTs and UPDATEs statements, so I can not
At 18:48 +0100 7/5/04, Javier Diaz wrote:
Hi
I really don't like the idea to set innodb_flush_log_at_trx_commit to 2, the
information in these tables is important. On the other hand there is nothing
I can do from the point of view of the number of transactions. Each process
run its own set of
On Mon, 5 Jul 2004 18:48:50 +0100 , Javier Diaz [EMAIL PROTECTED] wrote:
I really don't like the idea to set innodb_flush_log_at_trx_commit to 2, the
information in these tables is important. On the other hand there is nothing
I can do from the point of view of the number of transactions.
On Monday 05 July 2004 12:54 pm, Ying Lu wrote:
Hello all,
I have a datatype question.
When there is column named ID, users are able to
give it either char(11) or int(11).
Please advise, which type is better such as more
secure, save space, etc? Or it dose not matter at
all?
It depends
Hello,
what is the most effecient way to query the last record in a table, if querying
the primary key(acctid) column ??
I've tried select *,max(acctid) as lastid from subscribers where acctid =
'lastid' group by acctid
but this returns nothing ??
TIA :)
--
MikemickaloBlezien
At 13:52 -0500 7/5/04, Mike Blezien wrote:
Hello,
what is the most effecient way to query the last record in a table,
if querying the primary key(acctid) column ??
What do you mean by last? The row containing the largest acctid value?
You might try ... ORDER BY acctid DESC LIMIT 1.
I've tried
cancel this, found my problem :) this query worked:
SELECT * FROM subscribers ORDER BY acctid DESC LIMIT 1
Original Message
Subject: Query last record in table
Date: Mon, 05 Jul 2004 13:52:28 -0500
From: Mike Blezien [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Organization:
Hi Tia,
I'm not sure, but my old SQL trick was to do a select * top 1 from
subscribers order by acctid desc
Scotty.
-Original Message-
From: Mike Blezien [mailto:[EMAIL PROTECTED]
Sent: July 5, 2004 2:52 PM
To: MySQL List
Subject: Query last record in table
Hello,
what is the most
Javier Diaz wrote:
Hi
We have changed all our tables to InnoDB and now the server is not able to
handle the load, even when we are not running the SELECTs statements against
these tables yet.
As I mentioned in my email we make a lots of INSERTS and UPDATES in these
tables (more than 3000 per
Hi,
I have this pretty complex query which uses two temporary tables.
The first temporary table ( T1 ) is created as a result from query 'A'
The second temporary table is created as result from a query based upon
temporary table one ( T1 ). At this point I get the message
ERROR
hi...
a basic select question/issue that should work
mysql select * from instructorTBL;
++--++-+---++
| name | universityID | deptID | email | phone | ID |
Hi,
I have the following tables in my database for proxy logs. I have broken
down the URL for each line into the following 4 tables:
url_schemes e.g. http
url_serverse.g. www.google.com
url_paths e.g. /search
url_queriese.g q=searchstring
To get a list of the websites a user has
Possibly because, if there is no typo, your table's name field is:
dr. smith1 (note the period after dr)
But your query is looking for
dr smith1
Does that fix it for you?
Wes
On Jul 5, 2004, at 4:18 PM, bruce wrote:
hi...
a basic select question/issue that should work
mysql select * from
Hi,
Is MySQL Cluster Aware?
Thanks
Quentin
The information contained in this email is privileged and confidential and
intended for the addressee only. If you are not the intended recipient, you
are asked to respect that confidentiality and not disclose, copy or make use
of its contents. If
Hi,
Can you use IF?
SELECT iu.time as time, INET_NTOA(iu.ip) as ip,
concat(usc.scheme,://,us.server,up.path, if(uq.query= ,,concat(?,uq.query)))
as url,uc.category as
HTH
Quentin
From: J S [mailto:[EMAIL PROTECTED]
Sent: Tue 6/07/2004 8:22 a.m.
To:
At 17:10 -0700 7/5/04, Mauricio Pellegrini wrote:
Hi,
I have this pretty complex query which uses two temporary tables.
The first temporary table ( T1 ) is created as a result from query 'A'
The second temporary table is created as result from a query based upon
temporary table one ( T1 ). At
So now that I know that there's no place around to take courses and where to
take the exam I've decided to teach myself and I have two quick questions.
1. what do I need to know for the exams?
2. would it be better to practise on a UNIX-bases system?
--
MySQL General Mailing List
For list
Hi there,
I am having trouble converting a timestamp from mySQL to the US Format mm/dd/.
Can someone please help. I am also having trouble converting -mm-dd into a normal
mm/dd/ format as well.
I am using the following line of code:
date('m/d/Y', $row10['modified']);
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 05 July 2004 06:07 pm, Gary Mack wrote:
Hi there,
I am having trouble converting a timestamp from mySQL to the US Format
mm/dd/. Can someone please help. I am also having trouble converting
-mm-dd into a normal mm/dd/
Gary Mack wrote:
Hi there,
I am having trouble converting a timestamp from mySQL to the US Format mm/dd/. Can someone please help. I am also having trouble converting -mm-dd into a normal mm/dd/ format as well.
Normal format *is* -mm-dd.
I am using the following line of code:
-Original Message-
From: Levi Campbell [mailto:[EMAIL PROTECTED]
1. what do I need to know for the exams?
I'm trying to keep this in mind,
http://www.mysql.com/training/certification/candguide/, while I use the
My SQL Certification Study Guide by DuBois, Hinz and Pedersen.
2. would
Gary:
Am I looking at PHP's date() function? You are taking a timestamp
from a MySQL table and wanting to convert it into a US format. Is the
timestamp stored in your MySQL table a Unix timestamp or a MySQL
timestamp?
It's important to note that you can't take a MySQL timestamp and use
PHP's
Hi there,
I am having trouble converting a timestamp from mySQL to the US Format
mm/dd/. Can someone please help. I am also having trouble
converting -mm-dd into a normal mm/dd/ format as well.
A bit off-topic but,
if you are able to use Perl anytime during your
Hi,
i created a database with around 20 tables. However i
created the tables by script writting all create table
statements, create constraints, etc...
I need now a Entity Relationship diagram so i have a
visual information about my database.
I tried MySQL Comand Center but i doens't have such
Leandro Melo wrote:
Hi,
i created a database with around 20 tables. However i
created the tables by script writting all create table
statements, create constraints, etc...
I need now a Entity Relationship diagram so i have a
visual information about my database.
I tried MySQL Comand Center but i
Hi,
1. What is the difference between GROUP BY and DISTINCT in the background
engine? How MySQL treats each one of them?
2. Why GROUP BY statement ALWAYS uses a temporary file???
3. Why using LIMIT with a GROUP BY statement takes about the same time as
without using LIMIT?
any answer would be
i'm considering a situation where i need to update a group of tables with
data. i'd like to be able to either add all the data to all the tables, or
to add none, and report an error.
mysql/google indicates that this is possible if i use a table type=bdb...
i'm trying to understand what i
Bruce,
i have two hypothetical tables
create table owner (
- name char(20) ,
- ownerid int(10) auto_increment primary key);
create table dog (
- name char(20) ,
- ownerid int(10),
- dogid int(10) auto_increment primary key);
i'm curious as to how i'd go about inserting a
44 matches
Mail list logo