Estimated gurus.
I've got a MyISAM table with 3000 rows.
Two days ago, it showed an error Got error 127 from table
handler.Therefore, I made OPTIMIZE TABLE tabla and it was solutioned.
But today, table has 3200 rows, and it shows another error Found link that
points at
2325343242342323
I am having a problem accessing my SQL from our webserver. Between the
two is firewall. All the ports between the SQL server and firewall are
currently blocked.
except port 3306 which is open.
However, my I can't connect to the mySQL server. Is there anything I
can do to test or what other
* USER
Is there any way to do an Update...Select like an InsertSelect?
For instance can I fill one table with data from another table.
The columns
do not match exactly so a table copy won't do much good. But the data
retrieved in the select command is compatible with the new table
Keith,
I got it! What you said about replacing one JOIN with another is what did
the trick. After a little trial and error (maybe a little more than a
little) I got the results I needed. Thanks for the help. In case you're
still curious I am modeling short track racing here in New York
Thank you, we shall investigate this problem.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
___/ www.mysql.com
Mysql pick up the database list from its default datadir C:/mysql/data
as it is mentioned in
my.ini file in window.
but i want to use my own directory which contains some database , if i
am setting the datadir into my
directory i am able to use my own directory to which i have to copy the
Takacs,
Thursday, February 14, 2002, 9:19:37 AM, you wrote:
TI Wed, 13 Feb 2002 15:02:01 PM, you wrote:
TI After the default mysql-3.23-47 installation,
TI there are two entries in the mysql.user table
TI where the User and Password fields are empty.
TI I'd like to know what is the purpose
Vernon,
Thursday, February 14, 2002, 5:01:06 AM, you wrote:
VAW Why, if I have MySQL is the MySQLAdmin not on the box? Is
VAW there something else I must install? I've downloaded the
VAW rpm from the web site and installed. When it boots, MySQL
VAW does come up and it says that it has
Hi, Amit
What kind problem do you have?
I can't understand your problem.
In JDBC API, Connection.commit() method does not return
affected row count.
Generally, Statement.executeUpdate(String) method returns
that count.
Thanks.
Amit Dilip Lonkar wrote:
HI
I am using java. i am
Martin,
Thursday, February 14, 2002, 7:42:43 AM, you wrote:
MJ You need to set access privileges for SQL server. try with this :
MJ GRANT ALL PRIVILEGES ON database.tables TO [EMAIL PROTECTED] \g
MJ flush privileges \g
Martin, you are right, but i want to add that there is no need to run
Asit,
Thursday, February 14, 2002, 1:21:04 PM, you wrote:
AS Mysql pick up the database list from its default datadir C:/mysql/data
AS as it is mentioned in
AS my.ini file in window.
AS but i want to use my own directory which contains some database , if i
AS am setting the datadir into my
AS
Hi
I am trying to write an auction script that uses mysql as its backend. Each
auction can have upto 25 sub auctions(cells) taking place.
I'm trying to query the DB to give me a list of all the successfull bids
for each cell, for each auction...
SELECT b.auctionId, b.cellId, MAX(b.bid) as bid,
Peter Pierre writes:
mysql
Is there a manual for it.
Yes, there is.
It is a file MySQL.help, that came with distro.
To set it up to work with F1 key, see the config example of my.cnf,
that also came with distro.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr.
Andreas,
If anyone else is interested, I have solved the problem in stepwise/tutorial fashion
below (best viewed using a
fixed font).
If anyone is skilled in the user of FROM...JOINs, (I'm sure Andreas, and) I'd welcome
a critique/any
improvements!
I have taken a look at this problem, and
Hi,
My database users have problems with the missing sub-query feature of MySql
that I would like to solve by letting them create temporary tables since
their scope is a connection thread. However I cannot let them to start
creating tables that are not temporary.
Unfortunately I cannot find
Hi all,
Will MySQLDump and the update-log work 100% if I'm not using transactions
with the database? I'm concerned that if there are a few updates buzzing
along together and then the tables are locked, I could end up with a copy of
the DB that has only a part install in it.
Or is there a
Kevin,
Thursday, February 14, 2002, 8:30:18 AM, you wrote:
KC Is their any special instructionsfor upgrading within versions. A software
KC vendor says I need to be at 3.23.39 or greater for their product to
KC function. I am at 3.23.36. When I try to upgrade with rpm -Uvh her is my
KC
Brumpton,
Thursday, February 14, 2002, 10:47:14 AM, you wrote:
BR I am having a problem accessing my SQL from our webserver. Between the
BR two is firewall. All the ports between the SQL server and firewall are
BR currently blocked.
BR except port 3306 which is open.
BR However, my I
Jochen,
Thursday, February 14, 2002, 8:52:01 AM, you wrote:
JK Can I use the RedHat-rpms on mysql.com to update a SuSE 7.3 prof or
JK do I need to compile it from source with some parameters?
JK I run 3.23.44 max and I want to update to 3.23.48 max
Yes, you can use MySQL (rpm) for upgrade.
Greetings,
How do I get the rows in a table to be in a different
order? I know I can sort a SELECT statement with an
ORDER BY clause, but how do I make this a permanent
adjustment to the table, so that all future SELECTs
will produce ordered data? How does MySQL know what
orders the rows are in
Hi,
I remember reading article about how to use MySql table as a place to put
picture file. I can't find that article now. Can anyone help me with this? or
point me to URL or something. I am using php as the front end.
Thanks.
Reuben D. Budiardja
Reuben,
You can store the images into a database, but no one recommends it.
What I do, is actually store the location of the file in the database
then have PHP open it.
-Original Message-
From: Reuben D Budiardja [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 14, 2002 9:08 AM
On Thursday 14 February 2002 10:16 am, Todd Williamsen wrote:
Reuben,
You can store the images into a database, but no one recommends it.
What I do, is actually store the location of the file in the database
then have PHP open it.
Any reason why it is not recommended?
I was going to do it
Bryan,
Thursday, February 14, 2002, 4:54:11 PM, you wrote:
BM Greetings,
BM How do I get the rows in a table to be in a different
BM order? I know I can sort a SELECT statement with an
BM ORDER BY clause, but how do I make this a permanent
BM adjustment to the table, so that all future SELECTs
The two biggest reasons why
1. Bloats the database
2. Slow at retrieving the images
-Original Message-
From: Reuben D Budiardja [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 14, 2002 9:30 AM
To: Todd Williamsen; [EMAIL PROTECTED]
Subject: Re: insert picture file in MySQL
Hi,
After a couple helpful answers to my post, I realized I wasn't going
crazy, but that the root probably had a password and I just didn't know
it. Found this documentation which wasn't very clear except for the
comments at the bottom of the page.
Howdy
You can store the images into a database, but no one recommends it.
What I do, is actually store the location of the file in the database
then have PHP open it.
How would you go about doing this. Could somebody send me some sample code and also
explain how to get the image link into
Hi,
On 13 Feb 2002, at 12:44, Henning Sprang wrote:
Was something wrong with this post or is it really such a weird
problem that there is neither a solution nor anything i could do to
solve it, nor anything i could do to find out more about it?
Well. Replication is somewhat weird. ;-)
As some people knows, Oracle 9.0 has a version to Palm OS and privete
driver for the exchange. I'd like to know if MuSQL or even other DB like
PostrgreSQL has a kind of project in mind? Or is there any academic or an
Open Source project to DB for PALM OS?
Please PVT-ME,
Thanks
At 16:51 14/02/2002 +0530, Asit Satpathy wrote:
Hi!
Mysql pick up the database list from its default datadir C:/mysql/data
as it is mentioned in
my.ini file in window.
but i want to use my own directory which contains some database , if i
am setting the datadir into my
directory i am able to
On Thursday 14 February 2002 09:54, Bryan McCloskey wrote:
Greetings,
How do I get the rows in a table to be in a different
order? I know I can sort a SELECT statement with an
ORDER BY clause, but how do I make this a permanent
adjustment to the table, so that all future SELECTs
will
Hi!
I tested with .48 and it seems that if the estimator thinks you are going to
delete 10 % of the rows in your table, it scans the whole table.
In .47 this % limit is smaller, because I changed .48 to favor more index
searches over table scans.
But I tested with a very uniform table. Your
On Thu, 2002-02-14 at 08:42, Eric Torr Klopper wrote:
How would you go about doing this. Could somebody send me some sample
code and also explain how to get the image link into the database so I
can access the image. I'm fairly new to MySql and
PHP so any help on this will be appreciated.
I
Dear Listers:
In configuring for a 4.0.1 compile, all goes well.
The compiler, however, reports (apparently in the InnoBase section of the
compile):
../innobase/btr/libbtr.a(btr0sea.o): In nunction 'btr_search_guess_on_hash':
btr0sea.o(.text+0x1c58): undefined reference to
On Thursday 14 February 2002 07:58, Carl Shelbourne wrote:
Hi
I am trying to write an auction script that uses mysql as its backend. Each
auction can have upto 25 sub auctions(cells) taking place.
I'm trying to query the DB to give me a list of all the successfull bids
for each cell, for
Reuben,
Try http://www.phpbuilder.com/columns/florian19991014.php3
John Lodge
-Original Message-
From: Reuben D Budiardja [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 14, 2002 3:08 PM
To: [EMAIL PROTECTED]
Subject: insert picture file in MySQL (+php)
Hi,
I remember reading
Has anyone ever tried to use the Janus GridEX control with mySQL? I get an
ODBC Driver does not support the requested properties error.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Heikki,
Here is what you asked for:
mysql EXPLAIN SELECT * FROM Syslog USE INDEX(ds_index) WHERE datestamp
= 20020213185230;
++--+---+--+-+--+--+
+
| table | type | possible_keys | key | key_len | ref | rows | Extra
|
Hi ,
I have a servlet in which I connect through a mysql driver to the
database. The servlet has a string that represents the date in the
format 'MM/DD/YY'.
When I am trying to insert this date, I get sometimes the correct date,
sometimes I get the '-00-00'.
Here is the code:
String
Hi!
(Please continue this thread only on the internals list)
Ken == Ken Menzel [EMAIL PROTECTED] writes:
Ken Hi Monty and Jeremy,
We have been a bit reluctant to update the manual, as most of our
users are still using 3.23 and could easily be confused by this.
I think we should wait
Ok I can't seem to get this. Now is it possible to have MySQL on a other
computer and run the script.
In other words the perl script is on foo.com and MySQL database is on
foo2.com. What is need to make the script work. What I have in the
script is:
Configure.pl
sub configure {
This doesn't really answer your question, but whenever I deal with
dates I convert them to Unix and store them in the database, and then
convert them back when I use them. Sorting dates doesn't seem to
work as well in a non-unix format, and with UNIX dates you have much
more control over the
Hi Catalina,
I have a servlet in which I connect through a mysql driver to the
database. The servlet has a string that represents the date in the
format 'MM/DD/YY'.
When I am trying to insert this date, I get sometimes the correct date,
sometimes I get the '-00-00'.
Here is the code:
I have a servlet in which I connect through a mysql driver to the
database. The servlet has a string that represents the date in the
format 'MM/DD/YY'.
When I am trying to insert this date, I get sometimes the correct date,
sometimes I get the '-00-00'.
Here is the code:
Dear Sirs and Madams,
EMS HiTech company is announcing the next version (1.6) of MySQL
Manager -- A Powerful MySQL Administration and Development Tool for
Windows95/98/ME/NT/2000/XP.
You can download the latest version from
http://www.mysqlmanager.com/download.phtml
What's new in version 1.6?
Why is the internal order important? When SELECTing, the internal order is
of no importance to MYSQL. It does not speed-up the query or access. When
discussing relational database systems, all that matters is the order of
output.
-Original Message-
From: Victoria Reznichenko
In mysqldump.c there is // in 2 places, older compilers don't like it,
changing to /* */ fixes the problem.
Bart Kedryna
Software Engineer
Online Support
[EMAIL PROTECTED]
(215) 386 0100 x1470
ISI
3501 Market Street
Philadelphia, PA 19104
You're right, it's not important how the data is
stored inside the database. I was just hoping that
there would be a way to set a default order so that I
wouldn't have to write a cumbersome ORDER BY phrase
every time I wanted to see the data. I thought that
perhaps indexes could accomplish this,
Eric,
thank you for the printouts. Looks like MySQL refused to obey the USE INDEX
clause! Did you run the EXPLAIN on a very small table? Otherwise I do not
understand why it reports only 4700 rows.
You have a very long-running mass delete below. It has row locks on 13000
pages = 200 MB. It has
The VB front end I built using MySQL with MyODBC works great on my local
machine after performing the binary installations. If I move the front end
to remote machine, what files are required for successful connecting? Just
those bundled with MyODBC? I am attempting to keep the install as lean as
What Rick said is absolutely correct and you probably are obsessing about
something that doesn't matter. But I would venture you are using an
auto-number field as the primary key when you could easily change it to a
function something similar to: set ID = MAX(ID) + 1.
-Original
Hi!
January 12, 2002:
There is a bug in some GCC compiler versions and consequently compilation of
the function btr_search_check_guess fails. Fix: replace the declaration
'UNIV_INLINE' in that function in mysql/innobase/btr/btr0sea.c by the
declaration 'static'. Fixed in 3.23.48.
Best
-Original Message-
From: Peter Ruan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 14, 2002 4:04 PM
To: [EMAIL PROTECTED]
Subject: [PHP] MySQL question...not sure if this is the correct forum to
ask.
Hi,
Can the UPDATE statement have conditional check embedded in it? I
have a
On Thu, Feb 14, 2002 at 01:05:24PM -0500, Richard C Rossy wrote:
Ok I can't seem to get this. Now is it possible to have MySQL on a other
computer and run the script.
In other words the perl script is on foo.com and MySQL database is on
foo2.com. What is need to make the script work. What
What about REPLACE?
http://www.mysql.com/doc/R/E/REPLACE.html
'REPLACE works exactly like INSERT, except that if an old record in the
table has the same value as a new record on a unique index, the old record
is deleted before the new record is inserted'
Regards,
Dan
-Original
Hello All,
sorry about the off-topic... somewhat :)
We are going to be implementing the mod_auth_mysql apache module on a client's
site. And I was wondering, when using this module for password protection, and
the appropriate .htaccess file is put into the protected directory, do I need to
You /can/, but it may not work. SuSE uses a slightly different directory
structure, and RedHat RPMs may get confused. If at all possible, use
SuSE provided packages.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Victoria Reznichenko
Monty, Venu, I hope you read this... :)
I really, really want to use MySQL as the database backend for my
datawarehouse. Mind you I have played around with merge tables quite a
bit and know that MySQL is more than up to the task. There are numerous
(not necessarily cost related) reasons as to
How do you add a column that increments on the fly those fields
you've selected to print in a mysql query?
Example:
select count(g.Group_ID) as Number, g.Description,
sum(i.Retail_Value) from Groups g, Item i where i.Group_ID =
g.Group_ID and i.Group_ID 0 group by i.Group_ID order by
Hi List,
I need to select a set of stuff from the database and then delete
exactly the same stuff. I've formed two query statements and I'm
tacking modifications to their ends to be consistent, but I'm not sure
if with a limit clause the database will delete the same set of contents
selected?
MySQL Gurus,
I'm trying to figure out what the number after the type means for numbers.
I noticed in someone's code that for the ID field they used bigint(20).
bigint I thought was fixed at 8 bytes. Does this override the size? 20
bytes??? 20 bits?
Thanks
John
John,
The number in the parenthsis tells mysql how to format the column when
it goes to display it.. Here is the relevant section of
http://www.mysql.com/doc/N/u/Numeric_types.html:
Another extension is supported by MySQL for optionally specifying the
display width of an integral value in
Dear MySql experts:
we have mysql and mm driver installed on a unix
server, but when I try to run Blob (in testsuite/), it
gives error message:
cannot connect to MySQL server on //localhost:3306
here is the code for connection:
try {
Class.forName(org.gjt.mm.mysql.Driver).newInstance();
When I run the code below, information about the first column in each
table in my list is excluded. Any ideas why?
@table_listing=`cat /usr/local/file.txt`; # contains table list used
below
$dbh =
DBI-connect(dbi:mysql:database=dbname;host=hostIP;port=port_number,
user, password) or
On 14 Feb 2002, at 15:51, Brian Warn wrote:
When I run the code below, information about the first column in each
table in my list is excluded. Any ideas why?
[snip]
@row_ary = $sth-fetchrow_array;
You've read that information into @row_ary, but then you never do
anything with it.
At 15:51 -0800 2/14/02, Brian Warn wrote:
When I run the code below, information about the first column in each
table in my list is excluded. Any ideas why?
Why are you reading a row into @row_ary?
I bet you're thinking that row will correspond to the row of column
headers that you'd see were
Hi there, I hope someone will can help me... First, sorry for bad english :)
i'm french
First all I have those index in my table
+---+---+-++
--+-++--++--
+
I'm not an expert on MySQL or can address any of the tuning issues you bring
up. I will say this, you are not totally correct in how ACCESS is
retrieving records. VB and Microsoft Jet retrieve dynasets which is
basically the primary key in its entirety. When you move to the next screen
ACCESS
Wednesday, from Mike Wexler:
I don't think that would be appropriate. My example, is our site (tias.com) has
lots of antiques and collectibles. One popular categories is jewelry. If
somebody does a search for gold jewelry and the search engine interprets this
as anything that mentions gold or
Alright, I have student table and an attendance table.
student table
student_id int(10)
name varchar(60)
school int(4)
district int(4)
attendance table
student_id int(10)
status varchar(4)
datedate
Here is the query,
SELECT
David,
try
1) create temporary table x (a INT PRIMARY KEY AUTO_INCREMENT)
[select_statement]
where [select_statement] is some legal select statement, presumebly
select g.Description,sum(i.Retail_Value)
from Groups g, Item i
where i.Group_ID =g.Group_ID
and i.Group_ID 0
group by i.Group_ID
Wednesday, from David Axmark:
Your other point about exact vs. approximate answers is unclear, I expect
that Google's answers are exact for their currently available indexes at any
given time. But even if they are approximate, I'd be happy with that too.
The scoring on a FULLTEXT search
I am reposting this because it got sent right at the start of all the fun
with the mailing list.
Best,
Kyle
-
I have a series of data in one table that I need to put into a set of ranges.
Here is a simplified version of the tables:
data table fields (data):
val
http://www.mysql.com/doc/N/u/Numeric_types.html
20 is the display width:
'for a column declared as INT(5) ZEROFILL, a value of 4 is retrieved as
4'
Regards
Dan
-Original Message-
From: John D. Kirkpatrick [mailto:[EMAIL PROTECTED]]
Sent: Friday, 15 February 2002 12:27 p.m.
To:
Hi,
I still got stuck on a query...so slow...it took a minute or more
How can I improve my server...
Specs...
Computer:
Pentium II 333MHZ
128MB
20GB HardDrive
OS:
Windows 98,
Database:
Table definition
| edate | date | YES | | NULL|
| etime | int(5) unsigned
Hi all.
And Hi to the spam filter: MySQL, database, sql, etc...
We are considering using the BLOB data type to store documents - .doc,
.xls, .pdf mainly.
I have also considered just storing a hyperlink to a file on the
network, but with the amount of files, it seems a little messy.
So I'm
On Thu, Feb 14, 2002 at 03:41:32PM -0800, wally liau wrote:
Dear MySql experts:
we have mysql and mm driver installed on a unix
server, but when I try to run Blob (in testsuite/), it
gives error message:
cannot connect to MySQL server on //localhost:3306
Can you, at this point,
If I start mysql by changing to the msyql directory and run safe_mysqld
--user=mysql everything works fine, if I try to start mysql at boot time
with an init script it starts and immediately dies the log files say it
can't find a certain library file (a file that is in my LD_LIBRARY_PATH). It
what affects the rows in the host table of database mysql? is it when a
particular host logs in the server's mysql console? or is it when a user
browses a web file that launches a script to access a database? or both?
thanks
jembo
On Tue, Feb 05, 2002 at 07:10:01PM +0200, Victoria Reznichenko wrote:
jeremy,
Tuesday, February 05, 2002, 6:40:29 PM, you wrote:
jr hello,
jr i made the mistake of changing my root password manually in the mysql
jr database. after doing so, i 'flushed privileges'.
jr now i'm unable
The create table command included at the end of this message gives
the following error:
ERROR 1005: Can't create table './catalogmgr/macitm_vendordfrom.frm'
(errno: 150)
Creating it with type=myisam, and then doing an alter table and
converting it to innodb works okay. It just cannot be
Hello,
Look on the following page: www.dbtools.com.br.
There is a good software which can handle that task.
- Original Message -
From: Fabio Amura [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 14, 2002 8:33 AM
Subject: from ms access to mysql
Hi,
i have to
Hi,
Monty, Venu, I hope you read this... :)
I really, really want to use MySQL as the database backend for my
datawarehouse. Mind you I have played around with merge tables quite a
bit and know that MySQL is more than up to the task. There are numerous
(not necessarily cost
hi,
I am querying from the C api's,i am getting some result-set from which I
want to display particular colum??
Is there any C api by which I can directly point to the particular colum
and print it..
Thanks and regards,
Chetan Lavti
At 03:26 PM 2/14/2002 , you wrote:
What Rick said is absolutely correct and you probably are obsessing about
something that doesn't matter. But I would venture you are using an
auto-number field as the primary key when you could easily change it to a
function something similar to: set ID =
Bill,
Some databases can use a live result set when retrieving a lot of
records and I really really wish MySQL could do the same. A live result set
does not create a temporary table or use memory to retrieve all the
records. It will grab 50 or so records at a time, and when scrolling
Can I statically link to libmysqlclient? If so, what are the implications?
Will I have to distribute my application's source? IANAL, so what do I need
to do? What if I link dynamically? Can I redistribute the compiled
libmysqlclient library? What if I just link dynamically?
Cheers,
Andrew
Hi,
At 11:21 AM 14/02/2002 -0500, you wrote:
On Thursday 14 February 2002 07:58, Carl Shelbourne wrote:
Hi
I am trying to write an auction script that uses mysql as its backend. Each
auction can have upto 25 sub auctions(cells) taking place.
I'm trying to query the DB to give me a
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
I'd like to connect a local sql server to a remote server and get 1
database synchronized between them. For various reasons, I need to
try to run this from within the sql protocol (i.e. no ftp, etc.).
Replication is not the answer, and I can only work with one database
at a time, so a SELECT is
Is there _any_ way to do something like Oracle's OCI callback functions?
What I need to do:
Whenever my MySQL database changes data (inserts, updates, whatever) I need
to call some of my own code.
Any ideas?
-Andrew
-
Before
MySQL is awesome, but I think I found a bug.
The following script:
CREATE TABLE X1 (x smallint);
insert into X1 values(5);
RENAME TABLE X1 TO X2;
is producing the following error:
7 - Error on rename '.\db\X1.MY1' to '.\db\X2.MYI' (Errcode: 13)
The problem seems to be caused by using
Hi List
I have to set up a HA-Linux Server with Apache and mysql running on
two machines over load balancing. Apache isn't a problem. But mysql.
AFAIK it is impossible to cluster mysql - it only supports
replication. As I've said already, we have only two machines, and two
firewalls of course,
Eric,
-Original Message-
From: Eric Mayers [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Date: Friday, February 15, 2002 1:10 AM
Subject: RE: Does delete from .. where (condition) use an index?
Heikki,
I thought I'd bring this off the list to reduce list traffic (if you
think
94 matches
Mail list logo