On 22.02.2001 16:22:13 Simon Windsor wrote:
Has anyone user MySql on a ReisserFS file system ?
HERE!
No problems whatsoever - why should there be problems anyway?
-
Before posting, please check:
On 22.02.2001 17:55:36 Jon Haworth wrote:
Well, you could filter anything sent or cc'ed to [EMAIL PROTECTED] into
a separate folder
But only, if your client allows that - and changing is not always an option!
-
Before
[EMAIL PROTECTED] wrote:
On 22.02.2001 16:22:13 Simon Windsor wrote:
Has anyone user MySql on a ReisserFS file system ?
HERE!
No problems whatsoever - why should there be problems anyway?
Only problem we know is that in our tests on ReiserFS is MySQL was 30%
faster on writes :/
--
Peter Skipworth wrote:
I'd heard that even in general use, some users had a noticeable increase
in disk reads/writes under ReiserFS...it sounds like you haven't
experienced this (?). I'm thinking about moving over to ReiserFS as well,
shortly, and am looking for as much feedback from people
Hello,
I tried a lot of statements similar to this one from visual basic on an access
database:
"select * from Times where" strField " between '" CDate(FilterA) "' and '"
CDate(FilterB) "'"
=select * from Times where StartTime between '20/02/01' and '24/02/01 23:59:59'
but it doesn't
dear lists, i'm a newbie from italy, i installed apache and my sql. apache it's good
but i can't use mysql and i have this:
Warning: MySQL Connection Failed: Can't connect to MySQL server on 'localhost' (10061)
in lib.inc.php3 on line 255
Erreur
coul someone help me?
thanks in advance
Hi there,
Doesn't seem to be a FAQ so here goes with a question
My MySQL manual has the following to say about how to count the number
of distinct values in a particular column
COUNT(DISTINCT expr,[expr...])
Returns a count of the number of different values.
mysql select COUNT(DISTINCT results)
On 23.02.2001 10:29:21 ?iso-8859-1?Q?T=F5nu?= Samuel wrote:
Only problem we know is that in our tests on ReiserFS is MySQL was 30%
faster on writes :/
Hmm, so, I understand you right: You're saying that it's not a good idea to use
MySQL on ReiserFS, as you may get a speed rush? *G*
Hi everyone
I am new to MySql and PHP
I have downloaded and configured both
I have just finished my first db and are on a high. I was quickly broad to
ground when I tried to load a image via a form into the database. Could someone
please help with:
What field type must be defined for
Jeremy D. Zawodny writes:
On Thu, Feb 22, 2001 at 12:39:41AM +0100, michi platzer wrote:
i need to write my own very basic aggregate functions for MySQL and
had a couple of questions regarding this:
* does anybody know of a site with a collection of UDF's written by other
Christopher McClan writes:
Hello,
I've followed the instructions from the MySQL web site entitled "Instructions
for building MySQLGui with the FL_Editor, and am currently trying to install
mysql++1.78. I've made the modifications to sqlinst/connection1.hh
sqlinst/result1.hh
Steven Roussey writes:
My troubles continue with INSERTs (i posted a message about INSERT
DELAYED crushing a server before). Now, I have this:
We are running Linux and MySQL 3.23.30 and have similar problems. In
particular we have a lot of INSERT DELAYEDs into a fixed table, and
Hi!
I have a table where a textfield is set to VARCHAR and 255 as maximum
length. I need to change that to a fieldtype that can hold more text. I
tried changing the type to TEXT and 2000 as fieldlength. But i only get a
syntax error.
Isnt it possible to make that change? If not, what can i do
Agreed
I generally set aside a directory for any images, etc, per table, and
simply save any images as [primary_key].jpg. That way you can write
simple GetImage([table_name], [primary_key]) functions to return the
location/URL of the matching image.
regards,
P
On Fri, 23 Feb 2001, Mikel
Theres a long list of error messages following but the first is;
ha_berekeley.cc:105: syntax error before ')'
..deleted for brevety...
ha_berkeley.cc:297: warning! unreachable code at beginning of switch statement
Just wondering if this looks familiar to anyone. We are using FreeBSD4, gcc
In the 3.23 news article, at the bottom it says this:
Online Table Maintenance
MySQL 3.23 now incorporates many of the table maintanence
features of the (previously only external) utilities
`(my)isamchk' directly into the MySQL server. The use of
these newly
Hello,
is there any (simple?) way to import SolidSQL data to a mySQL
database?
Could someone give me further information or some url's where I can
find more stuff about importing Solid tables etc to mySQL?
Thanks,
Janek R.
Look up "repair table" in the on-line manual.
regards,
P
On Fri, 23 Feb 2001, Hardy
Merrill wrote:
In the 3.23 news article, at the bottom it says this:
Online Table Maintenance
MySQL 3.23 now incorporates many of the table maintanence
features of the (previously
[EMAIL PROTECTED] wrote:
On 23.02.2001 10:29:21 ?iso-8859-1?Q?T=F5nu?= Samuel wrote:
Only problem we know is that in our tests on ReiserFS is MySQL was 30%
faster on writes :/
Hmm, so, I understand you right: You're saying that it's not a good idea to use
MySQL on ReiserFS, as you
Hi
The new replication features in 3.23 look really good, but appears to limit you to a
single replication thread per mysql configuration.
We currently have a number of totally independant production databases and are
considering using replication in 3.23 to enhance
our backup/recovery
At 12:48 PM -0500 2/22/01, Joe and Nancy M wrote:
I finally got my ISP to resolve the issues with connecting to my db.
I have a test table in the database named test. I have 3 fields;
ID(20Char), PRICE(int),QTY(int). I am using php (this is what my
ISP supports and suggested).
I can connect
On 23.02.2001 13:01:44 Danie Weideman wrote:
What field type must be defined for pictures.
MEDIUMTEXT for the data
VARCHAR/ENUM/INTEGER/whatever for the image type
How to load and retreive pictures from a database using PHP
The same you do with "normal" data. Ie.:
Store:INSERT INTO
On 23.02.2001 13:35:33 ?iso-8859-1?Q?Daniel_Als=E9n?= wrote:
tried changing the type to TEXT and 2000 as fieldlength. But i only get a
syntax error.
What did you type and what was the error? Maybe the VARCHAR field was indexed
without bounds? That's not possible for BLOB types; you have to
On Fri, Feb 23, 2001 at 11:29:21AM +0200, Tnu Samuel wrote:
[EMAIL PROTECTED] wrote:
On 22.02.2001 16:22:13 Simon Windsor wrote:
Has anyone user MySql on a ReisserFS file system ?
HERE!
No problems whatsoever - why should there be problems anyway?
Only problem we know is
Hi!
Here is a worst case i have even seem so far:
create table aa(
some_numberint unsigned not null,
indexaa_sn (some_number)
);
create table bb(
min_numberint unsigned not null,
max_numberint unsigned not null,
range_typechar(1) not null,
primary
On Fri, 23 Feb 2001 15:54:03 +0100, Yong Li [EMAIL PROTECTED]
wrote:
Hi,
I wanted to create a column with type set, and to specify a default
value for this column, but I always got either SQL syntax error or
invalid default value error. What is the right syntax for doing this?
or, it's
Description:
3.23.32 can't reestablish replication link after slave shutdown (fixed)
How-To-Repeat:
Configure master and slave, start replicating then stop and restart the slave.
Fix:
file: sql/slave.cc, line: 516
is written: mi-log_file_name[length]= 0; // kill \n
Create a unique key on the id, or date,id.
If you insert first, and update if the insert fails, you don't have to
lock anything. Inserts and updates are atomic.
"Opec Kemp ( Ozemail )" wrote:
Basically you'd have a DB set up like this:
hits_table
Any idea why the create or edit table don't seem to do anything? I select
them and nothing happens?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Maybe because text doesn't have a fieldlenfth.
Daniel Alsn wrote:
Hi!
I have a table where a textfield is set to VARCHAR and 255 as maximum
length. I need to change that to a fieldtype that can hold more text. I
tried changing the type to TEXT and 2000 as fieldlength. But i only get a
"d" == drew [EMAIL PROTECTED] writes:
dJust wondering if anyone could help me out here? I have recently
d downloaded the binary distribution of mysql for FreeBSD (mysql-
d 3.23.32-unknown-freebsdelf4.2-i386.tar.gz). Now my problem is
d probably an easy fix but here goes. When I try
What privileges does a MySQL user need to execute the CHECK TABLES
command on a table? Is it possible to GRANT very limited privileges
to a "chktbl" user so that all that user can do is "CHECK TABLES"?
But privs that will also allow that user to CHECK TABLES on tables
for *any* database in
Hi
How can I store a BLOB object (image file) into MySQL database ?
Could you give me a sample SQL for this ?
Hesham Farouk Anan
Computer Science Department
Old Dominion University
Norfolk, VA 23529
Peter and Sander,
relevant questions, I will try to answer them.
Good questions - I have a few more :)
A) why does it seem to use fixed-size storage units. (The files)
I have copied the concept of a tablespace consisting of a small
number of files from Oracle. When the database itself manages
Hi!
There is a consensus that blobs containing image files like .jpgs, .gifs,
etc. might better be stored just as links in the database, with the actual
files in a directory pointed to by the database links. Forgive my
ignorance, but can someone explain a few of the more obvious reasons why
Using Linux 2.2.x, Perl 5.6
MySQL 3.23.x (several versions).
We have been using LAST_INSERT_ID to do sequence tables to generate unique
IDs for use in several other tables.
Sequence table:
CREATE TABLE seq_table ( id_val bigint(20) unsigned );
We use SQL like this: "UPDATE
Edward Peschko wrote:
I *then* talked to berkeley db, and they said 'well, mysql distributes its own
copy of berkeleydb with modifications. Is this true? If so, where do I get it?
http://www.mysql.com/downloads/mysql-3.23.html
Scroll down, Berkeley DB 3.2.9a is listed.
AMK4
--
On Fri, Feb 23, 2001 at 11:20:03AM -0700, Ashley M. Kirchner wrote:
Edward Peschko wrote:
I *then* talked to berkeley db, and they said 'well, mysql distributes its own
copy of berkeleydb with modifications. Is this true? If so, where do I get it?
I agree with Jeremy and Colin.
Its one thing to add functionalities, in terms of modules and
interfaces, but adding to the core program is limited in it
practicality, because it will just slow down execution or load-time
or both. This penalizes users who don't happen to need the
capabilities
On Fri, 23 Feb 2001 18:56:08 +0100, "CGint" [EMAIL PROTECTED] wrote:
I'm about to migrate from an MS-access to MySQL.
I named my primary-key-columns 'Key'.
Now, if i try to query this column I get an error:
mysql SELECT key, description FROM project;
ERROR 1064: You have an error in your SQL
On Fri, Feb 23, 2001 at 10:16:55AM +0100, Guido Adam wrote:
maybe a FAQ, but I didn't find it in the docs: We started to
replicate our databases with the new features MySQL 3.23.33 offers.
So far, so cool.
The documentations says something about SQL commands (i.e. SELECT)
that are
Yes, and the confusion will arise no matter whether it's "visible" or not.
Nah! I think I'd prefer to do it myself and have the compiler/interpreter
come up saying "hey buddy, what ya trying to do? This ain't no number"
rather than it changing the number into string and happily continue on
Hi;
I insert the following code in a file:
$count = sql_command("select count(id) from calendar");
$count = $count[0] + 1;
$mydate = $month.','.$day.','.$year;
echo $mydate;
echo "br";
echo $time;
echo "br";
echo $name;
echo "br";
sql_query("insert into calendar
Well, if you have other varchar fields in your table, then it probably
wouldn't have any impact on performance. But since BLOBS and TEXT are
considered varchar, the table no longer is a fixed width. It is my
understanding that MySQL can locate specific records faster (even with
indexes) in
Hello All !!!
I 'm in a rather strange position . I've a servlet that fetches data from a MySql DB .
If the database is without a password it works perfectly fine . Ironically if i assign
a user name and passwd to the DB the servlet doessn't seem to like it and throws up
the foll :
I am sending a rather large UPDATE query to a table with a handful of sequential
fields (i.e. color1, color2, color3, size1, size2, size3, etc). The query is
generated and executed from within a PHP script, and to make the script more
efficient, the query is generated with a FOR loop, so that
what language are you using?? it looks like maybe PHP?
try using some error functions to see what mysql has to say.
Atle
On Fri, 23 Feb 2001, Ben Ocean wrote:
Hi;
I insert the following code in a file:
$count = sql_command("select count(id) from calendar");
$count = $count[0]
Please read the documentation on date functions. That looks like one of
your problems.
Secondly, your not using any '' to encase your strings.
- Original Message -
From: "Ben Ocean" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, February 23, 2001 11:12 AM
Subject: Why Doesn't
Greetings All!
I'm in process of writing a web page indexer, which retrieves
pages from a preset URL list, strips them from HTML tags, and
inserts the text into a database. Now what I'm puzzled with is
the table structure which holds the text information. Setting
TEXT/BLOB fields as an indexes
Safest thing for you is to use our latest 3.23 binaries which are
statically linked with stable glibc and with some additional patches.
For this reason and greater simplicity :) I have been using your binaries
for a long time now. Part of the reason we never tested BDB tables...
There can be
Oh, this is so perfect ... just a little humor to brighten your otherwise dull and
boring Friday... ;)
http://www.hwnd.net/pub/mskb/Q209354.asp
--
Ed Carp, N7EKG [EMAIL PROTECTED] 940/367-2744 cell phone
http://www.pobox.com/~erc [EMAIL PROTECTED] - text pager
On Fri, 23 Feb 2001 [EMAIL PROTECTED] wrote:
I am sending a rather large UPDATE query to a table with a handful of sequential
fields (i.e. color1, color2, color3, size1, size2, size3, etc). The query is
generated and executed from within a PHP script, and to make the script more
efficient,
Hello,
The staticly compiled mySQL gui, comes up with the following when I start
mysqlgui :
Can't connect to local mySQL server through socket (111)
I'm doing this as root, I have set a password, and managed to create a
databse (using mysqladmin), and then play with it using the mysql
are you sure the password is set properly in the mysql.user table? did you flush
privileges after
setting it?
HTH,
James
- Original Message -
From: "Donald Korth" [EMAIL PROTECTED]
To: "mysql@lists. mysql. com" [EMAIL PROTECTED]
Sent: Friday, February 23, 2001 7:40 PM
Subject: Foxes
Just realized that a while ago, I fixed a bug in 3.23.33 with time
replication, and forgot to post the fix to the public lists - just sent it to
the user who reported the bug:
--- 1.86/sql/slave.cc Wed Feb 14 12:51:49 2001
+++ 1.87/sql/slave.cc Wed Feb 14 21:23:20 2001
@@ -857,7 +857,8 @@
On Fri, 23 Feb 2001, Marty wrote:
My questions are:
a) does it matter what order you attempt to update the fields in?
Once again... No
b) is there a way to view what the warnings were?
and.. Yes. with PHP: mysql_error()
Atle
Atle Veka wrote:
Why not use something that's already created for you, and is probably
*much* faster than your solution :)
Oh... if it really was an acceptable choice, I won't post this question.
:))
One example is ht://Dig (htdig.org).
Atle
--
Vahan Yerkanian
What is wrong with this syntax, it looks like what chapter 7.7 says.
mysql CREATE TABLE cur (FLD1 char(30), FLD2 numeric(6,2), FLD3 int(7));
I get a parse error.
Thanks,
Joe.
Sorry, I tried it several times and kept getting the parse error. It must have been
butterfingers, worked ok now.
Thanks, Joe.
On Fri, 23 Feb 2001 15:50:23 -0500, "Joe and Nancy M"
[EMAIL PROTECTED] wrote:
What is wrong with this syntax, it looks like what chapter 7.7 says.
mysql CREATE TABLE cur (FLD1 char(30), FLD2 numeric(6,2), FLD3 int(7));
I get a parse error.
Joe,
I don't think "numeric" is a valid data
I have my database created on my ISP's server. I can telnet to it and log in. I have
created my table. I inserted 4 test records. I have written my .php3 pages and pull
the data and get the results I want. Now I need to populate the table with
hundreds of records exported out of
Help I ran into this problem while compiling.
root @
fwnau060.usco.com:/root/mysqlgui/fltk-1.0.10
= make
=== making src ===
Compiling Fl.o...
Nah! I think I'd prefer to do it myself and have the compiler/interpreter
come up saying "hey buddy, what ya trying to do? This ain't no number"
rather than it changing the number into string and happily continue on
running through the rest of the programming. Takes you longer to figure
It might have installed it in a separate place. I believe the default
might be /usr/local/libexec/mysqld.
Do a 'find /usr/ -name "mysqld"' to attempt to find your binary.
I always like to install stuff by source, cuz then I can always specify
where things go :) RPM usually should work fine,
Thank you.
I got /usr/local/mysql/bin/mysqld as the only return from that find
command.
I'll try again from a tarball.
On 23 Feb 2001, at 14:58, Atle Veka wrote:
It might have installed it in a separate place. I believe the default
might be /usr/local/libexec/mysqld.
Do a 'find /usr/
I have a general design question.
Is it better to design one table with 45 columns or to split it into 3
tables with 15 columns each. There would be about 5000 rows in the table and
it would be used more for reading rather than writing.
I'm new to this, is there anything I'm missing?
Thanks,
In the section of "How to cope without commit/rollback" of mysql manual,
it said
1. Use LOCK TABLES ... to lock all the tables you want to access.
2. Test conditions.
3. Update if everything is okay.
4. Use UNLOCK TABLES to release your locks.
my question is what is Test
Your reply triggered a question?
If you are on a win32 box and using the binary builds, what is the
proceure for getting these patchs? Last time I checked the site is was
still showing 3.23.33 as the current release?
On Fri, 23 Feb 2001, Sasha Pachev wrote:
...
Just realized that a while
Hi,
How would the data look a like.
And how about the query's
Greetz Tbone
- Original Message -
From: "Nino Skilj" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, February 24, 2001 12:17 AM
Subject: Table Design -- which is better?
I have a general design question.
Is it
Hi,
My problems with open64 and fopen64 have been solved by using a newer
version of glibc, however now I get the following errors when trying to
link the MySQL C Client API library with my program.
/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_uncompress':
It is about If one can be allowed to update table.
If table colume has max value 100 and current value is 100 just one more
person can insert into table.
In case of this administrator should limit access other.
That's it..
Maybe use select query
From: WANG_KING£¨Íõ¸Ö£© [EMAIL PROTECTED]
To:
Support EzClickThru.net ([EMAIL PROTECTED]) writes:
I have a user that I want to grant create,drop on %_ext to user@localhost but it
does not like the wildcard in the tablename. I am creating heap tables and then
dropping them but I want the user to have create and drop privileges only on
The data would be 1's and 0's (on/off)
Nino
-Original Message-
From: Tbone [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 23, 2001 4:18 PM
To: [EMAIL PROTECTED]
Subject: Re: Table Design -- which is better?
Hi,
How would the data look a like.
And how about the query's
Greetz Tbone
Hello,
I am running MySql 3.23.33 on Linux RH 6.2. In the documentation, it says if
you want to add a user that is allowed to connect from anywhere, use the "%"
symbol for host. When I add a user whil an empty host field or even a "%" -
I still get access denied... However when I go ahead and add
Hai,
Pls let me know at the earliest where I can download SQL 7
Thanks in advance
Vinay Talwar
[EMAIL PROTECTED]
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
MySQL version is currently 3.23.33 and always available at www.mysql.com
regards
-ilham-
On Fri, 23 Feb 2001 [EMAIL PROTECTED] wrote:
Hai,
Pls let me know at the earliest where I can download SQL 7
Thanks in advance
Vinay Talwar
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Description
I have installed MySql version 3.23.33-1 using the RPM's for Redhat
Linux -i386 (RedHat version 7)
After installing I find myself unable to do any basic db
administration including changing the password.
I simply installed the packages with rpm -i package name and the
Hi Joe (and Nancy ;-) ),
On Fri, Feb 23, 2001 at 05:23:10PM -0500, Joe and Nancy M wrote:
I have my database created on my ISP's server. I can telnet to it and log in. I
have created my table. I inserted 4 test records. I have written my .php3 pages and
pull the data and get the results I
Thanks
Vinay Talwar
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Mohamad Ilhami
[EMAIL
On Fri, Feb 23, 2001 at 06:05:53PM -0600, Don Hosek wrote:
This'd be a piece of cake with sub queries: What I have is a table with two relevant
fields: iIssue and iSubId
iSubId represents a magazine subscriber
iIssue represents any issues that person has/had coming
SELECT iSubID
Ed Carp wrote:
Have you tried the full text search capabilities yet? Might work in your case -
docs at http://www.mysql.com/doc/M/y/MySQL_full-text_search.html
Yeah I tried them, but it doesn't work on substring search, only phrase
search,
e.g. MATCH Keywords AGAINST('vid orce') wont find
On Sat, Feb 24, 2001 at 08:56:03AM +0100, Fred van Engen wrote:
On Fri, Feb 23, 2001 at 06:05:53PM -0600, Don Hosek wrote:
This'd be a piece of cake with sub queries: What I have is a table with two
relevant fields: iIssue and iSubId
iSubId represents a magazine subscriber
iIssue
82 matches
Mail list logo