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
--
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, chmod
-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.
- --
jimoe at
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
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
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
...
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 more
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
Hello,
I do the next request on a table with a column type varchar2
insert into XX ('test\annuaire\');
the request succeeds but in the table '\ have disapeared.
testannuaire
Could someone help me?
thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
No, the slaves replicate fine and I can see their entries in the processlist
normally (as their hostname), not as unauthenticated user..
--
Keith Bussey
Wisol, Inc.
Chief Technology Manager
(514) 398-9994 ext.225
Quoting Nils Valentin [EMAIL PROTECTED]:
Hi Keith,
from your last e-mail I
No, replication is fine I can see those processes as they should be. The problem
processes all come from the webservers' requests.
--
Keith Bussey
Wisol, Inc.
Chief Technology Manager
(514) 398-9994 ext.225
Quoting Dominicus Donny [EMAIL PROTECTED]:
If it is the replication problem...::
Quoting Nils Valentin [EMAIL PROTECTED]:
When you said you modified the scripts, are these the scripts on the 12
webservers (mysql clients) ?
Yes, when I mention modifying my scripts, I mean the scripts/pages on the 12
webservers
If not, then these mysql clients (webservers) would still be
Hello,
how can i delete an foreign key between two tables? Is there a drop foreign
key - command available?
Thanks
Nico
--
+++ GMX - Mail, Messaging more http://www.gmx.net +++
Bitte lächeln! Fotogalerie online mit GMX ohne eigene Homepage!
--
MySQL General Mailing List
For list archives:
# [EMAIL PROTECTED] / 2003-06-27 09:45:06 +0200:
how can i delete an foreign key between two tables? Is there a drop foreign
key - command available?
yes, read:
http://www.innodb.com/ibman.html#InnoDB_foreign_keys
--
If you cc me or remove the list(s) completely I'll most likely
I have an installation of MySQL where the data directory is located on an NFS share.
Client and server are connected by Full Duplex Gigabit Ethernet (both hosts run Linux
2.4.21). The NFS is exported with sync option.
Read performance is really fine, but when it comes to writing e.g. an
Hi Nico,
I understood that DROP FOREIGN KEY is not supported before Version 4.0.13.
( In such case you will have to drop the table and recreate it.)
Best regards
Nils Valentin
Tokyo/Japan
2003 6 27 16:45Nico Gr :
Hello,
how can i delete an foreign key between two tables? Is there a drop
Hi!
On Jun 27, Nils Valentin wrote:
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
Hi!
On Jun 27, Daniel Rossi wrote:
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
Hi Sergei,
Thank you for the reply. I could indeed install the tables on the rpm
installation (4.1 alpha).
However on the the xx.tar.gz (4.0.13) version I get this:
./mysql_install_db: line 1: my_print_defaults: command not found
Didn't find ./bin/mysqld
You should do a 'make install' before
I don't have direct answers to your questions but you should consider
adding an integer 'userid' to member table and using it as a foreign key
in member_log table instead of username. It will make selects and joins
faster, data and index sizes smaller.
Also, I don't know what you mean by 'medint'
Sorry to reply to myself but after reading your post again,
I think you can use replication to maintain member table in sync:
it is possible to restrict replication to a some tables within a
database: check 'replicate-do-table' option.
Hope this helps
Joseph Bueno
Joseph Bueno wrote:
I don't have
Hello,
Is it possible to load from the database a field entry with
password(XXX) and see it not crypted, as if we 've made a
unpassword(XXX) action ?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hi all,
i have a table in my mysql database with around 66 million rows in it. when i query this table, it takes anywhere from 3 minutes to 10 minutes to return the results. i've tried this both from within the mysql command line and from java programs.
Section 1.2.4 in the manual says the
select * from TableName LIMIT NumberOfRows
George Christoforakis
- Original Message -
From: Maurice Coyle
To: [EMAIL PROTECTED]
Sent: Friday, June 27, 2003 12:34 PM
Subject: very long query time
hi all,
i have a table in my mysql database with around 66
Replace \ with \\
Ulterior
=
Global FTP Search - www.filesearch.lt
- Original Message -
From: Gantier [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 27, 2003 9:11 AM
Subject: Pb with insert
Hello,
I do the next request on a table with a
Gantier [EMAIL PROTECTED] wrote:
Is it possible to load from the database a field entry with
password(XXX) and see it not crypted, as if we 've made a
unpassword(XXX) action ?
Nope. This encryption is non-reversible.
--
For technical support contracts, goto
Mike [EMAIL PROTECTED] wrote:
Where can I find more info on converting and what can be converted.
Check the following section of the manual:
http://www.mysql.com/doc/en/Using_mSQL_tools.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is
Seth Redmond [EMAIL PROTECTED] wrote:
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
Ed Kiefer [EMAIL PROTECTED] wrote:
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'
User doesn't have permissions to create database.
--
For technical support
Gantier [EMAIL PROTECTED] wrote:
Hello,
I do the next request on a table with a column type varchar2
insert into XX ('test\annuaire\');
the request succeeds but in the table '\ have disapeared.
testannuaire
You must escape this char:
Hi
http://www.mysql.com/doc/en/Fulltext_Search.html
the create and insert of data went ok but when i do
SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('database');
i get SQL-query
I am using RH8.0 and mysql 3.23.56 and php 4.3.2
I connect ok and my other code works SELECT term,
Hi.
When I execute the perl script mysqlaccess I receive the following error
Can't locate CGI.pm in @INC (@INC contains:
/usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.0
Hi Maurice,
I would be interested to see how your SQL reuqest looks like. Perhaps it is
possible to optimize at this point, just a guess so.
Best regards
Nils Valentin
Tokyo/Japan
2003 6 27 18:34Maurice Coyle :
hi all,
i have a table in my mysql database with around 66 million rows in it.
On Friday, June 27, 2003, at 05:34 AM, Maurice Coyle wrote:
i have a table in my mysql database with around 66 million rows in
it. when i query this table, it takes anywhere from 3 minutes to 10
minutes to return the results. i've tried this both from within the
mysql command line and from
[EMAIL PROTECTED] wrote:
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
Syamsul Arifien [EMAIL PROTECTED] wrote:
I have :
call to undefine function mysql_connect() atphp line
that's the message..
First of all, please, answer to the mailing list, not to me directly.
This error means that PHP isn't compiled with MySQL support.
--
For technical support
Shaun Callender [EMAIL PROTECTED] wrote:
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
I think it's always a bad idea to create complex setups like you are
contemplating. I would try everything else first. For instance, I don't
see any reason to use varchar, that creates variable length records
which you want to avoid if you can. Especially with the number of
records you are
I have a question regarding mysqlhotcopy's use.
I'd like to use the --flushlog option in order to have a nice backup
synchronized log for my replication slave in case of recover need
(without stopping the master).
But the lock used by mysqlhotcopy made me split the backups into
something like:
It's not the insert that are taking a long time, it's the selects.
Trying running the command with and explain in front of it to see where
you query is bottlenecking. Perhaps you don't have an index on one of
your search fields.
The first query is probably running faster because you have a few
G'day all,
Having trouble with SUM, could use a hand. I inherited a table, Funds_Recd that looks
like this:
ID Job Sub Task Amt
1A01 A1910,001.00
102 B53 A201 79.47
213 X99 L8838,289.02
284 A01 A19126.98
I do not have ownership and *MAY NOT*
Hi all,
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Sent: Friday, June 27, 2003 3:18 PM
To: [EMAIL PROTECTED]
Subject: Re: incorrect SUM() results
Shaun Callender [EMAIL PROTECTED] wrote:
I'm using mySQL 4.0 trying to solve what I think is a simple
That can't be the output of the query.
The fourth column would me titled 'soma'
There is no seperator bar between the data for sw_or_local and soma on
the data lines.
Fabio Bernardo wrote:
hi there
I wrote this querie :
select pop, prot, sw_or_local, sum(qtd_porta) as soma from clientes where
Yes, if you have transaction logging turned on.
You can edit the transaction log, and run it against the restored database.
Subhakar Burri wrote:
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
On Fri, Jun 27, 2003 at 09:05:48AM -0400, Moulder, Glen wrote:
G'day all,
Having trouble with SUM, could use a hand. I inherited a table, Funds_Recd that
looks like this:
ID Job Sub Task Amt
1A01 A1910,001.00
102 B53 A201 79.47
213 X99 L8838,289.02
Kevin H. Phillips wrote:
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
adding an integer 'userid' to member table and using it as a foreign key
in member_log table instead of username.
You're right. The main reason i'm doing this, is due to legacy reasons.
Also, I don't know what you mean by 'medint' but if it is a mediumint,
you will be in trouble since its
Part of the problem may be the size of the returned set. If you are
having MySQL return the date on 11K rows, your bottleneck may be the
network or disk. Remeber, MySQL has to read all that data from the
database and transfer to your program or display it for the command
line. Even if you had
Exactly that's the problem!
how can I rewrite the query syntax avoiding the multiplication?
Thanks
Patrizio
-Messaggio originale-
Da: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Inviato: giovedì 26 giugno 2003 22.15
A: [EMAIL PROTECTED]
Oggetto: Re: sum() problems - I don't understand
On
Hello,
I work with apache, tomcat and linux redhat 7.3 and mysql 4.0.9
When I try to connect to my database from my application with the user
XXX with password YYY, the next message appears :
INVALID AUTHORIZATION SPECIFICATION :
ACCESS DENIED FOR USER '[EMAIL PROTECTED] 127.0.0.1' USING
This more a perl question.
You need to install CGI.pm for perl.
The CGI module should be available from RPMs.
HTH,
Lian
-Original Message-
From: Iago Sineiro [mailto:[EMAIL PROTECTED]
Sent: Friday, June 27, 2003 1:32 PM
To: MySql Mail List
Subject: perl error when execute
I think it's always a bad idea to create complex setups like you are
contemplating.
I'd agree. They are very hard to maintain if you need to change things in the
future.
see any reason to use varchar, that creates variable length records
which you want to avoid if you can. Especially with the
OK.
I sent to you once on the list, and to the original poster, but it was
returned from his email server (who knows).
Here it goes.
The most probable reason reason that file is not there is permissions. When
mysqld starts (under user mysql or mysqld) it writes the file in the
directory
Shaun Callender [EMAIL PROTECTED] wrote:
calculate the balance by account #
TABLE 1 contains
ACCOUNT #, INVOICE #, INV TOTAL
TABLE 2 contains
there can be multiple payment records associated with an invoice
ACCOUNT #, INVOICE #, PAYMENT, PAYMENT DATE
select TABLE1.accountno,
I have had similar performance concerns, but on a much smaller scale.
The data was well indexed, but took far too long to query (particularly
with aggregate queries).
Check the individual row size of your table. In my case, I had a TEXT
field that would frequently be fairly long. Moving that
Can any one help me?
Yasir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks to everyone for their help, I actually managed to fix the problem by bypassing
MySQL's optimization using STRAIGHT_JOIN. Out of curiosity can anyone tell me why
MySQL failed so miserably at optimizing my query? (The two hour long query took 10s
with Straight_join).
mysql explain select
Thanks. I've installed package perl-CGI and now it works.
Iago Sineiro
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Enviado el: viernes, 27 de junio de 2003 15:48
Para: Iago Sineiro; MySql Mail List
Asunto: RE: perl error when execute mysqlaccess
This more a perl
I am trying to get the fulltext search working properly as described in the
manual but some queries do not seem to be working correctly. When I run this
query:
SELECT allusa.name,title,full_text,match(title,full_text) against ('chicken
soup lemon') from recipes, bb.allusa where innid =
Hi Fred, group,
I wrote--
I'm trying to get just a total of the funds amount for a
Job, Sub and Task like this --
SELECT Jobs.Job, Jobs.Sub, Jobs.Task, sum(Funds_Recd.Amt) AS Amount
FROM Jobs, Funds_Recd WHERE Jobs.Job=Funds_Recd.Job and
Jobs.Sub=Funds_Recd.Sub and
Ok, I added IN BOOLEAN MODE and now it somewhat works...It is just a matter
of optimizing it now. Thanks.
- Original Message -
From: Cliff [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 27, 2003 8:13 AM
Subject: Problem with FULLTEXT searches
I am trying to get the
I posted to this thread yesterday indicating that I had the same
problem. After playing with it some more I realized that I was not
starting MySQL with the appropriate user/group. As mentioned below,
the user has to have write permissions to this directory in order to
create the unix domain
I've developed a CMS using PHP and MySQL 4.1 alpha.
It ran just fine with the standard MySQL 4.1a binaries both on my
Powerbook running Mac OS X as well in a production environment on my
FreeBSD server. However, after having installed everything on a clean
Debian Linux system, there are some
Are .fil files associated or view able with sql at all. Someone
mentioned to me that they might be. My companys database uses .fil
files and I want to be able to link to the information in them for web
based inventory display.
Or --- Am I way off base here?
Make it a great day!
Ben
At 10:36 -0500 6/27/03, Ben Ferderer wrote:
Are .fil files associated or view able with sql at all. Someone
mentioned to me that they might be. My companys database uses .fil
files and I want to be able to link to the information in them for web
based inventory display.
What's a .fil file?
The extension of the data files specific to my companys inventory and
accounting info. If it helps this programs seems to be written in
cobol or acucobol.
Ben Ferderer
System Administrator
Radio TV Equipment
[EMAIL PROTECTED]
800.288.9134
-Original Message-
From: Paul DuBois
In that case they are probably fixed width files. If they are not fixed
with and are in fact delimited by tab or comma, you can use LOAD DATA to
bring them in.
See http://www.mysql.com/doc/en/LOAD_DATA.html
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Ben Ferderer
Well, without seeing your table structures and key definitions, how
could we tell?
You are selecting on code=87901 , but there is no indication here
about what tbale that column belongs to.
Did you run analyze on your tables to update key distribution
information so the server could make a
'localhost 127.0.0.1' is not a valid host.
Use 'localhost' if you want to use the local socket.
Use '127.0.0.1' if you want to use the TCP port.
Gantier wrote:
Hello,
I work with apache, tomcat and linux redhat 7.3 and mysql 4.0.9
When I try to connect to my database from my application with the
This is a shot in the dark, but perhaps you need to optimize your
indexes. By default, MySQL assumes an even distribution of values for
indexes. I'm not sure when it diverges from this default, I assume it
does at some point. MySQL uses the data distribution values/assumptions
to determine how
Hi
I'm connecting to a MySQL server on the internet from a VB6 app on Win2K
using MyODBC.
I understand that the connection itself is not secure. I cannot implement
SSH for the connection as my ISP does not support this with MySQL.
However, when MyODBC sends the username and password etc to the
Did you try increasing max_connections ?
Michael Edlund wrote:
I've developed a CMS using PHP and MySQL 4.1 alpha.
It ran just fine with the standard MySQL 4.1a binaries both on my
Powerbook running Mac OS X as well in a production environment on my
FreeBSD server. However, after having
Plain text. Use of the upcoming MyODBC 3.52 will make it in binary form,
but not encrypted. Is the remote server MySQL 4.x? You could possibly
use Stunnel (www.stunnel.org) to access the server via SSL.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Mike Fish (Shoal
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Mike Hillyer wrote:
Plain text. Use of the upcoming MyODBC 3.52 will make it in binary form,
but not encrypted. Is the remote server MySQL 4.x? You could possibly
use Stunnel (www.stunnel.org) to access the server via SSL.
The MySQL protocol
# [EMAIL PROTECTED] / 2003-06-20 11:07:09 -0400:
Hello,
I am trying to compile MySQL 3.23.57 on NetBSD 1.6.1. I downloadded
pthreads-1_60_beta6-mysql.tar.gz from your site and extracted it to
mysql-3.23.57/ I ran ./configure --with-mit-threads in mysql-3.23.57 and
everything went fine.
SQLyog v3.51 - The definitive Windows Front End for
MySQL, has been released.
SQLyog is a superfast, compact and easy to use Front
End for MySQL.
Some of the new features added in SQLyog 3.51 are -
-- Complete support for MySQL 4.1.
-- Improved SQL Editor.
-- Improved ODBC Import Tool.
--
# [EMAIL PROTECTED] / 2003-06-27 14:44:55 +0200:
I have a question regarding mysqlhotcopy's use.
I'd like to use the --flushlog option in order to have a nice backup
synchronized log for my replication slave in case of recover need
(without stopping the master).
But the lock used by
On Thu, Jun 26, 2003 at 08:33:15PM +0100, Aodhan Cullen wrote:
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
On Fri, Jun 27, 2003 at 08:08:40AM -0500, gerald_clark wrote:
Yes, if you have transaction logging turned on.
You can edit the transaction log, and run it against the restored database.
MyISAM doesn't have transactions.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine,
On Fri, Jun 27, 2003 at 09:20:45AM +0200, [EMAIL PROTECTED] wrote:
I have an installation of MySQL where the data directory is located
on an NFS share. Client and server are connected by Full Duplex
Gigabit Ethernet (both hosts run Linux 2.4.21). The NFS is exported
with sync option.
Read
Thank you for replying.
I can change DISTNAME in Makfile.common, but then I might not be able to
uninstall it. I am relatively a novice, and I don't want to mess anything
up.
In order to use MySQL, will I need to download both the client and the
server? I don't have a lot of space on my HDD, and
MySQL GUI is no longer supported. Try using MySQL CC instead and let us know if
you still have problems.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
Did I help you? Want to show your thanks?
www.amazon.com/o/registry/EGDXEBBWTYUU
- Original Message -
From: Tang, Sean X
Ok, update log.
Jeremy Zawodny wrote:
On Fri, Jun 27, 2003 at 08:08:40AM -0500, gerald_clark wrote:
Yes, if you have transaction logging turned on.
You can edit the transaction log, and run it against the restored database.
MyISAM doesn't have transactions.
Jeremy
--
MySQL General
I am so new to mysql that I only know it can be used to as a database
linked to WebPages via perl.
This is what I want to do with. I have had such experience with asp.
What are some good web tutorials to teach me installation and the basics
of mysql adding perl is always a bonus.
Make it
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 5:49 PM
The dump file will be larger than the MyISAM data file for the
original table -- especially if you have many non-text columns
(dates, numbers, ENUM columns, etc.). In some
I only know good references:
the manual: http://www.mysql.com/documentation/index.html
the Bible: MySQL by Paul Dubois ;)
for the access to mysql from webpages, you'll need to use perl dbi and
acquire some notions about how CGI works
Wavyx
Ben Ferderer wrote:
I am so new to mysql that I only
Jeremy/Gerald
I just tested it with an insert statement on a MyISAM table and an Innodb table, and I
saw the both insert statements in the binary log. So, I can roll forward these
changes, right?
I still don't see how your answer (MyISAM doesn't have transactions) relate to my
initial
On 27 Jun 2003 at 14:49, David Brodbeck wrote:
FWIW, if size is a problem, mysqldump files compress quite well with
gzip. (Lots of repeated text.) The same is true of update logs, if
you're keeping those.
The same is also true of the original tables (the .MYD files), so I
stand by my
The permissions on my /var/lib/mysql directory are: File Owner: mysql
- MySQL Server; Group is mysql.
I did discover that I had not set a user in /etc/my.cnf. Once I did
that, the mysql.sock file was set up (doh! sorry about that).
Here's a portion of what I get when I do ls -l
Hi,
I'm using 3.23.51 and I'd like to update a field in a certain order. I've
got a table of images for a slide show and the format of the table is:
image varchar(128) not null
order_number integer not null primary key
So we might have something like:
duck.jpg 1
cat.jpg 2
horse.jpg 3
I want
Hello MySQL folks,
I'm searching through my database (version 4.0.13) looking for certain
strings that start with - v000 - but the fulltext index doesn't seem to be
indexing that string of letters/numbers. If I do a normal WHERE LIKE, it
shows me what I need, but when I try and use the fulltext
On 27 Jun 2003 at 16:30, Daniel Whitener wrote:
an example of this string is V00021 - they all start with v000
[snip]
mysql select ID from emails where body like '%v000%';
[snip]
mysql SELECT ID FROM emails WHERE MATCH(h_subject, body) AGAINST
('v000');
Full text searching searches by
Ben,
You can also access MySQL databases from PHP, FYI.
I've learned a lot from the book:
PHP and MySQL Web Development By Luke Welling Laura Thomson
ISBN: 0-672-31784-2
Hope that helps!
Len
--
Len French
Technical Applications Specialist
Lutron Electronics, Inc.
[EMAIL PROTECTED]
Hey Keith,
Thanks for the quick reply! Actually I read through that page before and I
tried it and still nothing
mysql SELECT ID FROM emails WHERE MATCH(h_subject, body) AGAINST ('V000*');
Empty set (0.00 sec)
any good reason why that wouldn't work?
Thanks again,
Daniel
Keith C. Ivey
On Fri, Jun 27, 2003 at 04:47:43PM -0400, Daniel Whitener wrote:
Thanks for the quick reply! Actually I read through that page before and I
tried it and still nothing
mysql SELECT ID FROM emails WHERE MATCH(h_subject, body) AGAINST ('V000*');
Empty set (0.00 sec)
any good reason why
On 27 Jun 2003 at 16:47, Daniel Whitener wrote:
mysql SELECT ID FROM emails WHERE MATCH(h_subject, body) AGAINST
('V000*'); Empty set (0.00 sec)
any good reason why that wouldn't work?
Sorry, my mistake. The asterisk only works in Boolean mode (which
requires MySQL 4). Try this instead:
You're running a join on table two which will result in the following set (if
you remove the group by and sum()s):
ABCCORP 500, 150, 350 (from table 1, row 1, join table 2, row 1)
ABCCORP 500, 50, 300 (from table 1, row 1, join table 2, row 2)
ABCCORP 500, 50, 250 (from table 1, row 1, join
I'll second the recommendation of Welling Thomson's book. It's a great
starter with numerous real-world examples, and it includes a CD of all the
source code, which all decent books do. I find that I've generally outgrown it
already, but they always told me I was a fast learner!
Edward Dudlik
Say you have a column in a search table by the name of politics.
Each political view is represented as an integer from 0 - 16. A user can
choose multiple political views, and those views have to be represented
in the db as a single row. How can a single column for a single row of a
searched
On Fri, 27 Jun 2003 14:50:58 -0700, Dathan Vance
Pattishall [EMAIL PROTECTED] wrote:
| So, my question is how can multiple values for a single field get
| represented in a single row and receive the benefits of an index? How
| can this data be represented?
Try using a SET column type and then
1 - 100 of 113 matches
Mail list logo