Hi,
if you use the following command in mysql:
CREATE TABLE somedb.group(mip INT (8) UNSIGNED DEFAULT '0' NOT NULL
AUTO_INCREMENT, name CHAR (255), PRIMARY KEY(mip), UNIQUE(mip), INDEX(mip))
Where somedb is the database name and group was the intended group, you can
create a table called
Hallo,
mysql on a win2k box do not start after
a server down
win2k error:
mysql can not start cause
it was unexpected shutdown
mistake 1067
what going wrong
Tank you
-
Before posting, please check:
Hi
The Oracle export function, exp, does not export data in a clean file format,
and whilst it may be possible to tidy the output to load into another
database, you'd do better writing a perl script to dump the tables required
to disk.
The time factors in moving data from db1 on one machine
Hi
I have a problem with performance for out mysql db. The docs on www.mysql.com don't
really help because they arent specific enought (what is big ???).
The load on our server currently is over 2 permanently and I don't think that is very
good.
We use:
MySQL 3.23.51
Linux Kernel 2.4.16
we
Kevin,
are you sure that your 2 and 3 letter words do not appear in more than
half of all rows? That would exclude them from the search.
Thomas
On Wed, 20 Nov 2002, Kevin Lewandowski wrote:
Hi, Sergei.
In myisam/ftdefs.h I changed:
#define MIN_WORK_LEN 4
to:
#define MIN_WORD_LEN 2
I want do build a mysql cluster.
The master receive all queries.
Then, the master write, update, delete, ecc..
the slaves answer SELECTs
If this is impossible, which is the utility to have slaves???
-Messaggio originale-
Da: Jon Frisby [mailto:[EMAIL PROTECTED]]
Inviato: mercoledì 20
Not out of the box.
You would have to right some code to do this.
The best way to do this is get every one who rights code to set up to hosts
at the top of there code.
Simon
-Original Message-
From: Massimo Bandinelli [mailto:[EMAIL PROTECTED]]
Sent: 21 November 2002 09:48
To: Jon Frisby
Daniel,
- Original Message -
From: Daniel Kiss [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, November 21, 2002 7:18 AM
Subject: Version 4.1
Hi all,
I would like to know when MySQL version 4.1 will be available for windows
as compiled install kit?
my guess is
Pallavi,
[Please keep replies on-list. It helps other people, my mail rules keep you
separated from paying clients, and the list archives are complete]
actually i created a new file by vim then did cut paste .
=therein lies the problem. If you compare the listing below with the
expected
hi,
do you have hints/documents for me were to find information about mysql
server tuning (not table/index optimizing, but memory-tuning etc).
thx!
regards
Sönke Ruempler
top concepts Internetmarketing GmbH
--
http://www.topconcepts.com
Hi,
I´m using MySQL version 4.0.5 in Windows and I want to make a JOIN between
two tables that have approximately 20,000 records and 20 columns. As all
the records
from one of the tables must appear in the result of the SQL( the tables
don´t have the same
number of records) , I ought to use a
J.C.,
Thursday, November 21, 2002, 10:20:06 AM, you wrote:
JCK if you use the following command in mysql:
JCK CREATE TABLE somedb.group(mip INT (8) UNSIGNED DEFAULT '0' NOT NULL
JCK AUTO_INCREMENT, name CHAR (255), PRIMARY KEY(mip), UNIQUE(mip), INDEX(mip))
JCK Where somedb is the database name
Frank,
Thursday, November 21, 2002, 10:28:59 AM, you wrote:
FK mysql on a win2k box do not start after
FK a server down
FK win2k error:
FK mysql can not start cause
FK it was unexpected shutdown
FK mistake 1067
Run MySQL server in standalone mode
mysqld.exe --standalone --console
You'll
Steven,
Thursday, November 21, 2002, 7:29:41 AM, you wrote:
SR There seems to be nothing in the Manual about a lot of things. For
SR example, the utilities mysqldumpslow, and mysqlcheck, etc.
As to mysqlcheck:
http://www.mysql.com/doc/en/Using_mysqlcheck.html
As to others you can write
theapparatus,
Thursday, November 21, 2002, 5:35:04 AM, you wrote:
tandn I just have a quick question. I've been setting up a
tandn website using a MySQL database loaded with a large
tandn number of articles but I'm having a problem.
tandn Some of the articles did not load correctly into the
Trystano,
Thursday, November 21, 2002, 2:52:54 AM, you wrote:
Taadc Hi, this is my first dabble of using MySQL and am having trouble setting a
Taadc password.
Taadc I have installed MySQL on Windows XP. I've gone through the manual, but I
Taadc can't really find how to do it. If you could post
Hi,
Suppose my data contain 2 column
column A for code
column B for detail
data like this
row A B
1 100 AA
2 100 BB
3
Hello, I am new to the list, I've subscribed in last ressort when I couldn't
find an answer, neither the web or the list archives...
I've had a question from a client that I've answered in this way :
One other question, when you have built the
database, will it be
expandable to the size for
Hi all,
Where can I download MySQL version 4.1 source code?
Thanks,
Daniel
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
Hi,
Take a look here :
http://www.mysql.com/doc/en/Installing_source_tree.html
Regards,
Jocelyn
- Original Message -
From: Daniel Kiss [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, November 21, 2002 11:58 AM
Subject: Where is 4.1 source
Hi all,
Where can I download
Where can I download MySQL version 4.1 source code?
http://www.mysql.com/downloads/mysql-standard-4.0.html ahhh?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi all.
The example mysql configuration files included in support-files directory of
MySQL distribution are optimized for MyISAM table type.
I want to tunnig the server optimized for InnoDB because I won't use MyISAM
table type except for mysql database and *.frm files.
I want to know which
On Thu, 21 Nov 2002, Daniel Kiss wrote:
Hi all,
Where can I download MySQL version 4.1 source code?
Hi,
There are no 4.1 source distributions yet, see this:
http://www.mysql.com/doc/en/Installing_source_tree.html
You need to download the bits via BK.
Dobrý den,
quinta-feira, 21 de novembro de 2002, 09:58:47, napsal jste:
IS Hi all.
IS The example mysql configuration files included in support-files directory of
IS MySQL distribution are optimized for MyISAM table type.
IS I want to tunnig the server optimized for InnoDB because I won't use
On Thursday 21 November 2002 12:58, Daniel Kiss wrote:
Hi all,
Where can I download MySQL version 4.1 source code?
http://www.mysql.com/doc/en/Installing_source_tree.html
Regards
Georg
-
Before posting, please check:
Listen,
Wednesday, November 20, 2002, 7:31:27 PM, you wrote:
LH thanks for your great advice, finally pointing out the reason for the
LH problem.
SH mysql ALTER TABLE auftrag CHANGE Nummer Nummer INT UNSIGNED NOT NULL
SH PRIMARY KEY;
SH ERROR 7: Error on rename of '.\trainee\auftrag.MYI' to
Mark,
Wednesday, November 20, 2002, 4:52:24 PM, you wrote:
MC I would like to export the full contents of one particular table in a
MC database to a csv file once every day. I will then email this file I am
MC running MySQL 3.21 on a RedHat 7.2 server. Is there an automated way of
MC doing this?
I just want to add that unlike what it is printed (Download BitKeeper from
http://www.bitmover.com/cgi-bin/download.cgi. You will need Bitkeeper 2.0 or
newer to access our repository.), Bitkeeper 3.x seems to be needed.
Perhaps the manual should be updated :)
Regards,
Jocelyn
- Original
make[2]: Wechsel in das Verzeichnis
Verzeichnis »/usr/src/mysql-3.23.53/libmysql«
/bin/sh ../libtool --mode=compile
ME=\/usr\ -DDATADIR=\/usr/var\
-DSHAREDIR=\/usr/share/mysql\ -DUNDEF_THREADS_HA
CK -DDONT_USE_RAID -I./../include -I../incl
ude
i'm running an oracle enterprise server in a test
environment for corereader, and i've noticed
that, although oracle sometimes takes a while to
wake up, after you have its attention, it throws
data at you very fast. sometimes a developer
does not use connections properly. in your case,
i
Then, the master write, update, delete, ecc..
the slaves answer SELECTs
If this is impossible, which is the utility to have slaves???
it is possible. Follow the manual for a good start. A couple
caveats:
- your application has to be able to send the selects to the different
(read only)
Description:
Dump several big tables or entire databases with mysqldump, then
import to same or another database with mysql -f db dumpfile or
on mysql console by typeing source dumpfile.
You can then see that the amount of free memory decreases quite
fast,
Hello all,
Is there a mysql function that extracts sub matches from regular
expressions. for example in perl when you match a string to a regular
expression like /\s+(\S+)\s+(\S+)/ the submatches (strings matching the
part of the expression between parenthesis) are available in variables
$1, $2
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 21 November 2002 13:49, Sönke Ruempler wrote:
make[2]: Wechsel in das Verzeichnis
Verzeichnis »/usr/src/mysql-3.23.53/libmysql«
/bin/sh ../libtool --mode=compile
ME=\/usr\ -DDATADIR=\/usr/var\
Hello,
I've got a big board using Linux Mdk 8.2, PHP 4.1.2 and Mysql 3.23.49.
All messages are stored in one table (850 000 messages) and I have some
other tables but smaller. My posts table is 500 Mo large, index is also big
because of full text index.
I now have problems with my board: the
Does the memory amount used increases any further if repeating the dump
import.
If so there is a leak if not you just got fooled by the standard malloc
of solaris which wont return memory free(d) to the system but instead
the memory will be kept in a pool for the next malloc.
Lars
On
Using PHP 4.2.3 with MySQL 3.23.52
Report:
---
- Table has 2 keys: 'account' as PRIMARY and 'id' as unique
- I make an SQL update on an existing a record with id=anid setting
id=anotherid but another record exists with id =anotherid
- The update is performed and the record already existing
Lars,
the amount used increases until all free memory is used plus a fair amount of
swap. On a machine with 2GB memory this can well grow up to 1GB.
Any chance to get the current size of the malloc pool to check if this
causes the effect?
thx so far,
Markus
On Don, 21 Nov 2002, Lars
Hi,
Could you give us SHOW CREATE TABLE your_table ?
Greetings from France too ;)
Jocelyn
- Original Message -
From: BPF Webmaster [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Thursday, November 21, 2002 2:25 PM
Subject: Duplicate key delete record with same key
Using PHP
The problem was with the ending record/line break character.
I added:
LINES TERMINATED BY '\r\n'
and the import worked wonderully! And only took a little over ten
minutes to process.
Thanks for the help.
-Original Message-
From: Roger Abrahamsson [mailto:[EMAIL PROTECTED]]
Sure:
CREATE TABLE `reg_member` (
`account` bigint(20) NOT NULL auto_increment,
`userid` varchar(48) NOT NULL default 'Your name',
`uilogin` tinyint(4) NOT NULL default '0',
`id` varchar(48) NOT NULL default '',
`password` varchar(10) NOT NULL default '',
`joined` bigint(20) default NULL,
My problem is this:
I have an hosting server and it contains many domains (100.000).
It supports php and mysql and I don't want to tell my users to use different hosts for
select and update.
However, thanks.
-Messaggio originale-
Da: Johannes Ullrich [mailto:[EMAIL PROTECTED]]
Inviato:
Renaud Raffier wrote:
Hello,
I've got a big board using Linux Mdk 8.2, PHP 4.1.2 and Mysql 3.23.49.
All messages are stored in one table (850 000 messages) and I have some
other tables but smaller. My posts table is 500 Mo large, index is also big
because of full text index.
I now have
I took a look at the command but I don't see where you tell
mysql which specific field to use within a specific column. The
rest of the column is fine and I understand the id=# points at the
column that I want.
Thanks for the response btw,
Mike Wendell
At 01:07 PM 11/21/2002 +0200, you wrote:
le 21/11/02 15:38, Danny Haworth à [EMAIL PROTECTED] a écrit :
I assume you are using mysql_pconnect()? That way, PHP will reuse old
connections instead of opening up a brand new one each time.
Now, we do not use persistent connections but me have set thread_cache=25 to
have enough
Hi Markus,
I just missed something in your original Mail,
I guess its not the mysql server growing to 1gig (check with ps -ely)
its simply the system memory showing no free mem.
If you have root access to the maschine its probably a good idea to
install the prtmem command
I should have been more specific in my previous post. I am actually after
the syntax to get the data out of a table and into a file. I couldn't quite
work this out from the stuff I read in the manual.
mysql
This e-mail is intended for the
I am having 'issues' with MySQL running on Redhat Advanced Server
on a 8 Gigbyte machine (dual P4-Xeon).
After large imports ('load data infile', file size about 1 Gigbyte) into
a large table (20-30 GByte, 100 Million rows), the database crashes.
I did try several key_buffer_size settings. The
: )
excellent. i envy you.
i'd noticed the same thing about oracle. seems
to be a resource hog. the only thing worse that
i've seen is ms access. they make mysql look
very efficient.
hate to say much, since it appears that you know
what you're doing, but you might also take a look
at
Thanks. I'll try immediatly.
-Messaggio originale-
Da: Johannes Ullrich [mailto:[EMAIL PROTECTED]]
Inviato: giovedi 21 novembre 2002 16.17
A: Massimo Bandinelli
Cc: [EMAIL PROTECTED]
Oggetto: Re: R: R: Mysql Replication
I have an hosting server and it contains many domains (100.000).
On 21 Nov 2002, at 8:46, Juan C. P. Garrido wrote:
When I make the LEFT JOIN between the two tables, it takes a long time,
and it seems that the machine is crashed , because everything I try to make
in the machine is extremely slow, so I have to reset it manually.
Do you have indexes on the
I am in college and doing a comparison of Oracle and
MySQL (term paper). One of the items that must be
included is whether or not they support user defined
data types. What I found on the web is below this my
name and discusses Oracle8, which would indicate the
article is old. Has anything
Lars,
uhm, installed that package and it confirms your suspicion:
Total memory: 612 Megabytes
Kernel Memory: 60 Megabytes
Application: 89 Megabytes
Executable libs: 32 Megabytes
File Cache: 419 Megabytes
Free, file cache: 6
My delayed_insert_timeout is the default 300 seconds. Why then would I have
DELAYED threads that have been idle for 14+ hours?
+--+--+---+++---+---
-+--+
| Id | User | Host | db |
MySQL 3.23.51
Linux Kernel 2.4.16
we do have 1 GB of RAM
the main problem seems to be a table with about 8.597.146 records.
Similar situation here (100 Million rows).
things I found that help:
- be selective on what rows to index. Try to limit yourself to one
row.
- increase the key
Description:
When mysql is installed via linux rpm file, it does not install
mysqladmin command?
How-To-Repeat:
just install mysql from redhat linux rpm.
Fix:
?
Submitter-Id: submitter ID
Originator:MikeL
Organization:
MySQL
BPF,
Thursday, November 21, 2002, 4:36:58 PM, you wrote:
BW CREATE TABLE `reg_member` (
BW `account` bigint(20) NOT NULL auto_increment,
BW `userid` varchar(48) NOT NULL default 'Your name',
BW `uilogin` tinyint(4) NOT NULL default '0',
BW `id` varchar(48) NOT NULL default '',
BW `password`
Juan,
Thursday, November 21, 2002, 12:46:55 PM, you wrote:
JCPG Iam using MySQL version 4.0.5 in Windows and I want to make a JOIN between
JCPG two tables that have approximately 20,000 records and 20 columns. As all
JCPG the records
JCPG from one of the tables must appear in the result of the
I've actually just started playing with full text indexes and have been
following this thread along with searching the internet. I'm not using
MySQL 4 yet, so my options are limited. I do have a need to search on
three letter words (i.e. C++,ASP,AIX,awk, XML).
What I am doing now, which seems
On Thu, 2002-11-21 at 09:47, Johannes Ullrich wrote:
And more difficult, try to look at your application design and try
to come up with 'cache tables' that are generated by a cron job
periodically and are used for most queries.
This is an excellent suggestion and may make you think about your
I have a few servers running MySQL and regularly (almost every web page!)
connect from one to the other to update or query a remote database. I have
never had any problems (love that mySQL) until I upgraded one of the systems
and re-loaded the websites etc.
Now, when I try to connect to the new
Apologies if this is off topic ... please let me know what a more
appropriate forum is if so.
Quick question: since there is normally a per-process limit of 4GB on
32-bit linux/intel platforms is there any point to installing more than
4gb in an sql server that is only running running 1 instance
Keith C. Ivey wrote:
On 21 Nov 2002, at 8:46, Juan C. P. Garrido wrote:
When I make the LEFT JOIN between the two tables, it takes a long time,
and it seems that the machine is crashed , because everything I try to make
in the machine is extremely slow, so I have to reset it manually.
I have an applet and I'm trying to use Connector/ J 3 to connect to my
database.
I have uploaded the applet to my web server.
I have uploaded the mysql-connector-java-3.0.2-beta-bin.jar file to the same
dir as the applet
I have made a reference to the mysql.jar file in the html file like so
PARAM
Egor Egorov
Sir, I understand how intimidating the manual may seem, especially when
you are starting out.
Don't give up, and here is a suggestion that I found to help a lot.
(Although some around here might laugh.)
I got a book called MYSQL and PHP for Dummies. It does a fantastic job of
giving
You can expect that your operating system will use the remaining
memory as a file cache that will speed up your databases accesses.
We don't have that much memory our dedicated database server, it has
only 2 Gb. mysqld itself is using around 600Mb the rest is used
by the OS mainly for file
Just a small comment to this thread:
If you follow this link you'll see that you are searching on two words which
both are only two chars long.
Just press the 'søk' bottom and you will be doing a search on the
booktitles, in a database containing 1.4mill books, running Mysql
4.0.4-beta.
I
Even if you have more than 4 Gb of physical RAM, a single process
cannot address more than 4 Gb of memory (a P4-Xeon is still a
32 bits processor :( ). You have also to take into account that
a process cannot use these 4 Gb for data since some memory is
used for code, stack,... The exact amount
You have to send the SELECT queries directly to the slaves. Your code
must know to connect to an appropriate machine for the type of work it
wants to do: If it's only reading data (SELECTs), it should connect to
one of the slaves. If it must alter data (INSERT/UPDATE/DELETE) or must
both read
Im running the following query:
SELECT
user.nickname,
user.id,
user_detail.points
FROM
user,
user_detail
WHERE
user.details = user_detail.id
AND user.id 101
AND user.language = 'en'
ORDER BY user_detail.points DESC
LIMIT 5;
It basically lets me know the top 5 contributors to my website.
What causes the following error and what can I do to keep it from happening.
mysql:Out of memory (Needed 5961744 bytes)
The number of bytes needed varies. The error sometimes occurs when sending a large
number of INSERT requests using batch mode, e.g., mysql -u user -h hostid
Victoria,
So I looked deeper in my PHP code (I wrote it in February 2002) and saw
I use a REPLACE statement:
class persistent
{
// put method to save properties into the DB
function put($thePrefix)
{
// job
Hi,
Can anyone tell me how to set the following parameters in mySQL 3.23? I'm
new to MySQL and am setting up a BBS. MySQL is installed and running OK.
Database Server Hostname / DSN:
Database Name:
Database Username:
Database Password:
Prefix for tables in database:
How do I set the cache limit? Any suggestions on optimizing mySQL?
At 07:05 PM 11/21/2002 +0100, Joseph Bueno wrote:
You can expect that your operating system will use the remaining
memory as a file cache that will speed up your databases accesses.
We don't have that much memory our dedicated
Hi There,
In my ongoing project one of my application is
building reports and Printing them from a Remote
access Machine..
Actually i have done the whole project in ASP, IIS,
Access-2000. but the problem is IIS has Restricted
number of users(10) on WIN 2000 prof.
So, instead of buying an MS
Mysql gives what I'd call incorrect output when outputing week and years at
the end of the year.
PHP handles this correctly -- if I do a date(W-y, $date) for '2001-12-31'
I get '01-02', but in mysql you get the wrong year: '01-01'
Here's the an example (the second one is not what I'd expect):
PHP handles this correctly -- if I do a date(W-y, $date)
for '2001-12-31'
I get '01-02', but in mysql you get the wrong year: '01-01'
I don't know where you got this data from, but the second number would be the year,
that means mysql is showing the right year and php is showing the wrong
PHP handles this correctly -- if I do a date(W-y, $date)
for '2001-12-31'
I get '01-02', but in mysql you get the wrong year: '01-01'
I don't know where you got this data from, but the second number would be
the year, that means mysql is showing the right year and php is showing the
wrong
Hello all,
What does it mean to be in the Repair with keycache state, and how do I
fix this?
I am running MySQL v3.23.36 on a Red Hat 7.1 machine. One of my tables has
about 21,000,000 (21 Million) records in it. I am trying to index one of
the fields with the alter table command:
mysql
I don't know about incorrect, but confusing, sure. It is easy to
predict what is going to be returned based on the documentation.
On Thu, 2002-11-21 at 14:19, Joe Siegrist wrote:
I don't agree that mysql is 'right' here though, I realize that if you
simply strip out the year for the date it
Thanks to all you for helping me, I still can't connect, but now i know that
it is an issue of the delphi. I'll keep trying and researching.
Patricio
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, November 20, 2002 1:07 AM
http://www.mysql.com/doc/en/INSERT_SELECT.html
You cannot select from the table you are inserting into. Insert into a temp
table and then insert into holds from that table.
-Original Message-
From: Eric [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 21, 2002 1:14 PM
To: [EMAIL
http://www.mysql.com/doc/en/SHOW_PROCESSLIST.html
Repair with keycache - The repair code is using creating keys one by one
through the key cache. This is much slower than Repair by sorting.
It is going to take a long time to build an index on a table that big,
especially if you still have
Hi, all,
sql, query.
I try to use a mysqldump file from development database and insert back into
production database on another server.
bkp_dbname.sql is copied over to prodution, and I am using the following
command at production.
shell mysql -ujqu -pjqu1234@ dbname bkp_dbname.sql
File
At 22:10 + 11/21/02, Jannie Qu wrote:
Hi, all,
sql, query.
I try to use a mysqldump file from development database and insert
back into production database on another server.
bkp_dbname.sql is copied over to prodution, and I am using the
following command at production.
shell mysql
I have a DATETIME column, indexed, which I store both a date and time in, as
expected. However, I often want to select all rows for a given date,
regardless of time.
I've played around with a couple different methods, but the only way I can
see to use the INDEX (according to EXPLAIN) is doing a
Hello Jennifer,
Thanks for your reply.
At 02:07 PM 11/21/2002 -0800, Jennifer Goodie wrote:
http://www.mysql.com/doc/en/SHOW_PROCESSLIST.html
I guess I have an older/different version of the doc's. I was using the
version that came with the Windows install of MySQL. Thanks for the URL.
At 22:40 + 11/21/02, Jannie Qu wrote:
Hi, paul,
I got some error when using:
mysql set foreign_key_check=0;
ERROR 1064: You have an error in your SQL syntax near
'foreign_key_check=0' at line 1
mysql select version();
+-+
| version() |
+-+
| 3.23.53-log |
Hello,
Adding an irrelevant second column to an index instead of
just a single column index gives an incredible speedup and
I don't know why!
(server version: 3.23.53a running P133 32 megs ram - not a speedy
machine)
I have a bunch of records with the relevant columns being:
id
At 04:41 PM 11/21/2002 -0600, Robert Citek wrote:
So, now I know that repair with keycache is slower than repair by
sorting. What can I do about that? That is, how can I make the repair
use sorting? I would have thought they would be part of the alter table
... syntax, but I haven't seen
On 21 Nov 2002, at 14:38, Hans Zaunere wrote:
I've played around with a couple different methods, but the only way I can
see to use the INDEX (according to EXPLAIN) is doing a query along the
lines of:
... WHERE thecolumn BETWEEN '2002-11-17' AND '2002-11-18'
You don't explain what you
In the last episode (Nov 21), [EMAIL PROTECTED] said:
Adding an irrelevant second column to an index instead of just a
single column index gives an incredible speedup and I don't know why!
If you then remove the index, is it still fast? Maybe you are just
seeing the results of mysql rebuilding
On 21 Nov 2002, at 15:18, Hans Zaunere wrote:
Because it seems ineffncient to me, as MySQL must be doing more work to
calculate the range. Even EXPLAIN tells me this, by showing that a
less-than-optimal TYPE is being used. Although WHERE thecolumn =
'2002-11-17' doesn't yield any results,
Dan, thanks for your reply.
When I changed the table definition to use the single index and
the multi-index I reloaded the data from scratch each time.
(I did the trials many times from scratch just to be sure and I
do get consistent results)
I also just did an optimize table as you suggest
--- Keith C. Ivey [EMAIL PROTECTED] wrote:
On 21 Nov 2002, at 14:38, Hans Zaunere wrote:
I've played around with a couple different methods, but the only way I
can
see to use the INDEX (according to EXPLAIN) is doing a query along the
lines of:
... WHERE thecolumn BETWEEN
Hi Eric,
thats oracle function INSERT INTO ... SELECT. it doesn't work in
mysql.
Mirza
[EMAIL PROTECTED]
__
21.11.2002 22:13
Hi,
This should work, I think, but doesn't
INSERT INTO holds (ord_num)
SELECT orders.ord_num FROM orders
Hi,
Yes it works, but you can't insert and select data from the same table with
this syntax.
Regards,
Jocelyn
- Original Message -
From: Mirza Muharemagic [EMAIL PROTECTED]
To: Eric [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, November 22, 2002 12:30 AM
Subject: Re: INSERT
We are trying to setup the following MySQL replication
MSSQL Server - Push replication to Server 1
Server 1 - (Receives push replication from MSSQL and is Master MySQL for
Server 2)
Server 2 - (Slave to Server 1, Master for Server 3)
Server 3 - (Slave to Server 2)
Okay to make a long story
Hello,
I am trying to figure out how to use the NOW() function with a MySQL Insert
command on a Timestamp field.
Here is my mysql command:
INSERT INTO $tablename
(sender, recipient, whenread, whensent, subject,
messagetext, folder, priority, condition)
VALUES
('$directorid', '$SendTo',
INSERT INTO $tablename
(sender, recipient, whenread, whensent, subject,
messagetext, folder, priority, condition)
VALUES
('$directorid', '$SendTo', '00', NOW(), '$SetSubject',
'$MessageText', 'Inbox', '$SetPriority', 'TO')
Easy as that!
j- k-
mysql, sql
--
Joshua
1 - 100 of 113 matches
Mail list logo