I am using the largest datatype I can, LONGTEXT or LONGBLOB,
and still get the above, the data can't be that large, so I have no idea.
--
Ravi Gupta
Solutions Architect
JBoss by Red Hat, Inc.
Email: rgu...@redhat.com | c: 773.544.6894 | http://www.redhat.com
--
MySQL General Ma
|
|
}
|
//free(sel_smt);
mysql_free_result(res);
mysql_close(MySQL);
exit(0);
}
--code
ends here
Thanks and regards,
Ravi
- Original Message -
From: "walter
Dear All,
I want to connect MYSQL with following C application , while i'm
trying to retrive the query generated , its corrupting the memory.
Is there any solution , to retrive the query generated with out any memory
crashes?
Please help me to solve this problem.
code a
Dear Mat,
Your mail is not very clear. But I have a feeling that using '%' wildcard in
the like operand should help you
Regards,
Ravi.
On 11/14/07, Matthew Stuart <[EMAIL PROTECTED]> wrote:
>
> Hi, I have built a site with Dreamweaver and I have a problem with a
>
Try this (I do not have 4.0.24 to try):
delete table1.* from table1, table2 where table1.id = table2.id and
date wrote:
>
> Dario Hernan wrote:
> > Hi all I need to delete some fields from a table but in the where
> > clause I need to put a select command.
> > For instance, delete from table1
select distinct vehicle from
On 11/6/07, Jamessketch <[EMAIL PROTECTED]> wrote:
>
>
> Hello,
>
> I have a table that looks like this:
>
> vehicle | type| color
> car mercedes blue
> boat croater silver
> plane airbus red
> car volvogreen
> c
Hi,
I have a script which updates a mysql table. When I run this script the
update in not happening.
But if I stop mysql and start in safe mode as follows
mysqld_safe --skip-grant-tables --user=root &
then the update script is running properly.
Why it is not happening in the non safe mode.
Sorry a correction
SELECT DISTINCT LEFT(DATE_FIELD_NAME, 10), COLOR_FIELD_NAME, COUNT(T.*) AS
CNT FROM TABLE_NAME T GROUP BY LEFT(DATE_FIELD_NAME, 10), COLOR_FIELD_NAME
Ravi
On 10/28/07, Peter Brawley <[EMAIL PROTECTED]> wrote:
>
> Neil,
>
> Do you mean ...
>
> SEL
Hi Neil,
Try this:
SELECT LEFT(DATE_FIELD_NAME, 10), COLOR_FIELD_NAME, COUNT(T.*) AS CNT FROM
TABLE_NAME GROUP BY LEFT(DATE_FIELD_NAME, 10), COLOR_FIELD_NAME.
Post the table structure if this does not help.
Regards,
Ravi
On 10/27/07, Neil Tompkins <[EMAIL PROTECTED]> wrote:
>
&g
ournal.com/519655.html
-Ravi
B. Keith Murphy wrote:
I think you will find the load data infile will work faster. I am performing testing right now in preparation for a migration from 4.1 to 5.0 but I am confident that will be the case.
Keith
- Original Message -
From: "Sid Lane"
Make sure each of the replication slaves uses different server_id.
--Ravi
Ben Clewett wrote:
MySql,
I am running 5.0.41 on a master and four replication slaves, all 64
bit Linux.
In the error.log on all four replication servers I keep seeing:
070626 8:34:23 [Note] Slave: received end
(logintime) from T2 for each
user. How do I do this? I tried variants of this:
update T1, T2 set last_login_time = max(logintime) where T1.userid =
T2.userid.
Thanks
Ravi.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
Can any one help me please?
Ravi Kumar. wrote:
Hi All,
We have a MySQL 5.0 server (master) running on Windows. For backup, I
wish to setup another system with same version of MySQL to act as
backup / slave. But this slave can not have direct access to the
master. Is there a way I can achive
master. Would it work, if I take the binary replication logs manually
from master and "provide" it to slave? Any other way to achieve desired
results.
Thanks,
Ravi.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.
e have several parallel calls running - its a multi threaded app), there
is a race condition. And at times several continuous calls return same
result (odd or even).
How do I achieve thread safety?
Please help. Its urgent.
Thanks.
Ravi.
(T1.score) where T1.playerid =
T2.playerid
OR
update T2, T1 set T2.totalscore = sum(T1.score) where T1.playerid =
T2.playerid group by playerid
However none of the above is working.
Where am I wrong? Please help.
The version of MySQL I am using is 4.1.14-standard-log.
Thanks,
Ravi.
Which thread library is the mysqld linked against? Linuxthreads shows
each thread as a separate process in top or ps output. All threads
share the same memory. From your output, it is likely that you are
using linuxthreads(all pids having the same VSZ and RES memory).
Regards,
Ravi
Cabbar
. I am using 4.1.14-standard-log.
The table is huge, hence the query should be streamlined enough.
Please help.
Thanks,
Ravi.
True, but they are very slow in 4.1.14.
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 26 September, 2006 00:12 AM
To: Ravi Kumar.
Cc: mysql@lists.mysql.com
Subject: Re: Conditional copy of values
Ravi Kumar. wrote:
> Dear All,
>
> I have
27; section prevents duplicate rowid values T2.
Thanks again.
Ravi.
-Original Message-
From: Gerald L. Clark [mailto:[EMAIL PROTECTED]
Sent: Thursday, 21 September, 2006 18:30 PM
To: Ravi Kumar.
Cc: mysql@lists.mysql.com
Subject: Re: Conditional copy of values
Ravi Kumar. wrote:
> D
.
Thanks,
Ravi.
' or name like 'b%' or
name like 'c%';
Thanks,
Ravi.
Hi All,
I am looking for a data dictionary for MySQL. It should be free and ideally,
developed in php. And such that it stores the data dictionary in MySQL
itself.
Any suggestions / pointers?
Regards,
Ravi.
Dear All,
Thanks for the prompt replies. The version of MySQL we are using
(4.1.14-standard-log) supports INSERT ON DUPLICATE, hence I am using this.
Have a fantastic day!
Regards,
Ravi.
_
From: Douglas Sims [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 29 August, 2006 12:02 PM
To
insert,
another thread inserts a matching record?
Do we have any alternative?
Thanks,
Ravi.
-Original Message-
From: Douglas Sims [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 29 August, 2006 10:48 AM
To: Ravi Kumar.
Cc: mysql@lists.mysql.com
Subject: Re: Conditional Insert
Hi Ravi
Standard
Dear Members,
I wish to insert and update conditionally into a table using a single SQL
statement. That is if a record already exists in a table, the statement
should update it, else it should insert it. Probably something like this:
if (select * from UserPoints where username = 'ravi&#
How are you importing the dump into mysql? Importing by piping the dump
file to mysql may broke some chars due to shell.
Have you tried this: (with in mysql client)
SET NAMES UTF8; SET CHARACTER SET UTF8
source /pathto/dump.sql
Cheers,
--Ravi
Sean O'Hara wrote:
Hi All,
I've bee
This blog may help,
http://www.xaprb.com/blog/2006/07/23/how-to-track-what-owns-a-mysql-connection/
Cheers,
Ravi
Rithish Saralaya wrote:
Hello people.
Is it possible to find the process that invoked the mysql thread, given a
mysql thread id?
We have a web application that runs on Linux
delete the table. Performance wise, using
individual tablespaces may help in I/O load balancing, if tablespaces
are spread over disks.
--Ravi
Tripp Bishop wrote:
Howdy all,
I'm trying to clean up a development server so that we
can retask it. I tried dropping a very large but no
l
Hi,
I want to run following command thru script .
analyze table t1;
optimize table t1;
analyze table t2;
optimize table t2;
Can I do it on linux mysql ?
I also want to run script like during analysing if we notice any error
related with table then run repair table t1 l repair
yes, that is the reason for slowness .
Thanks,
Ravi
On Tuesday 11 April 2006 10:51, Mohammed Abdul Azeem wrote:
> Hi Ravi,
>
> Since the sync'ing is done to disk with sync_binlog=1, the update
> queries to server are slower compared to the server having sync_binlog=0
&g
se of crash you lose at most one statement/transaction from the
binary log; but it is also the slowest choice (unless the disk has a
battery-backed cache, which makes sync'ing very fast). This variable was
added in MySQL 4.1.3.
--Ravi
On Tuesday 11 April 2006 10:22, Mohammed Abdul A
Joerg: thank you. That worked and much faster too.
WHERE EVENT_DATA.utime >
UNIX_TIMESTAMP(SUBDATE(CURDATE(), 5)) AND
EVENT_DATA.utime < UNIX_TIMESTAMP(SUBDATE(CURDATE(),
4))
Ravi
--- Joerg Bruehe <[EMAIL PROTECTED]> wrote:
> Hi Ravi, all,
>
>
> Ravi Malghan wrote:
&
is run. I have tried searching in google
and www.mysql.org and have not had any luck. Does
mysql use different definitions? or can someone
provide some pointers on the web which explains how to
pass parameters with SQL statement.
Thanks
Ravi
__
Do
how
to get the start_time and end_time values.
Thanks
Ravi
--- Joerg Bruehe <[EMAIL PROTECTED]> wrote:
> Hi Ravi, all!
>
>
> Ravi Malghan wrote:
> > Ok. I found something. But wondering if this is
> most
> > efficient
> > Events for yesterday:
> >
(DATE_FORMAT(CURDATE(),'%v')-1);
TIA
Ravi
--- Ravi Malghan <[EMAIL PROTECTED]> wrote:
> Hi: I have a date/time field (utime) which has unix
> time in epoch time. I want to select events from
> yesterday and another statement for all events from
> previous week.
syntax error or just the wrong
info.
select * from TABLE where utime < endtime and utime >
starttime
how do I get the starttime and endtime for yesterday
and also the last week(Sunday to Saturday)?
Thanks
Ravi
__
Do You Yahoo!?
Tired of spam?
Hi,
What command used to check table size and database size?
thanks
-
Blab-away for as little as 1ยข/min. Make PC-to-Phone Calls using Yahoo!
Messenger with Voice.
tmp/mysql.sock' port: 3306 Source
> distribution
It looks like your disk is having problems.What does 'dmesg'
or /var/log/messages say.
Thanks,
Ravi
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks Bill.
--- Bill Adams <[EMAIL PROTECTED]> wrote:
> UPDATE table SET field_a=field_b;
>
> b.
>
>
> Ravi Malghan wrote:
>
> >Hi: is there a way to copy all field values from
> one
> >field to another fr
Hi: is there a way to copy all field values from one
field to another from the mysql prompt?
Thanks
Ravi
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MySQL General Mailing List
For
ave 'log-slave-updates' flag enabled also along
with bin-log in Slave1 and Slave2 in order to have the updates from master
by slave sql-thread to be logged in their bin-log.
Have a look here
http://dev.mysql.com/doc/refman/5.0/en/replication-options.html
--Ravi
On Monda
st looking for some pointers to get started
on this.
Thanks
Ravi
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
ables:
Table 'mysql.host' doesn't exist
060214 15:53:06 mysqld ended
Please advice.
thanks
Imran Chaudhry <[EMAIL PROTECTED]> wrote:
On 2/14/06, Ravi Kumar wrote:
> Starting mysql with root.I tried withn mysql user account also but still same
> error.
> than
Starting mysql with root.I tried withn mysql user account also but still same
error.
thanks
"Peter M. Groen" <[EMAIL PROTECTED]> wrote:
On Tuesday 14 February 2006 00:28, Ravi Kumar wrote:
> Permission denied 060213
I assume you are starting MySQL NOT as root..
mysql
basedir=/usr/local/mysql
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Please sugegst .
thx
+ravi
-
Brings words and photos together (easily) with
PhotoMail -
up of master. But it goes through fine for few days(2-3
days) , after which the same error reiterated.
what does this error mean?
Please help me in figuring out this error.
Thanks ,
Ravi
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
n read more about this
http://www.mysql.com/news-and-events/newsletter/2003-11/a000270.html
Thanks,
Ravi
On Monday 26 September 2005 17:01, James Green wrote:
> Hi,
>
> Intend on the following replication scenario:
>
> A -> B -> C
>
> A is replicating to B no prob
replication.
Thanks and appreciate very much if some one could donate the time and help.
Ravi T.
-
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger
t ipaddress FROM ip_via_pingsweep;
Empty set (0.00 sec)
mysql> SELECT ipaddress FROM object_subips;
Empty set (0.00 sec)
I am using 4.0.18-standard binary. Any ideas? Does this version support subselects.
TIA
Ravi
leshooting this
effectively.
Thanks.
Ravi T.
-
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway - Enter today
Hi !!
I am new to My SQL. I have got a requirement where
data existing in one schema has to be migrated to
another. Both schemas look alike except some minor
changes in the table definitions here and there.
Does MySQL provide some kind of tools by default for
these sort of things or we need to go
/X11R6/include
-Imoc/ -o tmp/CMySQLQuery.o shared/src/CMySQLQuery.cpp
shared/src/CMySQLQuery.cpp:40: syntax error before `::'
what am i doing wrong? thanks,
--ravi
-
Before posting, please check:
http://ww
you have pointers to pre-compiled binaries for qt3
for freebsd <= 4.5 that would help also!
thank you,
--ravi
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.
Greetings Friends,
How could cache the whole mysql database in the memory? Which parameters
would help?
Regards.
Ravi Verma
916 705 3261
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
Hi.
use mysql_pconnect.
the manual page has a ton of info on using it to avoid the problem you're
describing.
http://ca.php.net/manual/en/function.mysql-pconnect.php
hth.
-ravi
-Original Message-
From: markus|lervik [mailto:[EMAIL PROTECTED]]
Sent: December 13, 2001 3:30 PM
To: [
ur foreign keys are named the same, i.e. Customer.customerID
=> Invoice.customerID so that it can generate those relationships too.
With a bit of manual tweaking, it works well enough for us.
hth.
-ravi.
-Original Message-
From: Steve Osborne [mailto:[EMAIL PROTECTED]]
Sent: November 30
just about to hit send, when I got curious and found something:
This page (http://www.mysql.com/doc/S/o/Solaris.html) says to add a line to
your config.cache, and also has recommended configure arguments.
hth.
-ravi.
-
Before posti
That has happened to me occasionally, I wrote it off as me being tired.
It seems to work now, although a date/thread list would be nice.
But those (along with my email address!) are all over the net.
-ravi.
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]]
Sent: November
Hi.
Not really interested in getting involved in the flamewar that seems to be
brewing, but this might help:
http://www.nexial.com/mailinglists/
-ravi.
-Original Message-
From: john [mailto:[EMAIL PROTECTED]]
Sent: November 28, 2001 2:52 PM
To: Johnny Withers; 'Etienne Marcott
hi.
/path/to/mysql means the path to the mysql _executable_...
type 'which mysql' to see for sure, but it might be /apache/mysql/bin/mysql.
good luck.
-ravi.
-Original Message-
From: Ben Ocean [mailto:[EMAIL PROTECTED]]
Sent: November 26, 2001 2:38 PM
To: [EMAIL PROTECTE
Hi again.
Why were you compiling php against the mysql source rather than using the
built-in mysql support in php?
>From what I've read, it's probably more trouble than it's worth on OSX...
-ravi.
-Original Message-
From: Erik Price [mailto:[EMAIL PROTECTED]]
Sent: No
hi.
regarding 'bundling' GPL products with commercial ones:
http://www.gnu.org/licenses/gpl-faq.html#GPLInProprietarySystem
to summarize, it's okay, if it's done properly.
hth.
-ravi.
-Original Message-
From: Shankar Unni [mailto:[EMAIL PROTECTED]]
Sent: Novembe
hi.
first of many replies, i'm sure:
mysql> select count(compid) from dbLastFaxed where lastFaxedDateTime IS null
;
when you're looking for NULL fields, select where something IS NULL, instead
of '='
-Original Message-
From: Brendin [mailto:[EMAIL PROTECTED]]
Sent: October 26, 2001 5:46
eate a table.
-ravi.
-Original Message-
From: Robert Cross [mailto:[EMAIL PROTECTED]]
Sent: October 22, 2001 10:07 AM
To: Dexter Coelho
Cc: [EMAIL PROTECTED]
Subject: Re: How to copy table structure easily.
-
Before pos
>I do keep forgetting about it. And it seems that MySQL has a 'Dynamic FAQ'
>linked from their site. Perhaps we could get them to add a link to the
>bitbybit version too? (MySQL Folks?)
Ideally linked from this page:
http://www.mysql.com/documentation/index.html
-
I agree.
The attitude I have towards MySQL-related announcement messages on this list
is roughly the same as the attitude I have towards all the other
messages...read them if they look interesting, ignore them if they don't. I
really doubt most people read _every_ message on this list, and if the
Good reply, Cathy.
I'm not sure why there is such an outspoken negative reaction to a
commercial software company announcing a related product on a mysql
list...Not only can Mysql AB be considered a commercial software company,
but so could myself and many others on this list.
For the record, I (
change it to hours, then add the difference in hours...
that will probably do what you're looking for.
hth.
-ravi.
-Original Message-
From: Sommai Fongnamthip [mailto:[EMAIL PROTECTED]]
Sent: October 18, 2001 4:27 AM
To: [EMAIL PROTECTED]
Subject: time calculate
hi,
I'
Or, use mysqldump to dump the entire database, edit the CREATE DATABASE line
at the top to the new name and pipe it all back into mysql, then drop the
old one?
-ravi
-Original Message-
From: Carsten H. Pedersen [mailto:[EMAIL PROTECTED]]
Sent: October 3, 2001 11:50 AM
To: Brandon Lewis
diagram
is generated for, unfortunately, is as well not free.
the evaluation versions seem to work okay, overlooking the missing
functionality.
if you (or anyone else) finds/has found anything better i'd be interested to
know.
-ravi.
-Original Message-
From: Eugene Mah [mailto:[
, this can take a few seconds.
turn off this feature if you want, by starting the client with mysql -A.
if you change table names and want to rebuild the list of tables for
completion, type 'rehash'.
-ravi.
-Original Message-
From: gabriel [mailto:[EMAIL PROTECTED]]
Sent:
ults are returned.
hth.
-ravi.
-Original Message-
From: BW (ST) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 11:16 AM
To: MySQL List
Subject: cc/gcc during configure on solaris 2.8
During my attempt to configure the 3.23.41 source, I encountered the error:
"configure
title | check |
+-+---+
| a | 1 |
| b | 1 |
| c | 1 |
| w | 1 |
| z | 1 |
| a | 0 |
| h | 0 |
| z | 0 |
+-+---+
i.e. each subset (check=1 and check=0) sorted al
hi.
select Title, IF(Title LIKE "%TOMMY%", 1, 0) as check
from inv where...
... order by check desc;
hth.
-ravi.
-Original Message-
From: Carl Schrader [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 04, 2001 10:30 AM
To: [EMAIL PROTECTED]
Subject: Query Question
I
names becomes a user defined datatype.
Please help!
-Ravi Pawar
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e
-Original Message-
From: Ravi Raman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 12:05 PM
To: Jay Fesco
Subject: RE: Licensing terms for an Intranet site
hi.
i think this is jeremy's not-so-subtle way of bashing your choice of email
client.
check this link:
ionNumber) = 2;
update Erf set PortionNumber = CONCAT('', PortionNumber) where
LENGTH(PortionNumber) = 1;
have a nice weekend!
-ravi.
-Original Message-
From: Liana Wiehahn [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 17, 2001 9:13 AM
To: [EMAIL PROTECTED]
Subject: Manipu
foreign key constraints, which is important to know
1) if those things are important to you, and
2) if you're comparing it to oracle.
so i'll stick by my statement that the link is "a page with _a lot_ of
interesting comments from both sides of the commercial-RDBMS vs.
mysql-po
d system, the question of where it fits in and whether it's worth
integrating is up to you guys.
a page with _a lot_ of interesting comments from both sides of the
commercial-RDBMS vs. mysql-postgres is here:
http://openacs.org/philosophy/why-not-mysql.html
hth.
-ravi.
-Original Messag
s?
maybe different tcpdump options are in order for more pertinent information?
again, thanks in advance for any ideas you may have.
-ravi.
-Original Message-
From: mike cullerton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 02, 2001 8:41 PM
To: Ravi Raman; [EMAIL PROTECTED]
Subject:
hi.
find ar...add it to your path..something like:
PATH=$PATH:/usr/sbin
export PATH
type make again.
hth.
-ravi
-Original Message-
From: Alex Cook [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 03, 2001 2:19 PM
To: '[EMAIL PROTECTED]'
Subject: Error during make proces
versions of mysql.
what's going on here?
what does the "writing to net" state mean (besides the obvious)? couldn't
find any relevant docs.
any input is appreciated.
-ravi
-
Before posting, please check:
, the sequence starts over
for all table types.
what type is the table you're using?
hth.
-ravi.
-Original Message-
From: William N. Zanatta [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 20, 2001 3:54 PM
To: mysql
Subject: auto_increment, is this a bug?? Where to report it?
Hello
)
any input would be gratefully appreciated, if the table descriptions would
help, i'll post those.
this seems like an easy join, but i'm confused as to what to do to speed it
up.
-ravi.
-
Before posting, please
the link got split over 2 lines when it was copied/pasted...
manual_Privilege_system.html
instead of
manual_Privilege_system.h
-ravi.
-Original Message-
From: Werner Stuerenburg [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 18, 2001 11:25 AM
To: Ravi Raman
Cc: [EMAIL PROTECTED
>mysqld --skip-grant-tables
section 6.3 on this page:
http://www.mysql.com/documentation/mysql/bychapter/manual_Privilege_system.h
tml
-ravi.
-Original Message-
From: Andy Tanner [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 18, 2001 10:03 AM
To: Werner Stuerenburg; Rischb
hi.
i have a question (or 2)...
since this email doesn't contain the words "sql", "table", "database" or
"query", is the reason it got through because of the "mysql" in the
header/footer?
that doesn't really make sense, because then everything would get
through...maybe because of the word "profita
hi.
www.sunfreeware.com has a sun package that can be added via the pkgadd
utility.
hth.
-ravi.
-Original Message-
From: Mike Jimenez [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 10, 2001 12:44 PM
To: Steve Brazill; Mysql
Subject: RE: Solaris
Okay I can understand that I need to
hi.
make sure you have the right binary...i believe it's called mysql-max or
something...
hth.
-ravi.
-Original Message-
From: Brandon Berry [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 05, 2001 4:55 PM
To: Ravi Raman
Subject: RE: Innodb
It's a binary insta
hi.
use mysqlc instead of mysql when you start the client.
hth.
-ravi.
-Original Message-
From: Sibel Toprakkiran [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 05, 2001 2:35 PM
To: [EMAIL PROTECTED]
Subject: MS-DOS
Hi,
I'm starting mysql in a DOS window. Is there a
possibili
dary database to run intensive up-to-date
statistic queries that otherwise would have locked important tables. (pre
row-level locking table types, of course).
if you just want backups made at intervals, i'd just dump all/important
tables to a file periodically via cron.
that's just me.
ht
le set Info='somethingelse' where Info='blahblahblah';
will leave CreationDate as its original value, and change UpdatedDate to
whatever the current timestamp is because it is first in the table
description/create definition.
hth.
-ravi.
-Original Message-
From: Sh
hi.
an alternate solution is to have a table like this:
Create table(
UpdatedDatetimestamp(14),
CreationDatetimestamp(14),
Infovarchar(100)
);
as mysql only automatically updates the _first_ timestamp column in a table.
hth.
-ravi.
-Original Message
hi.
check out the TIMESTAMP column type...maybe TIMESTAMP(14) as the column
type?
you can then format the date accordingly with...uh...DATE_FORMAT() in your
select statements...
hth.
-ravi
-Original Message-
From: Richard Bates [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 26, 2001 3
o.orderID = 1 and
o.orderID = oi.orderID and
oi.itemID = i.itemID
or something like that.
you could replace the customer/address columns in order with a customerID
referencing a customer table as well...
-ravi.
-Original Message-
From: Jeff Jones [mailto:[EMAIL PROTECTED
are truly identical, it won't
matter which of them (third one, first one, second one) you delete.
-ravi.
-Original Message-
From: LAMULA LALLAL [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 11, 2001 2:47 AM
To: [EMAIL PROTECTED]
Subject: Row to delete
Hi
Can some one help me for this
hi.
rtfm.
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#So
laris
-ravi.
-Original Message-
From: Aaron Williamson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 07, 2001 3:06 PM
To: [EMAIL PROTECTED]
Subject: Problems installing on Solaris 2.6
I'm
hi.
if you're not on a windows box, try something like:
mysql -uroot -p &1 | tee output.log
the mysql client also has a --tee option, as well as a tee(\T) command that
could be of use.
-ravi.
-Original Message-
From: Mohammad Shoja [mailto:[EMAIL PROTECTED]]
Sent: Wednesda
;re out of luck.
otherwise, you'll have to do this in 2 queries within your app.
if anyone can point out something i'm overlooking (either re: your request
or mysql), i'd be interested to know.
-ravi.
-Original Message-
From: Rodrigo Gonzalez [mailto:[EMAIL PROTECTED]]
Sent
1 - 100 of 131 matches
Mail list logo
