hi...
if i process multiple subsequent sql where the later statements might be
dependent on the completion of the former/earlier sql statement, will this
cause a problem...
ie:
$dbh->do("SET AUTOCOMMIT=0");
eval
{
$dbh->do("insert into foo(Name,Vorname,Konto) values
('Ehmann','Andres',710235434)
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 in
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 get/lose
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
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 do
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
to
>
> > 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
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
> -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. wo
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:
d
-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/
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']);
$row10[
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 archiv
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
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.
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 r
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 ins
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
hi...
a basic select question/issue that should work
mysql> select * from instructorTBL;
++--++-+---++
| name | universityID | deptID | email | phone | ID |
++--++-+---+
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 1
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 second
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
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: Th
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 "
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 :)
--
MikeBlezien
=-=-=-=-=-=-=-=-=-=-=-=
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
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 transaction
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 INSER
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 r
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 PRO
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 lot
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 archives:
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 "
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 o
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 thre
-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, b
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 M
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
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
ex
Mitch,
- Alkuperäinen viesti -
Lähettäjä: "Mitch Pirtle" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
Kopio: <[EMAIL PROTECTED]>
Lähetetty: Monday, July 05, 2004 4:26 PM
Aihe: Re: InnoDB and long semaphore waits
> Heikki Tuuri wrote:
>
> >Mitch,
> >
> >please se
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
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 synt
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
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 in
44 matches
Mail list logo
