Thanks to all those who replied, it worked fine
-
Chris Kay (Systems Development)
Techex Communications
Website: www.techex.com.au Email: [EMAIL PROTECTED]
Telephone: 1300 88 111 2 - Fax: (02) 9970 5788
I installed the Linux RPMs for the latest version of MySQL. But, no my.cnf.
How do I create one? I can't find anything in the 800+ page manual on how
to create said file.
I can't get any of the programs to work either. The mysql daemon starts,
the firewall has a hole cut in it for my IP to
I looked at the MySQL manual and it tells you how to
do automatic timestamps in TIMESTAMP columns. I can
do that fine if I use INSERT or UPDATE statements from
MySQL monitor. However, LOAD DATA INFILE delivers
zeros in the TIMESTAMP column. What am I overlooking?
How can I avoid getting the
Hi
I have doubt what to use to store the following:
1. If I have html data eg. htmlbodymy long data are here which include
more html tags/html etc...
Now, I would like this is stored as what it is and would like to do
query like
searching for specific word or words. Which is the best
Hello all,
Could someone be so kind and share with this newbie where he might find
crystal clear step-by-step instructions on how to install MySQL v3.23
on Mac OS X 2.2. I've looked through the manual and all I could find
was one sentence talking about what doesn't have to be done but no
Anybody seen a general page or study guide for the beta test yet? There
used to be a section on the MySQL site
(http://www.mysql.com/training/candguide/sec-core.htm) but its 404 now and
taking the test here in a couple days. Looked around on the site but the
information doesn't seemed to around
On 3 Dec 2002, at 10:45, Peter Abilla wrote:
Column One Column Two
1999-09-17 16:30:18 1999-09-18 13:30:18
I want to calculate the minutes like
(Column Two - Column One) = Total Minutes
Something like ( UNIX_TIMESTAMP(column2) - UNIX_TIMESTAMP(column1) ) / 60 ?
On 12/3/02 11:37 PM, Brian Radford [EMAIL PROTECTED] wrote:
Hello all,
Could someone be so kind and share with this newbie where he might find
crystal clear step-by-step instructions on how to install MySQL v3.23
on Mac OS X 2.2. I've looked through the manual and all I could find
was one
Sarah Killcoyne wrote:
I need to be able to connect to mysql through a perl or C++ script without
knowing the name of the database to connect to. I can't seem to find a way
to do this. Is it possible to either: look up database names so I can pick
one before connecting or connect without a
http://www.mysql.com/doc/en/Option_files.html
http://www.mysql.com/doc/en/Automatic_start.html
If you have not my.cnf file you can create a new one with a text editor.
Just write your options and then save it to the required place with the
name my.cnf.
If you enter a password for user root try
×𾴵ĸóÏÂmysql:ÄúºÃ!
´ÓÍøÉϲ鵽ÄúµÄÐÅÏ¢£¬ÎÒÃÇÊÇEE163ÍøÂçÓªÏúÖÐÐÄ£¬×¨Òµ
µÄÍøÂçÓªÏú¹«Ë¾£¬Ä¿Ç°´ó¶àÊý¹úÄÚÍâÆóÒµÒѾ¿ªÊ¼ÍøÂçÓªÏú£¬
EE163ÍøÂçÓªÏúÖÐÐĵÄÓªÏú²úÆ·ÊÇÆóÒµÓªÏúµÄ±Ø±¸¹¤¾ß£¬¼òµ¥
µÄ²Ù×÷¼´¿É×öǧÍòÈ˵Ĺã¸æ£¬ÏêÇéÇë·ÃÎÊÎÒÃǵÄÍøÕ¾¡£
ÓʼþÓªÏúÀ¸Ä¿£ºhttp://www.ee163.net/index-1.htm
--On Tuesday, December 03, 2002 12:14 PM -0500 Keith C. Ivey
[EMAIL PROTECTED] wrote:
My first guess is that you have CRLF where you think you've got just
LF. Have you tried the query with '\r\n' in place of '\n'?
That was it. I guess the data must have been imported from source that was
Caro Rogério,
Interpretei muito mal sua pergunta, peço desculpas e que desconsidere minha
resposta.
Apenas gostaria de dizer a respeito da sua pergunta, que acredito ser
difícil conseguir algum
comando SQL que resolva este antigo problema. Na minha opinião a linguagem
SQL visa buscar e
On Tue, 3 Dec 2002, Roger Baklund wrote:
* Simon Green
A LONGBLOB can store 4294967295 bytes
A LONGTEXT can srote 4294967295 bytes
In theory, yes. But not for real. MySQL 3.23.x has a limitation on the
max_allowed_packet parameter, the max setting is 16M. This will prevent any
single
I have downloaded 4.0.5 for Windows and so far it seems
to work. I am also using myCC and it works just fine. I
use some share/freeware called Cacheman to monitor the
memory and I will watch it closely today to see any
problems.
thanks
-Original Message-
From: DL Neil [mailto:[EMAIL
Hi Michael,
Well, the SQL Query you requested is exatcly the one I'm asking! :-)
Like I said in other message, I solved the problem using TWO queries. In
the first one I get the 10th date. In the second one I use this date to
LIMIT the result to what I want. But is not a question of solving
On Wed, 4 Dec 2002, tan hai shi wrote:
Hi
I have doubt what to use to store the following:
1. If I have html data eg. htmlbodymy long data are here which include
more html tags/html etc...
Now, I would like this is stored as what it is and would like to do
query like
searching
Taake a look a t /usr/share/mysql (or /usr/share/doc/mysql). You will
find some my.cnf templates in there.
Adolfo
-Original Message-
From: Vidiot [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 2:40 AM
To: MySQL mail list
Subject: No my.cnf - why?
I installed the
Folks
I'm trying to download 4.05a-beta for HP-UX 11.00. However I select the
file and go of to the sites to be told i'm trying to download binaries for
HP-UX 10.20. Anyone know where I can get the correct binaries for 11.00 ?
Rgds
Mike
E-mail: [EMAIL PROTECTED]
/mysql
sql
MySQL generated the following error messages about a corrupted table:
/
021127 15:48:01 InnoDB: Started
InnoDB: error in sec index entry update in
InnoDB: index umDoc table bdatena/tabdocumentoconsultado
InnoDB: tuple 0: len 8; hex 6c616e6472616465; asc landrade;; 1: len 4;
hex
Hola,
He instalado MySQL 3.23.53a y en numerosos documentos veo referencias a
'/usr/local/lib/mysql' cuando dicho directorio en mi sistema no existe, así
como a la libreria libmysqlclient.so
He hecho algo mal en la instalación?
Puedo crear dicho directorio consiguiendo los archivos de algun
Hello.
I 'm trying to connect from vb to a mysql 4.0.5 server with ssl support
with myodbc 3.51.The problem is that if i change the ssl_type in
mysql.user table from nothing to 'ANY' or 'X509' i get the message of
wrong password.Does anyone know what i have to do?
Thanks.
Giannis
Hi,
I m developing a web based application using Tomcat, Struts, JSP, mysql.
I m using mysql 3.23.39-max-nt and mysql-connector-java-2.0.14 to access
mysql through java 1.3.1.
But sometimes the select query on 1 particular table returns less no of rows
than the actual.
Most of the times it
MySQL uses memory and HDD the most and so processor speed is not so
important.
So I would go with what ever costs me the less.
Also how you OS works with the processors will be important.
What OS are you going to got for?
Threads and OS limits will also play a big part with speed.
Simon
I need some help on a select if it is possible. Take for Example the
following data.
--
| RUSH | FileNumber | PTime | PDate |
--
| 1 | 1-1023-001 | 08:00 | 12/04 |
| 1 | 1--001 | 06:00 | 12/04 |
| 0 |
Anybody seen a general page or study guide for the beta test yet? There
used to be a section on the MySQL site
(http://www.mysql.com/training/candguide/sec-core.htm) but its 404 now
and taking the test here in a couple days. Looked around on the site
but the information doesn't seemed to
On Wed, 4 Dec 2002, Helmut Apfelholz wrote:
Hi,
I am assembling mysql only server. I am planning 2Gb
RAM, 4 x 15k SCSI disks. However I cannot decide if I
should get 2 p4 processors or 2 tuallatin pIII.
I could not find any mysql specif?c benchmarks, that
would show which processors I
David,
Not bang on. A foreign key is a key which is the value of a key from a
'parent' table. In MySQL, if the table and its parent are InnoDB, the db
will prevent you from editing the parent key 'out of sync' as you say.
PB
-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi again,
Hi,
I am assembling mysql only server. I am planning 2Gb
RAM, 4 x 15k SCSI disks. However I cannot decide if I
should get 2 p4 processors or 2 tuallatin pIII.
I could not find any mysql specif?c benchmarks, that
would show which processors I should use.
I will be running linux on the server.
Sie erhalten diese E-Mail aufgrund einer Eintragung auf unseren
Webseiten. Information zur Abbestellung weiter unten
##
Hallo [EMAIL PROTECTED],
schön das Sie interesse am Thema digitales Video haben und Sich für
I've got two MySQL books that I've just purchased in order to help me
utilize the MySQL on my web host's server. I've been searching them both,
but I still don't have answers to some very basic questions.
Okay, the MySQL database I want to run will be on my web host. Since I don't
have the
* Thomas Spahni
On Tue, 3 Dec 2002, Roger Baklund wrote:
* Simon Green
A LONGBLOB can store 4294967295 bytes
A LONGTEXT can srote 4294967295 bytes
In theory, yes. But not for real. MySQL 3.23.x has a limitation on
the max_allowed_packet parameter, the max setting is 16M. This will
How can a query like HANDLER table READ on a MyISAM table be locked? I
thought the idea of HANDLER table READ was that it couldn't be locked.
Kill 1696313 xxx localhost xxx Query 3 Locked HANDLER questions READ
FIRST WHERE qid = 290184 LIMIT 1
Hello,
I have a simple database schema with a table of log entries that grows
quickly. Every month I'd like to break last month's entries off into a new
table for that (last) month. I know creating new tables within an existing
schema is not recommend database design, but in this case it seems to
On my RedHat Linux 7.3 system with MySQL 3.23, I can manually start mysqld
by using the following command: /usr/share/mysql/mysql.server start.
I always want the SQL server daemon running, so how can I automate the
startup?
Also, isn't there a way to safely stop the daemon automatically on
Nope , you haven't read my email .
I use PHP and MySql . Php closes mysql connections when the script ends .
And the script ends every time a user hits a page .
http://www.php.net/manual/en/function.mysql-close.php Quote : 'Using
mysql_close() isn't usually necessary, as non-persistent open links
Hi,
Can anyone please suggest a simple and effective method for converting a huge database
i hv in Access xp to MySQL ??
hv tried various methods, including using dsns , a small script available at
http://www.cynergi.net/exportsql/ etc.. they all work but not deliver a clean result...
any
Hi,
I am trying to access a third party MySQL table containing a BigInt field,
using ADO with a MyOLEDB driver.
The problem is that all this field ever returns are 0's.
I tried using ODBC with the Convert BigInt to Int option but then the
numbers get truncated.
Is there a way around this?
Linda:
MySQL is a database and Apache is a webserver. They are two independent
applications. To access the MySQL database, you will use CGI
programming or JSP.
Theodore Reph
[EMAIL PROTECTED]
-Original Message-
From: Linda Carter [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December
En que sistema lo instalaste?
Yo hice la instalacion en Red Hat 8.0 y lo instalo en
/usr/local/mysql(version infor) y luego tuve que crear un link
(/usr/local/mysql) que apuntara a ese directorio.
JFernando
** sql **
-Original Message-
From: Vicente Valero [mailto:[EMAIL PROTECTED]]
Is is it possible to write an aggregation function which returns
more than one row?
Thanks,
felix
Mysql sql query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
We're currently operating 1 MySQL server and are investigating methods
for having a primary and secondary server (with the secondary taking
over if the primary fails). I know about replication in MySQL, and was
thinking of using that to keep the secondary in sync, if the primary
should fail,
martin,
Monday, December 02, 2002, 6:13:58 AM, you wrote:
ml joins and nested where clauses.
ml Description:
ml The query analyzer seems to hang while trying to parse/optimize this
ml particular query if there is data in the table. Trying to understand why
ml mysql locked up running a
miked2miked,
Wednesday, December 04, 2002, 8:18:04 AM, you wrote:
myc I looked at the MySQL manual and it tells you how to
myc do automatic timestamps in TIMESTAMP columns. I can
myc do that fine if I use INSERT or UPDATE statements from
myc MySQL monitor. However, LOAD DATA INFILE delivers
myc
Steve,
Monday, December 02, 2002, 8:55:05 PM, you wrote:
SV Have you got a rough timescale as to when 4.1 will come out?
Before this year ends.
SV If not then is there a way to simulate Unicode in MySQL?
You can store unicode data in the MySQL database in the 3.23 and 4.0
as well.
On Wed, 2002-12-04 at 15:23, Helmut Apfelholz wrote:
--- Simon Green [EMAIL PROTECTED] wrote:
MySQL uses memory and HDD the most and so processor
speed is not so
important.
Well, processor speed is also important, on some of
our servers processors are almost 100% occupied.
If your
Ken,
Tuesday, December 03, 2002, 11:21:33 PM, you wrote:
KM I downloaded MySQL 3.23 for my Linux server and installed it using rpm -Uvh
KM *.rpm.
KM The installation went OK and at the end, I was given a Don't set the root
KM password reminder.
KM Specifically, it tells you to set the password
Kittiphum,
Wednesday, December 04, 2002, 1:49:08 PM, you wrote:
K This query can find the record in Table1 that not found in Table2
K SELECT Table1.ID FROM Table1 LEFT JOIN Table2 Using(ID)
K WHERE Table2.ID IS NULL
K and what query that use to delete the record in Table1 that not found
K in
* Linda Carter
I've got two MySQL books that I've just purchased in order to help me
utilize the MySQL on my web host's server. I've been searching them both,
but I still don't have answers to some very basic questions.
Okay, the MySQL database I want to run will be on my web host.
Since I
How about
Create newtable select * from oldtable where conditions_are_met;
Qmail List wrote:
Hello,
I have a simple database schema with a table of log entries that grows
quickly. Every month I'd like to break last month's entries off into a new
table for that (last) month. I know creating
--- Simon Green [EMAIL PROTECTED] wrote:
MySQL uses memory and HDD the most and so processor
speed is not so
important.
Well, processor speed is also important, on some of
our servers processors are almost 100% occupied.
So I would go with what ever costs me the less.
Also how you OS works
I'm running Mysql 3.23.52 on a Redhat 8.0 installation booting to Gnome.
The machine is a dual AMD 1800, 1 gig of ram, one Ultra ATA IDE drive, and 2
18 gig scsi 10,000 RPM drives on a RAID controller running Raid 0.
I've got everything except /db on the IDE drive, /db is the only thing on
the
Ken,
Here's one way:
From a terminal window, logged in as root or su, run setup and then
select services and you can select mysqld to be automatically started.
HTH!
Cory
sql, mysql, select, query
On Wed, 2002-12-04 at 08:31, Ken Morley wrote:
On my RedHat Linux 7.3 system with MySQL 3.23, I
Willie,
what MySQL version you are running? On what OS?
What does
SHOW CREATE TABLE tabdocumentoconsultado;
print?
Have you used an InnoDB version = 3.23.43 and stored characters with code
127 in the table? E.g., accent characters? The ordering of such characters
in the latin1 charset
Hi,
If you are using mysql_pconnect, your connections will not be closed at the
end of the script, even if mysql_close is used.
Regards,
Jocelyn
- Original Message -
From: cristian ditoiu [EMAIL PROTECTED]
To: Dan Nelson [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday,
Hello Linda,
You said --- The MySQL database I want to run will be on my web host. Since
I don't have the server physically in my possession, is the working method
to install MySQL to my machine, develop the routines there, then upload them
to my server?
You may not need to do this. Check
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 4 Dec 2002, Mike Knox wrote:
I'm trying to download 4.05a-beta for HP-UX 11.00. However I select the
file and go of to the sites to be told i'm trying to download binaries
for HP-UX 10.20. Anyone know where I can get the correct binaries
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 4 Dec 2002, Ken Morley wrote:
On my RedHat Linux 7.3 system with MySQL 3.23, I can manually start
mysqld by using the following command: /usr/share/mysql/mysql.server
start.
I always want the SQL server daemon running, so how can I
I will assume that your hosting service supports MySQL, which most of
them do.
Also, most of hosting services allow you to administer your database
using phpMyAdmin, in which you can create and drop databases and tables,
run SQL scripts, etc.
I will also recommend you to install Apache in your
I saved the email last time this was posted, didn't look into it but someone
suggested looking at this site. http://www.intranet2internet.com . Another
option was to link the table, not exactly sure of all the steps but maybe
create an empty table in mysql with all fields and data types, then set
Hi,
Is there a good tutorial somewhere on the join command. No matter what I do
it just doesn't work. Obviously I'm doing something wrong, but the MySQL
manual just doesn't help at all.
TIA
-
Before posting, please check:
QD answer in PERL!
my ($file);
$file = 'database_names';
$cmd = qq!show databases;!;
open O, cmd or die could open cmd - $!;
print O $cmd\n;
close O;
system (mysql -uusername -ppassword cmd $file)
== 0 or die could not do system - $!;
open I, $file or die could not open
MySQL can do embedded SQL like that? I'm using 3.23. If so, can the embedded
query have a WHERE clause as well (something like WHERE datetime
date_sub(NOW(), interval 1 month).
Thx a lot
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Qmail List [EMAIL PROTECTED]
Cc:
i had the same problem too ... also with blob fields
... never solved!
please keep me informed.
thanks. bye
--- Andre Michel Descombes
[EMAIL PROTECTED] ha scritto: Hi,
I am trying to access a third party MySQL table
containing a BigInt field,
using ADO with a MyOLEDB driver.
The
I used MySQLFront. It wasn't entirely automatic, but it did a reasonable
job. There are some gotchas.
Take your time, and be sure to read the notes for using Access and MyODBC
with MySQL, if that's how you're going to do it -- some column types are not
recommended. You'll want to add a
Sarah,
Wednesday, December 04, 2002, 12:48:15 AM, you wrote:
SK We updated mysql yesterday to 3.23max and have just discovered that load
SK data local infile . no longer works unless you enable it somewhere
SK specifically. I've tried starting mysql with the option -local-infile=1 in
SK
Julia,
Tuesday, December 03, 2002, 10:50:19 PM, you wrote:
Tuesday, December 03, 2002, 2:24:49 AM, you wrote:
JS I have just installed the mysql binary on solaris 8.
JS I would like have the data go to a different directory than /local/mysql/data.
JS How do I get it to do that?
JS I
Veysel,
Tuesday, December 03, 2002, 6:48:12 PM, you wrote:
VHS I use mySQL 3.23.49 with latin5 character set. At some of my tables I
VHS use binary fields. At normal fields order by clause returns true sorting
VHS but at binary fields I get wrong results. Is there any way to correct
VHS this
On Wednesday, December 4, 2002, at 12:50 AM, R. Hannes Niedner wrote:
Yes google :-)...
I'll have to remember that for the next time I think of asking a simple
question on this list! ;-)
http://www.entropy.ch/software/macosx/mysql/ or download the binary
for
mac os x from the mysql.com web
How can I tell what port number mysql is running on? I need it for a chat
program. :)
Thanks,
-Mike
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
I want to do the following:
1-If table x exists, then drop.
2-then, create table x again.
Explanation:
Table x in (1) has different date parameters than table x in (2). They are
called the same name because there is a function that uses that table.
Basically, I want to do something like:
DROP
I have a problem here.
I cannot connect to a particular server remotely at certain times. I get
the error
remote connection is blocked because of many connection errors. I can login
locally on the box.
To resolve this problem i would run FLUSH HOST and i can connect remotely.
But say about
En el mio tampoco, pero todo funciona OK. Mandrake 9 y MySQL 4.0.5
Adolfo
-Original Message-
From: Fernando Grijalba [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 11:21 AM
To: MySQL Help
Subject: RE: MySQL
En que sistema lo instalaste?
Yo hice la instalacion
Hi all
I have a detail table that has multiple records associated with an ID number
Both fields are integers
E.G.
Id Code
4 23
4 27
34 23
34 45
34 28
What I need to find is the Id where the code is 23 and 45 for
To get MySQL to automatically to start at bootup for mode 3:
In /etc/rc.d/rc3.d, mv K12mysql to S12mysql.
Theodore Reph
[EMAIL PROTECTED]
-Original Message-
From: Ken Morley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 8:31 AM
To: '[EMAIL PROTECTED]'
Subject:
I had a problem that required a proper sort of the following:
IT66
ITD38
IT68
ITD39
ITD40
IT69
ITD55
ITD56
IT72
ITD57
ITD58
ITD59
ITD60
IT73
ITD73
ITD67
IT74
ITD69
ITD70
IT78
IT79
IT83
ITD71
IT81
ITD75
ITD76
IT84
ITD96
ITD97
ITD98
ITD99
ITD100
ITD101
ITD102
Once server 1 is down you should be able to set server 2 master and then
point dns to server 2 and all should be good for server 1 to come back as
slave.
If you did not set server 2 as slave it would still work as a master the
only problem is how to point the questions to server 2! Dynamic DNS?
The only one I found that creates a good schema that only needs minimal
massages, and imports all the data correctly is Access-To-MySQL. It's
not free though, but they have a trial. Once I went through my access
database and removed certain invalid records (some rows had a screwed up
primary key
select * from processo_arquivos order by DATE desc limit 10
-Original Message-
From: Felipe Moreno - MAILING LISTS [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 03, 2002 12:42 PM
To: [EMAIL PROTECTED]
Subject: MySQL: Select HELP!
Importance: High
Hi List Users,
I want to know
At 17:29 +0200 12/4/02, Tom Roos wrote:
hi
does this function handle a binary string of any length or is there
some sort of max limit.
when i load a binary file (filesize 49Kb) into a blob field, the
function is ok but when the filesize is 1.8Mb, the function fails
and my programs aborts.
I'd suggest installing the MySQL RPMs from the MySQL.com website. They
will setup all of the init.d scripts to handle startup/shutdown of the
service.
Download all the RPMs to a directory on your server, then as root type,
rpm -Uvh MySQL*.rpm
Then you can stop/start it like this: service mysql
On Wednesday 04 December 2002 16:29, Tom Roos wrote:
hi
does this function handle a binary string of any length or is there some
sort of max limit.
when i load a binary file (filesize 49Kb) into a blob field, the function
is ok but when the filesize is 1.8Mb, the function fails and my
Is there an equivilent to a trigger in mySQL?
I need to build a cache mechanism for a website and I thought I'd use MySQL
for persistance. The problem is that I need it to schedule a cleanup task
every 24 hours - to remove old cache records. MS SQL Server provides a
trigger for scheduling such
hi
does this function handle a binary string of any length or is there some
sort of max limit.
when i load a binary file (filesize 49Kb) into a blob field, the function is
ok but when the filesize is 1.8Mb, the function fails and my programs
aborts. using the debugger, the program aborts when
Having the fastest memory that is available in your system is not as
important as having enough memory in your system. Without sufficient
memory, you can choke your whole system and bring your server to a crawl (or
even crash).
Bruce
- Original Message -
From: Nicolas MONNET (Tech)
On 4 Dec 2002, at 17:29, Tom Roos wrote:
when i load a binary file (filesize 49Kb) into a blob field, the function is
ok but when the filesize is 1.8Mb, the function fails and my programs
aborts.
There are two limits you should be concerned about. First a BLOB
field has a maximum size of
Felix,
Is is it possible to write an aggregation function which returns
more than one row?
Yes - if I have understood your requirement correctly.
It would have been helpful if you had given some idea of the
application/what you want to achieve. Here's an example from out of my
imagination:
On Mon, Nov 18, 2002 at 10:14:19PM -0700, Mark Stringham wrote:
Howdy -
I have heard that periodically optimizing tables can be helpful in the
overall maintenance of the table space in the db. Is this correct and how
often should it be done?
Depends how frequently the data in the table
On Wed, 4 Dec 2002 14:39:01 -, Sandeep Murphy wrote:
method for converting a huge database i hv in Access xp to MySQL ??
I just wrote a short program in Delphi (using MyODBC) to pull
information from an Access MDB and update a MySQL table. Worked fine.
I'm sure one could
On Wed, Dec 04, 2002 at 08:55:51AM -0200, Felipe Moreno - MAILING LISTS wrote:
Well, the SQL Query you requested is exatcly the one I'm asking! :-)
No; I want to know what you intended for those 10 dates to do. The LIMIT query
worked, as posted by someone else, which you quoted. What do you
Adolfo,
Thanks for the info, but can you elaborate on it, 'cause basically I am just
not getting the concept. No way no how can I get these joins to work.
mysql describe songs; (this contains an ID field and the title of the song
and the artist.)
whenever I try to start MySQL server...
I see this message
I'm operating Windows XP Professional...
what should I do??
Every Network Protocal was installed...
_
Help STOP SPAM with the new MSN 8 and get 2 months FREE*
Hi Mike,
i'm a newbie in optimizing the inner structure of a db - so i stick to the
os-part where i might have a vague clue ;-)
did you take a look at the memory / swap-space mysqld used when doing the
query?
(maybe use TOP (add swap to the view by hitting f and then o), look at
the swapspace
Hi
REposting as the 'spam' filter didn't like my mail.
Question, If I need to add a data file to the InnoDB setup can I just tack
another 'data file' to the innodb_date_file_path setting, restart server and
it will be used? Or, is there more involved like dumping data, re-creating
ALL the
I've posted my comments before but the important thing is that P4 is
largely unnecessary as it doesn't have instructions that apply to server
applications (mostly).
So, PIII (dual is quite helpful) the fastest you can get without paying
a premium
1 GB ram
dual scsi drives (raid 1)
This is the
Let's assume you want the entire albums list which the song
Day and Night by Billie Holiday is in.
SELECT t1.title,t1.artist,t3.name FROM sings t1
INNER JOIN reference t2 ON t1.ids=t2.ids
INNER JOIN album t3 ON t2.ida=t3.ida
WHERE t1.title='Day and Night' AND t1.artist='Billie Holiday'
(or WHERE
I have a table a with:
ItemID int unsigned not null,
CommID int unsigned not null
I have a table b with:
ItemID int unsigned not null
I want to move CommID from table a to table b. I've updated my schema
to have CommID in b as well for now, and changed my code to insert the
value into table
The first thing I would do is toss the ultra ata drive and just use the
scsi drives running raid1, raid0 just isn't safe and hardware raid1 is
much faster than you would think. This may seem counter-intuitive, but
there are all sorts of bus issues that could be interfering. You may
very well
Dear Tom,
when i load a binary file (filesize 49Kb) into a blob field, the function
is
ok but when the filesize is 1.8Mb, the function fails and my programs
aborts.
The communication buffer (between client and server) is set to 1 MByte by
default. You can change this either by starting the
Oh, and what's up with the thread_concurrency being 6? That doesn't
make any sense unless you have a tri-processor setup.
-Original Message-
From: Ledet, Mike [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 11:01 AM
To: '[EMAIL PROTECTED]'
Subject: Slow performance
1 - 100 of 113 matches
Mail list logo
