Hi MySQL Fans, hi MySQL AB ;-);
Is this structure
TRUNCATE [TEMPORARY] TABLE orginal_table_copy SELECT * FROM original_table;
planned to be supported or perhaps even working already and I missed
something ?
I was thinking f.e it would be nice to update a temporary table with new data.
Of co
On Friday, June 27, 2003, at 02:14 AM, James Moe wrote:
On Fri, 27 Jun 2003 01:44:53 -0400, [EMAIL PROTECTED] wrote:
umm... how do I specify which "one"? (this sounds really "slow-poke"
to me, sorry.)
Use either "people.peopleID = some_specific_ID" or "models.modelID =
some_specific_ID".
I'm
If it is the replication problem...::
Check the replication account on the master server:
...[EMAIL PROTECTED] identified by ...
...[EMAIL PROTECTED] identified by ...
...[EMAIL PROTECTED] identified by ...
...
...[EMAIL PROTECTED] identified by ...
or perhaps simply set to
...
Hi Keith,
from your last e-mail I understand now finally that we are talking about
replication here. Would have been a short cut to mention it in your first
e-mail.
The failed login attempts couldn't be from your slaves trying to login, but
you havent set them up on the master yet ?
Just a gu
When you said you modified the scripts, are these the scripts on the 12
webservers (mysql clients) ?
If not, then these mysql clients (webservers) would still be wanting to send
to IP addres 192.168.1.71 as configured for php or in your client.
Best regards
Nils Valentin
Tokyo/Japan
2003年 6月
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 27 Jun 2003 01:44:53 -0400, [EMAIL PROTECTED] wrote:
>
>umm... how do I specify which "one"? (this sounds really "slow-poke"
>to me, sorry.)
>
Use either "people.peopleID = some_specific_ID" or "models.modelID =
some_specific_ID".
- --
> I am having a similar problem. I looked at another Linux machine that
> has MySQL 4.0.13 running on it and the file /var/lib/mysql/mysql.sock
> is there but it is empty.
Well, that's the way sockets always look to my when I look at them with
a directory listing.
> So I created the file, chm
Neither of these two machines send the request.
I have 12 webservers, which send the requests.
I have 5 database servers, 1 master(for updates/inserts/deletes) and 4
slaves(for selects).
Machine A below was the current Master DB server, however it is old and was
being replaced by machine B
--
SELECT
LIMIT 1;
- Original Message -
From: <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Friday, June 27, 2003 1:08 PM
Subject: SELECT single record
Thanks everybody for all you great help!
Ok, this statement will select all of my records nicely:
> Well, the find / -name mysql.sock didn't return anything at all so this
> *is* an odd predicament.
Maybe it doesn't exist unless mysqld is running? Maybe the mysqld user
can't get at the directory the socket is supposed to be in?
> Would it work if someone with a similar
> version e-mailed m
Ok, this is good:
SELECT firstName, lastName, deptPOS, workPH, homePH, location, model,
make, propID, addressIP, OS FROM people, make, models, machines
WHERE people.peopleID = machines.peopleID AND make.makeID =
models.makeID AND models.modelID = machines.modelID LIMIT 1;
umm... how do I specif
Where can I learn --someplace really for dummies?-- about creating
filters and limits?
Thanks,
Ted
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 01:08 AM 6/27/2003 -0400, [EMAIL PROTECTED] wrote:
Thanks everybody for all you great help!
Ok, this statement will select all of my records nicely:
SELECT firstName, lastName, deptPOS, workPH, homePH, location, model,
make, propID, addressIP, OS FROM people, make, models, machines
WHERE peop
LIMIT 1
"Me fail English? That's unpossible"
###___Archon___###
- Original Message -
From: <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Friday, June 27, 2003 12:08 PM
Subject: SELECT single record
> Thanks everybody for all you great help!
>
> Ok, this statement will s
Thanks everybody for all you great help!
Ok, this statement will select all of my records nicely:
SELECT firstName, lastName, deptPOS, workPH, homePH, location, model,
make, propID, addressIP, OS FROM people, make, models, machines
WHERE people.peopleID = machines.peopleID AND make.makeID =
mod
I was wondering how I could remove old records. Perhaps if I had a field containing a
date for the record to be removed, how would I actually implement the deletion, could
I get mysql to do it automatically or would I have to call a php page every few days
to check if any outdated records exist
If the ID field is *not in your text file, why not take it out of the
CREATE statement and add it afterwards?
Ted
On Thursday, June 26, 2003, at 10:46 PM, Scott Haneda wrote:
I have this
CREATE TABLE `dictionary` (
`id` int(11) NOT NULL auto_increment,
`word` text NOT NULL,
`def` text N
I have this
CREATE TABLE `dictionary` (
`id` int(11) NOT NULL auto_increment,
`word` text NOT NULL,
`def` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
I have a huge text file, that is in the format of
stringstring
I want to load this into mysql, but I want to ski
sorry i worked it out put it after the table , i got some interesting results
Queried The Database 1 times for 9.9892050027847 seconds
+---+--+--+--+-++--+-+
| table | type | possible_keys|
Ok but that's not what I meant.
I'll try to explain better.
Machine A: IP = 192.168.1.71
Machine B: IP = 192.168.1.79
1) Scripts goto 192.168.1.71 - Everything is OK
2) Changed scripts to 192.168.1.79 - Site works at first, but processes pile up
until server is killed
3) Halt machine B
4) Gi
hi there i dont think this will help any further on my full text searching but i would
like an example of how to use FORCE INDEX , there is no example on the mysql site and
the hint is misleading i am getting sql errors , lemme know thanks
--
MySQL General Mailing List
For list archives: http:/
Hi Keith,
The wrong IP address could only avoid a client to connect to the database
server.
If you have the TCP/IP address specified in /etc/php.ini or for phpmyadmin in
config.inc.php or which ever tool you use than of course it will try to
connect to this IP address.
Best regards
Nils Val
Hello,
I'm using mySQL 4.0 trying to solve what I think is a simple problem.
to calculate the balance by account #
can this be done without the use of temporary tables ?
TABLE 1 contains
ACCOUNT #, INVOICE #, INV TOTAL
TABLE 2 contains
there can be multiple payment records associated wit
I'd instead setup a 2nd backup server that's a slave to the master,
replicates all the time, keeps in sync.
At X time, stop replication/mysql, backup data to tape .. restart mysql
and it will catch up/re sync back to master..
On Thu, 26 Jun 2003, SAQIB wrote:
> > mysqlhotcopy does your lockin
Hi Subhakar,
I would be interested to know what you mean with roll forward ?
In case you have another backup let's say @10AM you could use this one, but if
you dont have another backup where do you want to do a roll forward from ??
Do I miss something here ??
Best regards
Nils Valentin
Tokyo/
Hi Keith,
2003年 6月 27日 金曜日 09:05、Keith Bussey さんは書きました:
> Major problem!
>
> I've installed mysql-standard 4.0.13 (from binary) a new DB server, it is
>
> - quad-xeon (500mhz each cpu)
> - 3 gig RAM
> - Linux Redhat 7.3
>
> When I start up mysql, processes looking like the following begin to pile
Hi MySQL Fans,
I understood that within the mysql command line client there exist two help
pages:
a client help page - accessable with "help"
a server help page accessable with "help all"
I found that the file (seems like a table within the mysql privilege database)
was not included in the 4.1
Major problem!
I've installed mysql-standard 4.0.13 (from binary) a new DB server, it is
- quad-xeon (500mhz each cpu)
- 3 gig RAM
- Linux Redhat 7.3
When I start up mysql, processes looking like the following begin to pile up
until it kills the server:
| 106 | unauthenticated user | 192.168.1.
Can I roll forward if I do backups using Mysqldump? Say, I did backups using Mysqldump
@ 8:00 AM and my instance crashed @ 2:00 PM. I can restore the tables (both Innodb and
MyISAM tables) from my 8:00AM backup, but can I roll forward the data that changed
after 8:00 AM or do I lose the data aft
Fabio Bernardo wrote:
select pop, prot, sw_or_local, sum(qtd_porta) as soma from clientes where
status<>'C' group by pop,prot,sw_or_local
And I have this result :
+++-++
| pop| prot | sw_or_local | sum |
+++-++
|B
On 26 Jun 2003 at 15:01, danchik wrote:
> was the field type varchar? because it seems that no default varchars
> set the NULL or (NULL) as a literal "(NULL)" not a binary 0 for some
> reason.
You're confusing various meanings of "null". NULL in SQL has nothing
to do with binary 0 bytes (which
hi there
I wrote this querie :
select pop, prot, sw_or_local, sum(qtd_porta) as soma from clientes where
status<>'C' group by pop,prot,sw_or_local
And I have this result :
+++-++
| pop| prot | sw_or_local | sum |
+++-+---
hm, no, it works fine with int and varchar(40)
-Ursprüngliche Nachricht-
Von: "danchik" <[EMAIL PROTECTED]>
An: <[EMAIL PROTECTED]>
Gesendet: Freitag, 27. Juni 2003 00:01
Betreff: Re: can you insert null?
> was the field type varchar? because it seems that no default varchars set
> th
I ran the SELECT without the INSERT earlier today and it ran considerably
faster (at least 4 times), so I didn't think that it would be too bad to insert the
data.
Would it be faster to combine the two SELECT statements into:
insert into mytab2
select y03m02_Pt.person, y03m02_Acdt.plac
I take that back about defaults, worked fine on all types... the earlier
test i did on varchar after inserting NULL i brought the field up in edit
mode and aparently the editor converted it to literal "(NULL)" from NULL
(maybe it thought to be smart with varchars) where as the actual stored
value w
Actually, denormalizing aside, are multiple Joins or statements like...
SELECT lastName, location, model, make
FROM people, make, models, machines
WHERE people.peopleID = machines.peopleID AND make.makeID =
models.makeID AND models.modelID = machines.modelID
...common?
I guess that's actually c
was the field type varchar? because it seems that no default varchars set
the NULL or (NULL) as a literal "(NULL)" not a binary 0 for some reason.
- Original Message -
From: <[EMAIL PROTECTED]>
To: "danchik" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, June 26, 2003 2:31 PM
Su
I keep getting this error when I try to create a new database:
mysql> create database cheese_catalog;
ERROR 1044: Access denied for user: '@localhost' to database'cheese_catalog'
--
Ed Kiefer
Advantage Mail Services
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
On 26 Jun 2003 at 17:45, Charles Vos wrote:
> Could somebody please enlighten me as to why it takes nearly 2
> hours to put 8 rows of data into my table?
It's not the INSERT that's taking so long -- it's the SELECT. Try
the SELECT alone, and it will probably take the same amount of time
Steven
Why do you include the field name in your FROM part ? The syntax is SELECT
fields FROM table
I guess that could be the reason. Try with :
SELECT *
FROM `traffic`
LIMIT 132947
Freddie
-Original Message-
From: Mike Hillyer [mailto:[EMAIL PROTECTED]
Sent: Donnerstag, 26. Juni 2003
On 26 Jun 2003 at 17:16, Ware Adams wrote:
> mysqldump creates text files containing insert statements that
> recreate a table and repopulate it with data. They are somewhat
> portable across database servers and human editable if necessary.
> They take up less space than the original table beca
Hello All,
Could somebody please enlighten me as to why it takes nearly 2 hours to put 8 rows
of data into my table?
The insert commands I use are:
insert into mytab2
select y03m02_Pt.person, y03m02_Acdt.place, y03m02_Acdt.charge_id, y03m02_Acdt.disch,
y03m02_Pt.age, y03m02_Pt.sex, y03m02_Pt
I am having a similar problem. I looked at another Linux machine that
has MySQL 4.0.13 running on it and the file /var/lib/mysql/mysql.sock
is there but it is empty. So I created the file, chmod to 777 and then
tried to light up /usr/bin/mysqld_safe and it is giving the same error
message you
Yes, that works for Teradata and Oracle as well.
Regards,
Jake Johnson
[EMAIL PROTECTED]
--
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Car Audio, and Performance Parts.
On Thu, 26 Jun 2003 [EMAIL P
Cool, Thanks a ton. I think I will stick with mysqldump for a while until
my tables get too large. Currently my backups only take a few seconds.
Regards,
Jake Johnson
[EMAIL PROTECTED]
--
Plutoid - http://www.plutoid.com - Shop Plu
mysqladmin -uroot -ppassword reload
Curtis
On Tue, 24 Jun 2003, Riaan Oberholzer wrote:
> Hi,
>
> I am created a user by using:
>
> GRANT ALL ON *.* TO username@"%" IDENTIFIED BY
> "password"
>
> I did this from the mysql command line tool, logged in
> as root. The command succeeds and the n
hm? i just did a little test on mysql 3.23.56-nt, and had no problems setting a null
value on a null column having a default value other than null. it turned to be null,
rather than the default value.
··· yves at unclassified.de
-Ursprüngliche Nachricht-
Von: "danchik" <[EMAIL PROTEC
At 14:20 -0700 6/26/03, danchik wrote:
your statement will do just that, but make sure the field has no default
value and allows NULL
Why would it matter if it has a default value?
- Original Message -
From: "Bill2" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 26, 2003
Hi,
I would like to know if there are some websites, references (except the
manual ;) ), exemples of using the libmysql, especially from windows.
I get crazy trying to call the dll from a C# environment !! I get
nothing else than a "NullReferenceException" ???!!!???
I read that for using the lib
mysqldump creates text files containing insert statements that recreate a
table and repopulate it with data. They are somewhat portable across
database servers and human editable if necessary. They take up less space
than the original table because they do not contain indices (only the
statements
your statement will do just that, but make sure the field has no default
value and allows NULL
- Original Message -
From: "Bill2" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 26, 2003 1:48 PM
Subject: can you insert null?
> Hello all,
>
> Does anyone know if you can p
At 13:48 -0700 6/26/03, Bill2 wrote:
Hello all,
Does anyone know if you can put the value(not the string) NULL?
Something like
UPDATE TABLE some_table SET field = NULL
Sure. If the column isn't defined as NOT NULL, anyway.
Why? Did you try this and get results you didn't expect?
Thanks,
Bi
Hello all,
Does anyone know if you can put the value(not the string) NULL?
Something like
UPDATE TABLE some_table SET field = NULL
Thanks,
Bill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is this better than using mysqldump?
Regards,
Jake Johnson
[EMAIL PROTECTED]
--
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Car Audio, and Performance Parts.
On Thu, 26 Jun 2003, SAQIB wrote:
> > m
What is the purpose of the join? I think I know what you are trying to do
so make the first query a sub query and join the subquery to the carello
table.
Regards,
Jake Johnson
[EMAIL PROTECTED]
--
Plutoid - http://www.plutoid.com -
Well, the find / -name mysql.sock didn't return anything at all so this
*is* an odd predicament. Would it work if someone with a similar
version e-mailed me a copy of their mysql.sock file?
Kevin
>
>
> John Nichel wrote:
It doesn't look as if you have any conflicting MySQL versions. When the
SELECT * FROM ardata
WHERE title REGEXP '.*2000.*'
change that into parameter, but if you want to search on multiple words as
OR, youll have to split them and do separate ORs on tile REGEXP per word, or
rewrite this one something like ".*(2000)|(leagus).*" perhaps, not sure if
grouping is suported
On 26 Jun 2003 at 15:07, gerald_clark wrote:
> The second query contains a join and may have many times more rows in
> the result set.
[snip]
> >++-+--++--+
> >| date1 | sum1| sum2 | cod| fromprev |
> >++-+--+
On 26 Jun 2003 at 12:24, SAQIB wrote:
> > mysqlhotcopy does your locking for you.
>
> So running
> ./mysqlhostcopy dbase /path/to/backup/dir
>
> is perfectly safe while database operations (selct, insert, update
> etc) are being performed?
Yes, but the inserts and updates will all be blocked un
It is a perl program, so you can look at it and see.
SAQIB wrote:
mysqlhotcopy does your locking for you.
So running
./mysqlhostcopy dbase /path/to/backup/dir
is perfectly safe while database operations (selct, insert, update etc)
are being performed?
---
Saqib Ali
http://www.xml-dev.com
The G5 may not be all Apple says it is, but then, nothing is what it
seems when it comes to CPU's and performance tests. That said, if anyone
who wants to buy me one when they come out, I won't complain.
Interesting article. get's a bit numberish though.
http://www.theregister.co.uk/content/39/31
Why would you expect they should have the same results?
The second query contains a join and may have many times more rows in
the result set.
PaT! wrote:
Dear All,
I have these two queries which are supposed to return the same results
for the fields with the same name (ex query 1 sum1 = query 2
I'd be interested to see what happens when MySQL gets run on a G5.
SPECint and SPECfp numbers look very good. there is an 8GB RAM limit on
it, though.
Curtis
On Tue, 24 Jun 2003, Jeremy Zawodny wrote:
> On Tue, Jun 24, 2003 at 05:37:24PM -0400, Curtis Maurand wrote:
> >
> > Linux compiled
> mysqlhotcopy does your locking for you.
So running
./mysqlhostcopy dbase /path/to/backup/dir
is perfectly safe while database operations (selct, insert, update etc)
are being performed?
---
Saqib Ali
http://www.xml-dev.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.
I've got an interesting problem for you all. I'd love to hear what you think.
I've simplified the database design of my web application to its root problem,
so it'll be very easy to see my difficulty, and if you're feeling generous
possibly offer a solution.
I have two tables.
member table (ci
Dear All,
I have these two queries which are supposed to return the same results
for the fields with the same name (ex query 1 sum1 = query 2 sum1):
The first query gives me back the correct result for the sum():
SELECT DATE_FORMAT(ordini.dataord,'%d-%m-%Y') date1,
perror 145
Vikas Gupta wrote:
Hello all,
My /var partition has become full, and now when I try load my db (the
files are in /var/lib/mysql/db/) I get the following message for the
table "my_table":
use db;
Didn't find any fields in table 'my_table'
I then do "describe my_table" and I get:
E
Hi there,
Is there a way to upload a saved script file into the GUI window to
execute? On the GUI interface, there are SAVE, EXECUTE buttons. But I
cannot find anything for uploading, even copying functions.
Thanks for the help.
Regards,
Sean Tang
Hello all,
My /var partition has become full, and now when I try load my db (the files
are in /var/lib/mysql/db/) I get the following message for the table
"my_table":
use db;
Didn't find any fields in table 'my_table'
I then do "describe my_table" and I get:
ERROR 1016: Can't open file: 'my_
mysqlhotcopy does your locking for you.
SAQIB wrote:
We are in the process of implementing enterprise wide (20,000+ users)
application that will use mySQL as the Database engine. I was wondering if
the slashdot readers can provide me some details about best practices /
experiences for Backing Up
I ran iostat, what are important values to consider?
I ran the job from 12:31:51 to 12:32:18. I can see there was a noticeable
drop in tps. I should mention that this node is basically idle at this time
(it's a new development node, so no non-core processes except mysqld.
Linux 2.4.18-3 (venus)
> If your tables are InnoDB, you could look at InnoDB HotBackup:
> http://www.innodb.com/hotbackup.html
No I m not using InnoDB
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Sounds like a corrupt table, try REPAIR TABLE:
http://www.mysql.com/doc/en/REPAIR_TABLE.html
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: Steven Dowd [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 26, 2003 11:13 AM
> To: [EMAIL PROTECTED]
> Subject: error message
If your tables are InnoDB, you could look at InnoDB HotBackup:
http://www.innodb.com/hotbackup.html
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: SAQIB [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 26, 2003 11:45 AM
> To: [EMAIL PROTECTED]
> Subject: Best Pratice
thanks for your hint in that direction!
i'm currently using the latest mysql 3.23, but i guess, i'll upgrade to 4.0 before i
get my server up and running.
but what i found, and may be more appropriate for my needs is the --safe-show-database
option. i just added it to /etc/my.cnf, restarted the s
Where can I find more info on converting and what can be converted.
Thanks
Mike Benzel [EMAIL PROTECTED]
Promote your Product with a Free SkyWiremeeting!
SkyWire Meeting - Internet Training from you PC or our Server.
We are in the process of implementing enterprise wide (20,000+ users)
application that will use mySQL as the Database engine. I was wondering if
the slashdot readers can provide me some details about best practices /
experiences for Backing Up and Restoring mySQL Databases. I am planning to
setup a
Just a guess from a raw newbie, but try using:
`traffic.trafficdb` instead of `traffic`.`trafficdb`
Ryan
Thursday, June 26, 2003, 1:13:03 PM, you wrote:
SD> can someone help me with this error, with my database in MySQL 3.23.49
SD>
SD> SQL-query :
SD> SELECT *
SD> FRO
Check the client sources.
The mysql client is a great example for the c API.
Sean Macmillan wrote:
Please bear with me here as I am new to this whole MySQL thing. Does
anyone know where I can find a good example of how the C API function
call mysql_thread_init() is implemented? Any help would
Please bear with me here as I am new to this whole MySQL thing. Does
anyone know where I can find a good example of how the C API function
call mysql_thread_init() is implemented? Any help would be
appreciated. Thanks in advance.
Sean
--
MySQL General Mailing List
For list archives: http://
can someone help me with this error, with my database in MySQL 3.23.49
SQL-query :
SELECT *
FROM `traffic`.`trafficdb`
LIMIT 132947
MySQL said:
Got error 127 from table handler
have I lost the data, or is there something odd happened which i sh
* Jeremy Zawodny ([EMAIL PROTECTED]) wrote:
> On Tue, Jun 24, 2003 at 09:14:18PM -0700, Carl B. Constantine wrote:
> > I want to be able to take a database running on a primary server and
> > duplicate/mirror it on a secondary server. I want to be able to update
> > the secondary server on a select
I've been having a few problems loading blobs via the LOAD_FILE function
I've tried things along the lines of:
UPDATE table SET binaryRecord=LOAD_FILE("/Users/shared/filename.mov")
where refNo=1;
It only seems to happen when loading something over 1-1.5mb, as I've
been able to load smaller fil
At 6:32 -0400 6/26/03, Andrew Pierce wrote:
I have a question regarding compiling a C program with the mysql C api.
From the documentation, the only way I really see explained for compiling
is a shell script that looks like this:
CFG=/usr/bin/mysql_config
sh -c "gcc -o $1 `$CFG --cflags` $1.c `$CF
At 16:22 +0900 6/26/03, Nils Valentin wrote:
Hi MySQL Fans ;-);
Does anybody understand what the QUICK option is doing when used with the
DELETE command ? It says in the manual "..no MERGEing of INDEX leaves during
delete".
Sorry, but I could not make any sense out of this. Could somebody please b
At 2:58 -0400 6/26/03, [EMAIL PROTECTED] wrote:
Ok, I trying to get this example... what is "table1 t1, table2 t2,
table3 t3, table4 t4", I mean, what does the t1, t2, t3, t4
represent? If you say, table 1, table 2, etc well, I assume
that, but isn't that there already?
t1, t2, etc. are tab
Hi,
MySql crashed complaining about signal 11 after we reconfigured the db for a
large db type.(It was running fine on medium db configuration) It is running on
Solaris 2.8 with 1 GB RAM along with Resin App Server.
Does large db configuration require the whole machine to run mysql?.
Do you have disk performance data? My guess would be it's the time to
read the information off the disk.
I think redhat has the iostat command. Try running
iostat 1
in one window while you run your query in another, what result do you
get from the iostat?
--
Michael Conlen
Bob Ostermann wrote
This may not help with the comma problem, but your app looks like a good
candidate for FULLTEXT searching, check out
http://www.mysql.com/doc/en/Fulltext_Search.html for information.
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: Tom Johnson [mailto:[EMAIL PROTECTED]
Hi-
I'm running mysql Ver 12.20 Distrib 4.0.13, for pc-linux (i686) / RedHat
7.3 on a AMD 2400XP 256 MB.
I've got a table (type=MyISAM) that's grown to 1,7 GB (154,815 records) and
it takes several seconds to perform even simple querys:
select data from eod where symbol='ZOOM'
yields: 1 row
I think you are after subselects more than a UNION. The latest example
of me using union was where a had 2 queries with table A and B: first
query has tableA LEFT JOIN tableb, second query had tableb LEFT JOIN
tablea. By using UNION I was able to retrieve the results of both with
one query.
Regard
hi all!
i am very much interested in knowing the
intricacies of the MySql server. i use Mysql version
3.23.52.
how can we get informations regarding all Mysql
transactions and regarding the tables and databases
that have been dropped. Also how can we get the amount
of time spent by
You could try
SOUNDEX(str)
http://www.mysql.com/doc/en/String_functions.html
which might do what you are looking for
HTH
Peter
-Original Message-
From: Tom Johnson [mailto:[EMAIL PROTECTED]
Sent: 26 June 2003 14:23
To: [EMAIL PROTECTED]
Subject: Need your help in a search query
Hi
"David Bush" <[EMAIL PROTECTED]> wrote:
>
> I run the following query:
>
> select * from x where x like 'x/%' ;
>
> I would like the result of this query to go to a file or pause at the end of the
> screen so that I can view each page. Any help would be appreciated.
Use S
"PaT!" <[EMAIL PROTECTED]> wrote:
> I have this two queries
>
> The first one gives me the right result for the sum():
>
> SELECT DATE_FORMAT(ordini.dataord,'%d-%m-%Y'),
>SUM(ordini.totale),
>SUM(ordini.quantita),
>
Hi MySQL Experts,
I am pretty new at this and need your help in figuring out if it is possible
to create a query to search for words in a given field. What I am trying to
do is allow a user to enter words to search for a given title in the
database. For example, a person is looking up the title
[EMAIL PROTECTED] wrote:
Ok, I trying to get this example... what is "table1 t1, table2 t2,
table3 t3, table4 t4", I mean, what does the t1, t2, t3, t4
represent? If you say, table 1, table 2, etc well, I assume that,
but isn't that there already?
Let me, or may I, give ask again with m
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
pswebcode, nyc wrote:
> Regular MySQL 4 setup exe does not work on my version
> of WINXP Pro.
>
> Can you provide link to an MSI installer download of MySQL 4
>
> [EMAIL PROTECTED]
>
>
There is not an MSI installer for MySQL 4.0. There will be one fo
Pat,
I think it might be caused by the fact that you are grouping by a column
that isn't being selected - ordini.numordine is not in the select part.
Andy
> -Original Message-
> From: PaT! [mailto:[EMAIL PROTECTED]
> Sent: 26 June 2003 12:50
> To: [EMAIL PROTECTED]
> Subject: sum() proble
EMS HiTech company is pleased to announce MySQL Manager for Windows 2.5 -
the next version of the best MySQL administration and development tool!
You can download the latest version and user's guide from
http://www.mysqlmanager.com/download.phtml
What's new in version 2.5?
1. We have added a pos
1 - 100 of 120 matches
Mail list logo
