Actually, blobs are stored in files in data directory. You can store your
binary files in data directory, if you wish.
- Original Message -
From: Gerald R. Jensen [EMAIL PROTECTED]
To: clay bond [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, February 17, 2001
Did you try
select count(*), sum(amount) from table1;
you also can use
... count(if(field=value,1,NULL)) ...
- Original Message -
From: jerome auza [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 14, 2001 2:49 AM
Subject: Help please: getting the total from the results
My Outlook Express 5.0 shows that message have attachments, but it doesn't.
- Original Message -
From: Maciek Uhlig [EMAIL PROTECTED]
To: Carsten Gehling [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, February 14, 2001 1:22 AM
Subject: RE: Here you have, ;o)
Isn't it possible
I suppose that only way to reorganize unique field is to use another table.
- Original Message -
From: Irmund Thum [EMAIL PROTECTED]
To: Rus [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, February 13, 2001 8:53 AM
Subject: Re: mysqlimport - LOAD DATA LOCAL INFILE
Rus schrieb
Check that your sql script has the syntax
use your_db_name
create table tablename ...
then try to exec it
mysqlmysql your_script_name
But first of all read the manual. It's help in most cases.
- Original Message -
From: C.o.m.b.u.s.t. [EMAIL PROTECTED]
To: Nielsen [EMAIL PROTECTED];
I think that KEY is the same as INDEX, but why UNIQUE?
- Original Message -
From: TJ Hunter [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, February 12, 2001 3:49 AM
Subject: indexing unique fields
I'm using the following table to store information about a merchant user.
He
Check the structure of txt file. Does it created with SELECT ... INTO
OUTFILE? Check command syntax.
- Original Message -
From: Joel Holtzman [EMAIL PROTECTED]
To: Nielsen [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, February 12, 2001 8:51 AM
Subject: Re: CREATE TABLE / Telnet
Check manual on ISNULL or another MYSQL functions that deal with NULL and
return 0 or 1.
- Original Message -
From: S A [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 08, 2001 3:34 AM
Subject: how to get SELECT to return 0 or 1 for WHERE match ?
I want to SELECT on
in manual:
-
DECIMAL[(M[,D])] [ZEROFILL]
An unpacked floating-point number. Cannot be unsigned. Behaves like a CHAR
column: ``unpacked'' means the number is stored as a string, using one
character for each digit of the value. The decimal point and, for
Have you try GROUP BY?
- Original Message -
From: Marc Swanson [EMAIL PROTECTED]
To: mysql list [EMAIL PROTECTED]
Sent: Monday, February 05, 2001 9:32 AM
Subject: usage of "distinct" in a table join query?
Hello,
I am trying to craft a query that will allow me to retrieve truly
6")-DAYOFYEAR("2001-02-04")) GROUP BY t1.id;
- Original Message -
From: Web Depressed [EMAIL PROTECTED]
To: Rus [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, February 05, 2001 12:39 PM
Subject: Re: Can anyone do this ?
Hi Rus,
I'm not sure I follow, but the DATE colu
select name,(Cashincome+transaction_income) as Income from TableA;
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, February 05, 2001 5:04 PM
Subject: Asking help about SQL(Select)
Dear All,
Sorry for bothering everyone.
I am just working with MySQL
Maybe mysql_result description could help you.
int mysql_result(int result, int row, mixed [field] );
mysql_result() returns the contents of one cell from a MySQL result set. The
field argument can be the field's offset, or the field's name, or the
field's table dot field's name
Can you explain what difference between dates 2001-02-04 and 2001-02-06 for
item2 and 2001-02-04 and 2001-02-06 for item1?
- Original Message -
From: Web Depressed [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, February 04, 2001 11:41 PM
Subject: Can anyone do this ?
Hi,
Maybe you should try
SELECT count(*) FROM bench WHERE year = 95 and
- value BETWEEN (0.7*63000) and (1.3*63000) ;
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, February 03, 2001 3:53 AM
Subject: BETWEEN problem?
Can anyone explain the
Use CONCAT
- Original Message -
From: Sanjeev Adhyapak [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, February 03, 2001 6:42 AM
Subject: Update
Dear Sir,
I want to update one table. situation is like this. i have a table with 3
columns.
tablename - sample
Fields
no -
There are some reserved words in new release. Read the manual.
- Original Message -
From: Paco Martinez [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 01, 2001 3:39 PM
Subject: MySQL + htdig
Is there any problem with htdig and MySQL 3.23.???
My PC was executing
From Beyond-Security's SecuriTeam.com(The information has been provided by Tharbad):
A security vulnerability in MySQL, a database management system, has been discovered.
This vulnerability allows remote attackers to crash by issuing a SELECT statement
containing a large amount of characters.
I think you could use 'WHERE catid IN'
For example, on PHP
$catlist="1,2,3,4,5";
... select ... where ... catid in ($catlist)
And of course you should use category id in web form instead category name.
- Original Message -
From: Beasley, Julien [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
That's nice :)
- Original Message -
From: Harald Fuchs [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, January 31, 2001 8:34 PM
Subject: Re: Auto-Increment - how can I avoid repeating IDs?
In article 009f01c08b0f$c85bbec0$be66bcd4@ruscomp,
[EMAIL PROTECTED] ("Rus&quo
If i get it right, you should use CONCAT
- Original Message -
From: leo.putz [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, January 31, 2001 10:50 PM
Subject: Once again ... row to column conversion
Sorry for having to post the same problem a second time -
but by now I'm
You can't use 'where' in 'insert' query. Use 'update' or 'replace'.
- Original Message -
From: Toby Miller [EMAIL PROTECTED]
To: Liste mysql [EMAIL PROTECTED]
Sent: Tuesday, January 30, 2001 2:28 PM
Subject: Insert Problem
I have a record being inserted and I don't see what the
For example, I have a table
value position
3001
1002
5003
2004
I have to update position ordered by value, and table must look like this
value position
3003
1001
5004
2002
Is it possible
23 matches
Mail list logo