MYSQL
I am trying to create tables that will be used in merge definition. The
merge seems to be very strict in the definition of like tables. So I tried
to use the "create table y select * from x;" but it does not create the
indexes in the new table. I did copy the x.frm to y.frm and all s
I got into trouble the other day trying to delete gobs of rows. Actually
I was selecting 90% of the rows from table1 and inserting them into a
table2, then deleting from table1. It was way too slow! So I stopped all
activity (inserts) from table1 and flipped table1 with table2 using rename
st
I frequently get a error 127 on merged tables. The query is a join of two
merged table with each merge table have 4 base tables. If I flush tables
the query works. I notice that when have about 190 tables in memory this
situation is more likely to happen. I am using 3.23.32.
Using 3.32.35,
At 11:05 AM 3/2/01 -0500, you wrote:
>On Thu, Mar 01, 2001 at 10:58:03AM -0500, [EMAIL PROTECTED] wrote:
>> HI, I sent this note a couple days ago and no one has commented. I am
>> trying to implement DBI-1.14.tar.gz Data-ShowTable-3.3.tar.gz
>> Msql-Mysql-modules-1.2215.tar.gz . The first
HI, I sent this note a couple days ago and no one has commented. I am
trying to implement DBI-1.14.tar.gz Data-ShowTable-3.3.tar.gz
Msql-Mysql-modules-1.2215.tar.gz . The first two packages completed
successfully byt the Mysql-modules failed druing the 'make test' step.I
am using mysql ve
I have almost installed all of the dbi/dbm modules but can't get thru the
'make test'. I get the error msg:
't/10dsnlist.DBI->connect(database=test) failed: Can't connect to
local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) at
t/10dsnlist.t line 45'
MySql is ruuning bu
From: Liu Danyu
Date: Thu, 18 Jan 2001 18:08:37 +0800
I would do the query as
select maker, pc.id
from table1
where pc.id > 2
order by maker;
dear all:
I need some help from you.
The dataset is as follo
From: Subba Reddy M
Date: Fri, 26 Jan 2001 14:52:29 +0530
Hello MySQL guru,
Please advise me,
on creating new table with existing table structure.
I have tried, how MySQL documentation referred, but unable to get success.
create table newtable select * from oldtable;
This works on 3.23.x
I am trying to bring up my third mysql server. This one is
MySQL-3.23.32-1.i386.rpm..rpm on a redhat 6.2 base. I was successful in
installing both the server and the host. Look around and every thing
looked cool! Piece of Cake! Then I decided to set up the mysqladmin user
and setup privelidge
