Depends. If this is a correlation table and the combined columns are a
primary key,
SELECT ObjId,
COUNT(ElemId)
FROMElems
GROUP BY ElemId;
if the combination is not unique, then:
SELECT ObjId,
COUNT(DISTINCT ElemId)
FROMElems
GROUP BY ElemId;
-
Have you looked at cron on LINUX?
- Original Message -
From: Jamie Buck [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 04, 2002 11:37 AM
Subject: Is it possible to have MySQL perform an action at a specifictime?
I have a file containing commands to add and drop tables as
If the snippet is copied directly out of your code, are you missing a single
quote before:
$link_glob
$result = mysql_db_query('$db_glob', '$query', $link_glob');
- Original Message -
From: Jule Slootbeek [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 03, 2002 5:09 PM
I have a question about MyODBC and the results of SQLGetTypeInfo from a
table with a column of type TEXT. The results show that the column is of
type VARCHAR with a length of 255. Is there a way to show the true
datatype? The MySQL that I'm running is 3.23.36.
SQL question..
So what is the best way to store information in a MySQL database through
MyODBC that is of a character type that is greater that 255 chars? BLOB?
- Original Message -
From: Venu [EMAIL PROTECTED]
To: 'David M. Peak' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, April 30, 2002 2
greater than 255?
- Original Message -
From: Venu [EMAIL PROTECTED]
To: 'David M. Peak' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, April 30, 2002 2:45 PM
Subject: RE: MyODBC Question
Hi,
-Original Message-
From: David M. Peak [mailto:[EMAIL PROTECTED]]
Sent: Tuesday
If you only want it ascending, take out the DESC as in:
$query = SELECT * FROM gigs WHERE date '$today' ORDER BY date ASC LIMIT
3;
- Original Message -
From: David Rice [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 28, 2002 12:19 PM
Subject: Queries help (part II)
Well I was able to fix the problem by doing a Select into Outfile and
specifying in my select list and using IF...
thanks
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: David M. Peak [EMAIL PROTECTED]; MySQL List
[EMAIL PROTECTED]
Sent: Thursday, March 21, 2002 4:24 PM
Is there a way to tell MySQL to put a blank space instead of \N in the
tab-delimited files when it does a dump? I'm working on a MySQL to SQL
Server migration and having problems with the output files. I'm doing this
all in batch fellas so I'm not finding a good search and replace utility.
ok, more specific:
here is a table:
CREATE TABLE FOO (foo1 int NOT NULL, foo2 int NOT NULL Default 1)
If I do an insert into the FOO table with the following:
INSERT INTO FOO (foo1,foo2) VALUES (1,1)
Everything works as planned.
If I do an insert into the FOO table with the following:
Beings as I haven't gotten an answer to this, is there a better place to
find information on this?
- Original Message -
From: David M. Peak [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Friday, March 08, 2002 1:03 PM
Subject: Re: Changing Default for Not Null to NOTHING
I
if it is left out of an
insert statements list of column/value set.
Does this make sense??
- Original Message -
From: David M. Peak [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Thursday, March 07, 2002 9:22 AM
Subject: Changing Default for Not Null to NOTHING
Is there a way for me
Is there a way for me to NOT have a default value for a column in a table
that I define as NOT NULL?
EXAMPLE SQL:
mysql CREATE TABLE FOO (foo1 int NOT NULL);
Query OK, 0 rows affected (0.05 sec)
mysql DESCRIBE FOO;
+---+-+--+-+-+---+
| Field | Type| Null |
is there a max row length for MyISAM tables? I'm having a hard time finding
it.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
Don't forget to ensure that the account that the mysqld is running under has
the proper permissions to the new directory. I ran into that one before..
- Original Message -
From: Matthew Smith [EMAIL PROTECTED]
To: 'MySQL' [EMAIL PROTECTED]
Sent: Tuesday, December 18, 2001 10:24 AM
try:
mysqladmin -u root password new_password_here
- Original Message -
From: Jeremiah Jester [EMAIL PROTECTED]
To: 'MySQL' [EMAIL PROTECTED]
Sent: Tuesday, December 18, 2001 10:50 AM
Subject: mysql password
Im attempting to install mysql. The service started and everything seems
to
16 matches
Mail list logo