> Date: Sat, 16 May 2009 15:39:56 -0700
> From: davidmichaelk...@gmail.com
> To: mysql@lists.mysql.com
> Subject: Confused about syntax for specific join with 3 tables
>
> I've been doing some experimenting with the data model from the "MySQL"
> book
I've been doing some experimenting with the data model from the "MySQL"
book (Addison Wesley). I have no trouble understanding joins between
two tables, but I'm finding it's a little confusing when 3 or more
tables are involved. I'm going to cite a particular set of tables and a
specific quer
It's not skipping any rows. When you select records from a database,
it gets them in the order that is quickest to retrieve them, not the
order they were entered. The "natural" order is how they are stored on
disk. As your database is updated over time, this order may change.
If you have an a
Hi folks,
I'm trying to use MySQL Migration Toolkit 1.1 with MS SQL server 2005
http://dev.mysql.com/downloads/gui-tools/5.0.html
- basically all is working great - some tables import no problem - except...
I'm trying to import an address table and in the summary it says that
there's a few probl
My web server is running drupal. Yesterday it started giving error messages
instead of displaying the hom page. The error says, "The MySQL error was:
Host 'web1.math.wisc.edu' is blocked because of many connection errors;
unblock with 'mysqladmin flush-hosts'."
I want to find out why that happ
in your data file use this for inserting null values '\N'
0.12345;qwer
1.2345;\N
\N;asdf
On 7/17/08, Gilles MISSONNIER <[EMAIL PROTECTED]> wrote:
>
> Hello,
>
> I do not understand the behavior of a simple table :
> from what I red, in the following exemple the Null column tells the value
> can
Hello,
I do not understand the behavior of a simple table :
from what I red, in the following exemple the Null column tells the value
can be set to NULL, and the Default value is NULL.
It doesn't seem to work that way.
Some one could explain it ?
I run on a linux debian/etch 5.0.32 MySQL relea
I assume each part can be associated with multiple projects, which is
a many to many relation. In that case you need to create a "join"
table that holds the relation. Table like that are typically just 2
fields, one for the project id and one for the part id. You may want
to add other field
lets say u have a table called Parts and another called Projects ,,,
how can u associate the Parts Table with the Projects table so lets say
u wanna add a Specific Part to a project maybe even add three parts
from the parts table and associate it with a specific project ???
so maybe u would
I would say caching, on multiple levels (CPU, DB, File System). By
splitting at least some of the load, it's possible for parts of the
cache to become old and get flushed. When everything is on one
machine, the box has a complete picture of the traffic patterns and
can optimize better.
A puzzler for you guys.. all plausible explanations (and suggestions
for proving them) gratefully received.
We run several MySQL database servers in the traditional master-slave
configuration and attempt (rather poorly) to spread select queries
between them. Normally the slave gets 1/3 o
On Thursday 07 December 2006 10:09, Ed wrote:
> Hi all,
> I need a database that is able to handle french characters.
Sorry about that, it's probably due to my OS rather than MySQL.
$ echo "Fête"
Fête
$ touch Fête
$ ls -l
-rw-r--r-- 1 me me 0 Dec 7 14:20 F?te
$ rm Fête
Hmmm, ba
Hi all,
I need a database that is able to handle french characters. I read the "Mysql
Reference Manual" and have done the following in a table to test the
different results but I wasn't successful which leads me to believe I am
doing something wrong... and yes, I'm a noob. ;)
CREATE TABLE comp
Patrick,
>Shouldn't I be getting back a '1' when I do my select???
>Why am I getting an empty set?
First, creating a table doesn't add any rows. Show Create Table ...
returns a row of data definition info, not a row of table data.
Second, Defining the column as NOT NULL will require numeric
Patrick Duda <[EMAIL PROTECTED]> wrote on 02/21/2006 02:39:47 PM:
> Why, when I create a table as follows:
>
> mysql> create table requestid ( request_id int not null default
> 1, constraint requestid_innodb_pk_cons primary key(request_id) )
> ENGINE=InnoDB;
> Query OK, 0 rows affected
On Tue, 21 Feb 2006, Patrick Duda wrote:
> Why, when I create a table as follows:
>
> mysql> create table requestid ( request_id int not null default 1,
> constraint requestid_innodb_pk_cons primary key(request_id) ) ENGINE=InnoDB;
> Query OK, 0 rows affected (0.02 sec)
Defines the propertie
Why, when I create a table as follows:
mysql> create table requestid ( request_id int not null default
1, constraint requestid_innodb_pk_cons primary key(request_id) )
ENGINE=InnoDB;
Query OK, 0 rows affected (0.02 sec)
Do I get the following?
mysql> select request_id from requestid
Chris et al -
The MySQL online manual does show *.* to be used for global priviledges,
but my MySQL book only used the *. My mistake! However, the online
manual does not indicate (or I am missing it) what the use of * grants.
Thank you for the help...it is now working and my DB, "sfyc" does
Hello.
> grant all on * to todd identified by 'my_password' with grant option;
May be you wanted '*.*' instead of '*'? See:
grant all on *.* to todd identified by 'my_password' with grant option;
> mysql -u todd -p sfyc
You should specify the database name not a table name ('sfy
Did you run the statement witht he mysql database as the current
database? If so , you're statement probably got converted to this:
grant all on mysql.* to todd identified by 'my_password' with grant option;
It seems like a logical thing
The grant statement applying to all databases/tables sho
I have created a table, "sfyc" and as root I issued the following:
grant all on * to todd identified by 'my_password' with grant option;
However, "todd" cannot access "sfyc" with
mysql -u todd -p sfyc
And the mysql db contains the following:
user table
+---+--+
| host | user
Peter
>How do i go about saving data to multiple tables from
>one entry form or should this happen automatically
If the model is that a user can have radios which in turn can have
events,
you need a userid column in users and radios, and a radioid column in
radios and events. You need to re
Hi folks
I have several small data bases running on mysql 4.1.13 no problem brought a
book read it yes well
i have a data base consisting of 3 tables , radios , users , events
radios contains 4 fields csgn , setid , sernum cmmnts. this is populated and
is more a lookup table for the radio
I am having trouble with this small bit of sql I am using for a
homepage.
I need to select information on the next two events from two
separate tables; tblevents (which holds event related info), and
tbleventdate (which holds info related to each date, including times and
informatio
I am having trouble with this small bit of sql I am using for a
homepage.
I need to select information on the next two events from two
separate tables; tblevents (which holds event related info), and
tbleventdate (which holds info related to each date, including times and
informatio
Wrong path, you are referring to an uri, not a path. Way off topic to
starting explaining basic file system stuff here.
You should be the same path you used when your uploaded the
file. Something like:
/home/chris/datafile.txt
Frank
At 10:06 PM 6/7/05, Chris wrote:
Well, in fact
Well, in fact I have read the documentation several times before posting
this note.
My problem arises because I don't know what is meant by full file path. If
you mean: 'http://www.mydomain.com/datafile.txt' that produces the error:
Can't get stat of 'http:/www.mydomain.com/datafile.txt' (Errcode:
yes he is right i am doing the same. and giving full path. i have other
problems with load data infile :(
- Original Message -
From: "Frank Bax" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, June 08, 2005 1:39 AM
Subject: Re: LOAD DATA INFILE - still confused
> At 03:
At 03:59 PM 6/7/05, Chris wrote:
I have a simple php script which runs the following query:
LOAD DATA INFILE 'datafile.txt' INTO TABLE LocationTEMPSR12 FIELDS
TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'
which generates the error:
File './mydabasename/datafile.txt' not found (E
I have a simple php script which runs the following query:
LOAD DATA INFILE 'datafile.txt' INTO TABLE LocationTEMPSR12 FIELDS
TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'
which generates the error:
File './mydabasename/datafile.txt' not found (Errcode: 2)
The simple php script an
Hello.
Yes. See a long discussion at:
http://bugs.mysql.com/bug.php?id=6511
"Thomas van Gulick" <[EMAIL PROTECTED]> wrote:
> Try this:
>
> Setup a database server, with MySQL 4.1, with query cache turned on
>
> Setup a client machine with MySQL 4.0
> Setup a client machine with M
Try this:
Setup a database server, with MySQL 4.1, with query cache turned on
Setup a client machine with MySQL 4.0
Setup a client machine with MySQL 4.1 (libmysqlclient14)
Create very simple table
: CREATE TABLE woepwoep (CNT int NOT NULL);
Insert single row
: INSERT INTO woepwoep SET CNT=10;
Hello list,
I have already installed mysql 4.1.3 beta to my
windows xp. I set default-caharacter-set to latin5 and
default-collation to latin5_turkish_ci in my.ini
configuration file. Because I want latin5 my default
character set. Then I restarted mysql service and
looked up character set and col
lto:[EMAIL PROTECTED]
Sent: Wednesday, April 21, 2004 1:46 PM
To: Chris
Cc: [EMAIL PROTECTED]
Subject: Re: Confused by max and group by
This seems bizarre. Although I am the SQL neophyte and it is perhaps not
my right to whine about the mysteries of SQL, but this seem very surprising
and nonint
The problem you are running into is that you are getting the max of one
field and grouping by another. But then you want to get a third field
that changes within the grouping.
Perhaps this might work
SELECT myindex, myval, mycat
FROM `mytest`
GROUP BY mycat
ORDER BY myindex DESC;
I think what is happening is that you are getting the max value for one
field, but the "first" values for the other fields. Try ordering you
group by:
SELECT max(myindex), myval, mycat
FROM `mytest`
GROUP BY mycat DESC;
On Apr 21, 2004, at 1:35 PM, Noah Spurrier wrote:
I'm having trouble with "
ROTECTED]
Sent: Wednesday, April 21, 2004 10:35 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Confused by max and group by
I'm having trouble with "max()" and "group by".
It seems pretty simple. I hope someone can point out my mistake.
I want to
I'm having trouble with "max()" and "group by".
It seems pretty simple. I hope someone can point out my mistake.
I want to select the max index of a group.
In other words, I want to find the last record added for each group.
The problem I'm having is that the columns of the resulting rows
are mix
Judging from the times on the clock (03:00 to 07:00) I would guess that the
server on which MySQL is running is doing some scheduled activity. Cron jobs
for backup, slocate updates, security checks, etc. MySQL doesn't do
scheduled maintenance, especially not for four hours.
j- k-
On
Here is a log of query times I made when a certain page is loaded that uses
php and mysql, does mysql 4 do some sort of scheduled maintenance I am not
aware of?
2004/03/08 16:11:27OK, 77569 bytes0 seconds
2004/03/08 16:11:37OK, 77575 bytes0 seconds
2004/03/08 16:13:31OK, 77569
Thanks for the reply!! IndeedI am using version 3.23.58. I can
stop pounding my head against the wall now. Thanks again!!
*** REPLY SEPARATOR ***
On 2/19/2004 at 2:10 AM Jeremy March wrote:
>http://www.mysql.com/doc/en/UPDATE.html
>
>I believe multi-table updates weren
http://www.mysql.com/doc/en/UPDATE.html
I believe multi-table updates weren't supported until MySQL version
4.04. Are you using a version earlier than this?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am truly frustrated with what should be a simple update. Any help to
enlighten this newbie is appreciated.
[TABLE A] tdmr_dmr
dmr_customer_code
dmr_job_number_code
[TABLE B] tjl_job_list
jl_customer_code
jl_jobnumber
In Table A, the dmr_customer_code fie
s-through queries (more effort, better
performance). Someday soon (hopefully ;-) you'll be able to use stored
procedures.
Hope this helps,
John Hopkins
Hopkins IT
-Original Message-
From: Warren Stanley [mailto:[EMAIL PROTECTED]
Sent: Sunday, October 05, 2003 4:48 PM
To: [EMAIL PROTECT
Hi guys n gals
OK MySQL is nice and robust, i'm stiil new to it and have an "M$ Access" mentality
when it come to buiding and working with DBs.
Can i build an "example_client" table and an "example_appointment" table in MySQL and
then use M$ Access(odbc) or "data sources" in Open Office to crea
PAUL MENARD wrote:
Hello All,
I'm having trouble understanding the MySQL docs on how to subtract two DATETIME values. I have two tables that have a DATETIME column. In my SELECT I am doing a JOIN to bring in both sets of rows. What I want is to subtract the DATETIME values to determine the number
Hello All,
I'm having trouble understanding the MySQL docs on how to subtract two DATETIME
values. I have two tables that have a DATETIME column. In my SELECT I am doing a JOIN
to bring in both sets of rows. What I want is to subtract the DATETIME values to
determine the number of seconds betw
John Wards wrote:
I have this query:
SELECT *
FROM news_category
LEFT JOIN news_x_cat ON news_category.id = news_x_cat.cat_id
WHERE (
news_x_cat.news_id = 9 OR news_x_cat.news_id IS NULL
)
Which gives me this output:
id title perm show news_id cat_id
1 About Us 1
I have this query:
SELECT *
FROM news_category
LEFT JOIN news_x_cat ON news_category.id = news_x_cat.cat_id
WHERE (
news_x_cat.news_id = 9 OR news_x_cat.news_id IS NULL
)
Which gives me this output:
id title perm show news_id cat_id
1 About Us 1 1NULL
You have not shown us anything that would indicate that your output is
not correct.
If you think something is missing you have to show us what is missing,
and why you think
it should not be.
John Wards wrote:
I have this query:
SELECT *
FROM news_category
LEFT JOIN news_x_cat ON news_category.
nal Message-
> From: PAUL MENARD [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 24, 2003 2:51 PM
> To: [EMAIL PROTECTED]
> Subject: Confused about MyISAM vs InnoDB tabel types
>
>
> Can anyone either summarize for me a comparison between the
> MyISAM and InnoDB My
Can anyone either summarize for me a comparison between the MyISAM and InnoDB MySQL
table type?
I am getting ready to upgrade from MySQL 3.23.42 to 4.0.13 in the coming week and
started reading the upgrade documents on the www.mysql.com site. Never had even
thought about using another table t
Hi,
On Thu, Mar 27, 2003 at 05:35:22PM -0500, Gary Huntress wrote:
> > >I have noticed on many occasions some extensive traffic on my internal
> > >network that I cannot explain. Below you will see two sets of tcpdump
> > >traces. I have a mysql server running on my internal host named
> > >"h
Hi,
On Thu, Mar 27, 2003 at 02:28:37PM -0500, Gary Huntress wrote:
> I have noticed on many occasions some extensive traffic on my internal
> network that I cannot explain. Below you will see two sets of tcpdump
> traces. I have a mysql server running on my internal host named
> "herzegbol" an
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Gary Huntress" <[EMAIL PROTECTED]>
Sent: Thursday, March 27, 2003 4:33 PM
Subject: Re: Confused about network traffic on mysql port
> >I have noticed on many occasions some extensive
pers
Visit http://www.freesql.org
- Original Message -
From: "GERST, MICHAEL (SBCSI)" <[EMAIL PROTECTED]>
To: "'Gary Huntress'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, March 27, 2003 4:44 PM
Subject: RE: Confused about network t
Somebody got control of mysql, or your rooted?
-Original Message-
From: Gary Huntress [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 27, 2003 1:29 PM
To: [EMAIL PROTECTED]
Subject: Confused about network traffic on mysql port
I have noticed on many occasions some extensive traffic on
On Thu, Mar 27, 2003 at 02:28:37PM -0500, Gary Huntress wrote:
> I have noticed on many occasions some extensive traffic on my internal
> network that I cannot explain. Below you will see two sets of tcpdump
> traces. I have a mysql server running on my internal host named
> "herzegbol" and a w
I have noticed on many occasions some extensive traffic on my internal
network that I cannot explain. Below you will see two sets of tcpdump
traces. I have a mysql server running on my internal host named
"herzegbol" and a windows 98 host named shelbyville
This trace is when the MySQL server i
Hi There,
In my ongoing project one of my application is
building reports and Printing them from a Remote
access Machine..
Actually i have done the whole project in ASP, IIS,
Access-2000. but the problem is IIS has Restricted
number of users(10) on WIN 2000 prof.
So, instead of buying an MS Serve
At 23:52 +0800 9/10/02, Uriel Wittenberg wrote:
> >If mysql works fine, then you've already started the server.
>
>Then does a normal Windows installation set it up so the server autostarts
>whenever you boot up? I did not manually start the server.
It might be installed as a service.
> >You h
>If mysql works fine, then you've already started the server.
Then does a normal Windows installation set it up so the server autostarts
whenever you boot up? I did not manually start the server.
>You have to restart the server before it will notice the [mysqld] option
group change.
After I add
Tuesday, September 10, 2002 11:37 PM
Subject: Confused, discombobulated, weirded out, upset! --Windows standalone
user
I seem to have a version problem. I'm using v. 3.23.51 on a Windows
standalone system -- there is no network here. *ALL I want* is to run MySQL
standalone on this machine.
At 23:37 +0800 9/10/02, Uriel Wittenberg wrote:
>I seem to have a version problem. I'm using v. 3.23.51 on a Windows
>standalone system -- there is no network here. *ALL I want* is to run MySQL
>standalone on this machine. So do I need to "start the server"? MySQL seems
>to mostly work fine if I j
I seem to have a version problem. I'm using v. 3.23.51 on a Windows
standalone system -- there is no network here. *ALL I want* is to run MySQL
standalone on this machine. So do I need to "start the server"? MySQL seems
to mostly work fine if I just go and do:
C:\mysql\bin> mysql
without "starti
On Tuesday 20 August 2002 01:26 pm, Randy Johnson wrote:
> I am confused. (innodb table type)
I'm really not so sure about the 'lock in share mode' thing, but to the best
of my knowledge if you do a
SET TRANSACTION_ISOLATION_LEVEL=SERIALIZABLE
and then start a transaction w
I am confused. (innodb table type)
Client 1.
starts transaction
selects balance from table where id=1 for update
update table set balance=100
#At this point from what i have read the balance could be selected by anther
user.
committ
I have read that a select balance from table where id=1
[database,sql,query,table]
Mark Matthews wrote:
> Or download version 2.0.11 released today which fixes that bug (as far as
> I can tell):
Absolutely. Quick work, indeed. I've already switched over to 2.0.11 and
it's been smooth.
Thanks for the fantastic support!
--
Shankar.
--
Shankar Unni wrote:
> That's right:
> Do the following in a temp directory:
> jar xvf mm.mysql-2.0.10-you-must-unjar-me.jar
> This will create a directory called mm.mysql-2.0.10. Inside that, you'll
> find a mm.mysql-2.0.10.jar file, which is what you need to put in your
> classpath (you can
Paul DuBois wrote:
> I think that MM.MySQL used to be packaged as a tar file, but not is
> distributed
> as a JAR. Use the newer one, you'll be better off. And do as the filename
> indicates: un-jar it. You'll end up with a directory that contains the
> actual driver file plus a bunch of othe
At 16:11 -0600 1/25/02, Paul DuBois wrote:
>At 16:59 -0500 1/25/02, Rahadul Kabir wrote:
>>I'm a bit confused here. can some please tell me what is the difference
>>between this two files
>>
>>-- mm.mysql.jdbc-1.2c.tar.gz ( Includes mysql_comp.jar and
>>
At 16:59 -0500 1/25/02, Rahadul Kabir wrote:
>I'm a bit confused here. can some please tell me what is the difference
>between this two files
>
>-- mm.mysql.jdbc-1.2c.tar.gz ( Includes mysql_comp.jar and
>mysql_uncomp.jar)
>-- mm.mysql-2.0.10-you-must-unjar-me.jar
>
&g
I'm a bit confused here. can some please tell me what is the difference
between this two files
-- mm.mysql.jdbc-1.2c.tar.gz ( Includes mysql_comp.jar and
mysql_uncomp.jar)
-- mm.mysql-2.0.10-you-must-unjar-me.jar
For JDBC driver to run with mysql which one do I need? I thought you
only
Hi,
I've just downloaded and install mySQL on my server but only seem able to
connect to the server across my network if the server is connected to the
internet. Any ideas why and how to stop it. btw I'm running windows.
TIA
Alex
---
ich table? I would assume the
> users table?
>
> -Original Message-
> From: Roman Festchook [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 29, 2001 10:05
> To: Peter Moscatt; MySQL List
> Subject: Re: Setting User Privilges ? Confused !!
>
>
> By default
List
Subject: Re: Setting User Privilges ? Confused !!
By default you have record for anonimous user with any name and no pass in
your access tables, thats lock access any other user from localhost with
password to database. Just delete this anonimous user from mysql access
tables
On Wed 29
By default you have record for anonimous user with any name and no pass in
your access tables, thats lock access any other user from localhost with
password to database. Just delete this anonimous user from mysql access tables
On Wed 29 Aug 2001 13:08, Peter Moscatt wrote:
> I am pretty new to
I am pretty new to MySQL, in fact that also covers Linux as well.
I have Mandrake 8.0 which I have installed MySQL using the RPM format.
I plan to write code (python) to access the database to manage what
data it may hold.
The server automatically starts on boot - which is fine.
To be able t
# find /usr -name gcc
/usr/local/bin/gcc
# echo $PATH
/sbin:/usr/sbin:/usr/bin:/usr/ccs/bin:/usr/bin/X11:/usr/local:/usr/local/bin
It seems to find gcc for the CC compiler though, and that part of the configure works.
"Matthew P. Marino" wrote:
> OK. Much better. The configure can't find gcc.
g++ works in the configure stage, but then when I do the gnumake using g++ I get
the following error:
g++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/usr/local/mysql
\"" -DDATADIR="\"/usr/local/mysql/var\"" -
DSHAREDIR="\"/usr/local/mysql/sha
On Fri, Mar 02, 2001 at 11:30:31AM -0500, Terry Babbey wrote:
> Here is my configure statement and the generated error message ( I am using
> GCC2.95.2):
>
> CC="gcc" CXX="gcc" ./configure --prefix=/usr/local/mysql
Have you tried CXX="g++"? The C++ compiler of the GNU Compiler Suite
is g++, you
Here is my configure statement and the generated error message ( I am using
GCC2.95.2):
CC="gcc" CXX="gcc" ./configure --prefix=/usr/local/mysql
checking whether the C++ compiler (gcc ) works... no
configure: error: installation or configuration problem: C++ compiler cannot cre
ate executables
I notice some of you compile with gcc as you C-compiler (CC) and
C++-compiler (CXX). Configure generates an error message for me when I
try to do this. Can anyone help me with this?
Thanks,
Terry
--
__
Terry Babbey
Technical Support
83 matches
Mail list logo
