depends on your budget :)
We assembled a nice dual pIII server with 512Mb ram and 40Gb ide disk (+40 for backup)
running redhat 7 for less than $3000
You can spend any amount you like, from $30 for an old P133 up to $3 for a compaq,
and choose almost any platform you like.
without
We want to get the Unique value from a table.
can we use the following query:
select unique(ProblemNo) from MainProblem;
where MainProblem is a Table having Column ProblemNo.
the contents of ProblemNo are
1
1
2
2
3
3
3
the result of the above query must be :
1
2
3
Thank You.
use distinct() instead.
- Original Message -
From: AVDHUT SHEDGE [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 08, 2001 3:00 PM
Subject: Regarding SQL query with Unique
We want to get the Unique value from a table.
can we use the following query:
select
Salvador Casquero Algarra wrote:
Hi,
I am having a terrible problem with MySQL and I am desperated as
nobody seems to find the source. I have a Web site ( www.genteirc.com )
whith MySQL database access. The problem is that those Mysql processes are
growing continuously
AVDHUT SHEDGE wrote:
We want to get the Unique value from a table.
can we use the following query:
select unique(ProblemNo) from MainProblem;
where MainProblem is a Table having Column ProblemNo.
the contents of ProblemNo are
1
1
2
2
3
3
3
the result of the above query must
Hi,
I am new to MySql.
i have server runnng mysql-3.23.37-win under Windows NT
i am using mm.mysql-2.0.4-bin JDBC driver to connect to mysql
server.
i am able to connect to mysql server from java program run on
the same pc with host as 'localhost' or '127.0.0.1'.
the ip address of the pc
Hello,
I am trying to transfer my Microsoft SQL Server to a MySQL Server running
under Linux.
Until now I have tryied the following methods.
I installed DBtools 1.0.8 in a third machine running Win98 and connected to
the MySQL server (Linux). I tried to import data from the Microsoft SQL
Hi,
I've got a couple a questions concerning the speed of insert queries when
using the C API from MySQL. I've written an application that receives
data through a CORBA event channel and stores it in a MySQL database. The
problem is that a lot of events are dropped. I think (I'm quite sure
Absolutely. I am using BDB tables and accessing them through mm.mysql JDBC.
In a way I'm relieved; for a while there I thought I was losing my ability
to read and understand a good technical book...
Kevin McBrearty
ATG Automation Technologies Group Ltd.
-Original Message-
From: Paul
Absolutely. I am using BDB tables and accessing them through mm.mysql JDBC.
In a way I'm relieved; for a while there I thought I was losing my ability
to read and understand a good technical book...
Kevin McBrearty
ATG Automation Technologies Group Ltd.
-Original Message-
From: Paul
$ uname -a
HP-UX mnemosyn B.11.00 U 9000/800 122901567 unlimited-user license
$ cc -V /tmp/none.c
cpp.ansi: HP92453-01 A.11.01.00 HP C Preprocessor (ANSI)
ccom: HP92453-01 A.11.01.00 HP C Compiler
$ aCC -V
aCC: HP ANSI C++ B3910B A.03.13
$ LDFLAGS=+DA2.0W CFLAGS=+DA2.0W -D_REENTRANT
I am having a problem installing the MyODBC drivers. I run setup but
nothing happens. Any ideas?
David
[EMAIL PROTECTED] wrote:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the
Good Day:
I was just wondering, if I'm using mm.mysql.jdbc-1.2c
to connect to a database w/JAVA do I also need MyODBC
installed and configured also? Or is
mm.mysql.jdbc-1.2c all I need? Thanks alot..
Greg
__
Do You Yahoo!?
Yahoo! Auctions -
Hi there,
Using MySQL 3.22.27 and php3. The page I have does 7 queries to the database
and then displays the page. The first time it runs it takes 9 secs or more
before the data is displayed and then after that the thread is cached on MySQL.
But when I run the same Query from MySQL console I
I compiled all the components of MySQLgui without problems, but when I
ran the mysqlgui program, I got the following error message:
error while loading shared libraries: libsqlplus.so.1: cannot open
shared object file: no such file or directory.
Can you help me?
-Kingsley
Hi,
I would like to set autocommit = 0 as the default value when running the mysql
frontend. (Maybe with an entry in my.cnf)
Is that possible ???
Andre
--
E-Mail: [EMAIL PROTECTED]
Date: 08-May-01
Time: 15:42:09
() Join the ASCII ribbon campaign against html
Good Day:
Could someone help me and tell me which direction to
go to see why I'm getting unknown database error
caught by the SQLException catch. I checked to make
sure that the Class.forName was being executed and it
was. Just need a little helping hand. Thanks...
Greg
Andre,
I did not find such an option in my.cnf. But I agree that there should
be one. I will ask Monty to add that option to my.cnf.
Regards,
Heikki
.
Hi,
I would like to set autocommit = 0 as the default value when running the mysql
frontend. (Maybe with
Hi,
Will MySQL support COMMIT and ROLLBACK.
Thank You
Rajeev Ramanujan
insert 200 strings + timestamps a second through the API. Does that sound
too less or am I expecting too much? Do benchmarks or test results for the
C API exist? If someone has more experience on this or knows a place where
I can find out more, plz let me know.
I just ran this test on a
Hi,
I accidently delete all my records from a table, but I always make backups!!!
Okay, I deleted the (empty) table with drop table.
Than I recreate the table and all the data mith a mysql batch job (from
mysqldump) .
No problem. Than I started the mysql UI and make some test queries.
select *
Not only database design but system as well. Drive speed, drive
fragmentation and I/O resources can play a large factor in database speed.
Could you have a better disk environment on the Solaris machine versus the
win32-machine?
-Original Message-
From: Ansgar Becker [mailto:[EMAIL
Hi!
I think that for BDB and InnoDB tables MySQL first executes
SQL SELECT MAX(auto-increment-column) FROM your-table
for the table, and then adds 1 to the value it gets. It means that
if you delete the row with the highest counter value, MySQL will
assign it again to a new row. On the
Andre,
it might be a bug in the multiversioning code in InnoDB.
Can you describe in detail the situation:
- What is the CREATE TABLE statement?
- How many rows there are in the table?
- How did you import the table?
- Are you able to repeat the bug if you delete and drop the table,
and create
Rajeev,
with the transaction-safe table types InnoDB and BDB, MySQL supports
commit and rollback. They are available in the Unix source distribution and
in the MySQL -Max binary distribution. Monty said he already has also
Windows sources ready and will post them once he has time.
Regards,
I have downloaded the ODBC driver 2.50 37-nt form www.mysql.com
http://www.mysql.com/ , I have installed it and I have created the ODBC
data source called sample_mysql, but when I try to import tables form access
I get an error message saying: [TCX][MyODBC] cannot connect to mysql
server
Hi all...
I am using mysql database in linux. Now we want to use odbc calls in a linux
program to access this database.
Is this possible? I have no idea of this... and as my project dead line is
near i am in a fix. so if someone could tell me about this approach and also
send in a very simple
Could you have a better disk environment on the Solaris machine versus the
win32-machine?
The Solaris machine was a little bit slower executing the query, but it runs
as a production-webserver and there is much more load on it than on my
win32-test-machine.
query that inserted 1 string
Hi,
How can I have an UNIQUE key in MYSQL which
differentiates between case sensitive strings.i.e If I
want to store XYZ,XYz and xyz
differently.Currently mySQl is not accepting this type
of strings and treating them as the same.
Regards,
Ravi
Description:
On both precompiled and site compiled versions, the testsuite reports
errors in rpl000xx.test. This is on Solaris7.
The precompiled version reports the following errors:
rpl01
rpl04
rpl07
The site compiled version reports the following errors:
rpl01
VVM Ravikumar Sarma Chengalvala wrote:
Hi,
How can I have an UNIQUE key in MYSQL which
differentiates between case sensitive strings.i.e If I
want to store XYZ,XYz and xyz
differently.Currently mySQl is not accepting this type
of strings and treating them as the same.
Regards,
Ravi
I have downloaded mysql front and I was wandering how on the server end I
can connect to it from a remote location. I keep getting 'hostname is not
allowed to connect to this mysql server. I do have a static ip at this
remote location. I am new to mysql so sorry if this has already been
when a BDB table is being written to and another thread
issues a query I sometimes get this error code. Ideas?
The table is fresh it was created by the dumpfile that another
thread is loading in while I'm running the count query.
this is mysql-max 3.23.37
mysql select count(*) from _data;
Couple problems here...
Have a database with 36,316 emails archived.
emailarchive.emailbody has a FULLTEXT index.
If I query on a term that exists in the majority of the emails, it returns 0
rows and takes an incredible amount of time.
mysql SELECT count('') FROM emailarchive where listnum =
Hi David, did you ever find out how to resolve the problem
where rpl15 and rpl16 fail, after a mysql-3.23.37 build?
I have the same problem, when building (using gcc-2.95.3) for
Solaris/SPARC 7 and 8. When I run rpl15, the mysqld-slave.err
messages say --
010508 20:50:19 Slave:
Hi Darren, were you ever able to resolve the failures for tests
rpl15 and rpl16 (mentioned in your 27-Apr message)?
I have the same problem, when building (using gcc-2.95.3) for
Solaris/SPARC 7 and 8. When I run rpl15, the mysqld-slave.err
messages say --
010508 20:50:19 Slave:
hi list, im giving this command
mysqlLOAD DATA LOCAL INFILE c:/phani/phani.txt INTO TABLE phani1;
the columns in phani1 are equal to columsn in phani.txt
There are totally 3 columsn (empno, ename, address)
when i say select * from phani1;
im getting only empno and null values for ename and
Specify the format of the text field in your query.
For example, if the fields are tab-delimited and each line is a new row,
you would use
load data local infile 'c:\phani\phani.txt' into table phani1
fields terminated by '\t'
rows terminated by '\n';
Ben Gollmer
On Tuesday, May 8, 2001,
create table button doesnt work.
William Bowman
Hirons Company
Interactive Programmer
555 N. Morton St.
Bloomington,Indiana 47404
812-331-7500 Ext. 150
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 2:39 PM
What does this mean? It is referring to the following SQL statement:
INSERT INTO MaterialSubwall
SELECT subwallClassId,
mirrorEW,
rotation + 180,
sizeX,
sizeY,
offsetS,
offsetW,
offsetN,
offsetE
FROMMaterialSubwall;
AFAIK,
Hello,
I have recently converted my Java Servlets to run against mySQL where previously I was
using Microsoft Access. I use Tomcat and have swapped drivers etc and everything works
fine, more or less. However, I have one big problem which is as follows :-
My servlet software dynamically
green jon wrote:
Hello,
I have recently converted my Java Servlets to run against mySQL where previously I
was using Microsoft Access. I use Tomcat and have swapped drivers etc and everything
works fine, more or less. However, I have one big problem which is as follows :-
On Tue, 8 May 2001 22:38:52 +0100, green jon [EMAIL PROTECTED] wrote:
MySQL currently does not support sub select queries
Hello,
I have recently converted my Java Servlets to run against mySQL where previously I
was using Microsoft Access. I use Tomcat and have swapped drivers etc and
got an error in PhpMyAdmin for this syntax but no error message displayed,
could someone help me that's the first time i run such inner joins on an
other DDB than Ms SQL ...
Here's the Query :
SELECT informations.titre, informations.Texte FROM informations INNER JOIN
recurrence_informations ON
Check out the 2nd bullet under 7.21.1 of the manual:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#INSERT_SELECT
You could do this by creating a temporary table out of MaterialSubwall and
using that to select rows for the insert.
- TIM
What does this mean? It is
Hello,
I have a question on moving a MySQL database from a Windows Me machine to a Linux
machine. Most of our tables have over 22 million rows. I suppose the slow but safe
way is to dump the whole database on the Windows machine using mysqldump and then ftp
the dump file over to the Linux
Hi,
Im not sure wheter this is a bug ( and it will make me look silly ) but its
been annoying :)..
It could even have been fixed since 3.22.27 :) ( Yes! I will upgrade
tomorrow :)
I have these three tables:
***RULES***
CREATE TABLE rules
(id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
owner
On Tue, May 08, 2001 at 03:15:31PM -0700, David Potter wrote:
I have a question on moving a MySQL database from a Windows Me
machine to a Linux machine. Most of our tables have over 22 million
rows. I suppose the slow but safe way is to dump the whole database
on the Windows machine using
Is there anyone out there who knows where I can get support with this mod
for apache? The web page listed in the package seems to be invalid and I
can't seem to locate any support lists on the apache side of things.
Actually any help at all on how to make this install or any other method
out
Hello everyone,
I was wondering if anyone could help me out and explain a bit about the
FILE permissions and how they relate to two particular scenarios:
In both cases MySQL is running on SunOS 5.7 and running MySQL client
version 3.22.23b
MySQL UserA has permissions only on DatabaseA and is
At 11:13 PM -0400 5/8/01, A. Chris Nichols wrote:
Hello everyone,
I was wondering if anyone could help me out and explain a bit about
the FILE permissions and how they relate to two particular scenarios:
In both cases MySQL is running on SunOS 5.7 and running MySQL client
version 3.22.23b
How do I write SQL in MySQL to randomly select 5 records from a table?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
SELECT * FROM db ORDER BY rand() LIMIT 5
--zak
- Original Message -
From: Webmaster [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 08, 2001 9:38 PM
Subject: SQL help
How do I write SQL in MySQL to randomly select 5 records from a table?
I have a dedicated server in a colocation data center and I have root access
but I would like to use mysqlfront(http://www.mysqlfront.de) to administer
the mysql server from a specific location my static ip on a different
computer. Sorry should have been more clear about it.
i think it is more suitable to do it in programming level in mysql, though I
know there is a function is M$sql server.
if your table schema has a unique id field, before submit a query to DB,
1) select count(*) from it
2) from the above resultset, program to draw whatever number of records you
This may not be a mysql issue, but mysql is the manefestation of the problem:
Sometimes POST operation seems to loose variable contents, and the apache log
shows 302 result. Blank row is inserted into DB.
My script has a form:
form method=post action= ?echo $PHP_SELF;??action=? if ($action==mod)
Ah! ok, maybe I won't be much help after all. Only thing I can think of
would be your privilege tables.
- Original Message -
From: TWooly [EMAIL PROTECTED]
To: Rolf Hopkins [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, May 09, 2001 11:58
Subject: Re: mysql Front
I have a
i dont follow step #3.
At 11:42 PM 5/8/2001, Tony Shiu wrote:
i think it is more suitable to do it in programming level in mysql, though I
know there is a function is M$sql server.
if your table schema has a unique id field, before submit a query to DB,
1) select count(*) from it
2) from
for 3)
if you have a set of random values e.g. 1,3, 6, 9, 4
then your sql will be
select * from your-table
where id in (1, 3, 6, 9, 4);
FYI:
if you are using ver 3.23.X, you may use
SELECT * FROM your-table ORDER BY rand() LIMIT 5
contributed from: Zak Greant [EMAIL PROTECTED]
rand() seems
You might be able to do something like this instead:
SELECT *, id*0+RAND() AS r FROM table ORDER BY r LIMIT 5;
Check the list archives, this issue comes up quite often.
On Wed, 9 May 2001, Webmaster wrote:
i dont follow step #3.
At 11:42 PM 5/8/2001, Tony Shiu wrote:
i think it is
Hi,
Mysqladmin shows me :
| Key_write_requests | 80850 |
| Key_writes | 112447|
What does it mean, and how could this be possible ?
Thank you,
Jocelyn Fournier
Presence-PC
www.presence-pc.com
61 matches
Mail list logo