While trying to upgrade, i ran into this compiler error:
/bin/sh ../libtool --mode=link g++ -O3 -DDBUG_OFF -O2 -march=pentium4
-mcpu=pentium4 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE
-fno-rtti -fno-exceptions -fno-implicit-templates -fno-exceptions
-fno-rtti -rdynamic -o
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, 16 Dec 2002, Nick wrote:
I am running the Solaris 8 binary on all of my Ultra Sparc II Solaris 7
servers with no problems at this time, however I am not doing any of the
advanced features, such as MySQL-Max or replication.
Thanks for the
sql,query
Hi,
I am looking at the following situation:
I am reading some files arriving every minute and parsing them and
creating a set of files ready to be inserted into tables.
on the fly. While I am waiting for the next burst of files, I want to
insert these
Thanks for the reply Bill, however this did not solve the problem. I
still receive the same error with your method as well.
1064: You have an error in your SQL syntax near ';
CREATE TABLE Departments (
DeptID int(10) unsigned NOT NULL auto_increment,' at line 4
Are you first creating a new
Dear All,
Where can i find mysql client and devel .rpm files compatible for
MySQL-Max-3.23.53a-1.i386.rpm
Thanks in advance.
Regards,
Muruganandam g
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Please, anybody could help me with this?
Anybody have upgraded its MySQL release from 3.23.53 to Mysql release
3.23.54... I need to upgrade for fixing a bug in 3.23.53 and I would like
to know if it necesary to reinstall as the one solution.
Thanks a lot.
- Original Message -
From:
Hi,
It seems that you don't have any index on your tables.
You should at least create an index on flObjectID in all tables.
You should also use 'explain' on your query to make sure that
indexes are properly used.
Hope this helps
Joseph Bueno
John Glenn wrote:
I'm looking for recomendations
Seems to me there should be a built in SQL command to duplicate a
database. Jeepers. Or to read in a .sql file from PHP and create a
database out of it (which was the original intent).
Anyways, here's a 'hack'. I'd still love to hear anyone else's more
elegant solution.
$V2DB = V2_SL.$CompanyID;
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Daevid --
...and then Daevid Vincent said...
%
% Thanks for the reply Bill, however this did not solve the problem. I
% still receive the same error with your method as well.
%
% 1064: You have an error in your SQL syntax near ';
% CREATE TABLE
Hi,
There is an easier way to duplicate a database; from the comand
line, you can run:
mysqladmin create db2
mysqldump db1 | mysql db2
If you want to duplicate the schema only (without the data):
mysqladmin create db2
mysqldump --no-data db1 | mysql db2
(You may have to add host/user/password
Hi!
Heikki Tuuri writes:
Jari,
I am Cc:ing this to [EMAIL PROTECTED], so that other readers can follow
the discussion.
There is still no my.cnf option to set AUTOCOMMIT=0 globally though users
have requested it a lot.
I think that 4.1 will support a SQL script which is automatically
On Monday 16 December 2002 22:37, Bc. Radek Krejèa wrote:
I found SERVER-bin.* files from today in my MySQL directory, where
are databases stored. What are theese files and why was created.
SERVER-bin.001
SERVER-bin.002
SERVER-bin.index
These files are binary log files:
On Tuesday 17 December 2002 09:39, Troy Kruthoff wrote:
Invalid reporting of date calc
How-To-Repeat:
note: SESSIONTS is TIMESTAMP type
SELECT (NOW()-SESSIONTS) FROM WEBSESSIONS;
+---+
| (NOW()-SESSIONTS) |
+---+
| 1261 |
Hi
I am trying to get a handle on MySQL anticipating a PHP application I want
to implement on a website next year. I am using WinXP and the website is on
a Linux server.
I have created a new database, but am having problems creating tables. Its
not too obvious how to go about it. I have
Unfortunately, command line is not an option for me. As I said before,
the php scripts are on a web server and the database is on another
server.
-Original Message-
From: Joseph Bueno [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 17, 2002 2:47 AM
To: [EMAIL PROTECTED]
Subject:
I am not a PHP expert but I think you can run external commands from PHP,
so it should be possible to run mysqladmin, mysqldump and mysql from PHP.
This will work even if you database is on a remote server; just specify
the hostname (ex: mysqladmin -h mysqlhost create db2)
Daevid Vincent wrote:
You mentioned a
echo PRE.$sql./PREP;
in your first post; what do you see?
I see exactly what I expected to see. Basically the contents of a db.sql
file read in that looks like this roughly:
CREATE TABLE table1 (
blah int(10),
foo char(5)
);
CREATE TABLE table2 (
blee int(10),
You cannot execute several SQL statements within a single query.
You are trying to reinvent 'mysql' client batch processing; if you want
to do that, you have to write an SQL parser in PHP that split
your input in independant SQL statements and execute them one by one :(
Daevid Vincent wrote:
You
On Tuesday 17 December 2002 13:56, Martin Finnegan wrote:
I am trying to get a handle on MySQL anticipating a PHP application I want
to implement on a website next year. I am using WinXP and the website is on
a Linux server.
I have created a new database, but am having problems creating
On Monday 16 December 2002 16:24, Santiago Alba wrote:
I have installed MySQL 2.23.53 release and I want to upgrade to MySQL
2.23.54... how can
I do this? Have i got to reinstall? Is there any script?
As usual ;)
Seriously speaking - depends on the way have you installed it.
--
For
On Tuesday 17 December 2002 22:04, Muruganandam wrote:
Dear All,
Where can i find mysql client and devel .rpm files compatible for
MySQL-Max-3.23.53a-1.i386.rpm
You can use any recent 3.23.x version of client.
-devel.rpm should be the same as -shared.rpm if it's used.
--
For technical
On Tuesday 17 December 2002 11:08, moka at hol dot gr wrote:
I am looking at the following situation:
I am reading some files arriving every minute and parsing them and
creating a set of files ready to be inserted into tables.
on the fly. While I am waiting for the next
Hi.
You need automake ver. 1.5 don't use 1.5d (i did it and spent couple of
hours to discover, why source rpm 3.23.54a don't rebuild )
autoconf is 2.52
libtool is 1.4.3
Regards.
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, December 17,
What exactly is wrong about using ENUM's?
Luc
sql,mysql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread,
You might also wish to consider downloading and installing Webmin. It's one of the
easiest installs I have encountered. Simply tar the tarball and proceed into the new
subdirectory (IE webmin-1.030) and perform a /setup.sh . Webmin will allow you easy
access to your server via a web browser.
Hi,
Here is my configuration :
Linux SME Server 5.6 bêta 7
Mysql 3.23.49
I try to access to Mysql via a client programm nammed MysqlFront. I have
defined an user like this :
Username : blank
Host : .domain_name.ch
Password : blank
When I try to connect
Luc Foisy wrote:
What exactly is wrong about using ENUM's?
Changing them will kill you unless you're _very_ careful.
Using them is usually unnecessary as you could've used an ID value
pointing to another table of values. That table can then be added to
with no risk to your existing
Description:
When accessing this mysql version from a WinXP client (running in a VMWare
shel) the server crashes reproducable.
How-To-Repeat:
Access to server with DBTools 1.0.x from WinXP client.
Fix:
?
Submitter-Id: submitter ID
Originator:Hans-Joerg Wolff
Hi,
Seems that mySql sometime write Querys to Log but does
not execute them. I found folling in the MySql Log-File.
Comments made by me are signed with -.
Maybe some one has a solution for that ?
# at 5636748
#021216 15:27:38 server id 1 Intvar
SET INSERT_ID = 189612;
# at 5636770
#021216
In some of my tables I see overheard. What does it mean and does it mean I
have to optimize it every time? I seem to see it everyday. SQL
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
What exactly is wrong about using ENUM's?
Changing them will kill you unless you're _very_ careful.
Using them is usually unnecessary as you could've used an ID value
pointing to another table of values. That table can then be added to
with no risk to your existing queries. As a contrived
Have you thought about creating a fulltext index? Then you can search on
any word in a field. MySQL 4 has a lot more options for fulltext search,
but you can still do it in 3.
On Monday, December 16, 2002, at 04:25 PM, Chris Stark wrote:
SELECT my_id FROM my_table WHERE my_value LIKE
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Daevid --
...and then Daevid Vincent said...
%
% You mentioned a
%echo PRE.$sql./PREP;
% in your first post; what do you see?
%
% I see exactly what I expected to see. Basically the contents of a db.sql
% file read in that looks like this
Luc Foisy wrote:
We use enum extensively for 'Y' 'N' values, sort of true false.
That way the values are forced to be one or the other. So any end user has to put one of those values in (if we allow it in that way, though we usually force them to use a checkbox). And its a little more
I have some questions on how an index is built and
used.
I have a very simple table like this:
char_col char(10) not null
Index (char_col)
If I have 1000 records in this table, how big will the
index become? The data-size would be 10 000 right?
How does an index look like and how can it speed
From: David T-G [mailto:[EMAIL PROTECTED]]
...I still have to figure
out how to make sure that our credit card types and skill levels don't
get corrupted (MC, MasterCard, mastercard, ...), but I guess that gets
enforced in the software interface, right?
Isn't the card type a piece of derived
Hello list.
Please help me to refine a JOIN based query which I am not able to correct.
This the scenario (simplified).
Three tables:
Products
-
| id | description |
-
| 01 | bread|
| 02 | milk |
|
On Tuesday 17 December 2002 03:09, Lopez David E-r9374c wrote:
Problem is type SMALLINT needs to be MEDIUMINT (MyISAM).
column: id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT
My solution is to use the following ALTER statement:
ALTER TABLE messages CHANGE id
id MEDIUMINT UNSIGNED
On Tuesday 17 December 2002 09:24, B F wrote:
I tried your pass-through idea previously and it did not work. Today I even
typed my query directly into the mysql shell (and bypassing MS-Access
altogether) and my MySQL server still hung! So we can rule out problems
with Access of MyODBC...
What
Anderson, Alan R wrote:
Isn't the card type a piece of derived data? You should never have to enter it directly; it's computable from (the first digit(s) of) the card number.
Also note, the type of card isn't a SET option at all (it would be an
ENUM) and if its used as a foreign-key
There are many tools. Use a gui. mysql front (free), premium soft (my pick
but has a 29 day trial). There are also many small window applications to do
this. Do a search at one of the famous downloads. +client +mysql +gui
-Original Message-
From: Charles Mabbott [mailto:[EMAIL PROTECTED]]
Hello list,
I have been running MySQL 3.23.51 on a 4.6 FreeBSD box for some time
with no problem.
Recently, a client requested the ability to connect from remote. Until
now, I only allow connections from localhost and no TCP port open.
I have been going through the docs trying to figure out
Hello list,
I have been running MySQL 3.23.51 on a 4.6 FreeBSD box for some time
with no problem.
Recently, a client requested the ability to connect from remote. Until
now, I only allow connections from localhost and no TCP port open.
I have been going through the docs trying to figure out
Hi everyone,
this might be a newbie question:
is there a way to switch all rows and columns in the output of an
select statement?
I am using DBIx::XHMTL_Table to display all the contents of a table on
a website.
The problem is that the table has about 50 columns, but every query
result
One trick I have used in the past in other databases is to
create your own descending index. If your field is say fieldA, when
you enter a row into the table take the value of fieldA and subtract
from 0, then put that in fieldB. Index fieldB and you now can order
rows descending.
-
Hello list,
I have been running MySQL 3.23.51 on a 4.6 FreeBSD box for some time
with no problem.
Recently, a client requested the ability to connect from remote. Until
now, I only allow connections from localhost and no TCP port open.
I have been going through the docs trying to figure out
I am receiving an 'Assertion failed' error in my log and I am not really
sure how to continue. What I was trying to do was start the MySQLd (v
3.23.53) with support for innodb (it is compiled in) on a FreeBSD
4.7-stable server. I used the settings in my-large.cnf as a template. The
server in
I installed binary version (source distribution)... not with rpm
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, December 17, 2002 2:02 PM
Subject: re: Mysql - Upgrading from 3.23.53 to 3.23.54
On Monday 16 December 2002 16:24, Santiago
Sorry, but I don´t understand you... I have no idea, if you don't mind you
could be more expecific...
Thanks a lot for your answer.
- Original Message -
From: Ireneusz Piasecki [EMAIL PROTECTED]
To: Egor Egorov [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, December 17, 2002 2:20 PM
Hello,
I am having problems with mysql_install_db. I am running a bleeding-edge
Gentoo system (gcc 3.2.1 and glibc 2.3.1, both with some compatibility
patches. also running unpatched kernel 2.5.52).
MySQL compiles with no errors or problems, but mysql_install_db will not run
correctly.
At 23:39 -0800 12/16/02, Troy Kruthoff wrote:
Description:
Invalid reporting of date calc
How-To-Repeat:
note: SESSIONTS is TIMESTAMP type
SELECT (NOW()-SESSIONTS) FROM WEBSESSIONS;
What leads you to expect that this should yield any useful result?
+---+
|
Paul DuBois wrote:
I just tried this script:
[ ... ]
I don't see anything getting flipped.
Wow, I'm impressed :-). I've not actually tried this myself (as it has
been a known bug in at least other db software). Good to know that
MySQL has no such problem.
Now testing:
create table
i shoved it up my ass and things are now running great. Thanks for your
invaluable assistance.
Now if anyone on this list can be more helpful, I might just have an
orgasm, as well as a fix to my 'problem'.
Where is Paul DuBois when you need him? MY friend Jason says to look for
him on here.
as rejected by the spam filter: MySQL, query, blah blah.
hello,
i'm encountering some unexpected behavior in replace 3.23. when i pass it
many replace pairs (only about twenty), its behavior becomes unpredictable.
many times it does nothing at all, blatantly ignoring matches. other times
It sounds like you need to edit your hosts.allow file to allow from the IP
you want to connect from.
add either
mysqld : ###.###.###.### : allow
or
mysqld : all : allow
I'm not a sysadmin though, so you might want to do a search on the proper
way to do this.
-Original Message-
From:
Hi,
Does MySQL automatically create index on primary key ?
If not how can I create an index on a primary key ?
Thanks for any help.
Patrice Serrand
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Hello all,
I have checked the mailing list and the documentation but have been
unable to find any information regarding the level of support for
MySQL on the MacOS 10.2 platform. After moving a production database
from a linux to MacOS 10.2 for development I have noticed that on my
MacOS
Hi, all,
sql, query.
Greetings.
I got the following information. Does any one of you know whether it will
impact my MySQL db server or not: Version 3.23.53 with InnoDB on Mac OS
Darwin Kernel Version 6.2. If it does, what's the solution?
Thank you,
Jannie Qu
Thanks to all who replied!
I was just looking at MySQL Front.
Thanks all,
Yves Arsenault
Carrefour Infotech
5, Acadian Dr.
Charlottetown, PEI
C1C 1M2
[EMAIL PROTECTED]
(902)368-1895 ext.242
-Original Message-
From: Grant Cooper [mailto:[EMAIL PROTECTED]]
Sent: December 17, 2002 12:24
Please shove this up your ass
- Original Message -
From: Aaron Brick [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, December 17, 2002 10:05 AM
Subject: replace(1) weirdness
as rejected by the spam filter: MySQL, query, blah blah.
hello,
i'm encountering some unexpected
your problem being? perhaps you fail to realize that replace(1) is part of
the mysql distribution.
aaron.
so said [EMAIL PROTECTED] in 1.6K bytes at Tue, Dec 17, 2002:
Please shove this up your ass
- Original Message -
From: Aaron Brick [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Hi,
I have two tables: one holding bids for an auction (table bids) and one
holding user data who placed the bids (users). I would like to get the
highest bid, the user who placed the bid and the number of bids placed,
so I use the following query:
SELECT MAX(bids.amount) AS amount,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Tue, 17 Dec 2002, Jannie Qu wrote:
I got the following information. Does any one of you know whether it
will impact my MySQL db server or not: Version 3.23.53 with InnoDB on
Mac OS Darwin Kernel Version 6.2. If it does, what's the
I want to upgrade my MySQL version (3.23.51) because of the recently
revealed exploit; the only binary dist on mysql.com for solaris 2.7 is
3.23.53; will there be a problem compiling from source on this platform or
should I wait for the binaries to be updated? There is a .54 release for 2.8
and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 17 Dec 2002, John P wrote:
I want to upgrade my MySQL version (3.23.51) because of the recently
revealed exploit; the only binary dist on mysql.com for solaris 2.7 is
3.23.53; will there be a problem compiling from source on this platform
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 17 Dec 2002, Aaron Brick wrote:
i'm encountering some unexpected behavior in replace 3.23. when i pass
it many replace pairs (only about twenty), its behavior becomes
unpredictable. many times it does nothing at all, blatantly ignoring
Hi,
Why is it that I can not use two mysql queries in the same PHP file. I have
tried to do this several times trying to put my site together and have had
nothing but problems.
The recent one is this:
I use a SELECT statement to get some info from a table, then I modify that
info and use an
Same message I posted at JGuru and on the JDJ Mailing list, but posting here just
incase it is mysql related and someone can help
On RedHat 7.0 RedHat 7.3
with Java 1.4.0_03
When page is hit fairly quickly I get the following error:
2002-12-17 14:56:37 StandardWrapperValve[jsp]:
Why is it that I can not use two mysql queries in the same PHP file.
You can, I assure you.
Any info is appreciated.
Perhaps if you could provide your code? W/o it there is no way we can
determine where the problem might be coming from.
Chris
I tried to use mysql-max-3.23.54a but it isn't statically linked against
GBLIB 2.2
Please also note the file size:
mysql-3.23.54a-pc-linux-i686.tar.gz is 9831919
mysql-max-3.23.54a-pc-linux-i686.tar.gz is 6097043
At the startup it prints out:
/lib/libc.so.6: version `GLIBC_2.2' not found
Bye
On Wed, 18 Dec 2002 16:05:35 -0500, C. Reeve wrote:
I can not use two mysql queries in the same PHP file
Please post code snippets, this is possible.
- Steve Yates
- Burger Borg: We do it our way; yours is irrelevant.
~ Taglines by Taglinator - www.srtware.com ~
I executed the following statement:
SELECT * INTO OUTFILE '/home/medic/outfile.txt' FROM fool;
I get the error meassge
Can't create/write to file '/home/medic/outfile.txt' (Errcode:13)
I followed the solutions from the manual A.3.3 Problems with File
Permissions
and still have a problem.
I
Chris,
- Original Message -
From: [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Tuesday, December 17, 2002 7:28 PM
Subject: Assertion failed in buf0buf.ic
I am receiving an 'Assertion failed' error in my log and I am not really
sure how to continue. What I was trying to
Walt,
- Original Message -
From: walt [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Tuesday, December 17, 2002 1:58 AM
Subject: innodb/mysql slow returning anything other than primary key
I've run into an interesting problem. I have a large innodb table (2274962
rows, 46
Walt,
you can also test 3.23.54. The following bug fix may be relevant here:
MySQL/InnoDB-3.23.54, December 12, 2002
Fixed a bug: the InnoDB range estimator greatly exaggerated the size of a
short index range if the paths to the endpoints of the range in the index
tree happened to branch
I don't think this can be done in a single query, but what about:
SELECT Reference.id1, Reference.id2, sum(Table1.number)
FROM Table1, Reference
WHERE Reference.id1=Table1.id1
GROUP BY Reference.id1
Which gives you:
+--+--++
| id1 | id2 | sum(Table1.number) |
I can...
Hard to know why without more info but a starting point would be to turn on
the query log in MySQL and see what queries it is receiving.
_
Fraser Stuart
Logistics IT
77-85Phone: +61 2 9335 1235
Roberts Rd
Did you also check directory permissions? What system are you using?
Chuck
http://68.43.100.7:81/aa8vs
==
Patriotism is the willingness to kill and
be killed for trivial reasons.
- Bertran Russell
-Original Message-
From: sam [mailto:[EMAIL
hi
We are evaluating few databases for developing an application with
following specs,
1. OS not very important. Leaning towards Linux
2. Currently the database has about 5 million records but it will grow
to 120 million records.
3. The tables will have billing information for
On Wed, Dec 18, 2002 at 08:10:41AM +, B.G. Mahesh wrote:
If MYSQL or Postgres can do the job I prefer not to spend the money on
Oracle/MSQL. However, if Oracle/MSQL are required for getting good
reports and scalability, so be it. We will use Oracle/MSQL.
MySQL will have no problem with
yea, me too. but being second just isnt as good...
but did you grant the user permissions on the database
they want to connect too? can you connect to anything listening on
3306? htttp?
when i connect from remote over tcp its
mysql -h hostIP -p -u someuser somedatabase
the firewall accepts the
+ On Wed, Dec 18, 2002 at 08:10:41AM +, B.G. Mahesh wrote:
+
+ If MYSQL or Postgres can do the job I prefer not to spend the money on
+ Oracle/MSQL. However, if Oracle/MSQL are required for getting good
+ reports and scalability, so be it. We will use Oracle/MSQL.
+
+ MySQL will have no
hello, i have access to mysql db i created, using a client app even on a
remote pc (adding tables, fields, values) but when i try to connect with
dreamweaver i get an unknown error, or unexpected. what do i need to do to
us dreamweaver on my development machine to access an mysql db on my server?
Hi,
May I know that if it is posibble to roll back the
sql query automatic if the sql query get error by
using myisam table type and not using innodb type?
Thank for help.
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
CN YEONG wrote:
Hi,
May I know that if it is posibble to roll back the
sql query automatic if the sql query get error by
using myisam table type and not using innodb type?
Thank for help.
No. You need to use a transactional table handler, like InnoDB.
--
Daniel Kasak
IT Developer
* NUS
At 19:45 -0800 12/17/02, CN YEONG wrote:
Hi,
May I know that if it is posibble to roll back the
sql query automatic if the sql query get error by
using myisam table type and not using innodb type?
No. MyISAM isn't a transaction-safe table type.
I've since deleted the code and did it another way. The code however went
something like this. This is just a mock up (there is more being selected
etc and there are some joins, but the syntax is exact).
So what happens is the select statement with $user1 in it gets the proper
values (the first
Hello,
I am attempting to search a table based on information passed from a
submitted form.
The form contains details as follows:
(radio buttons)
Condition: O new O used
Type: O powerO sail
(textbox)
Make: [ ]
etc. etc. etc. ( it's a long list!)
If I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
BG --
...and then B.G. Mahesh said...
%
...
%
% Thanks for the quick response. My question may not be very valid..but is
% there a upper limit on the number of records it can handle?
I'll leave this to the experts. I'm almost certain there must
I just installed mysql but I get the command not found when I type mysql. I
am in the bin directory. Anyone know what is going on here?
Thanks
Gary
-
Before posting, please check:
http://www.mysql.com/manual.php (the
chown -R mysql:mysql /home/medic/
and make sure there is no outfile.txt already in that
dir.
--- sam [EMAIL PROTECTED] wrote:
I executed the following statement:
SELECT * INTO OUTFILE '/home/medic/outfile.txt' FROM
fool;
I get the error meassge
Can't create/write to file
Hello,
You're getting all new boats + all sail boats + all boats of type x
because you're using ORs. If you only want records that match all the
criteria, use ANDs instead.
SELECT * FROM boat WHERE condition='$condition' AND type='$type'
Or you might try
SELECT * FROM boat WHERE
do this at the prompt...
echo $PATH
whereis mysql
and compare the results.
when in the bin directory type ./mysql as root... without ./ the shell
wont find it...
Jim
-Original Message-
From: Gary Hostetler [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 17, 2002 8:33 PM
To: [EMAIL
I am not sure. Does anyone know any real examples of
mysql handling huge database and still perform well? I
am having problems with the performance with the MySQL
Left join recently. A big table (about 2.5 million
records) left join a small table (about 350K records)
takes generally 2 mins to
I've read limits are based on the filesize your OS can handle,
the HDD size, memory, how fast your RISC
or CISC processors are...and how the stars are aligned...
i think 4 billion records will need some horses pullin...
8 x 2.4 XEON/2 at least. I've run simple queries on
80 million records and it
Hi!
I have an enigma that I just can't seem to resolve.
==
What is Hoped For:
I have 3 variables (called F1, F2 and F3) which will contain either an
integers (a pointer to a feeback item in another table, actually) and a
database of questions, each having an F1, F2 and F3, any
At 23:33 -0500 12/17/02, Gary Hostetler wrote:
I just installed mysql but I get the command not found when I type mysql. I
am in the bin directory. Anyone know what is going on here?
Does it work in that directory if you type:
./mysql
If it does, then that's your clue. :-)
Thanks
Gary
rOn Tue, Dec 17, 2002 at 08:43:38PM -0800, Qunfeng Dong wrote:
I am not sure. Does anyone know any real examples of mysql handling
huge database and still perform well?
Our largest table is about 340 million rows now. It grows by roughly
100,000 records per business day. Performance is quite
A good question posted to another list..
forwarded message follows
Several vulnerabilities have been found in the MySQL database system, a
light database package commonly used in Linux environments but which runs
also on Microsoft platforms, HP-Unix, Mac OS and more.
When I type ./mysql I get the following:
dyld: ./mysql Undefined symbols:
./mysql undefined reference to _BC expected to be defined in
/usr/lib/libSystem.B.dylib
./mysql undefined reference to _PC expected to be defined in
/usr/lib/libSystem.B.dylib
./mysql undefined reference to _UP expected to
1 - 100 of 114 matches
Mail list logo
