On Thu, 24 May 2001, Scott Baker wrote:
I don't agree.
If mysql install in other directory then /usr/local
you need use --with-mysql=mysqldir
and sometimes --with-mysql-include and --with-mysql-lib
options.
> Do you need to specify a directory? I just did --with-mysql
>
> At 01:14 PM 5/24/2001
I have a problem with opening the table in datbase. Server and
database are ok. Other tables opened normaly. This one, under
windows give an info "error 127 from table handler". How I can solve
this or at least how I can reach the data from the table?
Zdzislaw A. Kaleta
-
Hi,
System Specs:
SCO Openserver 5.0.6
MySQL 3.23.38
I have the following SQL Query (don't worry about the table aliasing)
SELECT
vdm1.model, vdm1.version, vdm1.date_ls_ro,
zdna1.code, zdna1.name, zdna1.title,
zdna1.phone_bus, zdna1.phone_home,
zdna1.pstl_adr_1, zdna1.pstl_adr_2
Hi, i am a win2k professional user,
and i would like to get a mySQL front end tools
which can make
mySQL to be work more user friendly.
currently i am using MySQL-Front, for those who had
tried out others this kind of tools,
pls recommend any others tools
that u think is more powerful, ef
Verify that mysqld is running with a "ps ax" from a Terminal prompt.
Z
On Thursday, May 24, 2001, at 06:24 PM, Victor Spång Arthursson wrote:
> Hi!
>
> I installed mySQL on my Mac OS X last week, but I never really tried
> it, though I know it was possible to start.
>
> But after having reinsta
The problem is that this line is not telling MySQL that I want it to select
only the fields where the EventMonth = May. Displaying the other fields is
not a problem at this time.
At 09:54 PM 5/24/2001 -0500, you wrote:
>At 9:49 PM -0500 5/24/01, Tim Thorburn wrote:
>>Hi,
>>
>>I'm using PHP to
At 9:49 PM -0500 5/24/01, Tim Thorburn wrote:
>Hi,
>
>I'm using PHP to pull information out of my MySQL database -
>although its not entirely working.
>
>Here is the line:
>
>$result = mysql_query("SELECT * FROM comcal2001 WHERE id=$id and
>EventMonth='May'",$db);
>
>What I'd like this to do is
Is locking not necessary on BDB tables? Does transaction support get rid of
the need for table locking?
thanks,
-Seth
>On Thu, May 17, 2001 at 12:35:09PM -0400, Seth Hall wrote:
>>
>> Hi, could someone point me to a tutorial on when to do table locking
>> with the BDB tables in MySQL?
>
>Why
Hi,
I'm using PHP to pull information out of my MySQL database - although its
not entirely working.
Here is the line:
$result = mysql_query("SELECT * FROM comcal2001 WHERE id=$id and
EventMonth='May'",$db);
What I'd like this to do is select all the fields in my database where the
month = M
--with-mysql uses PHP's built-in MySQL libraries, while --with-
mysql=/path/to/mysql will build it with the libraries of the MySQL
installation already present. The version built into PHP4 seems to
work ok for most things, but it's a bit behind in the point revs; which
version it uses escape
- Original Message -
From: "Jari Mäkelä" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, May 25, 2001 0:10
Subject: adding many entries to database
> Hi,
>
> could any one tell what am doing wrong with this. I have a file of which
> parts needs to be trans
You did follow the post installation instructions, didn't you?
And does that table actually exist, ie. perhaps it was accidentally deleted?
- Original Message -
From: "Wasmund, Derek" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 25, 2001 1:43
Subject: Receiving "Table 'm
Check that the mysql server is running and that the socket file is in the
correct place.
- Original Message -
From: "Victor Spång Arthursson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 25, 2001 6:24
Subject: My mySQL doesn't start...
> Hi!
>
> I installed mySQL on my
You can still use foreign keys, just that it has no effect in mysql.
- Original Message -
From: "Adriano Nagelschmidt Rodrigues" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 25, 2001 4:45
Subject: Foreign keys just for table metadata?
> Hi,
>
> In the current app I'm wr
Yes, programmatically.
- Original Message -
From: "Roger Karnouk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 25, 2001 4:04
Subject: Updating one table from another
> Is it possible to update the values in one table from another table where
> certain criteria match bet
That file is automatically created upon starting the mysql server. For it
to disappear, either the mysql server has been shut down or there is a cron
job (or something like that) deleting it.
- Original Message -
From: "Michael Ragsdale" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent:
Firstly, this is way off topic as it has nothing to do with mysql.
Secondly, I don't know exactly what you mean by Matrix Logic System.
In mathematical terms, a matrix is a set of tabulated data, so my guess is
you need to build a system that can perform mathematical operations on
matrices such
On Tue, May 22, 2001 at 06:56:00PM -0700, Nathanial Hendler wrote:
>
> How does one know if their database server needs more memory? I
> have several tables around 600,000+ rows that are being joined. I
> have 512MB of memory. Is there a rule of thumb, or a good way to
> calculate how much mem
Robert Henkel accidentally sent a reply to me instead of to you or to
the mailing list. In his reply he states that he tried your SELECT
statement and it worked fine. If so, then the problem is in the
normalized version, and is probably a simple error similar to the one
I pointed out. Post you
At 1:53 PM +0200 5/24/01, Catherine Vi Clausen wrote:
>Hi!
>
>My name is Cathy and I have a problem after installing MySQL. I
>cannot get connection to the localhost. Whenever I type "mysqld" I
>get this message:
>C:\mysql\bin>mysqld
>Can't initialize InnoDB as 'innodb_data_file_path' is not set
On Thu, May 24, 2001 at 02:13:39PM -0300, Siomara Pantarotto wrote:
>
> I also get the same error and the weird thing is that my cgi script
> that acces the database are located in the same place that other cgi
> scripts from bugzilla are.
>
> However I get the error message and the other cgi scr
On Sat, May 19, 2001 at 09:54:36PM +0200, Jocelyn Fournier wrote:
> Hi,
>
> Assuming I have a INT type column named "numeropost", is this faster
> to write a query with "WHERE numeropost=12" instead of "WHERE
> numeropost='12'", or is this exactly the same speed ?
It would take just 5 minutes to
On Sat, May 19, 2001 at 01:18:42PM -0500, David Gullett wrote:
>
> I have 10 or so MySQL servers in the field, all writing data to a
> database of the same name. I would like to set up replication from
> all masters back to a single slave server and have each master write
> to a different databa
On Mon, May 21, 2001 at 01:35:58PM +0100, David Allen wrote:
> Hello again!
>
> Do you know if there is any way I can see what the mysqld is doing?
> If it is taking up 99% of the processor time, it is very busy doing
> something! I installed the binary version and consequently only have
> the to
On Fri, May 18, 2001 at 11:27:25AM +0200, Johan Andersson wrote:
> Hi,
>
> I heard something about a master election feature or something that
> will decide if a server would act as master or slave in a mysql
> replication "cluster"..
>
> But that was for version 4.0 ?
Correct. If you check th
On Thu, May 17, 2001 at 12:35:09PM -0400, Seth Hall wrote:
>
> Hi, could someone point me to a tutorial on when to do table locking
> with the BDB tables in MySQL?
Why?
> I'm running version 3.23.37 on RH7.0 (with BDB tables :) and if I
> attempt to do locking within a transaction, the transacti
On Wed, May 16, 2001 at 12:38:17PM +0200, Jesús Gómez wrote:
> Hi everybody
>
> Anybody knows how to make a mysql farm ( like a load balancer but
> wiht mysql) ?
Depends what you're after. Have you looked at MySQL's built-in
replication?
http://www.mysql.com/doc/R/e/Replication.html
Jeremy
-
On Mon, May 14, 2001 at 04:05:30PM +0800, Gu, Zhenghao (Zhenghao) wrote:
> I am new to MySQL.
> Can I use the binary distribution of Sun
> Solaris(Sparc)[sun-solaris2.7-sparc] on Solaris 2.6?
> Thanks for your info advance!
Maybe. Did you try it?
I've been working on building a Solaris 2.
On Thu, May 24, 2001 at 07:30:52PM -0400, Dave Weiner wrote:
>
> Is there a searchable archive of the mysql list on the web
> somewhere? Before I embarrass myself asking a question that may
> have been asked before, I'd like to search the historical archives
> :)
http://marc.theaimsgroup.com/?l=
If it's not too late, may I suggest that you re-structure your database
while using normalization & RDB rules???
The database that you are looking for is actually very straight-forward and
I'm sure it's been done many times before. To get you started, think about
how you would see these products
Is there a searchable archive of the mysql list on the web somewhere?
Before I embarrass myself asking a question that may have been asked before,
I'd like to search the historical archives :)
Dave W
P.S. - I think the filter, while a good idea, may be a bit too restrictive.
The filter didn't l
Hi.
I'm having some problems with formulating a SELECT statement to do the
following:
I have a database with one column of names with certain tags bounded by
square brackets, and a price column as well. The database looks something
like this:
ITEMPRICE
Shirt [Lar
> > > > *] I need to generate a RANDOM UNIQUE number for every new record.
Is
> > there an
> > > > *] easy way to accomplish this inside of mySQL.
> > > > *]
> >
> > What are the requirements for 'random' and 'unique'? Do you need some
sort
> > of cryptographic randomness? Does uniqueness be kept
database,sql,query
>Paul DuBois writes:
>> At 6:03 PM -0300 5/24/01, Adriano Nagelschmidt Rodrigues wrote:
>> >
>> >level ENUM('bad', 'good', 'great') NOT NULL
>
>[snip]
>
>> >SELECT * FROM foo WHERE level >= 'good'
>
>[snip]
>
>> >Shouldn't a numeric context be applied by the server
On Thu, May 24, 2001 at 01:17:08PM -0400, Billy Harvey wrote:
> Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
> > It is possible to get in a situation where you either "miss" updates
> > on the slave, or your slave tries to run an update query that is
> > already reflected in the table that you ar
I believe what you are talking about is an inverted text index where the
word is used to lookup what document it occurs in. To create this index you
would have to make a program that takes a "document" (be it a row in the
database or a file or whatever), splits it up into words, inserts these
wor
Hi!
I installed mySQL on my Mac OS X last week, but I never really tried it,
though I know it was possible to start.
But after having reinstalled Apache and PHP, it's not possible to start
anymore...
What happens when I type mysql in the terminal is:
[localhost:~] victor% mysql
ERROR 2002: C
[EMAIL PROTECTED] writes:
> 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 following words in your message:
>
> database,sql,query
This is _very_ annoying.
Paul DuBois writes:
> At 6:03 P
In the last episode (May 24), Michael Widenius said:
> - Message from "Joshua J. Kugler" <[EMAIL PROTECTED]> -
>
> Joshua> So, I can "SELECT id FROM table_name WHERE id IS NULL" as many times as I
> Joshua> need/want to, and it will return the proper value. Very nice.
>
> Joshua> So,
Hello, Im try to execute the load datafile query from php and I
get the following. " 13: Can't get stat of
'/home/somewhere/overhere/andhere/test2.txt' (Errcode: 2)".
All directorys have read permission and the file exists. What's wrong?
it makes no sense.
I tried putting the exact path, ./filenam
hi.
do you have these installed?
if not, install the libraries for ncurses and termcap.
if you don't want to/can't install these, build mysql without the client.
hth.
-ravi
-Original Message-
From: Greg Robillard [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 24, 2001 5:41 PM
To: [EMAI
On Thu, 24 May 2001, Aigars Grins wrote:
> > > *] I need to generate a RANDOM UNIQUE number for every new record. Is
> there an
> > > *] easy way to accomplish this inside of mySQL.
> > > *]
>
> What are the requirements for 'random' and 'unique'? Do you need some sort
> of cryptographic randomne
> > *] I need to generate a RANDOM UNIQUE number for every new record. Is
there an
> > *] easy way to accomplish this inside of mySQL.
> > *]
What are the requirements for 'random' and 'unique'? Do you need some sort
of cryptographic randomness? Does uniqueness be kept across tables?
If you 'onl
Help,
I get this configuration error when trying to configure mysql.
Any solutions.
Greg Robillard
At 13:53 24/5/2001 +0200, Catherine Vi Clausen wrote:
Hi!
The mysqld.exe was compiled with an instruction for NT/Win2k
platforms. Then instead of it, use mysqld-opt.exe or mysqld-max.exe
for to have support for tables BDB and InnoDB.
If you want to use mysqld-max.exe, read the instructions about
At 6:03 PM -0300 5/24/01, Adriano Nagelschmidt Rodrigues wrote:
>Hi,
>
>Supposing I have the following column definition:
>
>level ENUM('bad', 'good', 'great') NOT NULL
>
>I would like to be able to do:
>
>SELECT * FROM foo WHERE level >= 'good'
>
>Yet this doesn't work (MySQL v 3.23.38). I have
Hi,
Supposing I have the following column definition:
level ENUM('bad', 'good', 'great') NOT NULL
I would like to be able to do:
SELECT * FROM foo WHERE level >= 'good'
Yet this doesn't work (MySQL v 3.23.38). I have to use
level >= 2 instead.
Shouldn't a numeric context be applied by the
Hi,
In the current app I'm writing, it would be very useful if I could
store the information that a column references another table (my SQL
generation is automated), eg
CREATE TABLE foo (
...
tel1 INT UNSIGNED NOT NULL,
tel2 INT UNSIGNED NOT NULL,
foreign key (tel1)
run the perror app that should of come with your distribution
perror 13
Terry Shipclark wrote:
>
> What does this error mean?? Any help would be appreciated
>
>
>
> Terry Shipclark
> Technical Support Representitave/Cati Operator
> [EMAIL PROTECTED]
> tel. 416-445-9800 ext 2093
> www.bbm.ca
What does this error mean?? Any help would be appreciated
Terry Shipclark
Technical Support Representitave/Cati Operator
[EMAIL PROTECTED]
tel. 416-445-9800 ext 2093
www.bbm.ca
-
Before posting, please check:
http
I understand you reasoning. If you don't change the official source code, I
can always make the change when I get a new version. Whatever you feel is
best.
But what scares me is a comment in the source code by the line I commented
out:
/*
** Handles this special case for some ODBC applicati
Is it possible to update the values in one table from another table where
certain criteria match between the tables in an update query in MySQL.
Roger Karnouk
-
Before posting, please check:
http://www.mysql.com/manual.php
I've had mysql 3.23 running for quite some time now and have accessed it
remotely via the ODBC driver. All of a sudden, it won't let me connect
remotely anymore, while I still have a connection from localhost. I found
some info on the /tmp/mysql.sock file being deleted. I looked for it and
1) Not sure what's going on there, perhaps run a check on the table.
2) I just recently indexed a column on a table with ~50 rows, on a
char(4) field, took roughly 30 seconds.
3) No problems running multiple index's, a tip though, lock the table before
you add the index, you can sometimes get
Hi!
- Message from "Joshua J. Kugler" <[EMAIL PROTECTED]> -
Joshua> I've been arguing with MS Access lately. Fortunately, I won. But only
Joshua> because I had the source to MySQL available. Here's the situation:
Joshua> I grep'ed the source, and found this at line 3062 of sql/
Hi,
I have several related database indexing questions:
1)In trying to run SHOW INDEX FROM table my client (MySQL GUI 1.7.4) just
hangs, or else this takes many minutes. MySQL 3.23.33 What could be wrong?
I tryed an ALTER TABLE index creation on this table a while ago. Could it
be tied up wit
Hi all:
Apologies in advance if this is completely off-topic!!
I'm building a site right now in PHP/MySQL. Parts of the site are
database driven, other parts are not. http://www.tri-drs.org (racing
and bios are db driven) for those of you who are interested.
I would like to build a Search Eng
It would help if MySQL listed which database the slow query was coming
from in the slow query log.
Cory.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Hello.
I am playing around with MySQL 3.23.33 (on a Linux Redhat 6.2 system)
and wondered about the following:
shell> time mysql yasg -e "SELECT eid,parent FROM entry_busy1 WHERE gid=413456 AND
deleted != 'true' AND offsite = 'no' ORDER BY gid, offsite, deleted, parent, eid" >
/dev/null
0.130u
I need to replicate a database from one machine to the other in such a way
that the database is renamed on the slave. So I'd like to clone a database
"abc" to a slave system as "abc_live"
Has anyone had any experience using the replicate-rewrite-db option?? When
you use this, do you still spec
Do you need to specify a directory? I just did --with-mysql
At 01:14 PM 5/24/2001 -0400, Bill Tangren wrote:
>When I compile PHP4 (4.04pl1) with the option --with-mysql=mysqldir...
>
>I get the error
>
>'cannot find mysqlclient library under mysqldir'
>
>I did a search through the mysqsl (3.23.3
Your english is understandable so please don't apologize.
The way Access/ODBC works during a 'find' operation is that Access will
ask the MySQL Server for each record, one at a time, until it finds a
match. This is very resource intensive and I try very hard to avoid
finding records in this m
I run the following:
./mysqld --basedir $NMS_HOME/mysql --log-update
and receive the following:
./mysqld: Table 'mysql.host' doesn't exist
./mysqld: Normal shutdown
./mysqld: Shutdown Complete
I am trying to run mysql with extensive logging, traces for deletes,
updates, inserts and selects. I
Hello All,
When I check to running the mysql_install_db I have the error:
root@gem:/usr/local/mysql>scripts/mysql_install_db
ld.so.1: ./bin/my_print_defaults: fatal: libcrypt_i.so.1: open failed: No such file or
directory
Environment:
System: SunOS gem 5.6 Generic_105181-23 sun4u sp
possibly you could use the ascii value of the # character. if you look for
string functions in the manual on mysql.com there is a function (maybe
ASC(int)) that will use the character that corresponds to the integer you
specify.
>From: Siim Einfeldt aka Itpunk <[EMAIL PROTECTED]>
>CC: <[EMAIL
I have half my tables in the ISAM format and half in the MYISAM format. I cannot see
the current complete set of tables using WinMySQLAmin or Mascon. Whe I try to access
them they tell me that they cannot find the .frm Should I upgrade all tables to
MYISAM and then what would I use to view MyS
technical Support writes:
> Hello,
>
> Does anyone know of any tool that will take an ORACLE database and port
> it to mySQL?
>
> *
> * Visit http://www.computerstaff.net - Computer Jobs at all LEVELS *
> ***
Is it possible to create a Crosstab or Pivot Query
(where the values of a certain field become the column headers) in MySQL
ex.
+--++++
| Name | 1984| 1985 | 1986|
+--++++
| John
Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
> It is possible to get in a situation where you either "miss" updates
> on the slave, or your slave tries to run an update query that is
> already reflected in the table that you are copying.
>
> If the table is not updated frequently (and doesn't t
When I compile PHP4 (4.04pl1) with the option --with-mysql=mysqldir...
I get the error
'cannot find mysqlclient library under mysqldir'
I did a search through the mysqsl (3.23.38) source code after I compiled
it, and I don't find that library anywhere? What am I doing wrong?
Bill Tangren
-
I also get the same error and the weird thing is that my cgi script that
acces the database are located in the same place that other cgi scripts from
bugzilla are.
However I get the error message and the other cgi scripts don't
How come??? Can someone help, it's been two days that I am trying
Hi,
could any one tell what am doing wrong with this. I have a file of which
parts needs to be transferred to database but after successfully moving 66
entries into the database it dies at the mysql_query. There would be about
10 times more entries remaining. The file is delimited with ; but i
Hi,
I recently installed in MySql from binary distribution mysql-
max-3.23.38-pc-linux-gnu-i686.tar.gz. The install worked fine, the
database runs and performs fine but it refuses to shutdown short of a
'kill -9'. This is not so good:( I have tried 'mysqladmin shutdown' and
killing the safe_my
Hello,
Does anyone know of any tool that will take an ORACLE database and port
it to mySQL?
*
* Visit http://www.computerstaff.net - Computer Jobs at all LEVELS *
*
> My ISP is running on Cobalt RaQ4, so I downloaded mySQL Cobalt version to
> my web server. The installation was successful but now I don't know how to
> start mySQL. I tried telnet-ing to my server and got into the mySQL
> directory but that was as far I got. Everytime I tried to execute a
> co
Try clicking on "Execute SQL Statement" and entering "CREATE DATABASE
MyDatabaseName" (without the quotes, and replacing MyDatabaseName with
whatever you like).
It should be as simple as that, but if it doesn't work, you may want to
check with your host that you _are_ allowed to do it - some don'
my experience with web hosts is that they usually give you one database per
domain name hosted. So you likely CAN'T create another db that you can
administer in this fashion.
bummer,
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.abti.cc
717.464.2970
-Ori
On Mon, May 14, 2001 at 08:37:40PM +0800, Raymund D. Nones wrote:
> Everytime i connect to my database using perl i get this error message :
>
> install_driver (mysql) failed: Can't locate DBD/mysql.pm in @INC
>
> Can anyone help me ?
Have you installed DBD::mysql?
Jeremy
--
Jeremy D. Zawodny
On Mon, May 21, 2001 at 11:53:52AM -0700, Brian Warn wrote:
> Hello All,
>
> Is there some way, when mysql server is running, to change an
> option? I want to change skip_networking to OFF without doing a
> server restart.
Currently, no.
Monty has talked about making most of the variable tunab
I am brand new to MySQL - my web host has set up a graphical tool for me to
use, to try and administer it - it's called MysqlTool, Version 0.85. It's
got a database there that my host created for me. Now I want to create an
additional database, but don't see any kind of button for doing that. I
hi,
i have these 2 query's
select date, value1 from table1 group by date
select sum(value1) from table1
how can i do the above in one only query?!
is it possible?!
--
WEBSOLUT - Soluções Internet
Emailto: [EMAIL PROTECTED]
Personal Info: http:
On Wed, May 23, 2001 at 07:09:23PM -0700, S A wrote:
>
> How much if at all slower should a BETA-LOG build of MySQL be than
> one that doesn't log ?
>
> We have on BSD 3.23.26-beta-log which is MUCH slower than 3.23.32 on
> Linux.
It depends on how IO and CPU bound your system is. It could be
m
Hi,
I am supposed to build a Matrix Logic System (or something like this) for
merging to databases.
I have no idea what so ever of what is a Matrix Logic System. Can anyone
tell me with what this can be eaten?
Thank you very much,
Ciprian A.
On Thu, May 24, 2001 at 09:18:08AM +0100, Simon Windsor wrote:
>
> Could someone please clarify the following points for me:-
>
> If I use the command
>
> load table from master;
>
> on the slave, will the table once copied to the slave be kept up to
> date by the master ?
The slave will cop
On Thu, May 24, 2001 at 10:04:39AM -0500, Larry Hotchkiss wrote:
> Can anyone recommend a good book on MySQL that covers
> performance tuning very well?
I don't think so. Not one which deals with InnoDB, DBD, Gemini,
etc. But there probably should be.
I've discussed it with a few publishe
It is frequently faster. Although, not a problem in mysql, msql
frequently ran an order of magnitude faster if the "joins" were done in
perl rather than in the SQL statements.
On Thu, 24 May 2001, Brian Kaney wrote:
> Date: Thu, 24 May 2001 10:01:04 -0400
> From: Brian Kaney <[EMAIL PROTECT
Sommai,
I have developed InnoDB on a computer with 32 MB memory and 1.2 GB disk.
You can run it on 64 MB, but be careful when you specify the buffer pool,
key cache and other memory pool parameters in my.cnf, so that you do not run
out of physical memory. If Linux has to swap to disk, it can be v
Yes, his "MySQL" is the very good book I've been using.
It's copyright 2000, first printed December 1999. Is there an updated
one? You know MySQL is changing everyday :>) so the one I have is 1.5
years behind.
Dibo
Scott Baker wrote:
>
> I always recommend Paul DuBois' book. It's the best MyS
George,
this is the bug that slipped into the rollback code in .38.
You can download a patch from my website
http://www.innobase.fi/bugfixes.html
You are running out of tablespace when doing the table import.
MyISAM tables take a lot more space when converted to the InnoDB
type. Make your data
On Thu, May 24, 2001 at 04:07:48PM +0100, VVM Ravikumar Sarma Chengalvala wrote:
> I would like to have answers/confirmation regarding
> the following:
> i)
> Primary and Unique key fields are autoindexed by
> mysql.
Yes.
> ii)
> Indexing on a single or multiple fields will create a
> overhead
I always recommend Paul DuBois' book. It's the best MySQL book, and the
best technical book I've ever read.
Scott
At 10:04 AM 5/24/2001 -0500, Larry Hotchkiss wrote:
>To: "'MySQL List'" <[EMAIL PROTECTED]>
>Subject: Book recomendation.
>
> Can anyone recommend a good book on MySQL that
Hi Carlos,
>SELECT * FROM some_table WHERE field1 = 1 AND field2 > 0
>ORDER BY CONCAT(field1,field2) LIMIT 1
You have to give the concatenated field an alias name and use it in the
SELECT-subpart of your query, e.g.
SELECT field1, field2, concat(field1,field2) AS sortvar1 WHERE field1=1 AND
fi
Can anyone recommend a good book on MySQL that covers performance tuning
very well? On large qty of inserts (greater than 400k) I get 127 errors yet
the table is not corrupt according to check table and myisamck and when I
break the 1 million mark it pukes bad AND I get corrupt tables.
Hi,
I would like to have answers/confirmation regarding
the following:
i)
Primary and Unique key fields are autoindexed by
mysql.
ii)
Indexing on a single or multiple fields will create a
overhead on database memory.To what extent
iii)
Indexing Vs Perfromance based on a query frequency on
a part
Try:
SELECT *,
CONCAT(field1,field2) as newField
FROM some_table
WHERE field1 = 1 AND field2 > 0
ORDER BY newField LIMIT 1
I don't have access to my server right now but this SHOULD work.
HTH,
Cal
- Original Message -
From: "Carlos Savoretti" <[EMAIL PROTECTED]>
To: <
I think that you can not concat and ORDER BY? (or ORDER by a function).
Hope this help
Simon
-Original Message-
From: Carlos Savoretti [mailto:[EMAIL PROTECTED]]
Sent: 24 May 2001 15:53
To: [EMAIL PROTECTED]
Subject: Can I do this ?
I'm using C API to access MySQL from another database
If the contractor didn't use a my.cnf file, check your
$MYSQL/bin/safe_mysqld file. Somewhere around line 124 (v. 3.22.32 on
solaris), you should find and entry such as:
nohup $ledir/mysqld --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR
$MY_OPTS\ >> $err_log 2>&1
on my redhat box, the entry
I'm using C API to access MySQL from another database in order to re-use
a lot of existing software. Due the way the old database works I need
a query be done like this:
SELECT * FROM some_table WHERE field1 = 1 AND field2 > 0
ORDER BY CONCAT(field1,field2) LIMIT 1
This is for not to create
Check /etc/my.cnf or /etc/.my.cnf (I forget which) This should be the
global conf (ini) file for mysql.
Cal
- Original Message -
From: "Joe Fox" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 24, 2001 9:22 AM
Subject: Apologies in advance
> I'm new to Linux and mysql
I believe this is clearly explained in the manual at www.mysql.com
Cal
- Original Message -
From: "Eugénio Veiga" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Thursday, May 24, 2001 9:17 AM
Subject: Re: Default Date
> Hi
>
> Paul DuBois wrote:
>
> > On Thu, May 24, 2001 at
1 - 100 of 135 matches
Mail list logo
