> I am trying to determine when it is best to use
> varchar and when it is appropriate to use tinytext. I
> have looked at the manual and have read the difference
> between them but would like to have an understanding
> of this in more practical, real-life terms.
>
> Is a space between character
Note, that if you *really* want to speed things up,
you should make sure all your search fields are
BINARY (case sensitive).
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
> CHAR() is the quickest.
>
> Fixed width is almost
> Firstly, text is a reserved word in mysql. Secondly, varchars or chars
> can only have 255 characters. You should use a text type column which
> can be very large (megabytes!). You have read the manual on the
> different field types?
Clearly, he *did* read up on the field types in the manual an
On Fri, Jan 26, 2001 at 10:39:46AM -0600, Patrick Goetz wrote:
>
> Thanks for the response.
>
> On Thu, 25 Jan 2001, Jeremy D. Zawodny wrote:
> > > It just occurred to me, however, that this becomes a much bigger
> > > problem when the web server(s) and the database server are running
> > > on d
Here is the fix.
There is another reason. This happened to me on RH7.0. The mysql-
server3.23.22-6 rpm installs in /var/lib/mysql with 'ls -l' = "drwx-
--", meaning only root has access. Since directory permissions must
match for the PF_UNIX socket to work, you have to 'chown -R' this to
th
I think that is the wrong answer ... Standard-SQL and ANSI-SQL require that
a column that is displayed
and has no grouping function applied to it MUST also appear in the GROUP
BY-clause!!!
The result:
fldNAME fldMONAT sum(fldSALARY)
boris 1 10200
stephan 1 6000
i
On Sat, 27 Jan 2001, Marcelo wrote:
> I'm trying to use libmysqlclient as
> described in the manual to compile
> another program in SCO Open Server
> Release 5.0.5, whe i tri to do
> gcc -O2 -g -o mysql1
> mysql.c -L/usr/local/mysql/lib -lmysqlcl
> ient -lnsl i get this messages can
> someon
I'm trying to use libmysqlclient as
described in the manual to compile
another program in SCO Open Server
Release 5.0.5, whe i tri to do
gcc -O2 -g -o mysql1
mysql.c -L/usr/local/mysql/lib -lmysqlcl
ient -lnsl i get this messages can
someone help me.
Undefined first
You are right that RedHat is funny. 7 really seems weird. I tried for two
days to get everything going, (still am) and ran into all kinds of errors
with Mysql. I tried different versions, and had different problems on each.
I finally ran up2date to get everything update, and thought that would do
Hi,
I installed mysql 3.23.32 in my linux machine. Unfortunately,
when I try to compile an application I get the following error:
libmysqlclient.a (my_compress.o): In function my_uncompress
undefined reference to uncompress..
could you please help me to find the compress/uncompr
>Thanks for the reply Bob,
>
>May I ask then what is the purpose of the SET(...) datatype ?
It has some peculiarities that make it useful sometimes. Among other
things, the values are actually stored as numbers, which can be handy
when you're sorting.
>In the past, I've always avoided it since
Does anyone know how to sort and recreate auto_increment field from, for example,
to
1
2
3
4
without creating any additional tables?
For example, I have a table
value position
3001
1002
5003
2004
I have to update position ordered by value, and table must look like this
value position
3003
1001
5004
2002
Is it possible t
I'm running Slackware Linux (2.0.36) and just set up a
binary version of MySQL 3.23.32. I followed the
directions exactly and all looks to be fine. However,
when I try and start MySQL by using typing
bin/safe_mysqld --user=mysql &
I get the following error:
www:/usr/local/mysql# Starting mysq
I've heard that redhat 7 is not that good. They implant many beta version
code inside.
Sam
- Original Message -
From: "Mike Tuller" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 27, 2001 9:10 AM
Subject: Error 2002: can't connect to mysql.sock
> I recently upgrade
Redhat is funny. I have 7 and had tried everything in the books to
get mysql back up and running after a shutdown. Fortunately, I had an
experienced programmer who had helped me set it up. I queried him and
set back this command:
/etc/rc.d/init.d/mysqld restart
That did the tric
I recently upgraded to RedHat 7, and now I can't get Mysql to start. I keep
getting error 2002: can't connect. I have looked at every piece of
documentation, and can't find the solution. The mysql.sock file exists, but
it still can't connect.
I have used the rpm of version 3.23.32 to install ever
Greetings all,
I have installed PHP 4.0.2 and MySQL 3.22.32 and Apache 1.3.12 on a Sun
Sparc 20 running Solaris 2.6. I can now
connect just fine using the mysql client and can run queries, etc.
However, when I try to do the normal connection
transaction using PHP Scripts, I get an error that say
http://www.mysql.com/doc/M/a/Mathematical_functions.html
Please please please read manual before asking questions.
SELECT SUM(minutes) AS ttltime, user FROM table WHERE user = 'someuser'
GROUP BY user
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, J
I know this is probably a simple thing, but what I would like to
be able to do, is to query a specific account name for minutes each day
and then have those minutes ADDED up to show the current total time
online.
My database has all of the info in the table, all I want to do is be
able
You can tell MySQL to use (lots) more RAM to cache Index Keys by setting
an explicit value for its key_buffer variable. You can use the
SHOW STATUS query to determine the cache hit rate by comparing these
two values: Key_reads versus Key_read_requests. Key_reads divided by
Key_read_requests would
I am a customer to a web designer that I have since cut relations with.He
left me high and dry and I am left to my own devices to ftp my web site to
another hosting co. Is there a driver exclusively for ftp work that you can
sell me; with step by step instructions of how to use it. or is the
You can create a "MERGE TABLE" (read all about it in the manual)...
CREATE MERGE TABLE everything ( animalname varchar(25)) TYPE=MERGE
UNION=(table_1,table_2);
Thereafter, you can select * from everything;
Cheers,
Kent Hoover
---
Hi,
There was a bug in 3.23.31 (I think) with fultext indexes. Was this fixed in
3.23.32?
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
-
Before posting, please check:
http://www.mysql.com/manual.php
Hi.
You posted to the wrong list. This list is for developing of MySQL itself.
As for your problem, MySQL does not have a good solution at this point. Have
you tried using the BACKUP command? It will flush and lock the table and
copy only the data and .frm files. A RESTORE will rebuild the index
Hello,
Well I have linked zlib to my program and still have the same error message.
I check to make sure the include and lib files are in /usr/include /usr/lib,
my program compiles fine without statically linking in the libraries. This
is highly unlikely, but could this be a problem with glibc?
Hi,
Check that you have zlib installed and then just add -lz to the libraries
you will be linking with.
Regards
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.
Add -lz to your linking options and all should go well.
"Dave Juntgen" <[EMAIL PROTECTED]> wrote:
Hello everyone..
I am trying to compile a CGI program written in C statically and I keep
getting this one error. I am using MySQL version 3.23.31, the compiler
error below shows that it is lib
Hello everyone..
I am trying to compile a CGI program written in C statically and I keep getting this
one error. I am using MySQL version 3.23.31, the compiler error below shows that it
is libmysqlclient.a that is having problems.
Can anyone help?
-Lgd -lgd -lcrypt -I/usr/local/mysql/include
I was just wondering what the "USAGE" privilege is good for and where it
would be used?
Pauls's book says that USAGE is a special "no privileges" privilege.
___
Scott A. Gerhardt P.Geo.
Gerhardt Information Technologies
[EMAIL PROTECTED]
___
Thank paul. I know about Date_format, but was curious if there is some
setup parameters would allow us to define the MySql date format .
Paul DuBois wrote:
> On Fri, Jan 26, 2001 at 01:40:12PM -0700, Web master wrote:
>
>> Hello,
>>
>> I would like to change the default date format MySql from
Update, which may be helpful:
The number I'm getting back (which I said is vastly too high) is in
fact the number of pictures multiplied by the number of ratings entries
for that artist.
I wanted to be able to get those two groupings separately. Is there a
way I can do th
On Fri, Jan 26, 2001 at 01:40:12PM -0700, Web master wrote:
> Hello,
>
> I would like to change the default date format MySql from /mm/dd to
> dd/mm/. Does anyone know, how to make this change in MySql?
You can't.
However, you can select DATE, DATETIME, or TIMESTAMP values using
DATE_F
Hello,
I would like to change the default date format MySql from /mm/dd to
dd/mm/. Does anyone know, how to make this change in MySql?
Thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Hello Anna,
According to the MySQL Crash-Me the maximum numbers for 3.23.xx are:
- Columns in table 3398
- max table row length (without blobs) 65534
- table row length with nulls (without blobs) 65502
If you understand the concepts of DB normalization don't bother reading the
following:
300
As far as PHP is concerned, 4.0.4pl1 is not enough. You need to install CVS
version later than 2001-01-18. At least this is my experience.
Maciek
> -Original Message-
> From: tc lewis [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 26, 2001 8:47 PM
> To: Maciek Uhlig
> Cc: [EMAIL PROT
Hardware-wise, probably not. It might depend on your configuration.
On my server, the only IDE connection is dedicated to the CD-ROM.
Everything else, except the floppy, is SCSI.
Maybe one of the gurus here has a way around it, but I think your
indexes are part of your data.
It sounds like yo
Can somebody provide me with some sample code for the following. I read it
over in the manual but am still lost.
thanks
Randy
+++
Sounds like you want a mutex and you can use get_lock and release_lock in
mysql for that.
http://www.mysql.com/doc/M/i/Miscellaneous_functions.html
GET_LO
Hi--
I'm running an art archive, and for the artist listing pages I have to
come up with a query something like the following:
select name,dirname,sortname,pictures.artistid,count(pictures.artistid)
as imgnum,avg(rating) as rateavg,max(uploaded) as lastmod
from artists,pictures,r
so we upgraded to 3.23.32 last night, but i'm still seeing a ton of:
010126 11:15:24 Aborted connection 30757 to db: 'XXX' user: 'YYY'
host: `ZZZ' (Got an error reading communication packets)
type errors in the error log.
i'm seeing these errors from both php connections and from perl dbi
conne
Do it the other way around.
If insert fails, do the update.
Udate may fail, and before you insert, another tread could do the
insert.
Now your insert would fail, and your data would be lost.
Pål Wester wrote:
>
> Why not do an update regardless if the record exist or not,
> then insert it if y
Thanks for the reply Bob,
May I ask then what is the purpose of the SET(...) datatype ?
In the past, I've always avoided it since I assumed that any
search that uses LIKE '%x%' in a query would be slow. However,
I now have a table that will never grow to more than 5,000
entries and using the SE
Why not do an update regardless if the record exist or not,
then insert it if you get an error?
-Opprinnelig melding-
Fra: Artem Koutchine [mailto:[EMAIL PROTECTED]]
Sendt: 26. januar 2001 19:02
Til: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Emne: Re: If exists UPDATE else INSERT
I've seen s
assuming that each table only has one element, you could do a select * from
2 table.
If you don't and you need to combine everything, then you're trying to do a
UNION.
mySQL doesn't support UNION's yet.
one way to do a union is to create a temporary table then use two queries to
fill the
tempo
What do you mean "get stuck". You some kind of error or just
it does shows that it compiles it and makes you wait a lot.
Well, if you look a bit above you will see that the following
compile may take a long time and IT DOES TAKE A VERY
LONG TIME ON SLOW MACHINES.
So.. WAIT!
If you got error, then
Hi i think
SELECT table1.*, tabla2.* FROM table1, table2
-Mensaje original-
De: Mike Mike [mailto:[EMAIL PROTECTED]]
Enviado el: Friday, January 26, 2001 11:05 AM
Para: [EMAIL PROTECTED]
Asunto: Selecting * from 2 tables
Hello list,
How would you go about selecting * from 2 tables?
I
You can't do
select * from table_1 UNION select * from table_2;
1st the structures of both queries have to be exactly the same. Second, you
have to specify them in the select.
select animalType from table_1 UNION select animalType from table_2;
should work, assuming that you have a field named
Hello list,
How would you go about selecting * from 2 tables?
I have 2 tables: table_1 and table_2
In table_1 I have the following data.
dog
bird
cat
In table_2 I have:
mouse
rat
hampster
How do I show both tables contents like:
+--+
|dog |
|bird |
|cat |
|mouse |
|ra
Right, I trying to compile MySQL latest stable on FreeBSD 4.2 but I
get stuck sql_yacc.cc ..
Any pointers?
--
contact:
Dave Yadallee NetLine 2000 The Edmonton Internet Service Company
[EMAIL PROTECTED] http://www.nl2k.ab.ca
414-5359
-
Hi,
I am trying to install MySQL on my Sun workstation
which has Solaris 2.6 installed. I have completed
following steps
1. configure
2. make
After step 2 when I am doing "make install" (step3)
it is giving me following error:
---
Warning: Y
I sent this message in but have not received one single reply... :-(
-- Forwarded message --
Date: Thu, 25 Jan 2001 11:10:52 -0800 (PST)
From: Ricardo Kleemann <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Problem with replication. :-(
Hi,
I'm running linux, mysql 3.23.32
In the last episode (Jan 26), Artem Koutchine said:
> The manual says that if two seprate single-column indexes exist on
> two different colums (col1, col2) and someone issues a query:
>
> SELECT * FROM tbl_name WHERE col1=val1 AND col2=val2
>
> optimizer will choose the index which matches the l
> Beside Jeremy's notable comment, please try latest FreeBSD binary
> available on our site.
>
> Also follow Ken Manzel's info on FreeBSD 4.* patches.
>
> The fact that you have SMP kernel should not matter much, as FreeBSD
> native threads can not use SMP for threaded servers.
>
> If you still ge
I've seen something about this in the manual. At the moment
the problem was how to call such an SQL command (like
REPLACE for DELETE/INSERT). I wonder if it was
implemented in 3.23.32 or is it only in 4.x?
- Original Message -
From: "Jan Willamowius" <[EMAIL PROTECTED]>
To: <[EMAIL PROTEC
After a long search we found out that the firmware & BIOS of raid
adaptor was to blame !
It was the ServeRaid-4L scsi controller of a IBM Netfinity. This card is
a new product. After the upgrade of BIOS and Firmware with version 4.50
(was 4.40) the server seems stable and some other strange be
I'm have a lot of queries where i have to check if a record exists
and if it does, increment a counter in it (most of the time). If it doesn't
exist I insert a new record with counter=1 (this case is rare).
Right now I do a select form Perl and then do one or the other.
To speed things up I could
The manual says that if two seprate single-column
indexes exist on two different colums (col1, col2)
and someone issues a query:
SELECT * FROM tbl_name WHERE col1=val1 AND col2=val2
optimizer will choose the index which matches the least
records and use it.
This is it. Manual does not say what
Hi Patrick,
You can try something like:
ssh -L 6969:ukdb-qa: root@ukdb-qa
Use the above on a remote host (lets call it wms-qa). This assumes ukdb-qa is
running a mysqld on port . This command will cause wms-qa to listen on port
6969 for connections and forward them all across a secure con
Julian Hiscock writes:
> We are currently trying to compile MySQL V3.23.32 under Tru64 V5.0a running
> on a Compaq Alphaserver DS20E. The error messages are as follows:
>
> Object file format error in: /usr/local/mysql/lib/mysql:
> read_pass1_info_malloc: bad file magic number
> ld:
> Ob
CHAR() is the quickest.
Fixed width is almost always the quickest way to handle data
from a programming perspective. But it can be wasteful of memory
or disk space. In the event that it uses so much RAM that your
server is swapping things in and out, then maybe VARCHAR()
would be faster
In the last episode (Jan 26), Don said:
> I have a table called Ports that contains Port information and has
> several columns. I've designated the Portname column as Primary as
> it is unique (I did not specify it as unique). When I do a:
>
> SELECT * FROM Ports;
>
> It does NOT show the table
Hi.
You would tell me who is quicker: CHAR(*), VARCHAR(*) or TINYTEXT.
I need to quicken DB to the maximum and to keep minimum size of the DB.
Thanks.
Nick.
-
Before posting, please check:
http://www.mysql.com/manual.php
We are currently trying to compile MySQL V3.23.32 under Tru64 V5.0a running
on a Compaq Alphaserver DS20E. The error messages are as follows:
Object file format error in: /usr/local/mysql/lib/mysql:
read_pass1_info_malloc: bad file magic number
ld:
Object file format error in: /usr/local/mysql/
Don wrote:
>
> Hi,
>
> I have a table called Ports that contains Port information and has
> several columns. I've designated the Portname column as Primary as it
> is unique (I did not specify it as unique). When I do a:
>
> SELECT * FROM Ports;
>
> It does NOT show the table contents in inde
Thanks for the response.
On Thu, 25 Jan 2001, Jeremy D. Zawodny wrote:
> > It just occurred to me, however, that this becomes a much bigger
> > problem when the web server(s) and the database server are running
> > on different machines.
>
> Only if they're on different networks. Ideally, you
Hi,
I have a table called Ports that contains Port information and has
several columns. I've designated the Portname column as Primary as it
is unique (I did not specify it as unique). When I do a:
SELECT * FROM Ports;
It does NOT show the table contents in index order (Portname beginning
with
Hi,
I`m not sure if this will be helpful or not but here goes...
If the Service calls are always going to be logged manually why not create a
Search feature so that he/she can enter in the company name it will search
and display the info, then he she makes a note of the comp_id. They do the
s
One approach might be to use a hierarchal menu -- first level
is first letter of the company, second level is all of the
companies whose names begin with that letter.
Or, set a search to pull up the list of companies which contain
a certain phrase.
-Tilghman
--
"There cannot be a crisis today.
It may become less readable on the server side, but if you
want to store lots of little bits of information, use a BIGINT
column as a collection of a bunch of bits ... pack and unpack
them in your application.
For searching, use the bitwise operators to do comparisons.
-Tilghman
--
"There cann
Hi,
I would like to know if Mysql can be used with Actuate Report writer. If yes
what drivers will I need.
Thank you,
Anju Bagaria
Total E Care Corp.
130 Campus Drive, Edison NJ 08837
Email:[EMAIL PROTECTED]
Phone:732-225- x199
Fax: 732-417-0482
-
I apologize for the OT question, but I've asked this on several other forums and
gotten no constructive replies. If someone wants to refer me to a better place to ask
this, I'd be grateful.
I've got a complicated question, which probably has a simple answer, so I'll try to
avoid wasting every
john1 writes:
> dear Sir :
>
> MySQL 3.22 on my linux 486 PC seems work so good. when I compile
> a simple C API programe which catched from the MySQL tutorial, it
> chokes at the end of compile process . the programe is as follows:
>
> #include
> #include
>
> #define def_host_name
Sam Wong writes:
> I'm using 3.23.32 + FreeBSD 4.2 /w Lastest Snapshots on a Dual P2 Xeon
> 400MHz 1MB Cache, 1GB Ram on 3ware IDE RAID
>
> The traffic of it is about 300 queries/second on average, and keep staying
> at around 400 q/s at night.
> The problem is that, it core dumps in 5-10 m
petro writes:
> Hello!
> Need some help.
> I have two tables
> t1 with fields id and site
> t2 with fields id, from, to, koef
> I want to update t2 set koef=2 if the from field in t2 table exist in
> t1.url
> such update return error.
> update t2, t1 set t2.koef=0 where t2.from=t1
Jennifer Devilbiss writes:
> We are using all the recommended versions of software to get MySQLGUI
> compiled and running. When we try to login we get a bus error. After
> putting the software in the debugger, we found that the string
> conversion routine is causing the address of the string
dear Sir :
MySQL 3.22 on my linux 486 PC seems work so good. when I compile
a simple C API programe which catched from the MySQL tutorial, it
chokes at the end of compile process . the programe is as follows:
#include
#include
#define def_host_name NULL
#define def_user_name NULL
#define def
*** Please forgive if this is double post.
*** My first attempt was from the wrong account :(
GNUe Forms is a data entry/query tool that allows a designer to describe a
data aware user interface via an XML based form definition language.
This file is then parsed at client startup and a prope
Hello!
I promised to report to the mailing list how the interfacing of MySQL
and Innobase engine progresses. Innobase will provide transactions,
rollback, row level locking, and Oracle-style non-locking consistent read
to MySQL. It currently runs on Intel Linux and NT.
Following items from the T
Do you know any free web hosting that supports MySQL. Please let me know.
**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addresse
hi,
i've been asked to design a for a new web-based system which stores lots of data on
it's members. There are currently about 500,000 member records.
the problem is that i have to store at least 248 pieces of information on each user.
i've made the system as relational as possible so that
GNUe Forms is a data entry/query tool that allows a designer to describe a
data aware user interface via an XML based form definition language.
This file is then parsed at client startup and a proper user interface is
dynamically generated. Currently the client portion of the system is
availab
Mehalick, Richard RE SSI-GRAX writes:
> I asked a week ago if BDB tables had ever been tested by the MySQL team on
> RedHat 7. Any ideas?
>
> -
> / Rick Mehalick Senior Consultant
> / Shell Services International SSI-GPAX
> / Phone:
Hi!
We get a lot of mail from users that would like to know if MySQL
works on BeOS. Unfortunately we don't have any person who knows BeOS
or has time to do a port :(
We are interested in finding someone to do a port, and we will help
them with any technical questions they may have while doing t
We are using all the recommended versions of software to get MySQLGUI
compiled and running. When we try to login we get a bus error. After
putting the software in the debugger, we found that the string
conversion routine is causing the address of the string to be an "odd
address". Has anyone ha
Hi,
just #include "mysql.h" and when compiling, add
-I/usr/local/mysql/include/mysql flag to the compiler options.
Rgds,
Indrek
---
Indrek Siitan, tegevjuht eMotion OÜ [http://www.eMotion.ee]
e-mail: [EMAIL
Hi,
> CLOS ??
Corel Linux. :-)
> Did you install just a precompiled version of MySQL? Sometimes there exist
> separate packages for developpers including the header files and
> libraries.
Nope - I installed from source!
mysql.h is in the /usr/local/mysql/include/mysql directory, but I don'
Hello,
For the company I work for I have set up a MySQL database for a
books website with more that 1 million records of books.
The visitor can search for keywords. A sequential scan would be
much too slow. (When I made the database, I had not yet heard of
the new FULLTEXT index in MySQL.) T
On Fri, Jan 26, 2001 at 02:28:37PM +0200, Evan James Dembskey wrote:
>
> It appears as if I have installed MySQL successfuly (under CLOS 1.2).
CLOS ??
> However, everytime I try to
>
> #includeOR #include "mysql.h" OR #include
>ETC
>
> I get a "No such file or directory" error.
Hello!
Need some help.
I have two tables
t1 with fields id and site
t2 with fields id, from, to, koef
I want to update t2 set koef=2 if the from field in t2 table exist in
t1.url
such update return error.
update t2, t1 set t2.koef=0 where t2.from=t1.site
Thank yoo very much.
-
Hi all,
Would be real grateful for some help on speeding up selects on a large table
(20+ million rows).
My question is: Is it possible to load just the index MYI file into RAM and
if this is possible, will this improve performance on selects?
Thank you for any help.
Michael Thomas
-
Hi,
It appears as if I have installed MySQL successfuly (under CLOS 1.2).
However, everytime I try to
#includeOR #include "mysql.h" OR #include
ETC
I get a "No such file or directory" error. Okay - so what library do I
include then?
Regards,
Evan
Legeard,
You can try this utility; I have never run it on Solaris but since it is
based on sh it should run and of course I'd be curious to see how well it
does. That asside it uses mysqldump and some shell scripting to auto
discover all of the databases in a running mysql system and dump e
Hi,
While trying to install the latest mysql Binary distribution
(mysql-3_23_32-pc-linux-gnu-i686_tar)to our Red Hat Linux 6.0 machine I
have encountered the following problem. I would appreciate, if some can
shade a light on it.
When I tried to Create the MySQL grant tables
shell> scripts
Hello,
For the company I work for I have set up a MySQL database for a
books website with more that 1 million records of books.
The visitor can search for keywords. A sequential scan would be
much too slow. (When I made the database, I had not yet heard of
the new FULLTEXT index in MySQL.) T
AFAIK, ISD, ISM is isam type table which are platform
dependent. So, you cannot just COPY them. You need
to do something trikier (sqldump and then restore using
mysql)
MYD, MYI - are myisam tables and they are declarede
platform independet. You can move then around w/o
trouble (AFAIK again).
Mys
On Fri, Jan 26, 2001 at 01:28:14PM +0100, Legeard Luc wrote:
> Hello
>
> I 'd like migrate my mysql server wich run on a Sunsolaris to a Linux
> computer.
> I have installed mysql on my linux and it works
> Now , i'like to move database from Unix to Linux
> A copy database ( *.ISD, *.ISM,*.frm)
Hello
I 'd like migrate my mysql server wich run on a Sunsolaris to a Linux
computer.
I have installed mysql on my linux and it works
Now , i'like to move database from Unix to Linux
A copy database ( *.ISD, *.ISM,*.frm) to Unix dosn't work.
Also, t have seen that on linux the extention of the f
GRANT USAGE ON table.* TO user@localhost;
GRANT select, insert, delete, update ON table.* TO user@localhost;
Boril
- Original Message -
From: "Mac Martine" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 26, 2001 3:13 AM
Subject: new mysql account
how do i set up an
I have tried as MySQL documentation help to create one duplicate table using existing
table structure.
But, It's raise error.
i.e.,
create table select * from ;
mysql>
mysql> create table works SELECT * FROM t_Works;
ERROR 1064: You have an error in your SQL syntax near 'SELECT * FROM t_Work
>I found a very strange behaviour of MySQL 3.23.xx with GROUP BY clause ...
>
>I have a Table:
>
>CREATE TABLE groupbyTEST (
>fldNAME varchar(20) NOT NULL,
>fldMONTH tinyint(4) DEFAULT '0' NOT NULL,
>fldSALARY decimal(10,0) DEFAULT '0' NOT NULL,
>fldDATE datetime DEFAULT '-00-0
1 - 100 of 111 matches
Mail list logo
