When comparing float values, you have to use '' around the value.
Your query should look like this:
select distinct sequence_id from sequence_protein where mol_wt = '53211.62';
- Original Message -
From: "Hannes Niedner" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 07
I've encountered this several times. When on the web I just use redirect
pages.
I'll submit the data to a page that puts the information into the database,
and then puts a header() call to redirect them to the real finishing page,
passing any minor variables I may need.
This way also has the un
I think your doing FAR more work than you need to. I'm also not getting
what you mean by it not paying attention to the initial query.
I suggest you combine those 3 queries into one, just like this:
SELECT somefield1, somefield2, DATE_FORMAT(EventStartDate, '%W %M %D %Y') AS
FormattedEventStartD
Please send me the actual physical query that was locking things up.
This sounds like a simple join, include table/key structures in your
response.
More than likely you aren't joining somewhere "nicely", and if you don't,
you end up with really really large result sets.
- Original Message --
1) Don't use the Redhat RPM's, download the RPM's from mysql.com
2) Check /var/lib/mysql/.err for error reasons
3) Check your config
4) Don't use the Redhat RPM's.
- Original Message -
From: "Tom Walker" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 25, 2001 10:37 AM
Subjec
Depends on OS, memory, disk space.
Theoretically there is no "limit".
If your using linux, and don't have support for large files built in, then
your table size limit is 4GB. Putting a table with 1k rows at a max size of
around 4 million records. If you have large file support in, and have the
UPDATE table SET name = REPLACE(name,'blue','');
- Original Message -
From: "Tiago Mota" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 25, 2001 9:43 AM
Subject: update a column
> Hi,
>
> I have a book explanning mysql and the commands, and I was here searching
> for some
Does your Bug_Report.c have an #include line for the mysql headers?
- Original Message -
From: "Nicu Popovici" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 25, 2001 9:54 AM
Subject: Compilation problems.
>
> Hello Gurus,
>
> I am trying to write a C client for a mysql
It's all about index's. My current "big" table is a table which currently
has ~500,000 rows. We add around 4000-5000 rows a day. This is simply a
table storing session data for visitors. Because of the large amounts of
inserts, we keep the index's low, have 1 primary and 2 non unique index's
w
1) Not sure what's going on there, perhaps run a check on the table.
2) I just recently indexed a column on a table with ~50 rows, on a
char(4) field, took roughly 30 seconds.
3) No problems running multiple index's, a tip though, lock the table before
you add the index, you can sometimes get
I really prefer SecureCRT from VanDyke software myself. Perfect blend of
features and simplicity for my needs. It has a shareware version that does
expire, but the license is cheap for it. Go to www.vandyke.com and download
the shareware version to give it a try.
- Original Message -
Fr
) from product where productid >3;
>
> COUNT(1)
> --
> 7
>
> Would count(*) show the same performance as count(1)???
>
> Siomara
>
>
> >From: "Eric Fitzgerald" <[EMAIL PROTECTED]>
> >To: "Siomara Pantarotto" <[EM
Actually, as far as performance goes, it depends on table types. Most of
the MySQL table handlers keep an internal count of record numbers. Thus, a
select count(*) from table; is as fast as it gets.
- Original Message -
From: "Siomara Pantarotto" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTE
> Any pointers on where to look?
That line says it all really. Your initiallizing connection as a pointer
(denoted by *), you have to treat it accordingly when passing it to
functions. Your function init would look something like this:
MYSQL_RES doquery (MYSQL *connection, char query[100]) {
What language are you using to prepare that query?
If it's perl, do something like if ($title =~ /Green/)
If it's php, do something like if (ereg("Green",$title))
If it's C, cycle the string finding that
This is a job for the client truthfully...but if you absolutly MUST do this
server side, her
MySQL is in fact, as you said, a backend database. Forms, reports, labels,
those are all done client side. If you do not want to develop your own
client application, I suggest using Mascon (if you have some windows
clients) available at: www.scibit.com. I have found it to be a VERY nice
client
You only need to specify SET once.
update Pictures set Date_Posted = '2001-05-09', Notes = 'Test' where ID
='1';
- Original Message -
From: "Barry L. Jeung" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 11, 2001 12:55 PM
Subject: Update problem, or more likely and problem
It sounds like you might be more interested in the SELECT * INTO OUTFILE
syntax...read http://www.mysql.com/doc/S/E/SELECT.html for more information.
- Original Message -
From: "Joseph Chow" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 11, 2001 9:57 AM
Subject: MySQL -- t
I would personally suggest they be broken up. I've noticed in the past some
speed issues when you have too many columns.
- Original Message -
From: "Richard Reina" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 11, 2001 11:26 AM
Subject: Hom many columns is too many?
> I
http://www.mysql.com/doc/S/t/String_functions.html
REPLACE(str,from_str,to_str)
Returns the string str with all all occurrences of the string from_str
replaced by the string to_str:
mysql> select REPLACE('www.mysql.com', 'w', 'Ww');
-> 'WwWwWw.mysql.com'
This function is multi-byte safe
http://www.mysql.com/doc/S/i/Silent_column_changes.html
second item, quoted here:
If any column in a table has a variable length, the entire row is
variable-length as a result. Therefore, if a table contains any
variable-length columns (VARCHAR, TEXT, or BLOB), all CHAR columns longer
than three
There are a few options here.
First off, when making the query, just put the NOW() statement into the
tableit's only a few extra keys to type, and it really isn't that
difficult.
The second option is using the TIMESTAMP type...take a look, it's probably
what your looking for :)
- Origin
I don't see any ticks surrounding userid...unless of coarse userid is a
number??
Also, myResultSet, is that public? If not, are you returning it? (I'm not
familiar with Java, so not sure if you need to or not)
- Original Message -
From: "Ryan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Ok, a few things I see...first off, slap some keys into those tables on the
join portions. Secondly, upon examining your query a second time, your
never joining subsnp and locuslink. I see your trying to use a full join,
but you didn't put the criteria for it in the where clause. That would
cau
Please do a "SHOW FIELDS FROM" and "SHOW KEYS FROM" on all tables involved
so we can see what's going on here. Also, a warning, if desacription is
indexed, by doing LIKE '%GABA%' with wildcard at beginning, it won't use
index's.
Would also help if you did an EXPLAIN on that query and sent that.
Actually, there is a way to do this by taking advantage of variables. If
you read my previous post on the matter, you can use variables to get a
cumulative total.
- Original Message -
From: "Steve Ruby" <[EMAIL PROTECTED]>
To: "Roger Karnouk" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Se
It sounds like you might have some stray ' characters in your text
You didn't give much information, but let me see if I can't figure out kinda
what your doing...
Your using perl, so I assume your going to be using DBI. In DBI you have
your statement handles, or do statements. That means y
as
FALSE. And the translation occurs on the way up, with 1 being TRUE, and 0
being FALSE.
Please let me know if you want me to send you this file.
Eric Fitzgerald
Server Administrator/Programmer/MySQL maintainer/Jack of all trades
AMN Television M
Since MATCH is evaluated AFTER the where, you need to use HAVING
SELECT
url,newwebsites.description,newwebsites.title,newwebsites.catid,category.ful
lname,MATCH
newwebsites.description AGAINST ('aliens') as GOO from newwebsites,category
LEFT
JOIN userrestrictions ON userrestrictions.name REGEXP
'[
TECTED]>
To: "Eric Fitzgerald" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 1:29 PM
Subject: Re: Signal to Noise Ratio...
> "Eric Fitzgerald" <[EMAIL PROTECTED]> wrote:
> > I can understand the concern of longer de
I can understand the concern of longer delays in moderation. My problem
with anti spam filters is simply because they are too much like anti-virus
filters. TOO many false positives.
- Original Message -
From: "Steve Werby" <[EMAIL PROTECTED]>
To: "Eric Fitzgera
This is an open plea to the MySQL team. The amount of spam and other noise
on the list has been growing more and more every day. I would like to make
a couple basic plea's. The first, is that you require a poster to the list
have an actual account on the list, that should help cut out some of t
hardware. I'm sure the MySQL software has some kind of roof somewhere, but
where it's at I have no idea.
- Original Message -
From: "Florin Andrei" <[EMAIL PROTECTED]>
To: "Eric Fitzgerald" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tues
Depends on your hardware...
500 machines of logging, how many entries per second? I've seen people
report their MySQL installs doing hundreds or thousands of queries per
second, and not even phasing the machine.
- Original Message -
From: "Florin Andrei" <[EMAIL PROTECTED]>
To: <[EMAIL
Make sure that /tmp is writable by the user running MySQL.
You say you are setting MySQL up on your account, do you have access to the
root account on this box? If not, are you sure that the box your on doesn't
already have MySQL running?
- Original Message -
From: "Tatti" <[EMAIL PROTE
Here's how I would do it:
$inlist .= sprintf("\'%s\'",$Array['Email']);
Then after the loop:
$query = "DELETE FROM sometable WHERE email NOT IN (".$inlist.")";
mysql_query($query);
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 29, 2001 5:02
Your query converted to using left joins:
SELECT DISTINCT Questions.QuestionID, Questions.Question,
Experts.ExpertFullName, Category.CategoryName, Questions.Shows,
Questions.Views
FROM Questions
LEFT JOIN Experts ON (Questions.ExpertID = Experts.ExpertID)
LEFT JOIN Category ON (Questions.C
Need a lil bit more information from you.
Right now mysql doesn't support views, however it does support temporary
tables which can accomplish most things. What is it your trying to do here?
- Original Message -
From: "Marglobal - Pablo Salazar (Jefe de Sistemas)" <[EMAIL PROTECTED]>
To
I'm going to jump in here and give a little more information.
The password() function is in fact a one way encryption. For a two way
encryption use the encode() function. But beware, any data stored with the
encode() function is only as secure as the master password you assign it.
You can do so
The problem many of us have is not the questions. If I didn't want to
answer questions when I have free time, I wouldn't be subscribed to this
list. The problem most of us have is with the people who flat out refuse to
read the manual or try to find answers on their own. IMHO part of the
learni
I'm gonna take a crack at this.
The type keyword in the alter table command is there to convert databases
from one type to another. While yes, I do think that the MySQL team could
check if the types are the same and not recreate the table if it isn't
necessary. I don't consider it a bug that th
Databases are essentially just directories. What you do is create a
directory in the users home directory. Then, do this:
ln -s /path/to/home/dbdir /path/to/mysql/data/dir/somedbname
Then grant the user access to that db. Your all set :)
- Original Message -
From: "Andre Guerrero" <[E
st the two biggies that were on the top of my head.
- Original Message -
From: "Bryan Coon" <[EMAIL PROTECTED]>
To: "'Eric Fitzgerald'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, March 21, 2001 4:48 PM
Subject: RE: MySQL and XML
Well list, I think we have a new weekly dead horse to with which to use our
sticks on :)
To answer your question, no, XML is not being added currently to MySQL.
Flat files have some advantages, but have to be implented well to work well,
you can't just open the whole thing and scan through it loo
I'm not 100% familiar with the load data line, I've never had to do it (I
just write import proggies :)
I'd suggest a small little script like this (copy and paste this into a text
file on the server, give it execute permissions, and run it), please excuse
any wrapping:
#!/bin/sh
for file in *.
Please read the documentation...since it's obvious you havn't, I shall
repeat it here:
DON'T USE SOLARIS TAR! GET GNU TAR!
Sorry for the bit of a blow up there, but I am quite sure that this is well
documented, in big bold red letters on the DOWNLOAD page. And yet we still
get at least 1 perso
I saw that someone already gave you some suggestions, but the reply seemed
to lack a bit of WHY you have that limitation, so I thought I would explain.
The 2Gb limitation is not in MySQL. It's in your operating system. If you
read some of your OS's docs, you can see how to get around this probl
Well, really it matters on hardware
Some OS's have limits to file sizes, check your OS documentation on that.
Other than that, it's all a matter of how much hardware you put behind
mysql.
- Original Message -
From: "Jason Hurst" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesd
Very situational
Let me lay out what I *think* your saying your, tell me if I'm right/wrong.
You have a table with 3 (or more, but irelevent) columns. A sample of the
data is as such:
Product | Group | Name
1 | 1 | Full product listing
2 | 1 | Computers
3 | 2 | Motherboards
4 | 2 | Monitor
Please drop the stick and back away from the dead horse, it has been beaten
enough. :)
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 13, 2001 12:35 PM
Subject: XML
> I've done some rudimentary snooping around on both MySQL's site and on
> go
Two things here.
First off, we had this problem spring up on us, and I think I may know why
it's doing it to you. If your using PHP, the more recent version
automatically escape out variables sent to the mysql driver. Thus randy's
is converted to randy's. HOWEVER, if you still have old code wh
Just realized, the query I sent you will remove ALL instances of \ inside
the field you specify, if that isn't your intent, and you only want to
remove \' then do this:
UPDATE tablename SET fieldname = REPLACE(fieldname,'\\\'','\'');
-
Your not closing off enough )'s
should look like this:
insert into payment (payname1,ccaccount) values
('Kinney',encode('','Ilwfci'));
Then, for decode, you do it like this:
SELECT DECODE(ccaccount,'Ilwfci') AS ccnumber FROM payment WHERE payname =
'Kinney';
- Original Messag
depends fully on how you query the data out.
If your going to be using only one field at a time, make seperate indexes.
If your going to be ALWAYS using all 3 fields, then I don't see how a single
combined index would be a problem.
- Original Message -
From: "MikeBlezien" <[EMAIL PROTEC
Please read the documentation on date functions. That looks like one of
your problems.
Secondly, your not using any '' to encase your strings.
- Original Message -
From: "Ben Ocean" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 23, 2001 11:12 AM
Subject: Why Doesn't
pect an error back from mysql on connection...
- Original Message -
From: "John Tsangaris" <[EMAIL PROTECTED]>
To: "Eric Fitzgerald" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, February 16, 2001 4:46 PM
Subject: RE: Perl DBI
> Hi, Eric.
&g
Connect to the mysql database if you have access. It always exists.
- Original Message -
From: "John Tsangaris" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 16, 2001 1:58 PM
Subject: Perl DBI
> Is it possible to connect to mysql without connecting directly to a
>
I can see your command line problem right now...
./mysqladmin is what you need to do, or add the mysql/bin dir to your path
- Original Message -
From: srihari suthamally
To: [EMAIL PROTECTED]
Sent: Wednesday, February 14, 2001 4:36 PM
Subject: error in running mysql - this is
Saying your up to 768 courses doesn't give us much information. How many
queries/second is the server handling right now? My machine, which is
considerably slower than yours handles 10 queries/second without blinking an
eye.
When we were experiences an extreme slow down before, we found three i
ject: Re: MyODBC and SQL_BIT type
> Eric Fitzgerald writes:
> > Let's try this one more time, just in case it got scimmed over :)
> >
> > Hello everyone.
> >
> > I'm hoping the developer of MyODBC hangs out on this list, but here
goes. I
> >
use a LOT of bool fields. So if I can do a little translation on the
fly, I can fake this, and make everyone happy :)
Thanks in advance,
Eric Fitzgerald
Server Administrator
AMN Television Marketing
-
Before posting, please chec
fake this, and make everyone happy :)
Thanks in advance,
Eric Fitzgerald
Server Administrator
AMN Television Marketing
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Change the way it's stored in the table.
Seriously, if the data is stored in a single row, there is no way via SQL
(not defined in standards, not available in any SQL server implementation
I've seen either), then the program has to convert that into columns. The
standard mysql utility is capable
SQL itself is not the way the data is stored. SQL stands for Structured
Query Language and is a way of retrieving and modifying/adding records.
If you write your SQL carefuly, yes you can use it pretty much "as is" on
any SQL system. There are little changes and such however that every SQL
serv
I'm going to have to answer Yes, and No.
Yes, they can access it.
No, it won't be the best situation. The internet is not very trustworthy,
and having DB's seperated over such large distances accessing instantly is
probably not the best choice. Not to mention that if you have large record
sets
http://www.mysql.com/doc/M/a/Mathematical_functions.html
Please please please read manual before asking questions.
SELECT SUM(minutes) AS ttltime, user FROM table WHERE user = 'someuser'
GROUP BY user
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, J
http://www.mysql.com/doc/S/H/SHOW.html
always check the docs
show index from
- Original Message -
From: "Bill Long" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 17, 2001 3:23 PM
Subject: How to get a list of indexes on a table
> *This message was transferred wi
Please tell us the basic layout of your tables (field types, primary keys)
and the query your using
We can not do anything with the information you have given us.
- Original Message -
From: "Rekha Das" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 15, 2001 2:51 PM
Sub
Beyond the other suggestion, also remember to flush your STDOUT.
flush(STDOUT);
- Original Message -
From: "Ron Beck" <[EMAIL PROTECTED]>
To: "Mysql" <[EMAIL PROTECTED]>
Sent: Friday, January 12, 2001 8:56 AM
Subject: Perl question
>
> Hello all,
> I have a procedure that queries my d
Sometimes when people aren't answering a question, it isn't because they are
ignoring you or consider your questions stupid. Sometimes it's because we
don't know the answer.
Your question has nothing to do with MySQL and everything to do with php.
It doesn't like that charset. I have no clue o
I'm going to contribute to this discussion again. I want to counter some of
your basic arguments.
You seem to be trying to place MySQL newbies in the same level as computer
newbies. IMHO, this is a very bad thing to do. Someone who is going to be
working with MySQL is going to be using it for
Check your error log, usually located in the main database directory
(/var/lib/mysql on my sys)
- Original Message -
From: "Riccardo Scannapieco" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 11, 2001 9:42 AM
Subject: Mysql doesn't running
> Hi Friends, I'm Riccard
Have you tried looking at the data in your tables?
I would check that, and then, if it checks out, try to give us some more
information.
- Original Message -
From: "Mike Roberts" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 10, 2001 5:28 PM
Subject: Something went
ail to the list asking a
question that is very clearly answered in the manual, then I think your
being inconsiderate of others.
Eric Fitzgerald
Server Administrator
AMN Television Marketing
- Original Message -
From: "Carlos Corzo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED
http://www.mysql.com/documentation/mysql/commented/manual.php?section=LOAD_D
ATA
LOAD DATA LOCAL INFILE "myfile.txt" INTO TABLE mytable FIELDS TERMINATED BY
'|'
- Original Message -
From: "Marcus Ouimet" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Wednesday, January 10, 200
how about some ideas to help fix the problem :)
Maybe if this list was moved from an open list to a moderated one we would
see a drop? Also, might it be possible to move the manual comments to
another list? :)
Eric Fitzgerald
Server Administrator
AMN Television Marketing
- Original Message
76 matches
Mail list logo