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
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: http://list
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 P
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, Janu
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
m
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> ins
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 "$row[1] \n";
}
OR
$row = mysql_fetch_row($result);
do {
echo "$row[1] \n";
} while ($row=mysql_fetch_row($result));
"Marcelo Fabi
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 li
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, 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/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 foll
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
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 DES
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 don't
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. 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 f
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, i
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 englis
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 c
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
23 matches
Mail list logo
