Hi!
I need some help...
Since Friday I updated our MySQL-server from 3.23.32 to 3.23.39 by
deinstalling the old version (I did not use patches), because we need to
use transactions. I set default-table-type to BDB.
Our OS ist WinNT ServicePack 5, we use mysqld-max.exe .
Everything works fine, e
On Tue, 26 Jun 2001 16:21, [EMAIL PROTECTED] wrote:
> 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,table
>
> If you just reply to th
Mika Sjöman wrote:
>
> Hi...
>
> The only cause that I´m on this list is because Blueworld is makeing Lasso
> Professional 5 with built in MySQL database server.
>
> Because I am a Mac person I´m used to the powers of text string calculation
> in Filemaker pro.
> The information I have got, tel
Hi!
Last time I sometimes get this messages:
ERROR 1049: Unknown database 'stat
Database exist and I put many records to tables in this DB.
But sometimes I get this message.
This DB have many tables, now ~730.
Why I get this messages. Can I fix this?
PS
OS - FreeBSD 4.3-STABLE
max open file -
On Tue, 26 Jun 2001 16:08, Nick Kostirya wrote:
> Hi, All.
> Help me to understand why such different speed of two queries. These
> queries do the same and differ only in superfluous information (marked
> by red). Speed of the first is 0.37 second. Speed of the latter is 3.95
> second.
> Best R
hi everybody,
i have a problem with installation of mysql ++ api 1.7.9.
os: sun solaris 5.6
mysql version 3.23.33
after unpacking the archive with tar, autorun and autoconf i started configure.
everything was working fine ,
but "make " gave me the following message:
Hi,
I had a similar problem while compiling the Msql-MySQL perl module for
HP-UX 11.00. In the end I (apparently) solved it by running the configure, then
editing the Makefile in libmysql (and libmysql_r), and adding "-fpic" to the
"CFLAGS=" and "CXXFLAGS=" lines.
Hope this helps.
Any idea when we'll be able to get our grubby little paws on VCC?
I was trying out mysqlgui last night, and i found it did'nt add much
to using the command line client, So i'd be interested to see where you
are going with it.
Thanks
Sean
-Original Message-
From: Sinisa Milivojevic [mai
hiya,
I've had exactly the setup you describe running on a laptop,
(I've since switched to nt / linux ), download mysql,myodbc,
and optionally mysqlfront. Just run the setup programs for mysql
and myodbc (very easy), and you are all set up. If you create
a odbc connection for you database you c
Nick,
What happens to the time if you run the following on your database:
SELECT DATE_FORMAT(visits_1.date_time_visit, '%Y-%m-%d') AS dt,
Count(DISTINCT visits_1.id_visitor) AS cnt, visits_1.id_visitor,
visits_1.id_visit, visits_2.id_visitor, visits_2.id_visit,
visits_1.visit_number, visits_2.vi
hello
I am engeneer and i use mysql .
can you help me please in this questions:
1- tell me what is the language(arabic,french,english...) of the mysql
database data.
2- can we create a database that contain melange of arabic and latin data if
it is possible , how?
TH
Hi,
Even i am getting the following error while doing ./configure:
os: solaris 8 sparc
mysql: 3.23.39
/configure
loading cache ./config.cache
checking host system type... sparc-sun-solaris2.8
checking target system type... sparc-sun-solaris2.8
checking build system type... sparc-sun-solaris2.8
che
We're having quite a lot of difficulty with MySQL's fulltext search. The
problem is that it does partial matches. E.g., john matches johnson. Thus
a match of author against dickens takes about 0.09 seconds with a 700,000
record table, but a match of a shorter word takes a good deal longer - a
four
hey bob,
thanks for getting back to me - here's the full set up
i have a pc running windows98, apache, php and mysql. it sits on our
ethernet network and i connect to it via my mac using the ip address i have
set up in the network control panel on the pc. i use the mac for building
and the
Hi All,
I've been reading up on how to do joins on the mysql site.
Is there not an inverse function for DISTINCT, so that I can pull out
duplicate data as opposed to DISTINCT data...or will I have to get this
information by using joins?
Thanks very much for your help.
Anna
Your question has been answered already.
http://marc.theaimsgroup.com/?l=mysql&m=99348999221821&w=2
> Hi All,
>
> I've been reading up on how to do joins on the mysql site.
>
> Is there not an inverse function for DISTINCT, so that I can pull out
> duplicate data as opposed to DISTINCT data...o
Hi,
I have a Linux machine (Linux cartman 2.4.2-2smp #1 SMP Sun Apr 8 20:21:34 EDT 2001
i686 unknown) that is running MySQL 3.23.38-log and now I have a table that is getting
VERY near to the ext2 filesystem limitation of 2gb. Exact size of the table is:
2039867196 :) So my question is. What h
Hello there - I have this weird problem using MySql (version 3.23.39).
It seems that MySql interpretation of a SELECT statment using HAVING is
completely random.
I have a table called RobotRun which stores information about when a robot
has been running (start, stop and the id of the robot). Thi
Hello Matthew
I would be quite interested to know how you managed to make a
partial search. I built a search engine recently using fulltext, and
partial searches would never work. Say I type in child, I would never
get any results with children.
This is quite weird since you seem to want it the w
Hello everybody,
I thing, that I have a problem that needs a sequence and that
auto-increment can't do the job this time.
I already consulted the manual and the mailarchive.
I saw several different proposals, now I'm a bit confused and don't
know exactly what the rigth way is to do it.
Could s
If you searched for '% john %' - note the spaces, you would not find
'johnson' etc..
-Original Message-
From: Matthew Brealey [mailto:[EMAIL PROTECTED]]
Sent: Tue, 26 June 2001 11:29
To: [EMAIL PROTECTED]
Subject: Full text search gotchas
We're having quite a lot of difficulty with MySQ
Partial searches can be done with 'LIKE', i.e.:
SELECT * FROM yourtable WHERE somefield LIKE '%searchstring%'
The '%' is MySQLs wildcard here, so if you only want strings starting with
your searchstring, use 'searchstring%'
Regards,
Sebastiaan J.A. Kamp
> Hello Matthew
>
> I would be quite i
At 13:53 +0200 2001-06-26, Bruce Stewart wrote:
If you searched for '% john %' - note the spaces, you would not find
'johnson' etc..
*Sigh* Since when do wildcards work with the fulltext index?
Besides, there are characters beside a space wich can delimit words.
Three examples: Commas. Line br
Hello,
thanks for your reply. I was wondering...I thought the LIKE function
is only for single words? I have to admit I never tested it and started
right off with fulltext option.
So would following work then...
Lets assume one entry in somefield is: "The children are playing on the
play-ground"
mysql> select * from test;
+---+---+
| a | b |
+---+---+
| 1 | The children are playing on the play-ground
David Robley writes:
>
>
> I came across this discussion from April 2001 on the archives, but
> nothing more recent. I also have encountered the problem, and thought I
> could submit a bit more information.
>
> OS - Linux 2.4.3
> XFree - 4.0.2
> KDE- 2.1.1
>
> The problem is not exa
Peter Volke writes:
> hi everybody,
> i have a problem with installation of mysql ++ api 1.7.9.
> os: sun solaris 5.6
> mysql version 3.23.33
>
> after unpacking the archive with tar, autorun and autoconf i started configure.
> everything was working fine ,
> but "make " gave me the following me
[EMAIL PROTECTED] writes:
> Any idea when we'll be able to get our grubby little paws on VCC?
> I was trying out mysqlgui last night, and i found it did'nt add much
> to using the command line client, So i'd be interested to see where you
> are going with it.
>
> Thanks
>
> Sean
Regarding mysq
On Mon, Jun 25, 2001 at 06:52:34PM +, patrick ward wrote:
> Hello Mr. Ziegler,
>
> I'm sorry if I'm intruding and promise not to do so again without your
> consent but our db replication has come to a grinding halt with the error
> 'bad magic number, fire your magician'. I'm at my wits en
At 13:49 +0200 2001-06-26, Gunnar von Boehn wrote:
>Lets take a single row, integer value for holding the sequence:
>CREATE TABLE sequence(
> id int4;
>);
That works, though I would use a single table for all sequences, not
a new table per sequence.
The other solution would be to do check the
According to the MySQL documentation, it doesn't currently support full
outer joins and won't do in the immediate future. Does anyone have any
suggestions for a workaround?
I need to join three tables, only one of which has a common identifier with
the others, and produce a result which shows
Hi,
what does mean following ...
mysql> show processlist;
++--+---+--++---+-+--+
| Id | User | Host | db | Command| Time |
State | Info |
++--+---+--
Ok
Each Status ID is a thread and you can kill them with KILL "thredidnumber".
Delayed insert is just a sql insert command that has low priority.
Sleep is a thread that is kept open incase you would like to use it agene.
Question: How many thread do you allow on your set-up?
You have hit 102 thr
Guðmundur Ólafsson <[EMAIL PROTECTED]> writes:
> Hi,
>
> I have a Linux machine (Linux cartman 2.4.2-2smp #1 SMP Sun Apr 8
> 20:21:34 EDT 2001 i686 unknown) that is running MySQL 3.23.38-log and
> now I have a table that is getting VERY near to the ext2 filesystem
> limitation of 2gb.
Ext2 does
Running Unix, Apache, MySQL and PHP, should I worry about delay times, and
will the server always present the user with the latest database update
(after a possible delay)?
Suppose a user can add a new row to a database in a PHP page with a form,
and after submit, the next page he will see is
lipp & maimone wrote:
> is someone abble to tell me how can i do for running an sql database with windows98
>without crashing my systeme?
> Also, using asp ( activex server page ), is it possible with mysql version3,23?
>
>
Its most likely that you don't have enough memory on your system. If
Hello,
I am developing a data application using wxWindows 2.2.7 on Redhat
Linux 7 with MySQL at back-end. When I try to connect to MySql
Database sometimes it says Segment fault (Core dumped) error.
Pls help.
Sudheer.
-
B
Hello,
I am developing a data application using wxWindows 2.2.7 on Redhat
Linux 7 with MySQL at back-end. When I try to connect to MySql
Database sometimes it says Segment fault (Core dumped) error.
Pls help.
Sudheer.
-
B
Sudheer Palapparambil <[EMAIL PROTECTED]> writes:
> I am developing a data application using wxWindows 2.2.7 on Redhat
> Linux 7 with MySQL at back-end. When I try to connect to MySql
> Database sometimes it says Segment fault (Core dumped) error.
Which version of mysql?
--
Trond Eivind Gl
Please send relevant pieces of code!
> Hello,
>
> I am developing a data application using wxWindows 2.2.7 on Redhat
> Linux 7 with MySQL at back-end. When I try to connect to MySql
> Database sometimes it says Segment fault (Core dumped) error.
>
> Pls help.
>
> Sudheer.
---
How do I define cursors in mysql as in Oracle?
Here is an example in Oracle:::
Cursor CurPerson is
Select Arstall_Godkj_Stkomp
From Person
Where Fodselsdato = inFDato And
Personnr = inPNr;;
Begin
Open curPerson;
Fetch CurPerson i
I am administering a MySQL database that needs to be accessed by people who
don't know SQL. They need to be able to add and delete records, but they
don't need to be able to alter the structure of the database. Does anyone
know of a simple Windows app or web interface that I can throw on my
Try PhPMyadmin
http://phpwizard.net/projects/phpMyAdmin/index.html
Simon
-Original Message-
From: Mike Schwartz [mailto:[EMAIL PROTECTED]]
Sent: 26 June 2001 16:33
To: [EMAIL PROTECTED]
Subject: Simple Graphical Interface
I am administering a MySQL database that needs to be access
A simple question...
I noticed that the newer MySQL binaries are listed as being for Solaris 2.7+
(mysql-3.23.39-sun-solaris2.7-sparc.tar.gz)
I want to run it on Solaris 2.6, will this run OK??
There didn't seem to be any docs relating to this (would be nice to see
these kind of comments in the
Try
SELECT robotId, max(startTime) as crit
FROM RobotRun
WHERE startTime >= '2001-06-26 00:00:00'
AND endTime IS NOT NULL
GROUP BY robotId
This should return the robotId and the most recent startTime labeled 'crit'
for all records specified in the where clause. And have a look in the manual
for
Slight correction in the query...
> The query just looks like:
>
> REPLACE into reflectivity.measurement_extended_data set content_typeID =
> 7, contentID = 121529, arrayID = 0, positionID = 1, testID = 1,
> iteration = 0, test_locationID = 1, date_added = 993165848, added_by = 18,
> data =
Just installed 3.23.37 on Red Hat 7.0 from source. I've done this a few
times but this time I encountered a mysterious problem.
a) server is started and runs under my designated user (mysqladm:mysqlgrp)
b) /usr/local/mysql/bin is in PATH of both root and mysqladm
c) using either of these users,
> The above only implies that your program exited without calling
> mysql_close(). Nothing to do with your problem.
>
But.. why would the console be reporting this? Ie, I'm getting the same
result (same error in the error log, same truncation) when I manually
pipe the query to the mysql console.
Hello, I cannot find a COPY RECORD command in www.mysql.com - is it to be
found under another name? I have a 49 field record I have to create this
morning. Ugh.
-
Before posting, please check:
http://www.mysql.com/manual.php
I have a MySQL myISAM database that has about 300 MB of information.
Recently the index files became corrupted and I ran the myisamchk
*.MYI -r -S to repair them.
Ever since then mySQLd process has been using up a ton of processor time.
And some of the queries that I run have started taking a lon
Could it be that you have two mysql client binaries accessing two different
config files - some remainders of a previous MySQL installation?
Hannes
On 6/26/01 9:02 AM, "Peter Matulis" <[EMAIL PROTECTED]> wrote:
> Just installed 3.23.37 on Red Hat 7.0 from source. I've done this a few
> times
You must have an rpm installation of mysql and your source installation.
Check to see if there are mysql* commands within /usr/bin directory. It's
going to search there first, then /usr/local/bin. The commands within
/usr/bin are going to look for the mysql-everthing within /var/lib/
Jonathan
---
Hi Gunnar,
Why don't you keep the key out of the business rule and create a column to
identify the type of customer?
How are you going to handle the application when your business reaches more
than vip customers???
This is an issue that can be avoided by creating a type column .
Siomara
Hi Tom,
The solution to your problem could be simple if the redundancy is across all
fields. Then you could simply issue a
CREATE table distinct_records
SELECT distinct field_1,.field_last
FROM table_duplicate_records
WHERE 1=1;
Or
CREATE table distinct_records
SELECT field_1,.field_la
Hi, I don't know if you can use 2.7+ in a 2.6.
However I downloaded and compiled the source without no problems. Until now it's
running ok.
Please, tell me if I can help!
{}S
Jose Vilmar Estacio de Souza
MailTO: [EMAIL PROTECTED]
+ 55 21 7894-3041
INFORMAL INFORMATICA
http://www.informal.
I had the same problem last night,
eventually grant all to root on *.* identified by 'yourpass' got me in
I must have mucked up the permissions at
(the problem was with mysqlgui not mysqlshow though)
Sean
-Original Message-
From: Peter Matulis [mailto:[EMAIL PROTECTED]]
Sent: Tuesday,
On Tuesday 26 June 2001 04:49, Gunnar von Boehn wrote:
> Hello everybody,
>
>
> I thing, that I have a problem that needs a sequence and that
> auto-increment can't do the job this time.
>
> So, I think the only way to solve this is a sequence table.
>
> Lets take a single row, integer value for h
NUMBER(8,5). You'll need around 5 digits after the decimal point. (Think GPS
accuracy == 10 meters for high-grade, 100 m for dumbed-down civilian use. At
the equator, that's 0.9 or 0.0009 degrees respectively. At higher
latitudes, that'd be correspondingly less.)
If you value accuracy, DON'T
> Recently the index files became corrupted and I ran the
> myisamchk *.MYI -r -S to repair them.
Try an OPTIMIZE TABLE or ANALYZE TABLE. Your queries may be using the
incorrect indexes since the statistics have not been updated.
You can also do this: myisamchk *.MYI -a
Sincerely,
Steven Rouss
At 1:49 PM +0200 6/26/01, Gunnar von Boehn wrote:
>Hello everybody,
>
>
>I thing, that I have a problem that needs a sequence and that
>auto-increment can't do the job this time.
>
>I already consulted the manual and the mailarchive.
>I saw several different proposals, now I'm a bit confused and d
I want to prevent duplicate entries into my mysql database which holds
invertory of all network eqpt at my site. Engineers access it thru
netscape and the query insert is done via pdp [below].
I will place the script into php, any pointers on this would be
appreciated.
THX!
Pete
I appreciate that this might be a bit off topic but any help would be
appreciated.
I need to port this program (attached) to the Linux environment. This
is the first program I have attempted to port.
Has anyone ever had to port from Windows to Linux\Unix, and if so how
did it go and what tools
I searched the archives but couldn't find an answer...
Am I the only who has noticed that MySQL fails to
install properly on Solaris platforms? (at least Solaris 7).
Specifically the files under...
$(srcdir)/Data/ATIS/*.*
$(srcdir)/Data/Wisconsin/*.*
$(srcdir)/Results/*-*
$(srcdir)/Results-win3
The OS may not have a 2GB limit, however the table MAY. If you do a
myisamchk on the table it will tell you if you are running out of space in
the table. If you are.. you need do something like "alter table tablename
max_rows=1000".. (its in the manual)
ryan
> > I have a Linux machine (Linux
-- Original Message --
From: Pete Kuczynski <[EMAIL PROTECTED]>
Date: Tue, 26 Jun 2001 13:19:02 -0500
>I want to prevent duplicate entries into my mysql database which holds
>invertory of all network eqpt at my site. Engineers access it thru
>netscape and t
It's possible get the number of years between two dates in a mysql
function?
thanks,
Augusto
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list arc
Yes, I've read the docs on JOIN syntax, and search the list archives for
similar information.
I have this query:
SELECT leg_activity.activity_date, leg_transitions.trans_desc,
leg_text.leg_version, body_list.body_name
FROM (((leg_version_hist RIGHT JOIN (leg_comm_hist RIGHT JOIN leg_activity
Hello,
I was wondering, how can I lookup how much memory MySQL is currently allowed
to use, and how can I change this value?
Thanks in advance,
Leon Mergen
[EMAIL PROTECTED]
BlazeBox, Inc.
ICQ: 55677353
-
Before posting, plea
How do I get a default date time in the create table clause...
I have tried
Create table(
CreationDateDATETIMEDEFAULT NOW(),
Infovarchar(100)
);
Create table(
CreationDateDATETIMEDEFAULT "NOW()",
Infovarchar(100)
);
Create table(
Creat
Hi... I downloaded the mysql binary for HPUX10.20 and when I run
script/mysql_install_db I got the followin message:
---
$> scripts/mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
How do I get a default date time in the create table clause...
I have tried
Create table(
CreationDateDATETIMEDEFAULT NOW(),
Infovarchar(100)
);
Create table(
CreationDateDATETIMEDEFAULT "NOW()",
Infovarchar(100)
);
Create table(
Creat
Hi,
i found a method to do this:
try
extract(year from date1) - extract(year from date2)
I hope it will work
Michael
-Ursprüngliche Nachricht-
Von: Augusto Cesar Castoldi [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 26. Juni 2001 19:06
An: [EMAIL PROTECTED]
Betreff: Getting
hallo!
i have a backup-problem:
when i use
mysqldump -u michael -p --opt --all-databases > backup
i get the following error:
USE backup;
mysqldump: Got error: 1017: Can't find file: 'title.MYD' (errno: 2) when
using LOCK TABLES
but when i use
mysqldump -u michael -p --opt --database books >
I ran run-all-test with the following options.
---
run-all-tests --server=mysql --user=test --password=test --log
-
I got the following :
Can't locate DBI.pm i
Can Cold Fusion querys work with MySQL? What would I have to do if
anything to make it work?
WD
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list ar
(sql, to fool lame filter)
ryc <[EMAIL PROTECTED]> writes:
> The OS may not have a 2GB limit, however the table MAY. If you do a
> myisamchk on the table it will tell you if you are running out of space in
> the table. If you are.. you need do something like "alter table tablename
> max_rows=100
My primary key field is a auto incremented index, the field I want to
make unique, or to say, prevent duplicates in, is the hostname field,
which has, hostnames of devices. Is the key word UNIQUE then?
Not all of the devices have hostnames assigned to them, like terminals,
so the hostname field
Install an ODBC for MySql...
- Original Message -
From: "Wade DeWerff" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 26, 2001 2:57 PM
Subject: CF and MySql?
> Can Cold Fusion querys work with MySQL? What would I have to do if
> anything to make it work?
>
> WD
>
>
> --
There are many ways to do this - I'm assuming you want to do this on an
Windows box.
One way is through MyODBC. It's an ODBC driver that you can install on your
server, available from the MySQL web site. From there, all you have to do is
create a new DSN, either through the CF Admin or Windows. Y
If you are using Cold Fusion server, yes they will work..
You have to download MyODBC from www.mysql.com install it.. and then set it
up in the ODBC control panel (assuming you are using windows).
Then you should be able to see the mysql databases as a datasource in the
Cold Fusion admin page.
Has anyone ever attempted, or succeded in converting a Btrieve database to a
MySQL database?
Peter Marchetti
Media Visions, Inc.
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
I have used optimize table on several tables however it has not affected the
speed of the queries or the large amount of processor resources that are
being used.
Have you heard of a way to rebuild a table more efficiently?
-Original Message-
From: Steven Roussey [mailto:[EMAIL PROTECTED]
hi.
check out the TIMESTAMP column type...maybe TIMESTAMP(14) as the column
type?
you can then format the date accordingly with...uh...DATE_FORMAT() in your
select statements...
hth.
-ravi
-Original Message-
From: Richard Bates [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 26, 2001 3:
At 3:05 PM -0300 6/26/01, Augusto Cesar Castoldi wrote:
>It's possible get the number of years between two dates in a mysql
>function?
That kind of depends on what you mean by the number of years between
two dates. For example, do you define the number of years between 2000-12-31
and 2001-01-01
At 2:43 PM -0400 6/26/01, Richard Bates wrote:
>How do I get a default date time in the create table clause...
The MySQL Reference Manual states that DEFAULT values must be constants.
Insert NOW() into the field when you create new records.
>
>I have tried
>
>Create table(
> CreationDate
On Tue, Jun 12, 2001 at 04:42:42PM -0700, Jeremy Zawodny wrote:
> On Tue, Jun 12, 2001 at 05:06:59PM -0500, Zhu George-CZZ010 wrote:
> >
> > Is there a way/tool to migrate the Application from MySql to Oracle
> > 8i?
>
> Oracle has one available on their web site...
Mostly a waste of space.
Ti
But how about TIMESTAMP?
For example:
CREATE TABLE time_test (creation_date TIMESTAMP, info VARCHAR(100));
This should work fine too,doesn't it?
-sherzodR
On Tue, 26 Jun 2001, Paul DuBois wrote:
> At 2:43 PM -0400 6/26/01, Richard Bates wrote:
> >How do I get a default date time in the cre
Can someone explain me why is it waste of space???
Thank you
-sherzodR
On Tue, 26 Jun 2001, Tim Bunce wrote:
> On Tue, Jun 12, 2001 at 04:42:42PM -0700, Jeremy Zawodny wrote:
> > On Tue, Jun 12, 2001 at 05:06:59PM -0500, Zhu George-CZZ010 wrote:
> > >
> > > Is there a way/tool to migrate th
Ok,
The message set that I noticed this morning sparked my interest in this.
Currently I'm developing a search engine that will utilize mysql's
fulltext match technology. The problem that i've run into is, I can't
seem to find any documentation on how to force an AND search with in
MATCH AGAIN
Is their a C++ API library which is able to work on BOTH Windows (2K)
and Linux.
I need the SAME library to work on both platforms. I take it neither of
the top two will work (list below): Borland or MS libraries. What are
the other two.
I need to write a program which is portable to both wind
-- Original Message --
From: Pete Kuczynski <[EMAIL PROTECTED]>
Date: Tue, 26 Jun 2001 14:02:08 -0500
>My primary key field is a auto incremented index, the field I want to
>make unique, or to say, prevent duplicates in, is the hostname field,
>which has, h
On Tue, Jun 26, 2001 at 05:20:25PM -0400, Sherzod Ruzmetov wrote:
>
> Can someone explain me why is it waste of space???
No support for emulating autoincrement fields.
No support for mysql specific types.
No support for mysql specific functions.
No support for ...
In fact no support for almost
I'm not an expert, but I've never heard of a db getting slower after an
index rebuild. It's possible that's just a red herring.
You've been speaking generally about things being slower, I'd suggest you
get specific. Track down the queries are slow now, use EXPLAIN on them to
see what indexes
hello all,
I am kind of new to all the unix OS stuff. Lately i have been doing alot of work
in FreeBSD, and i have started playing with mysql. I got it to install and
everything, the only problem i am having, is i can't seem to connect from anywhere off
the machine, i run the "grant privi
Hi to all,
I'm new to linux and mySql (about 5 days and nights :)), I have mandrake8.0
that provide a version of MySql which I'm trying to use from a VisualBasic
application (on win2000), I connect to my database on MySQL using MySqlODBC,
and everyting goes OK, except the table names wich I need t
Don't know what a COPY RECORD command is but my best guess is that you are
looking for a create table with a select clause.
- Original Message -
From: "Klein, Tracy ISTA:EX" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 27, 2001 0:11
Subject: Copy Record command
> He
And what is the command you are using to connect?
- Original Message -
From: "Jason Brunk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 27, 2001 7:00
Subject: Newbie
hello all,
I am kind of new to all the unix OS stuff. Lately i have been doing
alot of work in
On Tue, 26 Jun 2001 22:29, Sinisa Milivojevic wrote:
> David Robley writes:
> > I came across this discussion from April 2001 on the archives, but
> > nothing more recent. I also have encountered the problem, and thought
> > I could submit a bit more information.
> >
> > OS - Linux 2.4.3
> > X
> I have used optimize table on several tables however it has not
> affected the
> speed of the queries or the large amount of processor resources that are
> being used.
>
> Have you heard of a way to rebuild a table more efficiently?
Go back and do this:
myisamchk -o *MYI
myisamchk -a *MYI
myisa
Did you convert the table/column names to lower case? If
"lower_case_table_names is=1" MySQL will convert all table names to lower
case on storage and lookup ... but you need to first convert your old table
names to lower case before starting mysqld.
If you have not done so, you should run an ALT
1 - 100 of 128 matches
Mail list logo
