> 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 (Addison Wesley). I have no trouble under
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
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
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
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
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 "
You aren't making any mistakes, it's just not possible to do. You can't rely
on which row MySQL will return when using a GROUP BY clause.
The standard method would be to do something like this:
CREATE TEMPORARY TABLE mytemptable
SELECT max(myindex) as myindex, mycat
FROM `mytest`
Warren:
Yes and no. You can use Access as a "front end" to MySQL, including
creating forms and queries. If you want relational integrity you'll need to
handle that directly in MySQL (with "raw" SQL) or with a dedicated MySQL
designer tool (there are several available, both freeware and commercia
You should find the following informative:
http://www.mysql.com/doc/en/Table_types.html
InnoDB offers transaction support, and seems to recover better from
crashes. You do sacrifice some speed and features such as FULLTEXT index
support.
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Me
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 my
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
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
Sorry! I made a mistake here. I still have the questions below but my
problem with LOAD DATA is SOLVED! I made an editing mistake when updating
the my.cnf(my.ini) files.
- Original Message -
From: "Uriel Wittenberg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 10,
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
[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
>>mysql_uncomp.jar)
>>-- mm.mysql-2.0.10-you
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
>
>For JDBC driver to run with
# 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
34 matches
Mail list logo
