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`
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
ppreciated.
Tony
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
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
--
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
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]
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
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
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
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
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
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:
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
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 -
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
. 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]
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
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/
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
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
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
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
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
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
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
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
);
?section consistency_check
select .
---
Does anyone know whether this functionality exists in MySQL?
Regards,
Tony
-
Before posting, please check:
http://
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
...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
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 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
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:
> &
.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
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,
> >
> >
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
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
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]
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
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:
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
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
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 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
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
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
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
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.
&
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
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
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
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
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 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
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
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
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
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
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();
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%'
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
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
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.
- 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
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
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
> - 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
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
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'
>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 '',
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:
.
+--+
| ___ ___ |
| //_/_/_/_/_/ //_/_/_/ |
|//_/ //_/ _/ |
| //_/ //_/ _/|
| //_/ //_/_/_/ |
+--+
| Tony Devlin - [EMAIL PROTECTED] |
| Airewaves Broadband, Systems Admin |
| Website - www.airewaves.com |
| Atlanta, Ga - 678.522.3923 |
| Beaufort, SC - 843.379.AIRE(2473
/english/errmsg.sys
Is anyone else getting this? Any ideas how to get round it?
Thanks!
Tony Butcher
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
base, use mysqladmin flush-hosts ...' or something to
that effect. (It's been awhile since it's happened.) Flushing the hosts
solves the problem but I was wanting to do garbage collection on these
connections to p
Try this.
ps aux | grep mysqld | cut -c 10,11,12,13,14
- Original Message -
From: Teddy A Jasin <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 16, 2001 7:32 PM
Subject: returning PID
Hi,
wat command to type under linux to get the PID of the mysqld that is
running?
suggest you try to divide your query into several small
queries. According to your query below, you are likely to join about 10
tables. As data grows, join those tables will produce undetermined large set
of data.
Tony
-Original Message-
From: Hannes Wyss [mailto:[EMAIL PROTECTED]]
Sent
One more suggestion is, using LIKE to search (whatever your column is
indexed or not) is definitely slow than using "=". I try it in 0.38 M
records before.
-Original Message-
From: Tony Shiu [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 11:21 AM
To: [EMAIL
ng in
.setEntityContext.
For setting default value to MySQL server, u'd better search in manual. I
haven't noticed that yet.
Tony
-Original Message-
From: muhammed najmi [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 29, 2001 2:51 PM
To: [EMAIL PROTECTED]
Subject:go
try
insert into pictures
values ('c:\\pictures\\computer.gif);
single \ is for escape special characters in MySQL.
-Original Message-
From: Roy Wasse [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 29, 2001 4:42 PM
To: [EMAIL PROTECTED]
Subject:Link to pictures outsi
in UNIX derivatives,
vi a text file, and write your create/other sql into it then save and close
it.
cat your_file | ./bin/mysql -uyour_username -p your_database
you will be prompted to enter a password for your username.
then enter your password.
- Original Message -
From: <[EMAIL PR
It sounds like the PHP module was compiled without MySQL support.
root wrote:
>
> Hi,
>
> I'm running mysql MAX 3.23.41 on LinuxPPC, everything was installed from
> an RPM.
> My problem is whenever I try to call mysql_connect (), from a php3
> script, I got the error function not found or misco
can anyone tell me why an auto increment field would jump from 231 to
something large like 883607 and then give me failure on future insertions
because of a duplicate key?
I'm running mysql 3.23.39 on RH 7.1
--Tony
-
B
just compile support for both in.
--Tony
On Sun, 2 Sep 2001, Kalpesh Modha wrote:
> Does mysql work on rehat 7.1.
>
> I have installed it but can not get PHP, JAVA to access the database. I just get
>connection refused.
>
you using 7.0 or 7.1. If 7.0 try grabbing the rpms from the 7.1 image and
see if that works.
--Tony
On Sun, 2 Sep 2001, Mike wrote:
> Using RH 7 after a Plain setup I tried to install the rpm's version 37
> through 39 with the same error. Not a valid RPM. I tried both Gnome RP
Thanks for clearing that up with me...didn't know that.
--Tony
On 3 Sep 2001, Trond Eivind Glomsrød wrote:
> Tony Bibbs <[EMAIL PROTECTED]> writes:
>
> > 7.1 doesn't install php with mysql support enabled.
>
> Yes, we did.
>
> > FYI, redhat is doing
t, the
php-postgres RPM is installed.
On a lighter note, I am glad to know the php-mysql RPM is on the RH
discs...makes future installs a tad bit easier. Sorry for causing such a
stir,
--Tony
On Tue, 4 Sep 2001,
Sinisa Milivojevic wrote:
> Trond Eivind Glomsrød writes:
> > Tony Bibb
Harpreet wrote:
>
> I am trying to use MYSQL CLIENT for the first time. I have setup the mysql
> server and connect to it from my machine using Telnet.
> But everytime i try to connect using mysql client or through access 2000 i
> get the following error:
>
> Host 'ip address' is not allowed to
Dave Lake wrote:
>
> Hi Folks
>
> I have used MySQL for some time and am just getting my head around PHP. I
> looked across a number of PHP sites for some input on this but failing to
> find an answer thought I would ask some MySQL users (surely many of you are
> using PHP right? ;-) ) for help.
Can someone help me decipher this make error?
Making all in client
CC -DUNDEF_THREADS_HACK -I./../include
-I../include -I./.. -I..
-I..-O3 -DDBUG_OFF -DHAVE_BROKEN_PREAD
-DDONT_USE_FINITE
-D_INCLUDE_LONGLONG -DNO_FCNTL_NONBLOCK -c mysql.cc
aCC: warning 901: unknown o
"Ralf R. Kotowski" wrote:
>
> I did install all RPM's exept the benchmark. What is the name of the
> header files?
>
> On 3 Oct 2001, at 14:20, Carl Troein wrote:
>
> >
> > Ralf R. Kotowski writes:
> >
> > > I got Red Hat 6.2 and the Mysql 3.23.36-1 RPM packages installed,
> > > when I try to c
riable table_cache=128
I have struggled with this for some time and any suggestions would be
very much appreciated.
Thanks,
Tony Lembke
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Would anyone know of a method to create/fake/move/configure and index on an
alternate disk than the base table? I hail from a platform that allows
specific disk specification for partition, index and alternate key files.
Naturally, I referenced Paul DuBois' amazing book, to no avail.
Just
Thanks, that worked. However, it appears that each time I execute an alter
table command (such as addng a new index), I'll have to repeat the process of
creating the index, moving the file, then again defining the symlink.
MySQL does not seem to respect the link with new DDL commands like th
%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
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
--
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,
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
(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
1 - 100 of 128 matches
Mail list logo
