Hi,
I believe that the query below is correct, but I do not believe that it is
possible in MySQL currently due to it not supporting sub-selects:
UPDATE table1 SET ID=table2.ID, Company=table2.Company,
Modified=table2.Modified FROM table1 INNER JOIN table2 ON
table1.Company=table2.Company
Hi!
Something like
CREATE TABLE CAMELON (A INT NOT NULL AUTO_INCREMENT, B CHAR (5),
PRIMARY KEY (A)) TYPE = INNODB;
Regards,
Heikki
http://www.innodb.com
At 02:01 PM 9/18/01 +0900, you wrote:
Hi, Heikki.
Thanks for the info.
I understand your first explanation, I'll
You might be able to do a few select * from mubo_boekhoud_boekhoud where
queries to be able to dump out most of the data in the table. Then you
can drop and recreate the table and import the data.
It's worth a try anyway.
Terje K
-Opprinnelig melding-
Fra: David Bouw
Hello mysql,
Hello mysql,
I'm quite lucky with providing with bad tables which does not repear
properly or having other strange behavior.
Here is one more:
mysql 3.23.42
gnome:~ # mysqldump -d layers_st57 g01kw_engines
# MySQL dump 8.16
#
# Host: localhostDatabase: layers_st57
Hi,
I'm trying to install MySQL into my Mac OS X 10.0.4
But i encountered problems halfway through the installation. I created a new
netinfo directory mysql. After 'gunzip' and changed into the top-level
directory, the './configure --prefix=/usr/local/mysql doesn't seem to
workand there's no
Rock,
Hi,
Does MySql support Synchronous or asynchronous I/O or
both?
What do they mean when they ask me if-
copy Db is supported by mysql?
I am not sure what this means. MySQL has replication
capability yes.
version db is supported by mysql?
The meaning is not clear. The InnoDB table
latest rpm on redhat
MySQL-3.23.42-1.i386.rpm
any ideas? i've installed and compile mysql on other machines before and
never had any problems (appart from sock file which was easily solved).
-powlow
- Original Message -
From: Sasha Pachev [EMAIL PROTECTED]
To: powlow [EMAIL PROTECTED];
I encounter this error using mysql and php (well, not I'm using mysql,
its a hosted server (not dedicated), so maybe just the disks are full or
so... has anyone another explanation?
little urgent, site is down (nobody changed the code, it just stop
functioning - maybe there have been new entries
hi!
i am rather new to mysql and i have problems with a multiple select
statement.
i have a search form where the user can choose 4 conditions, when all 4
conditions are chosen i get a result but when the user just chooses 1,2 or 3
conditions i get a mysql error...
does anyone know a
Hi,
I'm a beginner with MySql. Could anyone give me an example how transaction
isolation works on InnoDB tables under Win2000? (If you have any examples
I'll be happy). Thanks in advance.
Adi
-
Before posting, please check:
Post your query
- Original Message -
From: Michael Paffrath [EMAIL PROTECTED]
To: MySql [EMAIL PROTECTED]
Sent: Tuesday, September 18, 2001 12:10
Subject: multiple select
hi!
i am rather new to mysql and i have problems with a multiple select
statement.
i have a search form where the
am 18.09.2001 12:30 Uhr schrieb Chris unter [EMAIL PROTECTED]:
Post your query
SELECT * from tipps AND name LIKE '%$name%' AND stadt = '$stadt' AND kueche
= '$kueche' ORDER by $order ASC LIMIT $start, $limit
Michael Paffrath
fatmedia - agentur für interaktive medien
Schillerstraße 6
50968
If this is your query, you might have a problem at the first 'AND' :
SELECT * from tipps AND name LIKE '%$name%' AND stadt = '$stadt' AND kueche=
'$kueche' ORDER by $order ASC LIMIT $start, $limit
should be:
SELECT * from tipps WHERE name LIKE '%$name%' AND stadt = '$stadt' AND
kueche=
SELECT * from tipps
WHERE (name like '%name%' OR '$name' = '')
AND (stadt = '$stadt' OR '$stadt' = '')
AND (kueche = '$kueche' OR '$kueche' = '')
ORDER by $order ASC LIMIT $start, $limit
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 18 september 2001 13:05
To:
Hi everyone.
I'm trying to do the following update, which someone at Macromedia gave me,
however I get a SQL error when I'm trying to use it with MySQL, any ideas on
what is wrong.
update general_users
set rolling_total = sumUsr.rollingTotal
from
(
select
On Tuesday 18 September 2001 03:16, powlow wrote:
latest rpm on redhat
MySQL-3.23.42-1.i386.rpm
any ideas? i've installed and compile mysql on other machines before and
never had any problems (appart from sock file which was easily solved).
Provide the output of mysqlbug...
Also, what
The only think I did was copy 'my-medium.cnf' to 'my.cnf' and ran
mysql_install_db (successfully) and then ran mysqld as instructed which
didn't run successfuly and reported the errors below. I didn't change
anything in my.cnf, I didn't touch anything at all...
Is there a way that I can start
I've changed root's password via netscape with phpmyadmin and then
reloaded.
It's not possible to connect anymore. The system asked for a new
password but didn't accept the new one.
So, I've tryed to re-install mysql again
version : MySQL-3.23.38-1.i386.rpm on redhat Linux.
Now, when I try to
Hi!
I would like to know how to sort strings in MySQL according to the
national charakter set in Windows (CZECH). I have read about it on
other platforms - compiling issues, but could not get the right help
for me.
Thanks a lot !!!
Jan
database,sql,query,table
I had a similar problem on a win2k system when I started using mySQL. I
changed the user and password in phpmyadmin's config.inc.php. Or you can
change it in the my.ini file.
This might be alot more complicated with a unix system.
- Original Message -
From: GUYOT Carole [EMAIL
Hi Dean,
Thanks for the reply...
I indeed also thought of the mistake that I reversed the parameters...
Though I must say that all the other tables in the directory (luckily) still worked..
But reading your words it looks to me as if not a easy (unpossible) table to repair..
This really was
Description:
I just moved all of our mysql files over from a machine Running
Solaris 8 to a machine running Linux Redhat. I then installed the latest
version of mysql. For some reason, I get an error when trying to access
any table that is of the ISM format. I can've even convert
mySQl-to-Access 1.1 works great but it's not free. The trial version only
converts 5 records.
It's at http://www.convert-in.com/demos/sql2accd.exe
Chris
- Original Message -
From: Troy Montour [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 17, 2001 22:56
Subject:
On Tuesday 18 September 2001 14:14, Andrew Dixon wrote:
Hi everyone.
I'm trying to do the following update, which someone at Macromedia gave me,
however I get a SQL error when I'm trying to use it with MySQL, any ideas
on what is wrong.
A general lack of support in MySQL for this kind of
Mark Johnson [EMAIL PROTECTED] writes:
I must be a moron but I can't seem to figure out what I need to do to get
mysql to work on RH, on Mandrake it just worked straight away.
chown -R mysql.mysql /var/lib/mysql; chmod a+rX /var/lib/mysql
An errata was issued when RHL 7 was release, and more
Greetings,
We have an oracle database that we would like to explore using it as a
master database in order to replicate it's data into, in real or near
real time (like MySQL's replication), a set of MySQL servers.
We need only one way replication (oracle - MySQL), but the replication
needs
Hello,
May I use a query like this?
DELETE FROM b WHERE id NOT IN (SELECT id FROM a)
What can I do for make it?
--
Best regards,
Lyubomir mailto:[EMAIL PROTECTED]
-
Before posting, please check:
Hi!
On Sep 18, [EMAIL PROTECTED] wrote:
Description:
I just moved all of our mysql files over from a machine Running
Solaris 8 to a machine running Linux Redhat. I then installed the latest
version of mysql. For some reason, I get an error when trying to access
any table that is
Description:
Odd numbers round properly at the half (3.5) but even numbers don't (4.5).
How-To-Repeat:
mysql select round(15.5);
+-+
| round(15.5) |
+-+
| 16 |
+-+
1 row in set (0.01 sec)
mysql select round(16.5);
+-+
| round(16.5) |
What logs will a oracle database output?
If these logs can be feed in to MySQL in the way replication works you are
sorted.
But I do not know much about oracle.
The only thing is MySQL will no do some of the stuff that Oracle will so
some thing mike fail.
Simon
-Original Message-
Some thing like this mite work?
delete from b
where id.a != id.b;
Simon
-Original Message-
From: Lyubomir Simich [mailto:[EMAIL PROTECTED]]
Sent: 18 September 2001 16:15
To: [EMAIL PROTECTED]
Subject: need query
Hello,
May I use a query like this?
DELETE FROM b WHERE id NOT IN
Can MySQL client be built from source using the Sun Forte compiler (i.e.
/usr/SUNWspro/bin/cc)?
If so, then what are the proper ./configure settings (in addition to
--without-server) for using this compiler?
Calling ./configure --without-server succeeds with /usr/SUNWspro/bin as my
default
Troy,
If you cannot connect to it, how do you use?
Christopher Reed
Application Analyst
Information Technology
City of Lubbock
[EMAIL PROTECTED]
Troy Montour [EMAIL PROTECTED] 8:40:52 AM 9/18/2001
Christopher,
no this won't work for me because the hoster has it set-up weird that I
can't
Peter Zaitsev wrote:
I'm quite lucky with providing with bad tables which does not repear
properly or having other strange behavior.
Sometimes when myisamchk does not work (or it says it has repaired the table
but it quickly become corrupted again), I find that dumping and reloading
the
Try this:
SELECT *
INTO OUTFILE 'mytable.txt' FIELDS DELIMITED BY '\t' LINES DELIMITED BY
'\r\n'
FROM mytable;
Then, in Access, use the Import wizard and specify tabs as your field
delimiter and set your field qualifier to none (defaults to double-quote).
Optionally, you could prepend the text
I try the following command, and get that error every time:
mysql select company, tele, contact, mariacust.comments
- from
- customers where tele = mariacust.tele GROUP BY company;
ERROR 1109: Unknown table 'mariacust' in field list
mysql
And yes... the talbe exists.
mysql show
Mariacust must be included in you FROM list:
SELECT ...
FROM customers, mariacust
WHERE ...
-Original Message-
From: Armando Cerna [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 18, 2001 12:16 PM
To: [EMAIL
I have a problem with MyODBC trying to connect to MySQL from Access 2000 on
Windows 2000 pro via dialup connection.
On my work machine everything is OK, I'm running WindowsNT 4.0, Access 2000
and have a permanent Internet connection. Connection to MySQL situated at
some Internet provider server
Valentin Kulikov wrote:
while:I have set 'myname' as a user name. Somebody (MyODBC? Windows2000?)
added a suffix '@mydialup-provider.com' to my db user name.
Or maybe a problem is in something else and a diagnostic is incorrect?
Unless you connect to MySQL via a unix socket, the hostname of
I try the following command, and get that error every time:
mysql select company, tele, contact, mariacust.comments
- from
- customers where tele = mariacust.tele GROUP BY company;
ERROR 1109: Unknown table 'mariacust' in field list
mysql
I don't quite understand why this
Hi,
Odd numbers round properly at the half (3.5) but even numbers
don't (4.5).
This sounds like you're misunderstanding an intentional feature. A lot of
applications or system libraries do this to avoid giving 'incorrect' figures
when summing large amounts of rounded numbers.
Here's an
Hi!
Hi,I'm a beginner with MySql. Could anyone give me an example how transaction
isolation works on InnoDB tables under Win2000? (If you have any examples
I'll be happy). Thanks in advance.
Adi
Below is pasted an example from the InnoDB
manual at http://www.innodb.com/ibman.html
When you
Thanks so much to everyone who replied I got it working perfectly you guys
rule!
Armando
On Tuesday 18 September 2001 09:56 am, you wrote:
I try the following command, and get that error every time:
mysql select company, tele, contact, mariacust.comments
- from
- customers
Hi all, this is my first question on this list and I hope that you can
help me. I've got one dedicated box for MySQL and it's going downhill just
by starting the DB. The box is a dual PIII 800Mhz, 1 Ghz RAM, Linux RedHat
6.2 w/ kernel 2.4.6SMP, SCSI Drives and plugged to a 100Mb internal
First, there is no need to reinstall.
For future reference, if you forget your password - check the manual for an
easy way to fix: http://www.mysql.com/doc/R/e/Resetting_permissions.html
For a mysql that wont start, check the error log and isolate what the
problem is ( it probably isnt that
I'm sorry. When did it start supporting raw disk devices? As
far back as I can remember, MySQL stores it's data files on an
existing filesystem, in 3 separate files: .frm, .MYI, .MYD.
Ah, InnoDB apparently supports raw disk files. I suppose I
should have said that the NATIVE MySQL backend
Chase == Chase Peeler [EMAIL PROTECTED] writes:
There is alot of important info in those tables, and I really need
them.
Sorry to broadcast this to the whole list, but Chase's supplied email
appears to be invalid, or at least bouncing at the moment:
Chase, I'm in the NCBI part of NLM, and
I ve installed on my slackware 8.0 mysql + php 4.0.6
I can connect mysql server on line command, but
with the command connect in php, every time I try
to connect, I recieve this message ( example)
Warning: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2) in
There are some others with a similar problem(including me). The question
still remain,
if it is all caused by the same bug(?).
What table-types do you use? (MyISAM,Merge,BDB,...)
How many entries are in the tables?
How many queries/second?
Do the queries use indices?
Hi all, this is my first
I have posted before regarding a problem with mysql 3.23.41 hitting some
sort of threshold limit and spawing threads like crazy. I have seen
others post here with the exact symptoms, from what I understand these
are all linux boxen. I have personally tested it with the 2.4 series of
kernels, and
From: Stefan Pinkert [EMAIL PROTECTED]
There are some others with a similar problem(including me).
Hi guys. I'd be really interested in knowing things like how many requests, and of
what type, are being made of your database(s). If you're making a couple of dozen
SELECTs per day, then I'd
Agreed. Definitely odd that it doesnt behave exactly as documented, but it
does provide (9,2) precision, non? The fact that you can squeeze (10,2) into
the column in certain cases doesnt bother me.
Of course, if you came up with a patch to fix it, I dont think anyone would
complain.
dpk
-
There are some others with a similar problem(including me). The question
still remain,
if it is all caused by the same bug(?).
What table-types do you use? (MyISAM,Merge,BDB,...)
MyISAM
How many entries are in the tables?
Up to 145000 in some of the tables. But its not the usual
The quickest way to get this in front of developers is to provide a
reproducible test case. I know they like to use the new mysql-test stuff,
but its not heavily documented, so bash scripts or perl scripts are probably
fine too. This may also help other people confirm the problems that you are
The problem is that a number that is in the
MySQL database might be a magnitude of 10 times larger than a number that
is
in the PostgreSQL database.
Could you explain this?
dpk
-
Before posting, please check:
I am having a similar sort of problem, 88k+ records (syslog entrys) doing a
select * from db group by host takes 2.5seconds select * where with a host
with 87k records takes 5.7seconds. CPU useage jumps up to to between 10 and
99.9% With a single proc linux box the exact same happened but with
if you chmod a directory to 666, it will not be searchable.
robirossi wrote:
I ve installed on my slackware 8.0 mysql + php 4.0.6
I can connect mysql server on line command, but
with the command connect in php, every time I try
to connect, I recieve this message ( example)
Warning:
(to answer a couple of posts at once):
Our machine was seeing less than 20 connects / sec. The problems
continued after we broke largeish (although only about 350,000 records,
indexed) tables into smaller ones and verified/optimized all code that
makes mysql queries. We have a good mix of
I assume you've done the slow-query-log review thing... making sure all your
queries are fast, yes?
dpk
- Original Message -
From: [EMAIL PROTECTED]
To: Stefan Pinkert [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, September 18, 2001 11:22 AM
Subject: Re: AW: MySQL is hogging my
China Financial Guide 2002 has been published!
China has emerged as the most important market in Asia. The attractiveness of China
market is further enhanced with China joining the World Trade Organization. No
organization can afford to ignore this important market in Asia. The vast and
I'm thinking of switching to InnoDB, however - my application does a few
COUNT(*) WHERE queries on large tables (somewhere between 50K
and 2M rows)
I've read up on InnoDB and its issues with COUNT(*) on entire tables,
but is there
a reason to assume that InnoDB is also slower when
Hi.
I'm running mysql on NT. when I start it via mysqld everything works.
when I try to do:
mysqld --log-update,
I'm getting message can't initialize innodb as 'innodb_data_file_path' is not
set. I didn't see anything about innodb being related to log-update option
in the manual or MySQL
Basically mysql doesn't let you use data from one table in updating another
table. If you look at the update syntax at
http://www.mysql.com/doc/U/P/UPDATE.html you'll notice the lack of a very
much needed FROM option.
later,
mike
At 01:14 PM 9/18/2001 +0100, you wrote:
Hi everyone.
I'm
Hi,
I'm using Data environment (Visual Basic) and MyOdbc to make a connection to
Mysql database. Every time my program establishes a connection using Data
environment, the MyOdbc property window pops up. This dialog does not appear
if connection is established using ADODB.
So, firstly, is there
We've recently converted from MyISAM to BDB tables (transactions are
required and BDB is what was available), and have worked through all of
our problems except this one. Every so often (up to twice per day) mysql
decides to fill up gigs of space by writing out a seemingly endless
stream of 10MB
Hi!
I have no idea. log-update has nothing to do with InnoDB.
Try adding
skip-innodb
to your my.ini or my.cnf.
Regards,
Heikki
http://www.innodb.com
Hi.
I'm running mysql on NT. when I start it via mysqld everything works.
when I try to do:mysqld --log-update,
I'm getting message can't
Run the RPM's Binaries provided by MySQL and all will work correctly.
There is something MySQL is doing in the RPM's that there not telling us
Source users.
Michael McConnell
- Original Message -
From: djinn [EMAIL PROTECTED]
To: Rodney Broom [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sander,
I'm thinking of switching to InnoDB, however - my application does a few
COUNT(*) WHERE queries on large tables (somewhere between 50K
and 2M rows)
I've read up on InnoDB and its issues with COUNT(*) on entire tables,
but is there a reason to assume that InnoDB is also slower
Hi !
)-Original Message-
)From: Mikko Lampinen [mailto:[EMAIL PROTECTED]]
)Sent: Tuesday, September 18, 2001 12:33 PM
)To: [EMAIL PROTECTED]
)Subject: MyODBC properties window / VB data environment / ADODB
)
)
)Hi,
)
)I'm using Data environment (Visual Basic) and MyOdbc to make a
I believe the MyISAM format is so fast on simple SELECT count(*) FROM table;
because it actually keeps the current number of rows as a table statistic -
so it doesnt have to look at the data at all. Using a WHERE clause, however,
will force MyISAM to actually select all the rows and count how
I am getting a
Warning: Supplied argument is not a valid MySQL result resource in
/usr/home/tsguide/html/ssi/phpfunctions.php on line 48
No results were found ...
Pointers please.
--
contact:
Dave Yadallee NetLine 2000 The Edmonton Internet Service Company
[EMAIL PROTECTED]
What is the command in MySQL to grab the last item that was inserted into
the database?
thanks...
jay
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
On Tue, Sep 18, 2001 at 10:12:25AM -0500, Jeff Adams wrote:
Greetings,
We have an oracle database that we would like to explore using it as
a master database in order to replicate it's data into, in real or
near real time (like MySQL's replication), a set of MySQL servers.
We need only
On 9/18/01 11:25 AM, Dana Powers at [EMAIL PROTECTED] wrote:
The problem is that a number that is in the
MySQL database might be a magnitude of 10 times larger than a number that
is
in the PostgreSQL database.
Could you explain this?
dpk
Dear Monty and all,
In my application, on an SGI IRIX 6.5, I need to compile a program
which uses MySQL API to connect to our MySQL server. I need the -64
option to complie
my program since the lib I use are all compiled with that option. So I
need to
compile the MySQL client with '-64'
And my question is, if you've defined your column to have (10,2) precision,
why would you try to insert a higher precision number?
dpk
- Original Message -
From: Jim Dickenson [EMAIL PROTECTED]
To: Dana Powers [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, September 18, 2001 1:35
Try the PHP list, This is not a MySQL error.
System Administrator a.k.a. The Root of the Problem wrote:
I am getting a
Warning: Supplied argument is not a valid MySQL result resource in
/usr/home/tsguide/html/ssi/phpfunctions.php on line 48
No results were found ...
Pointers
Hi,
I'm getting this error with Mysql when trying to connect using a TCP
connection (not localhost connection):
ERROR 2013: Lost connection to MySQL server during query
This only happens on our Solaris Intel boxes. Our installations on
Solaris Sparc work fine. Also, if we downgrade to MySQL
I have deleted the Mysql 3.22.32 install and compiled
source for and installed Mysql 3.23.40.
The new installation resides at /usr/local/mysql.
Make Test did fail onlymerge
From the command line The daemon starts perfectly with either
mysql.server startor
safe
On 9/18/01 1:45 PM, Dana Powers at [EMAIL PROTECTED] wrote:
And my question is, if you've defined your column to have (10,2) precision,
why would you try to insert a higher precision number?
dpk
- Original Message -
From: Jim Dickenson [EMAIL PROTECTED]
To: Dana Powers [EMAIL
Head over to http://www.phpbuilder.com/forum/
There is an entire list there for just this problem.
Cheers
M;)
-Original Message-
FROM: Colin Faber
TO: System Administrator a.k.a. The Root of the Problem
CC: [EMAIL PROTECTED]
DATE: Tue 9/18/01 15:14
SUBJECT: Re: Error From Web Site
Hi!
Dana == Dana Powers [EMAIL PROTECTED] writes:
Dana Thanks for the reply! I can understand the situation with muti statement
Dana transactions, but I'm not using transactions ( at least from my
Dana perspective ); Im only issuing single 'atomic' statements. It would make
Dana much more
OBLIGATORY TOPIC REFERENCE TO BYPASS FILTER: mysql
Just a quick question regarding how (if at all) the binary update log
consumes resrouces.
Are there any potential performance issues or limitations to be
expected (other than excessive consumption of diskspace) if this log is
not
On Tue, Sep 18, 2001 at 01:45:30PM -0700, Dana Powers wrote:
And my question is, if you've defined your column to have (10,2) precision,
why would you try to insert a higher precision number?
Perhaps he's writing a report, and the application needs to know the
size of the data to expect. It's
In the course of using MySQL the following issue has come up a few times; I
am unaware of the solution for it, but I am sure one exists, since it seems
fairly elementary. It has to do with the COUNT(*) and GROUP BY functions.
Let's say I have clients, and clients buy items.
table clients:
I was running a mySQL server under slackware for a while, it was
interacting with php on an apache webserver, and everything worked fine.
There were a few times where I would mess linux up and need to
re-install,in which case I would move my database files to my windows
partition, re-install
Hi Raymond,
I have been having the same problem using the GROUP BY statement, even
without the COUNT(*) function.
I'm working with PHP and the way I got around this is to use arrays. I
retrieved all rows from the table and then sorted them into seperate arrays
according to, in your case,
At 7:40 PM -0400 9/18/01, Raymond Prisament wrote:
In the course of using MySQL the following issue has come up a few times; I
am unaware of the solution for it, but I am sure one exists, since it seems
fairly elementary. It has to do with the COUNT(*) and GROUP BY functions.
Let's say I have
How do I reset the auto-increment, I have a very large value in my table,
how can I reset it or make it use a number that isnt already used. The
value is so large now that it wont increment.
Thanks in advance
Dave
-
Before
At 03:30 PM 9/18/2001 -0500, Jay Paulson wrote:
What is the command in MySQL to grab the last item that was inserted into
the database?
i'm 99% sure there isn't one.
a sql table is an unordered set. there is no concept of first or last. in
theory you could get the same SELECT statement
At 3:30 PM -0500 9/18/01, Jay Paulson wrote:
What is the command in MySQL to grab the last item that was inserted into
the database?
thanks...
jay
If you mean the last record, there's no such command.
If you mean the most recent AUTO_INCREMENT value what was generated
during your current
At 2:27 PM -0600 9/18/01, System Administrator a.k.a. The Root of the
Problem wrote:
I am getting a
Warning: Supplied argument is not a valid MySQL result resource in
/usr/home/tsguide/html/ssi/phpfunctions.php on line 48
It means you didn't perform any error checking on the result of
your
You will not get 3.22 to recognize MyISAM format tables.
You need to either:
1. Upgrade your server to 3.23
or
2. Find a running 3.23 server, copy your table files to that server, ALTER
TABLE xxx TYPE=ISAM; on all your tables to convert back to older ISAM
format, and copy your table files
Search the manual, check the archives, blah blah blah. This question was
answered yesterday. See forwarded message below.
dpk
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Jay Fesco [EMAIL PROTECTED]; Paul Reilly [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Monday, September
How to install MySQLGUI under redhat 6.2 ?
rgds,
A. Ridwan Yulianto
IT Department
PT Tabitha Express
Taman Niaga Soewarna AL-3
Soekarno Hatta International Airport
Jakarta - Indonesia
Tel. (62-21) 559 0811,559 0911
Fax (62-21) 559 0821,559 0921
E-mail: [EMAIL PROTECTED]
Hi,
If I have a large table ( 70million rows, nearly 4 GB Index, 2.5G Data),
and I want to
ALTER TABLE mytable TYPE=MYISAM;
ALTER TABLE mytable change column col1 col1 tinyint unsigned not null;
ALTER TABLE mytable DROP INDEX index_1;
ALTER TABLE mytable ADD INDEX index_1(col2, col1);
I have a large set of tables that are 1-way replicating to an identical machine as the
master db, and for some reason 1 table doesn't make it into the binary log. Why would
updates to 1 specific table not make it into the binary log?
Thanks,
Gabe E. Nydick
On Wed, Sep 19, 2001 at 03:14:17PM +1200, Quentin Bennett wrote:
Hi,
If I have a large table ( 70million rows, nearly 4 GB Index, 2.5G Data),
and I want to
ALTER TABLE mytable TYPE=MYISAM;
ALTER TABLE mytable change column col1 col1 tinyint unsigned not null;
ALTER TABLE mytable
Hi,
just after a bit of advice on programming style
I have one main table which holds keys to records in other tables. There is also an
additional table that uses the main tables ID field as a key. I need to generate a
view that joins data from each of these tables. Should this be
99 matches
Mail list logo
