Hi All,
I need to know, how to configure MySQL can be support unicode like Chinese
(simplified and Traditional), Croation,Chezh or whatever.
Thank you for explain to me
Best Regard,
Hery Yulianto
-
Before posting, please
This is an english mailinglist. Please write in english.
1. Nej.
2. Ja, du hittar det på http://www.mysql.com/downloads/contrib.html#SEC641
On Wed, 23 Jan 2002, Jimmy Geschwind wrote:
Date: Wed, 23 Jan 2002 23:22:40 +0100
From: Jimmy Geschwind [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Hi there.
Im having some troubles with mysql and FULLTEXT.
I create one table like this:
create table pets (id INT AUTO_INCREMENT NOT NULL PRIMARY KEY);
alter table pets add name TEXT;
alter table pets add kind TEXT;
alter table pets add FULLTEXT name (name);
alter table pets add FULLTEXT kind
Hi,
I've an actually quite simple problem, so I guess someone might know an
answer...
I just need a single random result from my query.
With an older MySQL-Version this construction worked fine but with the
new one not at all:
SELECT ... ORDER BY RAND() LIMIT 1
So I tried out this one:
Hi SF,
Hi,
Please help me to use SQL (with mysql prompt) command to replace any digit
in column.
Example:
Old value 123466
New value 123456
How to replace old value at fifth digit (6) to 5?
You can download the MySQL manual to use it on your own machine, or access it online.
Take a
Gili,
When I execute DELETE FROM VALID_CACHE; where VALID_CACHE is
the name of a table I get 0 rows affected even if multiple rows are deleted..
I am expecting the return value to be the number of rows which were removed.
Sorry, this is expected behavior, check out second paragraph in
Database, query
THANKS TO ALL THAT HELPED, Roger, Egor, David, Anvar and anyone I missed
I am runninh MySQL 3.22.32 which puts it just outside the version
recommended by Roger, I tried spaces etc, even changed the to '' et
etc. I think Roger might be right in the end (that my version) just
Hi,
I know sub select would not work correct in 3.23.xx but I have a question
to ask. I'd like to find top 10 ranking of my customer by amount (using
order clause desc) but there are some customer have the same amount. I was
solve this problem by using group by and insert it into
Hi!
Todd == Todd Ratson [EMAIL PROTECTED] writes:
Todd Hi All,
Todd I have an OpenBSD box running mysql-3.23.47, php4.1.1 Apache 1.3.22.
Todd I have been using php-nuke on it for some time now without incident
Todd until today...
Todd I have tried to create a new database in order to add
Can anybody please help me with this? Some queries I try in ASP don't
return any result! Executing them in the EMS MySQL Manager show that
they all should return something...
%
Set con = Server.CreateObject (ADODB.Connection)
con.Open (Driver=MySQL;SERVER=peter;DATABASE=ppm3;UID=root)
set
Gili,
if all rows are affected (as in your case) MySQL just discards the whole
table content at once so it cannot return the number of affected rows.
If you are interested in it put a dummy where clause into your statement
such as 'where 10'. That causes MySQL to delete row by row and then it
Ken Menzel wrote:
Hi Oleg,
There is some sort of thread problem with freebsd but it usuually is
not that bad. How did you compile MySQL? I would recommend using the
ports version of Mysql (cd /usr/ports/databases/mysql-3.23-server) .
Look at the makefile if you are still havbing
* mike vogel
thanks to all respondents! one more thing, i have 2 foreign keys in the
bridge table, but not a primary key. is a primary key in the bridge
necessary for this type of join to work? thanks again.
Make the two foreign keys the primary key for this table, that way you
prevent the
Try using a recordset:
Set con = Server.CreateObject (ADODB.Connection)
Set rst = Server.CreateObject(ADODB.Recordset)
rst.Open SELECT ID FROM Items, con, 3, 3
' Use de results of the recordset here
rst.Close
Nuno A. S. Gonçalves
[EMAIL PROTECTED]
- Original Message -
From: Peter
Hi all,
Ive got a timestamp in a database column and basically
I was wondering if there was any function in PHP to
parse the date into something more readable from
20020123143547
23 Jan 2002 14:35
something like
$date1= datetoreadable($date);
Thanks
Shannon
Hi folks.
I have table:
mysql describe gosc;
+-+-+--+-+-+
---+
| Field | Type| Null | Key | Default |
Extra |
+-+-+--+-+-+
---+
|
Hi,
have a look at http://www.php.net/manual/en/function.date.php
According to your example, it would be something like:
?php
$date1=date(d M Y H:i, 20020123143547);
?
Regards
Marcus
Ive got a timestamp in a database column and basically
I was wondering if there was any function in PHP to
Hello,
in order to be able to use the replication features of MySQL we recently
gave version 4.0.1alpha a try, since these features are reportedly more
reliable in this version - although it is still alpha.
Unfortunately the disadvantages - at least on our machines - don't seem
to make up for
What's this? PHP on the MySQL list - such heresy!!!
Do not pass go, go directly to:
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
=dn
- Original Message -
From: Marcus Müller [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 24 January 2002 11:17
Subject: Re: Simple: Date
Oops,
got it all wrong. Thought it was a real timestamp, but it's already
the date, only formatted in a different way.
The date() function expects a Unix-timestamp as its second argument.
Thus you could try to leave the conversion to MySQL by using
UNIX_TIMESTAMP(your_timestamp_column) or if you
Hi,
I'm a bit to Mysql. We are trying to use mysql as a backend for our Visual
Basic application.
I had a set of tables which I exported from Access database.
But now, I want to index these tables. How do I go about that?
Also, any suggestions of how cursors work with mysql would be of great
Hi,
I installed mysql-3.23.47-win version on Win NT 4.0 Workstation, but I cant start MySQL
service.
When I am trying to start mysql service, I get an error msg like this:
Could not start the MySql service on \\SARADHI.
Error 1067 : The process terminated unexpectedly.
I installed mysql
I had a set of tables which I exported from Access database.
But now, I want to index these tables. How do I go about that?
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
mysql ALTER TABLE your_table ADD KEY(your_column);
Hope that helps
Marcus
Hola:
¿No es posible utilizar una funcion en el default de un campo de una
table?
Intentando, en un campo, poner default = sysdate(), para almacenar
automáticamente la fecha de inserción de cada registro, la fecha que se
almacena es 00-00-0001.
¿Es esto un bug?
Un saludo,
Carmen
i create table from script:
create table if not exists msg00m1 (
id int primary key auto_increment,
hid int not null,
dsg char(10) not null,
nt char(7) not null,
gn char(2) not null,
wot char(12) not null,
k char(19) not null,
k2 varchar(20) not
|Hi,
|
|I'm a bit to Mysql. We are trying to use mysql as a backend for our Visual
|Basic application.
|
|I had a set of tables which I exported from Access database.
|But now, I want to index these tables. How do I go about that?
|
Hi!
the simplest solution is to get a GUI client for
Hello list,
the regular mysql-client returns some useful information after batch-inserts
like:
Query OK, 11393 rows affected (0.47 sec)
Records: 11393 Duplicates: 0 Warnings: 0
I can fetch the number of effected rows in perl/DBI with $sth-rows,
but is it possible to fetch the count of
What did you change?
And the logs say?
Lauren Matheson wrote:
I've just bumped into the same problem - a RedHat 6.1 server that ran
for 2 years with MySQL-3.22.27-1.i386 rpm's from the mysql site, and
the server just died and is having identical behaviour to that
describe - hangs on
Can you be more specific?
Export to what/where?
Manish Mehta wrote:
Hi
i have 3.23.32 version of mysql. i wants to export the database from
\mysql\bin\
please tell.
thanks in advance
Manish Mehta
CORE Solucomm Limited
423 B, Hamilton Court,
DLF City, Phase IV,
Gurgaon,
India - 122 001.
Tel:
Since you said tables ( plural ), I hope you are not running myisamchk
while the server is running.
Fournier Jocelyn [Presence-PC] wrote:
Hi,
myisamchk shows me the following warning message on some of my tables :
myisamchk -a searchjoinhardwarefr2.MYI
Checking MyISAM file:
On Wed, 23 Jan 2002, Jim Lucas [jimmysql] wrote:
But I am installing all the apps from the RPM's that came from Redhat.com
The apps coming from Red Hat Linux work together. You have downloaded and
installed a different (development ) version of MySQL. It's not compatible
with the old one.
You have a function on a field in the where clause, so no index can be used.
Do your date_add() on the NOW() and compare it directly to the field.
Ireneusz Piasecki wrote:
Hi folks.
I have table:
mysql describe gosc;
+-+-+--+-+-+
Hello
What do to if mysql_use_result return NULL ? I can't understand ?
I have only one query by connection, of course.
I talk about SELECT statement in my query (not INSERT or anything else)
Mysql run on linux.
From time to time mysql_use_result() return NULL.
I throw and catch an
Alessandro,
Wednesday, January 23, 2002, 9:43:00 PM, you wrote:
How did you install MySQL? Is it the binary distribution from MySQL or you
have compiled the software from the sources?
AT I used the rpm inside the SuSE's distribution.
Download the binary distribution from
Angela,
Thursday, January 24, 2002, 11:15:46 AM, you wrote:
AH With an older MySQL-Version this construction worked fine but with the
AH new one not at all:
AH SELECT ... ORDER BY RAND() LIMIT 1
This should work fine. I think there are problems in your
statement where you have put ... in
Matthew,
Thursday, January 24, 2002, 12:30:13 AM, you wrote:
MD thanks a simple but effective explination.
You can insert whatever you want in that field - here applies all
the rules of a primary key. But when you insert zero (or nothing),
the database server will insert the next available
Diana,
Wednesday, January 23, 2002, 7:33:35 PM, you wrote:
DS Maybe you did not execute FLUSH PRIVILEGES or run mysqladmin
DS flush-privileges to tell the server to reload the grant tables.
DS Until this, your changes will not take effect.
There is no need to run mysqladmin reload or FLUSH
Manish,
Thursday, January 24, 2002, 8:57:01 AM, you wrote:
MM Hi
MM i have 3.23.32 version of mysql. i wants to export the database from
MM \mysql\bin\
MM please tell.
If you would like to export database, use mysqldump:
http://www.mysql.com/doc/m/y/mysqldump.html
If you would like to move
Rahadul,
Thursday, January 24, 2002, 12:17:17 AM, you wrote:
RK Hi,
RKI installed MySQL version 3.23.47. It starts up and stop when i
RK use the following command
RK /etc/rc.d/init.d/mysql start
RK /etc/rc.d/init.d/mysql stop
RK Bu I attem to start /usr/sbin/mysqld server and edit the
Princy,
Thursday, January 24, 2002, 3:23:24 PM, you wrote:
PT Hi !
PT I did try using the mysql client gui but you cant create indexes thru that.
PT Also, since I've exported from access, the datatype all seem to be
PT MEDIUMTEXT.
PT So, when I try the create index syntax,
PT ie, CREATE
Roman,
Thursday, January 24, 2002, 2:36:45 PM, you wrote:
RZ i create table from script:
RZ create table if not exists msg00m1 (
RZ id int primary key auto_increment,
RZ hid int not null,
RZ dsg char(10) not null,
RZ nt char(7) not null,
RZ gn char(2) not null,
RZ
Ives,
Thursday, January 24, 2002, 5:04:09 AM, you wrote:
IS Hi there,
IS yesterday my mysql server (running under irix) has gone away
IS and took one table with it
IS so i tried to recover the data with isamchk -o table_name
IS unfortunalty during the recoveryprocess half of the data
IS will
These are the items that iam interested in selling..
Could you help me with some details on the goods, history, origin etc.
are these worth anything and if so who would i contact with regards to
selling them? and the best way to sell them ie auction etc
APOLOGISE IF YOU HAVE ALREADY RECEIVED
Will MySQL, at any time in the near future, support multi-master
replication? We're looking at splitting some very large databases up among
several machines, but we need a way to bring them back together for our
stats creation databases on the backend.
What we need is a way to combine databases
Please help. I accidentally deleted the root user and now I can't do
anything. How can I recreate this user with super user privileges? I'm
new to MySQL so please be detailed.
Thanks in advance
Lisa
-
Before posting,
http://www.mysql.com/doc/R/e/Resetting_permissions.html
after starting mysql with the --skip-grant-tables, you'll have to
execute a grant statement
http://www.mysql.com/doc/G/R/GRANT.html
GRANT ALL PRIVILEGES ON *.* TO root@localhost INDENTIFIED BY
'somepassword' WITH GRANT OPTION;
then
How do you know what the maximum connections you can have at one time with
mysql?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
* Jay Paulson
How do you know what the maximum connections you can have at one time with
mysql?
mysql show variables like max_connections;
--
Roger
query, table
-
Before posting, please check:
log into the mysql command line, type
show variables
and look for
max_connections
In the last episode (Thursday 24 January 2002 11:24 am), Jay Paulson wrote:
How do you know what the maximum connections you can have at one time with
mysql?
Next question:
How do you increase that variable? Also, is there a number that is
generally considered too high or does that depend on the server you are
running MySQL on? (an example would be GREAT!)
thanks.
- Original Message -
From: Roger Baklund [EMAIL PROTECTED]
To: [EMAIL
I have seen this question a couple times on the mailing list, but have
not seen a legitimate answer except a link to the website it can be
downloaded. I have downloaded and set everything up for MyVBQL, but I
am new to databases in general and have no idea where to start to even
try to connect. I
Hello Chetan,
CL hi,
CL I wanted to set variable query_cache_size..
CL I have tried for this as in below but the machine hangs up every time i
CL am doing this...
CL Any other method by which I can set this Variable..?
Try to run safe_mysqld in background mode.
CL shell mysqld -u root
Victor,
Thursday, January 24, 2002, 10:59:03 AM, you wrote:
VHRV Hi there.
VHRV Im having some troubles with mysql and FULLTEXT.
[]
VHRV Now, I have the next rows:
VHRV ID NAME KIND
VHRV 1Boby Asiatic and colored
VHRV 2Linda American,
mysql, database
http://shop.barnesandnoble.com/booksearch/results.asp?WRD=MySqluserid=6AF42
HL01D
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
What if you run SQL questons from MySQL command line?
What SQL questons are you trying to run?
Simon
PS yes MySQL if very fast
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 24 January 2002 17:19
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Mysql very
At 05:19 PM 1/24/2002 +, [EMAIL PROTECTED] wrote:
I've installed Mysql on my machine, two of my machines, one on win98 and
other on windows 2000. But for some reason when the developer is trying to
run any query from a VB applications, it tends to slow and hang both the
machines. I 'm trying
Hi, I'm new at the Database Maintenance Role.
Can anyone tell me what are the basic things that need to be done to keep my
database healthy ?
i.e. I've heard that it's good to regularly rebuild indexes. How frequently
should that be done ?
And what is the best way to go about it.
-
Christopher Thompson writes:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
For various reasons, I need a C++ API to MySQL for use in Windows (and
possibly Linux as well). I know I can find one or two in the
downloads/contrib section but I'm looking for suggestions.
I'm quite happy
At 18:32 +0100 1/24/02, Peter Bremer wrote:
Hi,
Can anybody explain why the following does not work?
SELECT @variable := value1;
UPDATE table SET field1 = @variable WHERE field2 = value2;
The result is always that field1 is set to NULL...
Works for me, if I substitute a real value for
I found files whith names like localhost-bin.001, localhost-bin.002 in
/tmp/
What are they ?
Also, what does it mean that my MySQL database version is 3.23.47-log. What
does -log mean ?
Regards Jacob
[ www.sharksforum.com | www.eksperten.dk | +45 70 27 07 67 ]
Kalok,
Thursday, January 24, 2002, 6:51:26 PM, you wrote:
KL I'm having the same need.
KL It looks like the following is intended for MyISAM tables only:
KL http://www.mysql.com/doc/U/s/Using_mysqlcheck.html
KL Has anyone else had any other luck ?
Sometimes mysqlcheck works for BDB tables.
Ooops!! This seems to be a bug in EMS MySQL Manager... Sorry to bother
you all...
Regards
Peter
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: do 24 jan 2002 18:51
To: Peter Bremer; Mysql (E-mail)
Subject: Re: Problem with UPDATE and User Variables
At
Jacob Friis Larsen wrote:
I found files whith names like localhost-bin.001, localhost-bin.002 in
/tmp/
What are they ?
Log files.
Also, what does it mean that my MySQL database version is 3.23.47-log. What
It means it is logging.
does -log mean ?
Regards Jacob
[ www.sharksforum.com
On Wed, 23 Jan 2002 16:53:47 -0800
Jeremy Zawodny [EMAIL PROTECTED] wrote:
In sql/sql_parse.cc:72 (roughly), a list of command names is defined:
const char *command_name[]={
Sleep, Quit, Init DB, Query, Field List, Create DB,
Drop DB, Refresh, Shutdown, Statistics, Processlist,
hi,
I recently installed MySQL3.23.47 and now I need the JDBC drivers for
it. Does anyone know where can I find a Free JDBC driver that would work
with MySQL 3.23.47-1?
thanks so much
--rahad
-
Before posting, please check:
http://mmmysql.sourceforge.net/
On Thu, 24 Jan 2002, Rahadul Kabir wrote:
hi,
I recently installed MySQL3.23.47 and now I need the JDBC drivers for
it. Does anyone know where can I find a Free JDBC driver that would work
with MySQL 3.23.47-1?
thanks so much
--rahad
hi.
i'm trying to benchmark pgsql living in cygwin on a 2K box with mysql
installed normaly on windows. i get:
C:\mysql\benchperl
run-all-tests --host=PAVILION --server=Pg --user=n
--password=x --log --comment 2x Pentium II 400mz, 256M, under
vmware
Got error:
MySQL 3.23.41 on Solaris
Is it possible to select only the latest entries
from a table?
For instance I have a table of datasets that get
loaded each day. I want to find the latest date that
each dataset was loaded.
I thought maybe a join against itself might be the
answer, but this
I don't know of any changes that happened right at the time that it went
down. Now, the box _was_ rooted :-), but I *think* mysql going down was
independent of that. Since then I've reinstalled every rpm on the system,
so it should be clean. MySQL hangs as I install the rpm for it though as
On Thursday 24 January 2002 11:44 am, Sinisa Milivojevic wrote:
?(2) Can someone give me an idea what these correspond to:
?
? ? ?Connect Out
Slave connecting to master.
--
MySQL Development Team
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
Of course not ;)
I only run myisamchk -a on several table, and I noticed sometime a similar
message (although the tables seem to work perfectly)
Jocelyn
- Original Message -
From: Gerald Clark [EMAIL PROTECTED]
To: Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Hi all MySQL'ers,
We have finally completed our initial public version of the DataBreeze
Web Application system that uses MySQL as the underlying SQL database.
The system requires Linux(or unix), Apache, Perl, ModPerl and MySQL.
As this is a MySQL specific system, feedback from the MySQL
how can i select a join and then use the resulting table in another
join? i did it with a temporary table, but is there a way to do it with
a single compound statement? thanks in advance!
-
Before posting, please check:
I'm trying to increase the maxium number of connections to my MySQL database
but I am not sure how to do this. I've gone to the manual and it doesn't
say too much (maybe i'm looking in the wrong spot?). The machine I'm
running is an AMD 650 with 512 Ram on RedHat 7.1 and MySQL 3.23.41 so I
Hello,
I am using Visual C++ 6.0 and I have some linking
problems while trying to run the example program
MFC_ex.cpp included in the downloading files in the
mysql.com website.
Here are the errors I get:
Configuration: MFC_ex - Win32
Debug
Linking...
I have pasted below some queries and a table structure that I am finding to
be very slow.
As you can see, if I or the two keyed fields, the query takes ~7 seconds.
If I just run them by themselves, it takes no measurable time.
Is this something we just have to live with? Or, is there something
Sounds like you have a table (lkup_info) of load dates (date), in which you
record fileid (did) and date. Sounds like you do not have a separate table
of fileids. I'm assuming that the lkup_info table is updated synchronously
with the loading of each file that the table is recording, though
When doing selects on a read-only myISAM packed table, are varchar
fields still slower than char fields?
Thanks,
Michael
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
We have a somewhat large read-only table (2.9 million recs). I am wonder
if there is a utility that will look at each row of each columns and
come up with a summary of the largest field (in character length) for
each column. For example, scan each row's firstname field and report
that the
MySQL can only use 1 index per query. So take your first query for example:
update forum set approved='N' where id=644122 or thread=644122
it can only use the id key OR the thread key, not both. and since you have an 'or'
in your query MySQL must scan the entire table for either id being
On Thu, Jan 24, 2002 at 04:06:57PM -0500, Michael Stearne wrote:
When doing selects on a read-only myISAM packed table, are varchar
fields still slower than char fields?
Since it's essentially a MyISAM table with compression done at the
row-level, I'd expect so. But the difference has to be
At 04:10 PM 1/24/2002 -0500, Michael Stearne wrote:
We have a somewhat large read-only table (2.9 million recs). I am wonder
if there is a utility that will look at each row of each columns and come
up with a summary of the largest field (in character length) for each
column. For example,
Is this what you had to do? If so, could you point me to a location on the
web or in a book store to aquire knowledge on how to compile new software.
I have only compiled one piece of software, Courier Mail Service. It was
interesting!
But, I feel that I would need a little more help with all
On Thu, 24 Jan 2002, Jim Lucas [jimmysql] wrote:
Is this what you had to do?
No, I don't do it. If you stay with the stable version of MySQL, you avoid
this problem. MySQL 4 will show up in Red Hat Linux (at least the
development tree when it's declared the) stable branch, and applications
Christopher Thompson wrote:
At 04:10 PM 1/24/2002 -0500, Michael Stearne wrote:
We have a somewhat large read-only table (2.9 million recs). I am
wonder if there is a utility that will look at each row of each
columns and come up with a summary of the largest field (in character
length)
Hi!
CHECK TABLE does not do anything on BDB tables.
On InnoDB and MyISAM tables CHECK TABLE tries to verify the physical
consistency of the table and its indexes.
The way to repair InnoDB or BDB tables is to dump, drop, and reimport them.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order
On Thu, 24 Jan 2002, Shankar Unni wrote:
Should we take this offline?
The Redhat packaging for MySQL calls it mysql (lowercase). MySQL AB's
packaging calls it MySQL (upper/mixed case). The layout in each of those
packages is quite different.
But that wasn't the problem.
So version
select max(length(firstname)) from TableName;
-Original Message-
From: Michael Stearne [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 24, 2002 4:38 PM
To: Christopher Thompson
Cc: [EMAIL PROTECTED]
Subject: Re: Tighly packed table
Christopher Thompson wrote:
At 04:10 PM 1/24/2002
Acck!
Yes, please please do that. O(n) instead of O(n^2) (*). This is a much
better solution.
I was trying to convert 'there exists n such that for all m where n != m,
n = m, return n'. Damn logic.
(*) To be honest, I'm not even sure what the runtime of my original query
was. A good
The problem is, this query really hurts (I don't know if it finishes)
for unindexed field for 2.9 million rows. But I'm sure it will finish
eventually.
Michael
Roger Karnouk wrote:
select max(length(firstname)) from TableName;
-Original Message-
From: Michael Stearne [mailto:[EMAIL
Does anyone have a best practices for efficiently storing md5 hash
values in MySQL?
Since it is a 32 character string of hex numbers, I originally stored
them in a char(32) binary column. But that is wasted space (by a factor
of 2). And of course, these things add up, both in data files and
At 05:58 PM 1/24/2002 -0500, Michael Stearne wrote:
The problem is, this query really hurts (I don't know if it finishes) for
unindexed field for 2.9 million rows. But I'm sure it will finish eventually.
Yes, it will really hurt. After all, there's no way for MySQL to do this
other than
On Thu, Jan 24, 2002 at 12:19:12PM +0200, Oleg Prokopyev wrote:
Ken Menzel wrote:
Hi Oleg,
There is some sort of thread problem with freebsd but it usuually is
not that bad. How did you compile MySQL? I would recommend using the
ports version of Mysql (cd
I actually have all the records in a 1GB text file, so here comes perl
to the rescue!! (Easier than C to me, maybe I'll do it in Java as an
exercise.)
BTW if anyone has any questions on the ability of MacOS X with medium
size DBs. This DB is running on a 500Mhz iMac G3 with 1GB of RAM and
I will be putting variable length text into a field (up to 255 characters
but typically around 60 characters) and wonder what makes for faster
retrieval? Or does it matter? A field defined as Varchar(255) or Text? It
is unlikely this field will be used for searching and it will not be
...and because no one has been really cynical...
After that query runs, then prepare for a coffee overload whilst you perform the ALTER
TABLE, then get ready
because if you shorten the field to (say) 12 characters/bytes the very next day,
someone with a 13 character
name is going to try to
Hi all!
I bumped in a strange problem.
I dumped a help table (i.e. only text) into a file. The table contains two
fields: a topic (unique) field and a content field. Then performed a
LOAD DATA INFILE on the resulting file in a different database with
identical structure. Everything worked
Is this just something we have to live with or does MySQL 4 handle this
better?
Brian.
- Original Message -
From: Andrew Schmidt [EMAIL PROTECTED]
To: Brian Moon [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, January 24, 2002 3:11 PM
Subject: RE: Slow updates with two keys in
Just for the record, found the glitch: somehow, somebody on the way decided
to change LF's into CRLF's (I remotely dumped the data and e-mailed it
locally where I test the setup process, so maybe the mail agent?). I just had
to replace 0x0d0a's into 0x0a's in a hex editor and everything works
Anyone,
Are there any other mailing lists about databases out there? If so, can you
post a link to their site where i can register?
Thanks,
Mike
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
1 - 100 of 123 matches
Mail list logo