/usr/bin/perl is needed by MySQL-client-3.22.32-1
I already have MySQL server installed.
Thanks for your help.
Rus
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
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
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 poss
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 resu
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 LO
mysqldump creates a text file with such structure.
- Original Message -
From: Joel Holtzman <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 13, 2001 1:47 AM
Subject: Is this possible
> Hello, I am starting to get some success from Load data. Ok, now with
that,
> here
I am not shure about recalculating constants in mysql. Try
.
where activity.event_time_unix <= const
..
where const is the result of 981990589 - (2* ( 24 * (60 * 60) ) )
- Original Message -
From: Bryan Hunt <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, F
Maybe it's problem with end_of_line symbol.
You could use PHP to insert records directly into db.
- Original Message -
From: Irmund Thum <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, February 12, 2001 2:30 PM
Subject: mysqlimport - LOAD DATA LOCAL INFILE
> for my JavaScrip
Holtzman <[EMAIL PROTECTED]>
To: Rus <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, February 13, 2001 1:15 AM
Subject: Re: CREATE TABLE / Telnet (Linux / Unix server)
> I turned my access db into excel, and into .csv
>
> So that's the structure of my text fi
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 / Te
Use TEXT type to store texts larger than 255 symbols.
- Original Message -
From: Thomas Kaester(global) <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 12, 2001 11:10 AM
Subject: Problems with text fields
> Hello everybody,
>
> ich have a few problems with text fields
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.
> H
Check that your sql script has the syntax
use your_db_name
create table tablename ...
then try to exec it
mysql>mysql < 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
Hi!
Does MySQL open all tables in database when I select data from one table?
Will it be faster to split db to number of smaller db associated with concrete PHP
scripts?
I hope you have unique id in your table
Select distinct into temp table, then select each row from temp table and
delete from your_table where
field="dupl value" and id<>temp.id (in abstract syntax)
- Original Message -
From: Linsen Limsico <[EMAIL PROTECTED]>
To: mysql_list <[EMAIL PROTE
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 SELEC
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 negat
Check text for special symbols and use " in your query (f.e. ...
blobfield="text")
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 06, 2001 2:14 AM
Subject: Insert into blob
> Hi,
>
> I am having some problems inserting data into a blob fie
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 MyS
001-02-06")-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
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 trul
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 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 (fieldname.table
Why you don't use GROUP BY?
- Original Message -
From: Siim Einfeldt aka Itpunk <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, February 04, 2001 1:59 PM
Subject: problems getting DISTINCT data
>
>
> SELECT DISTINCT estitle,id,lepingid FROM main WHERE litsents='something'
> OR
You can pack entire directory with your DB then unpack it on server or you
can dump DB, pack it and then unpack on server and load with mysql.
- Original Message -
From: Donald Korth <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 03, 2001 7:25 PM
Subject: Help :- To
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
> Fiel
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 fol
>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.
According to your question it could be done as simple as
select * from People where PARENT_ID = 1 or OBJID = 1
:)
- Original Message -
From: Johannes Pretorius <[EMAIL PROTECTED]>
To: MySQL <[EMAIL PROTECTED]>
Sent: Thursday, February 01, 2001 4:43 PM
Subject: How can I do this ???
>
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 executi
You can use GROUP BY or upgrade your hardware :)
- Original Message -
From: <[EMAIL PROTECTED]>
To: mySQL list <[EMAIL PROTECTED]>
Sent: Wednesday, January 31, 2001 9:42 PM
Subject: can I select from one table only where some records exist in
anothertable?
> Sorry, that's not a very goo
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
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>,
select t2.id from gamers t1,games t2 where t1.user="jack" and t2.id<>t1.gid
group by t2.id
Original Message -
From: zbynek <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 31, 2001 4:31 PM
Subject: Selecting games which a given user can join
> Hi there!
>
> I'm new
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]
He need 10 last records ordered by id.
You also can try this
SELECT *,count(*) as c FROM item GROUP BY ID LIMIT c-10,10
or
SELECT *,count(*)-10 as c FROM item GROUP BY ID LIMIT c,10
Something should work
- Original Message -
From: Scott Gerhardt <[EMAIL PROTECTED]>
To: Rus &
That's strange. I thought that auto_increment field not suppose to use same
value. May be it's problem connected with transaction. Check doc's on
COMMIT. Try to set AUTOCOMMIT=1
- Original Message -
From: Viken Nokhoudian <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January
May be it could work
SELECT * FROM item ORDER BY ID LIMIT count(*)-10,10
or
SELECT * FROM SELECT * FROM item ORDER BY ID DESC LIMIT 10 ORDER BY ID
- Original Message -
From: Karlsson Andreas-andkar01 <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 6:00 PM
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 pr
Does anyone know how to sort and recreate auto_increment field from, for example,
to
1
2
3
4
without creating any additional tables?
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 t
41 matches
Mail list logo