http://tldp.org/HOWTO/LVM-HOWTO/whatislvm.html
On Tue, May 20, 2008 at 10:13 PM, Moon's Father
[EMAIL PROTECTED] wrote:
What is LVM?
2008/5/12 MarisRuskulis [EMAIL PROTECTED]:
Hello!
I'm wondering about MySQL LVM2 preformance, but cant found any
comparisions. I know that there is some
Hi all, i'm not trying to make trouble or bother someone with this
information, I'm a mysql user and I love it, I just wanna know your
point of view about it.
http://use.perl.org/~Smylers/journal/34246
Have good one.
--
obed.org.mx
--
MySQL General Mailing List
For list archives:
Use \ to escape.
mysql insert into table1 values ('algo\,otra');
Query OK, 1 row affected (0.00 sec)
mysql select * from table1;
+---+
| a |
+---+
| algo |
| algo,otra |
+---+
2 rows in set (0.00 sec)
On Sat, Mar 8, 2008 at 1:52 AM, J. Todd Slack
[EMAIL
On Jan 23, 2008 2:36 PM, Jay Blanchard [EMAIL PROTECTED] wrote:
[snip]
Hello Jay. Thanks for your reply but where is your solution to my
problem. I'm lost here. Help me -- please
Thx
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 23,
On 3/9/07, Gloria McMillan [EMAIL PROTECTED] wrote:
Dear MySQL general list members,
I have a guest book on a small club web page that has been getting
regular spam in with
the legitimate replies.
I use MySQL and (I think) Apache-style PHP to run the database. I know
it is PHP and
am certain
On 10/6/06, Chris Elhardt [EMAIL PROTECTED] wrote:
apologize for the newbie question.
installed mySQL 4 some time ago, and just played around with it in
terminal. Now that I really need to learn some database, I can't get
it to start in terminal. it autostarts; I can see it in the activity
Hi all... i'm developing an aplication and i'm need to use begin,
commit, rollback, but when i try to use rollback i get a warning
| Warning | 1196 | Some non-transactional changed tables couldn't be
rolled back |
this is what i did
mysql begin;
Query OK, 0 rows affected (0.00 sec)
mysql
On 8/25/06, David Lazo [EMAIL PROTECTED] wrote:
I didn't add it anywhere because the file exists in mysql/bin folder
c:/program files/mysql/bin
Does it need to be somewhere else??
mm.. i don't know, you tell us !!! try it. !!!
--
http://www.obed.org.mx --- blog
--
MySQL General Mailing
On 8/24/06, João Cândido de Souza Neto [EMAIL PROTECTED] wrote:
You ought to choice one of these ways:
while ($row=mysql_fetch_row($result)){
echo trtd$row[1]/td/tr \n;
}
OR
$row = mysql_fetch_row($result);
do {
echo trtd$row[1]/td/tr \n;
} while ($row=mysql_fetch_row($result));
On 8/22/06, Karl Larsen [EMAIL PROTECTED] wrote:
$ mysqladmin -U make new password for root doesn't work.
can you copy the error?
if you want to set the root password you can use
mysqladmin -u root password newpwd
--
http://www.obed.org.mx --- blog
--
MySQL General Mailing List
For list
On 8/15/06, Visolve DB TEAM [EMAIL PROTECTED] wrote:
Hello William
Try the below Query to insert next maximum value of the field into same
table
INSERT INTO Sample(id) SELECT MAX(id)+1 FROM Sample
Wooww it works :D ... i didn't know that... great !
--
MySQL General Mailing List
For
On 8/14/06, William DeMasi [EMAIL PROTECTED] wrote:
Does anyone have any ideas of how I can select the max value and insert the
next highest value?
I want something that would do something like this:
Insert into table1 (select max(field1)+1 from table1);
This obviously doesn't work.
I know
On 8/6/06, Ro BGCT [EMAIL PROTECTED] wrote:
Hello,
I installed MySQL on a remote server and am having a problem. I am
connected to it via SSH and I can do mysql -u root -h localhost just
fine and connect. However, when I try to connect via mysql -u root
-h web1.server.com, I get the following
On 8/6/06, Bill [EMAIL PROTECTED] wrote:
Hi
Can you remind me how to tell mysql to list vertically instead of horiz in
text mode?
Ex:
select all * from a_tablesends field1 field2 .
I want
field1
field2
field...
Thanks
if you type help you can find a lot o information
mysql
On 8/3/06, André Hänsel [EMAIL PROTECTED] wrote:
Hi,
I have a table logging downloads (time, username, download).
Now I'd like to have the last 5 downloads per user.
Can someone tell me a solution (or what to search for)?
SELECT download FROM table WHERE username='user' ORDER BY time DESC
On 8/3/06, André Hänsel [EMAIL PROTECTED] wrote:
Hi Dan, hi Obed,
of course I have no specific username, I want the last 5 downloads of each
distinct username in the table. :)
i was thinking a lot... and i can't find the solution but maybe yo
can do somthing like this
select user
Hi all, it's me again jeje !!!
i have a question, i want to do something like this
select 10 as a, 1 as b, (a+b) as c;
im want to get something like this
a | b | c
-
10 | 1 | 11
how can i do this... i want to do that becouse i get a big value from
a sub big subquery, so i
On 7/26/06, João Cândido de Souza Neto [EMAIL PROTECTED] wrote:
Hi.
Let me explain something about coalesce.
coalesce(field,0) return 0 if the field value equals null or the field value
if it´s not null.
:-) ooo !!! ok... it's the same to do: case when field is null then
0 else field end
Hi all !
i have two tables ingenio and detalle_tanque, detalle_tanque has a
foreign key to ingenio, i want to show all the ingenio values and a
sum of the cantidad field in the detalle_tanque table for each value
in ingenio, but one of the ingenio's values it doesn't exist in
detalle_tanque,
Hi. thanks ! but nop...
SELECT id_ingenio,cantidad FROM detalle_transaccion WHERE cantidad IS NULL;
Empty set (0.00 sec)
and with coalesce
nop :-( it's the same problem
mysql select id_ingenio, (select case when sum(
coalesce(cantidad,NULL) ) is null then 0 else sum(cantidad) end
On 7/18/06, Tim Lucia [EMAIL PROTECTED] wrote:
-Original Message-
From: Obed Soto Déctor [mailto:[EMAIL PROTECTED]
Sent: Monday, July 17, 2006 7:28 PM
To: mysql@lists.mysql.com
Subject: problem with double data
Hi, i'm sorry for my english, i'm from México and i'm gonna do my
Hi, i'm sorry for my english, i'm from México and i'm gonna do my best,
i've made a store procedure but i have some problems becouse when a
make a simple operation with double datas the result is not what i
wait.
look
cantidad_origen = 30.5
cantidad_ = 30.4
suma = 0
UPDATE detalle_tanque set
Dear mysql ,
MRS ELIZABETH OBED
C/O. SAM BELLO
BARRISTER SAM BELLO CO.
LEGAL PRACTITIONAL 2,
FALOHUN STREET,
AGUDA S/L LAGOS,
NIGERIA.
FAX: 234-1-7594260
I am Mrs. Elziabeth Obed, widow of the late Lt. Col. M. Obed, the former military
Administrator of Kaduna state of Nigeria. my late
23 matches
Mail list logo