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?
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
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
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
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
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
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
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
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 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
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
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
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
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
Does anyone know how to sort and recreate auto_increment field from, for example,
to
1
2
3
4
without creating any additional tables?
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
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
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
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 &
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]
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
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>,
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
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
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
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 ???
>
>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.
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
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
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
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
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
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,
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
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&#x
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
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
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 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
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
/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
41 matches
Mail list logo
