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;
- Origin
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 tab
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 P
data
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,
>
> > -Origi
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]>; &
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..
---
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
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"
&l
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.
(perl
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:
INSER
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:
T to get a value 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
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 requ
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
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
Does anyone know how to create a table that has two columns: databasename,
tablename that would list the databases and the tables in the databases? I
need to do this in a sql statement to create a reference table similar to
that of sysobjects in SQL Server or similar to the user_tables in Oracle
17 matches
Mail list logo
