I am using RPM. And for Centos 5 it was installing a lower version
of mysql than what was installed with the system. That is why I want
to check before doing the RPM. I guess the alternative is to use the
latest version all the time, but not sure whether that will work on
the 4.5 version.
The o
I have an install script that does some stuff with mysql (i.e. install,
start, etc). It installs
mysql Ver 14.12 Distrib 5.0.19, for pc-linux-gnu (i686) using readline 5.0
This was good when we just used CentOS 4.5. Now we are doing some later
CentOS versions and the mysql version may be higher
etc
ps: a collegue said to me that DBs are not design to do what I wanted to do
(in 1 sql query anyway). I'm beginning to accept that comment :(
Thanks John
Tony
>
> "John Hicks" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> > tony yau
said to me that DBs are not design to do what I wanted to do
(in 1 sql query anyway). I'm beginning to accept that comment :(
Thanks John
Tony
"John Hicks" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> tony yau wrote:
> > Hi John,
> >
> >
.3
1 12.212.2
2 31.031.0
3 1.021.02
3 4.94.9
thanks for your help anyway
Tony
"tony yau" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi John,
>
> I didn't know
Hi John,
I didn't know you can do that! (such a novice indeed!)
Thank you for your reply, I will put it to the test first thing when i get
back to the office tomo.
Cheers
"John Hicks" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> tony yau wrote:
> &
I have got a method that works (I think) by first do a SELECT getting
DISTINCT id values and then foreach of these ID I do another SELECT to get
the Changes values and then just massage the display.
Is there another way of doing this by using a single SQL query?
any help or hints will be very much
What is the sql command to export the whole database ?
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Hi Is there any sql commands for dumping/exporing the
content of a database to a file ?? Thanks. Tony.
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MySQL General Mailing List
For list
isolation level are you using now.
I am using the default which i beleive is REPEATABLE READ. The
particular query that is failing is done using autocommit as it a
standalone query.
Thanks
tony
>
> sujay
>
> -Original Message-
> From: Tony Leake [mailto:[EMAIL PROTECTED]
Hi,
I have a query:
UPDATE dbseXyzOrders.tblOrder SET intPoUid = 98 WHERE intOrderUid =
10798
intOrderUid is the primary key
There are 25 columns in the table and a further 8 of these have indexes
on them. The table is innodb
I have just tried to run the above query 3 times and i got the
ver.
when the flag is unset, app 2 reads it, process it and posts it to a
website via xmlrpc
app 2 site in a shell script while loop: (pseudocide)
while (1){
start app 2
sleep (60)
}
so there can never be more than one instance of app 2 running.
tony
--
MySQL General Mailing Li
ay the other
> server (app2) will either have consistent data or will never find out that
> anything was going on in the first place.
>
Many thanks Shawn, I few changes needed to the app but i'll give it a
go.
Regards
tony
--
MySQL General Mailing List
For list archives: http:
e when the server is loaded. Does this
happen? If so what can I do about it, would putting the inserts into
one big transaction help? At the moment All of the inserts are done by
implicit commits.
Sorry for the essay, i an just trying to fully document what I know.
Thanks
tony
--
MySQL Gener
On Fri, 2005-09-16 at 14:02 +0100, Mark Leith wrote:
> http://dev.mysql.com/doc/mysql/en/group-by-modifiers.html
>
perfect, thank you.
tony
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
6 100.00
total 10120.00
could someone point me to this in the manual please as I can't seem to
find it. Or did i just imagine it anyway?
thanks
tony
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
cords in the database and delete all matching records.
//convert the date.
$mysqlDate = preg_replace("|(\d{2})/(\d{2})/(\d{4)|", "\\3-\\2-\\1",
$_POST['strUserDate']);
//format the sql query
$strQuery = sprintf("delete from news where date = '%s',$mysqlD
Hi
I set up replication for the first time last week. 1 master 1 slave.
Everything worked fine for 1 week, i checked out a couple of records
this morning to check everything was still working and the slave had
stopped. show slave status showed that there had been a duplicate key
error, the record
On Wed, 2005-08-03 at 20:11 +0700, Dwi Putra L wrote:
>Some days ago, I create a software, using delphi 7
>and mysql 4.0.0 Alpha as the database.
are you sure about the 4.0.0 Alpha ? if so your're about 2 years
behind...
tony
--
MySQL General Mailing List
For li
al idea, it's
called cross tabulation.
if you google cross tabulation tutorial i'm sure something will come up
tony
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
all the information you need in the php manual
http://www.php.net/manual/en/index.php
tony
> Thanks for any help provided.
>
> Javier
>
> __
> Correo Yahoo!
> Espacio para todos tus mensajes, antivirus y antispam ¡gr
d here:
>
> http://dev.mysql.com/doc/mysql/en/innodb-configuration.html
I didi read through this before I posted, however I am a programmer with
no real admin experience in at the deep end, and it was all a little
over my head :( I guess i'll get to understand it in time.
Regards
tony
--
Hi David,
On Fri, 2005-07-15 at 10:25 -0700, David Griffiths wrote:
> Tony,
>
> " - not sure what version you are using
4.1.11. Server is a duel xeon machine with 4gb or ram running mysql and
apache webserver and not much else.
You should have used
> my-innodb-heavy-4G.cn
ppreciated.
Tony
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Wed, 2005-07-13 at 15:02 +0100, zzapper wrote:
> Is myisam still dominant for web applications?
depends on your application, if you're running a bulliten board or a
simple catalogue site, then myisam is a good choice as it is faster.
However for an ecommerce site i would definately go for inn
can i investigate this further? Table and query below
Thanks in advance
Tony
CREATE TABLE `tblSessionData` (
`sessionKey` varchar(32) NOT NULL default '',
`data` text NOT NULL,
`expiry` int(11) NOT NULL default '0',
PRIMARY KEY (`sessionKey`),
KEY `expiry` (`expiry`
Hi Guys,
you can always set a max time out for your php script (php.ini)
Tony
- Original Message -
From: "Gleb Paharenko" <[EMAIL PROTECTED]>
To:
Sent: Friday, May 20, 2005 12:45 PM
Subject: Re: MySQL give up on a query after a certain length of time
> Hello.
&
Hello,
I am new with using mySQL.
I have a little problem
I am starting a new web site on which I wanna use the "same" DB I am using on another
site (that was created by somebody else). Instead of starting from scratch, I would
like to use a copy of the DB we have, since we know it is alre
U 2.80GHz stepping 09
. CPU clock speed is 2793.7204 MHz.
Thanks for your advice everyone!
Tony
Ps. Good suggestion Donny, but both /tmp's are ext3. (And the new /tmp is faster,
based on this little test: rm -f ttt; sync; sync; time dd if=/dev/zero of=./ttt bs=16M
count=32)
Ke
90.260.651000
count_distinct12.000.510.020.531000
count_distinct (new box) 15.000.100.010.111000
Any advice at all, would be very much appreciated!
Thanks,
Tony
***
I'm a newbie but thought I'd try my hand and offer an extremely
inefficient query that seemed to work ...
select * from
word join
word as tw join
word as tm
where concat(word.wd, tw.wd, tm.wd) not like '%male%female%' and
concat(word.wd, tw.wd, tm.wd) not like '%female%male%'
On Sunday, September 28, 2003, at 11:40 PM, Tony Thomas wrote:
nl4br(); will insert a tag after every new line so your browser
can display it correctly.
Ahem. I mean nl2br();
That's because the browser doesn't read the line breaks without a tag at the end. All you need to do is this:
echo nl2br($textarea);
?>
nl4br(); will insert a tag after every new line so your browser
can display it correctly.
On Sunday, September 28, 2003, at 11:07 PM, delz wrote:
Hi All
Hi All,
I've been hearing a bit about SQL injection lately, but the only
documentation I can find refers to Microsoft or Oracle. Anyone know of
good articles about injection in MySQL? Prevention? Detection? Is MySQL
less vulnerable?
Thanks,
Tony
--
MySQL General Mailing List
For
o tell which records came from
which
table. If that dosn't matter obviously its not a problem.
- Original Message -
From: "Tony Thomas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 16, 2003 2:48 PM
Subject: Re: select data from two table
e using MySQL 3.x as that dosn't support UNION.
Haydies.
- Original Message -
From: "Tony Thomas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 16, 2003 2:01 PM
Subject: select data from two tables without join
: I have two tables tha
I have two tables that are similar, but not related. One is for
meetings and the other for training. I'd like to run a query to select
data from both based on the date so I can display the information on a
web page. Is that possible? It seems unnecessary to run a separate
query for each. I'd li
http://www.odbcunix.org (probably on RedHat's
site too)
http://www.mysql.com/downloads/api-myodbc.html
Hope this helps.
/Tony
ps. database, SQL, queries, sort, select, alter, table
and other words for the list man to read.
__
Do you Yahoo!?
Yahoo! Site
Good news for OS X users. CocoaMySQL has just been updated and it now
supports CSV imports among other improvements. It's freeware too.
http://www.MacUpdate.com/info.php/id/10573
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.c
I've been getting autoresponders from
[EMAIL PROTECTED]
[EMAIL PROTECTED] ("The Oracle")
[EMAIL PROTECTED]
On Saturday, August 23, 2003, at 12:41 PM, Joe Baptista wrote:
BTW, did anyone around here get mail from CServe containing important
email
addresses such as support? I got from them these
Once you get everything up and running, and get the basics of MySQL
down, here are some tools that can make database administration on the
Mac a little simpler in terms of doing every day things, like creating
databases, tables, searching, sorting and exporting:
Cocoa MySQL- http://versiontrack
The following is my guess, give it a try if you want:
Make sure that in your config file, "log-bin" isn't present, delete all
the log files, as well as the -bin.index file and restart MySQL.
I utilize my log files, so I can't say how to stop them totally.
--
Tony Ev
There are some good Mac clients to access MySQL. I personally use
CocoaMySQL for much of my day to day activity. You can find them all on
versiontracker.org. YourSQL looks okay too.
I agree though, the fancy interface, should you choose to use one of
the above clients, is much more useful if y
I need to install a mysql client only on a solaris2.8 machine, the mysql
server is on another machine.
I could not make the compile work using the source download. I got an
error in make.
Can someone point me to a binary client download somewhere? Or give me
a hint of the following compile error.
When I tried to build a client only version (v3.23.55) on a Solaris2.8
machine, I got the following error: ( while doing make install)
I did ./configure -without-server. It works fine.
This is the error make gives.
...
cc -DDEFAULT_CHARSET_HOME=\"/usr/local/mysqlc\"
-DDATADIR=\"/usr/local/mysq
Hi,
I can't use MySQL control center 0.8.7-alpha to insert records with fields
of Chinese GB2312 characters. The updated execution result is something
like "?20", I use varchar. I run it on IIS, Chinese windows2000
professtional with service pack3. But when I use console insert record
comm
can't find
the answer.
Regards
Tony Roberts
Mailbox Solutions Ltd
[EMAIL PROTECTED]
01777 700 600
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.389 / Virus Database: 220 - Release Date: 16/
;mysqladmin -p shutdown' and
supplying the root password. I'm baffled.
I'm not officially part of the list, so if anyone would care to lend some
aid, please e-mail me directly (or to the list and I'll eventually get it).
At this point, I'm desperate. The hot breath of my users
?
+--+
| ___ ___ |
| //_/_/_/_/_/ //_/_/_/ |
|//_/ //_/ _/ |
| //_/ //_/ _/|
| //_/ //_/_/_/ |
|--|
| Tony Devlin - [EMAIL PROTECTED] |
| Airewaves Broadband, Systems Admin |
| Website - www.airewaves.com |
| Atlanta, Ga - 678.522.3923 |
| Beaufort, SC
FYI..I use MyDNS here, and i really like it. has a nice little contribed
PHP interface included in it too.
be aware, it's only an authoritative name server, if you want to do
recursive/cache, you need something like djbdns dnscache along side it.
-Tony
-
S
no effect.
Sounds to me like some resource is being used up and possibly not being
released but apart from that I haven't much clue.
Regards
Tony Prichard
-
Before posting, please check:
http://www.mysql.com/man
ounds like a bug to me, and I've now done
this on both SuSE 7.0 and SuSE8.0.
Tony Butcher
> From: Gerald Clark <[EMAIL PROTECTED]>
> Organization: Supplier Systems Corporation
> Date: Fri, 06 Sep 2002 13:30:29 -0500
> To: Tony Butcher <[EMAIL PROTECTED]>
> Cc: [EMAIL
Sorry, user mysql and group mysql already exist, and permissions were
already set correctly. It didn't work.
Any more ideas?
Thanks again.
Tony
> From: Gerald Clark <[EMAIL PROTECTED]>
> Organization: Supplier Systems Corporation
> Date: Fri, 06 Sep 2002 13:30:29 -050
/english/errmsg.sys
Is anyone else getting this? Any ideas how to get round it?
Thanks!
Tony Butcher
.
+--+
| ___ ___ |
| //_/_/_/_/_/ //_/_/_/ |
|//_/ //_/ _/ |
| //_/ //_/ _/|
| //_/ //_/_/_/ |
+--+
| Tony Devlin - [EMAIL PROTECTED] |
| Airewaves Broadband, Systems Admin |
| Website - www.airewaves.com |
| Atlanta, Ga - 678.522.3923 |
| Beaufort, SC - 843.379.AIRE(2473
o mysql-3.23.51]#
First of all i have tar -zxvf mysql-3.23.51.tar.gz
Then i have enter the map, runing ./configure -prefix=/usr/local/mysql
Then make
Lol
// Tony B [EMAIL PROTECTED]
-
Before posting, please check:
>Description:
When dumping the 'mysql' database, the dump file contains syntax errors,
and I can't find where this has been rectified in later releases.
Example dump using 'mysqldump -cl mysql':
[snip]#
# Table structure for table 'db'
#
CREATE TABLE db (
Host char(60) NOT NULL default '',
nce it happens.
The results from a "variables" command after the event are at:
http://homepage.mac.com/tonyniesz/variables.txt
The results from "extended-status" are at:
http://homepage.mac.com/tonyniesz/extended-status.txt
The two data dumps refer to 3.23.46, but I'
Bonjour,
J'utilise Mysql 3.23... sous un environnement Solaris 7. La taille de la
base de donnée est de 1Go 5.
Quelles sont les limites pour le bon fonctionnment de mysql ?
Existe il un moyen plus rapide de faire des copies de bases que le dump ?
Merci
Cordialement,
Tony Jarr
You may also find it more convenient to edit a text file with all of your data and
table creation commands in it, then use the 'source' command inside an mysql session
to execute them. That way when you run into an error, you just edit the file and
repeat.
Another nicety about MySQL is a co
Just put a carriage return (e.g. the enter key) in your command every, say 72
characters or wherever the next logical word occurs. MySQL really only cares about
ending all the entry with a semi-colon (or some maximum line length which I think
you've run up against).
In short, hitting the en
By any chance are you using DBI, and prepare in the query? If so, have you use
prepare_cached and roled the select statement into a function that accepts the
'CONSTANT' as an input param to the function?
That gave me tremendous perf improvements.
-Original Message-
From: BD [SMTP:
> - Original Message -
> From: "Kim Hendrikse" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, March 03, 2002 7:04 PM
> Subject: Searchable archives of this list
>
>
> > Hi,
> >
> > For those of you who are not aware of it, we run a searchable archive of
> this
> > list at th
written in, any ODBC... and a
hundred other questions. Just what are you asking here?
Tony
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archiv
into test values (1, 'blah');
select * from test order by note;
I haven't tried any other versions yet, but the crash doesn't happen
with 3.23.21-beta.
-Tony
Tony
Sql. I would like that when I execute a search the results
would
> be show on pages with 20 results per page. Is that possible???
>
> Thank you
>
> Daniel F. Castro
>
This is a good site explaining just what you are after...
http://www.web
- Original Message -
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
To: "Tony Wu" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, February 19, 2002 8:38 PM
Subject: Re: would you send me the mysql distribution which can support big5
And YOU are part of the problem - every spam is backed up by one of your
complaints, doubling the traffic.
If it really bothers you that much then set up a filter rule (killfile) for
the persistent spammers, or risk being killfiled yourself - you have become
a spammer.
Can't you take your petiti
Rownum exists of a sort with the limit clause.
Rowid does not exist all at.
Tony
- Original Message -
From: "Emmanuel van der Meulen" <[EMAIL PROTECTED]>
To: "MySQL Java List" <[EMAIL PROTECTED]>; "MySQL General List"
<[EMAIL PROTECT
- Original Message -
From: "j.urban" <[EMAIL PROTECTED]>
To: "Tony Buckley" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, January 18, 2002 4:10 PM
Subject: Re: Porting from MS SQL to MySQL
> > Unless th
- Original Message -
From: "j.urban" <[EMAIL PROTECTED]>
To: "Tony Buckley" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, January 18, 2002 4:07 PM
Subject: Re: Porting from MS SQL to MySQL
> > Porti
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Tony Buckley" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, January 18, 2002 3:34 PM
Subject: Re: Porting from MS SQL to MySQL
> SNIPSNIP:)
> > > I agree. If they are a seriuo
c.
If you think E18k is a lot then ask for a detailed task plan with effort;
find out what they are asking you to pay for.
The DB was described as 'fairly complicated' whatever that may mean.
Perhaps - and we are all guesing - there are remote data issues, views,
stored procs, java
ential" stock scams.
>
Marjolein,
They sound like great opportunities. Do you have any more info?
Tony
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
l you a new platform
then your prices are clearly not a couple of pence per access.
Good luck,
Tony
- Original Message -
From: "Investor" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>;
&
See manual section 4.1.4.
- Original Message -
From: "Emmanuel van der Meulen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, December 30, 2001 9:47 AM
Subject: Multiples instances of MySQL
> Hello all,
>
> Could someone please advise, what is the procedure to start and ru
o
> write one. I've actually been keeping an archive of the MySQL list
> for quite a while in anticipation of doing this some day. Just doin'
> my bit...
>
> The archive is at http://archive.workmate.ca/myarchive
>
Simply fabulous! Thanks!
Tony
-
Anyone have any experience of using mySQL within Smalltalk servers on a
unix/linux platform?
Any decent links? I am just exploring this now as I have heard there is now
a Smalltalk mod for Apache. This sounds like a fun combination to play
with!
thanks,
Tony
(title
and text) and can be read or ignored by choice.
I am not a great fan of Newsgroups - they get spammed too much and messages
get lost or archived. Some ISPs carry them, some don't. All too hit and
miss for a resource on which I rely and am very grateful for.
Tony
- Original Me
1064: You have an error in your SQL syntax near 'select ID from
> user)' at line 1
>
> Is the "IN" keyword not supported in MySQL, or am I using it wrong?
>
Subqueries are not supported in mySQL. Have to rewrite it with a
combination of outer joins to do the
Hi Arjen,
- Original Message -
From: "Arjen G. Lentz" <[EMAIL PROTECTED]>
To: "Tony Buckley" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, December 09, 2001 1:40 AM
Subject: Re: From Oracle to the MySQL Database Server
>
> But eh,
sources/threads) have yet to fail. Does the job very
nicely. Yes there are the usual gripes about views, transactional
processing, and locking, but if you know about these at the design stage
they can be managed. I'm a fan!
Tony
--
th or well organized
information. Not trying to bust your chops, I did it (and still do from time
to time), just letting you know that there is a faster (and more complete)
way to find answers.
HTH,
Kind regards,
Tony
On Wednesday 28 November 2001 01:27 pm, A. Clausen wrote:
> Is ther
...I hate when this happens, I found it.
For those who didn't know:
insert into table1 select table2.* from table2;
I know, I should be column specifc to accomodate table schema changes later
in life, but this was a test.
T
On Tuesday 27 November 2001 12:46 pm, Tony wrote
I thought the following SQL statement would work (both tables are the same
schema):
insert into table1 values ( select * from table2 ) ;
...or was I seeing magic posts in the wee hours of the morning? I didn't
think that was a subselect, but maybe I am wrong there too.
Any help
%W %M %D
%Y') as thedate,
doctitle from docs, wdocid_bo where wdocid_bo.docid = docs.docid and docs.docdate >
FROM_UNIXTIME(975228544) AND wdocid_bo.wordid=1646 GROUP by docs.docid ORDER by score
DESC,
docdate DESC, docid DESC LIMIT 0, 10
TIA
Tony
);
?section consistency_check
select .
---
Does anyone know whether this functionality exists in MySQL?
Regards,
Tony
-
Before posting, please check:
http://
On Friday 09 November 2001 12:23 am, Steve Meyers wrote:
> Tables with variable length rows can get ugly if not optimized
> frequently. We had one which was taking 2.5 sec to do an indexed query,
> and when we optimized the table it dropped to .2 sec.
>
> But as long as you keep your tables opti
On Thursday 08 November 2001 10:55 am, Paul DuBois wrote:
> At 10:00 AM -0500 11/8/01, Tony wrote:
> >Does anyone know if putting (or grouping) varchar columns at the end of a
> >table provides any performance improvements? My indices are all integers,
> >but not have varch
Try this:
select * from my_table order by my_datetime ASC;
select * from my_table order by my_datetime DESC;
Cheers,
T
On Thursday 01 November 2001 06:15 am, brainheap wrote:
> Hi ppl!
>
> I have a table with datetime type column in it.
>
>
> when I make request "select * from
You might want to try Hurricane Electric, I've been using them for over a
year, MySQL, Telent, cgi, email account, DNS support starting at $10/month.
http://www.he.net
They've been great.
Cheers, T
On Tuesday 30 October 2001 11:44 pm, Joe Fan wrote:
> My current web hosting c
ellas NT. MySQLfront is a great tool for daily tasks, etc. I must
confess to preferring the text-based approach, probably the habit of years of
big DB work on Tandem systems, where GUI tools were (and are) few and far
between.
I have not heard of the Advanced Query Tool, which
On Wednesday 31 October 2001 10:44 am, Richard W. Wood wrote:
> I've been trying to add the following table to my database, and I keep
> getting the error below.
>
> CREATE TABLE mod_userpage_data (
>id INT(5) NOT NULL default '0',
>title VARCHAR(200) NULL,
>data LONGTEXT NULL,
>PR
ly, there
are pages on the online docs too, I just found his book, dog eared and easy
to find things.
HTH,
Tony
On Friday 26 October 2001 08:07 pm, Joe wrote:
> Is there a query I can run to change the next autoindex to the next highest
> integer in the column.
>
> I mean
as the key on one of the slaves than a pesky timestamp--er, I think.
Right now it is timestamp.
Thanks for the thoughts guys, I'll be sure to provide feedback on the results
if you are interested.
Regards,
Tony
On Thursday 25 October 2001 12:45 pm, Kyle Hayes wrote:
> On Wedn
n rows. I am running MySQL 3.23.36
and RedHat 7.1 (2.4.3-12)
Kind regards,
Tony
--botspeak: sql, query, database
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
indexing.
For disaster recovery of the master, one slave could be "untouched" and not
indexed.
I'd be interested to hear comments.
Thanks in advance,
/Tony
-
Before posting, please check:
http://www.mysql
. Just
curious to hear some opinions.
On Monday 22 October 2001 05:42 pm, Moshe Gurvich wrote:
> select max(length(column)) from table
>
> -Original Message-
> From: Tony [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 22, 2001 2:36 PM
> To: [EMAIL PROTECTED]
gging into the manual, but time savings would be greatly appreciated.
Regards,
Tony
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To re
duce just the create table text (using the '-d'
option). If you omit the '-d' option, it will also produce an 'insert'
statement for each row in the DB. Obvisously, this can get quite huge
depending on the amount of data in your DB.
[tony@hoosier tony]$ mysqldump -
1 - 100 of 128 matches
Mail list logo
