Hallo MySQLers
I have problems installing MySQL Version 3.23.33 on RS/6000 AIX4.3.3
>Description:
exec(): 0509-036 Cannot load program ../bin/mysqld because of the
following errors:
0509-150 Dependent module /usr/local/lib/libz.a(shr.o) could not be
loaded.
0509-152
Subqueries like that won't work until version 4.0.
for now it's rather ugly and inefficient, but one way you could do it would
be like this:
select table1.*, ifnull(table2.column2,-1) as marked from table1 left join
table2 on table1.column1=table2.column2 having marked=-1
I've done something si
Hello everyone, my error.log file have many messages:
010315 22:29:04 Aborted connection 6556 to db: 'test' user: 'root' host: `localhost'
(Got an error reading communication packets)
..
Is this a error? How can I solve it?
Thanks.
==
xiewer
Emailto:[EMAIL
select * from table1 where column1 not in (select column2 from table2)
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 7:13 PM
Subject: question about NOT IN
> Please I would want how I can get the list of records from a
> table1 tha
The first problem is not whether they provide oversea shipping.
The first is whether they have the transaction version or not.
-ÔʼÓʼþ-
·¢¼þÈË: Andrew CHEN [mailto:[EMAIL PROTECTED]]
·¢ËÍʱ¼ä: 2001Äê3ÔÂ16ÈÕ 14:00
ÊÕ¼þÈË: WANG_KING£¨Íõ¸Ö£©
Ö÷Ìâ: Re: Binary Distribution of New Version
Y
Yes, I am worried.And also yes I am from shanghai.
I want to get the binary distribution of mysql support transaction.
I think it must be more stable than I compile it with myself.
I want to know if I can buy the version from mysql.com.
The version you download from the web are the same a
On Thu, Mar 15, 2001 at 05:07:08PM -0700, Steve Ruby wrote:
> Patrick Calkins wrote:
> >
> > Hello all;
> > Are there any known problems with storing the database files on a NAS
> > (network attached storage) device??
> >
> > also, can you run multiple MySQL daemons pointing to one common databa
Hi friends,
I have a emergency question.
I want my application to use mysql and support
transaction.So I have downloaded the source distribution of
Mysql3.23.33 and Berkeyley DB 3.2.9a and I compile it to the new version.I
did not follow the manual because if I do s
I've tried to escape it and also to `bakctick` it - neither seems to work.
ex1- backticks:
mysql> select * from temp01 where `Post#` = 9019;
->
-
It does not compute as finnished and prompts for more, when I finish
manually it says:
-> ;
ERROR 1054: Unknown column 'Post' in 'where
At 2:18 AM +0100 3/16/01, Erling Paulsen wrote:
>I just exported (via myodbc) an old access database for my sportsclub to
>mysql (the tables). The ms-access database application still works nicely on
>the new linked tables in mysql. However, I'm now also writing a php based
>client to use the data
Hi,
I am facing problem while installing the mysql software in sun
solaris Operating System.
i downloaded the mysql file from www.mysql.com site and uploaded
into the server in the binary format and trying to extract the tar file
using gunzip file.
The file name is : my
Michael Widenius wrote:
> We plan to use the following algorithm on top of our current
> replication code to achieve this:
>
> http://www.fault-tolerant.org/recall/
>
> Regards,
> Monty
Greetings All:
2 Parts...
Part 1:
I reference the above because the Recall project hasn't had any activity
Hello all, I hope you can help me with a problem I have been trying to figure out for
the past week.
I bought Red Hat 7 and am trying to get Apache/PHP/MySQL working correctly. Using the
Red Hat install program, I installed all the RPMs including the php, mod_php, apache,
mysql, mysql-php, my
Please I would want how I can get the list of records from a
table1 that do not appears on a table2, supossing a column
e.g code is used as connector or joiner present at both
tables;
Thanks
Ernesto
-
Este mensaje fue enviado a través de Qnet
http
I just exported (via myodbc) an old access database for my sportsclub to
mysql (the tables). The ms-access database application still works nicely on
the new linked tables in mysql. However, I'm now also writing a php based
client to use the database over the web and the problem is as follows:
Th
I am running Ver 8.8 Distrib 3.23.22-Beta on RedHat Linux. I have two
databases, foo and bar.
Below I show the output of mysqladmin processlist. Pid 5 is executing a
long-running select from the event table of
db foo. Pid 1 (started after pid 5) is attempting an insert in the same
event table. It
Patrick Calkins wrote:
>
> Hello all;
> Are there any known problems with storing the database files on a NAS
> (network attached storage) device??
>
> also, can you run multiple MySQL daemons pointing to one common database, so
> you could have a "cluster" of database servers and one database??
Hello all;
Are there any known problems with storing the database files on a NAS
(network attached storage) device??
also, can you run multiple MySQL daemons pointing to one common database, so
you could have a "cluster" of database servers and one database??
Thanks!
Patrick
---
I'm experiencing a problem where mysqld is crashing every time I run a
particular query.
The specific error from the client is:
ERROR 1015: Can't lock file (errno: -30989)
ERROR 2013: Lost connection to MySQL server during query
The server error log is reporting:
bdb: transaction has acti
Hi,
I've compiled mysql 3.23.33 but while doing a 'make test'
the merge test fails (it passes all others). Any common
reason for this?
Thanks in advance.
Sander
-
Before posting, please check:
http://www.mysql.com/manual.p
I was having some problems with:
ERROR 1030: Got error 136 from table handler
many versions ago when my indexes got to be around 64M.
I started getting it again with 3.23.34 when I try to do inserts
into a table with this index size:
-rw-rw1 mysqlmysql94232404 Mar 15 11:34 F
I implemented a mysql based user tracker. On every visit
of a user I log some data to the DB.
Experimenting with INSERTs I used DELAYED and benchmarked
the page. An DELAYED insert takes aprox. 9 times more to
execute than an insert.
I am using PHP. When I call the query function it takes 9 time
According to the changelog, there's a bug in ORDER BY that was recently
introduced but fixed in 3.23.35. 3.23.34 fixed a bug in bidirectional
replication though, so I'm wondering what the specifics of the bugs
were, since I want to do bidirectional replication, but don't want a
serious ORDER BY b
I'm trying to install mysql on my redhat 6.2 machine, i've done the
groupadd, useradd, etc. when i ./configure --prefix=/usr/local/src/mysql
it runs thru everything and then stops- just a blinking cursor, that
leaves 3 processes running, when i try to run 'make' it says no targets
and no makefile?
# isamchk -a -d -e -f -i -l -o imp_addr.ISM
ISAM file: imp_addr.ISM
Data records: 1223 Deleted blocks: 0
Recordlength:25
Record format: Packed
table description:
Key Start Len Index Type
User time 0.00, System time 0.00
Maximum resident set siz
Hi Bogomolnyi,
I am really interested in your scripts. I don't have a use for them at this
time, but I am planning to use a fallback system myself in the next few
month.
> 5 pc , and I use it for a web cluster (10 pc) so I use 1 slave
> for 2 httpds
Do you have a similar scheme for the web serv
Hi,
Try some of the more aggressive fixing options on isamchk - see the manual
for details.
Quentin
-Original Message-
From: Nuno Ferreira [mailto:[EMAIL PROTECTED]]
Sent: Friday, 16 March 2001 10:39 a.m.
To: [EMAIL PROTECTED]
Subject: problems with mysql table
Hi there
Hi ,
I posted a few considerations about fialover implementation , to the list ,
but i don't recived any feed back , well lets see what we have :
But i write a bunch of perl scripts and now I use them in production and
very happy with the result .
Here what I have :
Baiscly what I want is an sql
On Thu, Mar 15, 2001 at 08:50:01AM -0800, Mike DeWolfe wrote:
> I'm having a problem with REGEXP :
>
> I have several rows that look like this :
>
> Health : health services : safety : physical abuse : women
> Health : health services : safety : rescue
> Health : health services : safety : sexua
No it does not.
[EMAIL PROTECTED] wrote:
>
> The problem with the \\ is that it inserts it into the database as \\ and
> when it's retrieved it's a \\
>
> - Original Message -
> From: "Michail A.Baikov" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Thursday
Hi there
I have a problem with one mysql table and i don't know how to
solve it .. the table has some important stuff.
when i make a select this is what happens
mysql> select * from imp_addr;
ERROR 1030: Got error 127 from table handler
mysql>
and isamchk
isamchk imp
The problem with the \\ is that it inserts it into the database as \\ and
when it's retrieved it's a \\
- Original Message -
From: "Michail A.Baikov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 2:08 PM
Subject: Re: Special Character \
Dear Software Manufacturer:
We can help you make it much easier to promote your software on the Internet.
Your company is invited to list its software products at no charge on BigSoftE, the
first Internet Software Search Engine. Launching this month, Bigsofte provides
detailed product informa
Ken Whitmore wrote:
>
> Somehow, our MySQL server just started giving the error:
> Error writing file './mydb/mytable.frm' (Errcode: 28)
> whenever I try to create a table using the following:
> CREATE TABLE boundary ( id INTEGER UNSIGNED NOT NULL PRIMARY KEY
> AUTO_INCREMENT);
>
> Preci
"Olivier, Dave" wrote:
>
> To whom it may concern:
>
> When running, the /scripts/mysql_install_db, it starts off with preparing
> the tables, and then it says it is Installing the tables. That is all it
> does, it says the process is running and everything. Does it take a real
> long time fo
use \\ combination
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 11:55 PM
Subject: Special Character \
Can someone tell me how to insert an selct back a directory into mysql using
sql? I'm trying to insert and reselect
c:\My Docu
Somehow, our MySQL server just started giving the error:
Error writing file './mydb/mytable.frm' (Errcode: 28)
whenever I try to create a table using the following:
CREATE TABLE boundary ( id INTEGER UNSIGNED NOT NULL PRIMARY KEY
AUTO_INCREMENT);
Precisely where can I find the documentati
To whom it may concern:
When running, the /scripts/mysql_install_db, it starts off with preparing
the tables, and then it says it is Installing the tables. That is all it
does, it says the process is running and everything. Does it take a real
long time for it to install the tables? If so how
Can someone tell me how to insert an selct back a directory into mysql using sql? I'm
trying to insert and reselect
c:\My Documents into a varchar field and I keep having a problem with the special
character \
Jeff
Your two Title fields are not the same size.
This could prevent a match.
It will slow down joins in 3.22.
Carl Schrader wrote:
>
> I have 2 tables with a common field of Title.
>
> Table 1 defined as:
> Name;varchar(60)
> Title;varchar(60)
> Year;varchar(4)
> Other;varchar(30)
> Other2;varchar(
I have 2 tables with a common field of Title.
Table 1 defined as:
Name;varchar(60)
Title;varchar(60)
Year;varchar(4)
Other;varchar(30)
Other2;varchar(30)
act_no;int(8) unsigned zerofill
Table 2 defined as:
MM;varchar(4)
Title;varchar(48)
Archive;varchar(4)
record_num;int(8) unsigned zerofill
I
I get the subject error when running the static or semi-static linux builds on
Mandrake 7.2. My database is working fine and I am able to use another client,
KMySQLAdmin, without problems.
Cal
__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you
I have been getting this error quite a bit, and
keep losing my access to the database from my
persistent connection, it seems... any idea where
I should be looking to solve the problem?
Mysql 3.23.34 on Solaris 2.7
Error is:
010315 10:41:55 Aborted connection 27 to db: 'events' user: 'webde
Does MySQL allow either user or group quotas to be enforced per
database?
Thanks,
Jose
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
I downloaded the 34a version (if the RedHat SRPM on the MySQL site is also
34a). I will use the file you gave me and it should compile and link now.
Thanks,
Rick
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 1:12 PM
To: Mehalick, Richar
Hi,
While searching the net I came across some perl to get enum values from
a table column, but I can't get it to work due to my lack of
understanding of what is going on, I am not even sure I have read the
data correctly.
my $sth = $dbh->prepare("SELECT $column FROM $sqlTable");
$sth
- Original Message -
From: walkiriocosta
To: Sérgio floripa
Cc: adrianovarig ; berg ; beto
; emilson ; fenix ; jacira ; junior ; marcelao ; vagno ; zeus
Sent: Sunday, March 11, 2001 6:43 PM
Subject: En:Fw: [BQ75] Fwd: Re: LER COM URGÊNCIA (fwd)
E-mail grátis BOL com antivírus! Fa
So sprach Tõnu Samuel am Thu, Mar 15, 2001 at 09:01:58PM +0200:
> Sunrise wrote:
> > Mysql has the type as the MSSQL BIT???
>
> Yes and this is documented in manual.
Hi Tõnu (geez, "strange" name you have - can't even paste it :])
Well, since you understood that question of sunrise - could you
Rick,
have you downloaded version 3.23.34 and not 3.23.34a?
I downloaded 3.23.34a, untarred it, and mem0dbg.c was in innobase/mem
directory.
I have attached to this email a copy of mem0dbg.c.
Are your Makefile's such that they did not build all the
object files and libraries needed for linking
For some reason I cannot figure, mysqld is now leaving loads
of SQL.ISD/ISM files in /tmp/ .. perhaps 10 a minute..
there are no errors reported in the mysqld log file, other
than one or two connection aborted every hour.
the files are all owned by root, group root.
/tmp is rwx word with t bi
Sunrise wrote:
>
> Hi, alexander.skwar,
>
> Mysql has the type as the MSSQL BIT???
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
Yes and this is documented in manual.
--
MySQL Development Team
Please see my comments below.
>Do you mean that when you compile, on the compiler line >there is not the
>flag -I../include?
No, not really. I mean in the dependencies for a target.
>If the flag is missing, there obviously is something >wrong with our
Makefile.am's or configure.in's. You >prob
I seem to remember that Microsoft SQL Server has the concept of a "covered index" that
worked something like this:
Suppose you have a table with a product_category, and a price. You query alot on
product_category, so you create an index on it. You're expression might look like
this:
select
MySQLGui is a good option in graphical mode, there are other command line
clients too
At 19.40 14/3/01 +0100, you wrote:
>can I manage mysql server 3.23 on red hat linux 6.1 using a win32 client on
>win nt ?
>thank you in advance.
>regards.
>
>Andrea GIGLIOTTI
>
>G&B Net S.n.c.
>Via Bagni Caldi,
Friends.
people out in here are very afraid , when they hear Mysql does not support foreign
keys.
It really become difficult , why foreign keys are not enforced by mysql.
Anyways, can u please tell me does our favourite database support composite primary
keys as in Acess databse key...?
U se
Hi,
I have to mananage a very big table (about 20 Go)
A database correspond to a directory.
A table correspond to a file.
Is it possible to distribute the table on several physical partition (like
with Oracle that can use several table space to store one table) ?
Thanks,
--
Pascal Thivent
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
Cold Fusion 4.5 Server is a hog. If you can run that you probably have
enough memory for MySQL. I would not run them simultaneously with less
than 384 MB ram.
Charles Hagen
On Thu, 15 Mar 2001, Chris Peterson wrote:
> I cant seem to find system requirements anywhere for MySQL, even inside the
I never found an answer. I plan to write a PHP page to help automate this, and
expect to have it done soon, time permitting.
--Jason Bell
Yurais Fernández Leal wrote:
> Does someone has an answer for this already done question ??
>
> - Original Message -
> From: "Jason Bell" <[EMAIL PRO
Does anybody know if this amount of memory usage is normal? (taken from *top*)
PID USER PRI NI SIZE SWAP RSS SHARE LC STAT %CPU %MEM TIME COMMAND
677 root 90 19228 0 18M 15801S 0.0
2.1 0:07 mysqld
679 root 9
I cant seem to find system requirements anywhere for MySQL, even inside the hundreds
of pages of the manual... I wish to run the latest stable release on MySQL on a
Windows NT Workstation PC, and will also use this PC to run ColdFusion Professional
4.5 server. Where could I find recommended
join
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PRO
Hi,
I would like to tune the performance of my database.
The database is rather small about 80 MB altogether. (with 20 Mb indexes)
The most complex selections open 32 tables at ones.
The database is mostly readonly (99%).
What settings show I use to maximize the speed of the queries?
What would
I encountered a few problems with the genuine 1.7.8-1 binary RPM for
mysql++.
- If I compile:
Connection con("temp","localhost","root","temp",3306,0,60,1,"",0);
The linker complains: undefined reference to `MysqlConnection::MysqlConnection(char
const *, char const *, char const *, char con
Is like that much faster than =? If so, this would be a good thing to know. I'm
assuming that not putting a % either before or after the variable would make it the
equivilent of an =.
Can you possibly point me somewhere that explains this a bit or possibly gives some
kind of benchmarks?
Tha
Does someone has an answer for this already done question ??
- Original Message -
From: "Jason Bell" <[EMAIL PROTECTED]>
To: "mysql list" <[EMAIL PROTECTED]>
Sent: Friday, March 09, 2001 5:58 PM
Subject: Postgres to MySQL Migration
> Anyone know an easy way to migrate a Database from P
I'm having a problem with REGEXP :
I have several rows that look like this :
Health : health services : safety : physical abuse : women
Health : health services : safety : rescue
Health : health services : safety : sexual abuse
Health : health services : safety : sexual abuse : children
Health :
Pawan Kanda wrote:
>
> Hi , i have the following method:
>
> public Object getValueAt(int row, int column){
> // in here i want to construct a SQL query which gives the object at a
> certain
> row and column
> }
>
> Do you know how to do it?
>
> Thanks
> Pawan
>
Maybe make your sql statemen
I see. I added the timestamp field (I never knew there was a field type
of timestamp), relinked the table in Access 2000 and the darn thing
actually worked! Did this just become a requirement in MySQL 3.23? As I
mentioned in a previous post, the timestamp field was not required when I
was w
>Description:
Performing a "mysqldump --all-databases --opt" produces invalid
SQL for the "db" table i.e.:
KEY User(User)
Attempting to rebuild tables with the mysql client using this SQL fails
with a syntax error.
If the SQL is modified to:
KEY User (User)
then the mysql
Hi everyone,
Could any one tell me what is the search engine you always use? Thank.
Calvin
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Anyone know of a Source control system implemented in MySQL?
C. Duncan Hudson
Dynax Solutions, Inc.
Tel 216.292.8203
FAX 216.292.8273
EMail [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/man
In the last episode (Mar 15), Mark Dombeck, Ph.D. said:
> All,
>
> >I've got a quick question - In section 7.11 of the manual on
> >Optimize_Table it states that the table is "locked" during
> >optimization. It does not state however, if this is a
> >read-lock, a write-lock or both. Can you cla
Okay, the Access 97 vs. Access 2000 might have something to do with my
particular problem now. I will check it using Access 97 later today. I
know for a fact, however, that when I first found this problem, I was
using Access 97 and the only thing that I changed was the MySQL version.
I supp
Hi , i have the following method:
public Object getValueAt(int row, int column){
// in here i want to construct a SQL query which gives the object at a
certain
row and column
}
Do you know how to do it?
Thanks
Pawan
-
Befor
Hi
I am using Resin1.2.3 engine to run my servlet and
mysql database with mysql-jdbc driver to connect my
servlet with database but it gives me null pointer
exception when I run my servlet
500 servlet exception
java.lang.NullPointerException
I hope many of you might have face t
All,
>I've got a quick question - In section 7.11 of the manual on
>Optimize_Table it states that the table is "locked" during
>optimization. It does not state however, if this is a
>read-lock, a write-lock or both. Can you clarify?
>
>Thanks
Since I'm not a member of this list, could any
resp
> I want to ask you :
> 1- How many rows does a mysql table can hold?
> 2- I have to design a database for all universities of my country , Is it
> better to consider one database for each university or one database for
all
> universities . Note that a query on a table "student" would be more qui
Hi Mario,
I think I had the same problem as you, and got som help...
You have three ways of doing this:
1. Switch to a FileSystem that supports bigger Files
2. Use MERGE, create a lot of small tables and use MERGE
in you select Querys, The manual is quit god at explaining
how to do this, but I'll
Dear Sir :
MySQL 3.22.32 on my linux 486 PC seems work so good. When I compile
a simple C API program which catched from MySQL tutorial, it
chokes at the end of compile process . The program is as follows:
#include
#include
#define def_host_name NULL
#define def_user_name NULL
#define def_pa
Yes, there are a couple of methods such as mysqlimport. Please read the
manual for the others.
- Original Message -
From: "WANG_KING£¨Íõ¸Ö£©" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 10:30
Subject: Data tool
> I want to load data to mysql.
>
> Does mys
Hi
I have a long-running select that's basicly just summing a couple of columns
in a 1-2GB big table.
It lasts for 5-10 hours and I notice that the disc activity is *very* high:
vmstat 1 says:
5 0 0 30332 3068 5240 129260 0 0 10260 658 498 63 35 3
4 0 0 30332 3192 5244 129132
Peter,
could you ftp your binary (compiled with -g option) to
support.mysql.com directory /pub/mysql/Incoming
I can then try to run the ATIS test on your binary on our SMP Linux.
One possible reason for the errors you get is that your version
of GCC is buggy in inlining of code, but that is only
Rick,
>I tried to build from source the latest MySQL 3.23.34a and I found the
>following problems:
>
>1) The Makefile in the 'pars' and 'mem' directory have missing ../include/
>paths on some dependencies.
Do you mean that when you compile, on the compiler line there is not the
flag -I../include
>
>
>
>
> And I've filled this with a bit of data. Well, more than a bit - 5,791,651 rows
>actually. Still, while this is large, it doesn't seem rediculously huge.
>
> Let's say I want to perform a query
Hello,
i´m trying to connect to mysql server from php but i can´t do it.
i created the databases successfully!!
i put :
Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (111) in
/var/www/html/juan/index.php
what happend? all look
No, it should not be.
Eric Morgan wrote:
>
> Yes, The prefix path I used below is the path to the source
> distribution. Should it not be?
>
> Eric
>
> Mohamad Ilhami wrote:
> >
> > On Wed, 14 Mar 2001, Eric Morgan wrote:
> >
> > > I configured and compiled mysql-3.23.34a without even a warni
Did you read chapter 6 in the manual?
denis mettler wrote:
>
> Hi there,
>
> i received the following message:
>
> [TCX][MyODBC] Host 'XYZ' is not allowed to connect to this MySQL Server
> (#1130)
>
> any ideas
>
> regards
> denis
>
>
You did not tell us what hardware and MySQL version you are using.
There is no Linux 7.
If you are refering to RedHat Linux Version 7.0, and you installed the
mysql found on the CD, then you have 3 choices.
1. chown -R mysql /var/lib/mysql
If the mysql data directories are not in /var/lib/my
>Description:
Compiling Mysql for aix. I receive an error saying char size is 0, I noticed
that another file is looked up and it is not present. "conftestval"
>How-To-Repeat:
I have set my c compiler and c++ compiler to gcc, then entered the following,
you shou
I am porting my accounting app. from Foxpro for DOS to
linux->perl->MySQL. I don't want to completely reinvent the wheel. I
am sure many a program has been written to do book keeping ( debit cash,
credit revenue, etc. ) Does any one know where I can get an idea about
how to code it and table de
On Fri, Mar 16, 2001 at 12:32:37AM +1030, Dan Makovec wrote:
> Hi all,
>
> I'm having problems getting reasonable speed queries from a simple table.
>
...
> I've created a simple table that contains stock exchange data, as follows:
>
> CREATE TABLE shares (
> date date DEFAULT '-00-00' NO
Yes, make sure you shutdown the server before running isamchk.
mohamed Abd El-Samei Mohamed wrote:
>
> Thanks for help .,
> I tried it but also got the same error
>
> any other advice
>
> "Gerald L. Clark" wrote:
> >
> > Run isamchk on your tables.
> >
> > mohamed Abd El-Samei Mohamed wrote:
>
hi
i am installing My Sql on Linux 7
i was trying it for the whole day..the only problem i
am facing since morning is that..
the SQL server starts during the booting of system
when i go in bin and give mysqladmin command it gives
error - Can't connect to server..
either the server is not running o
Hi!
> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello Heikki,
Peter> Finally I was able to check the innobase tables included into mysql
Peter> 3.23.34. Well first several times I was quite happy about them, but
Peter> later understud that this is because option --c
I had two questions about table design and format.
I'm designing an application that has two tables.
The first table will have
-Many selects that return about 20 results on average.
-Few inserts
-Very few UPDATEs
For this table it is not important that the newest inserts show up in selects
im
Hi all,
I'm having problems getting reasonable speed
queries from a simple table.
First, a little info about my server
setup:
From mysqladmin version:
mysqladmin Ver 7.11 Distrib 3.22.27, for
-free
I failed to mention that I used the RedHat Source RPM and I am using RedHat
6.2.
Rick
-Original Message-
From: Mehalick, Richard RE SSI-GRAX
Sent: Thursday, March 15, 2001 6:10 AM
To: 'Heikki Tuuri'
Cc: '[EMAIL PROTECTED]'
Subject: Innobase compile problems
Hi,
I tried to build from
I have been told you offer a service to convert ASP scripts that connect to
an access database to a mySQL database.
If this is the case could you send me the URL of this resource.
Many Thanks
Paris.
--
Paris Val Baker
E-mai
Hi,
I have a table:
CREATE TABLE http_refer(
rid int unsigned auto_increment,
refer varchar(255),
unique index(rid),
unique index(refer)
);
It is filled with referrers from our webserver log and has 4138 rows.
Today I've tried to execute:
mysql> select ma
1 - 100 of 130 matches
Mail list logo
