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
> > iIs
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 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
Thanks
Vinay Talwar
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Mohamad Ilhami
<[EMAIL PROTECT
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
>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 and the
mysqld was starte
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]
>
>
> ---
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)
http://list
Have you considered using the SET datatype? It would be perfect for your
situation.
- Original Message -
From: "Nino Skilj" <[EMAIL PROTECTED]>
To: "'Tbone'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, February 23, 2001 7:38 PM
Subject: RE: Table Design -- which is better?
>
IMO, you might as well keep them in one table. But I think that's up to
you. Choose a design method that you like and stick with it :)
Atle
On Fri, 23 Feb 2001, Nino Skilj wrote:
> The data would be 1's and 0's (on/off)
>
> Nino
>
> -Original Message-
> From: Tbone [mailto:[EMAIL PR
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
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
Vahan Yerkanian ([EMAIL PROTECTED]) writes:
> 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. Sett
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 t
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:
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':
my_compress.o(.tex
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
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
So, for example, if someone is subscribed for 4 issues and has subscriber ID 47, they
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
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
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,
N
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
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, but
> 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
Help I ran into this problem while compiling.
root @
fwnau060.usco.com:/root/mysqlgui/fltk-1.0.10
=> make
=== making src ===
Compiling Fl.o...
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 Peacht
I do believe I have a mess on my hands.
Lacking any other guidance, I tried upgrading my mysql to 3.23 with
an rpm on a Redhat Linux 6.1 system. I now have the same directory
layout for mysql as on my Redhat 7 server, except there is no daemon
to be found there. The only mysql daemon found anyw
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 v
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 14:18:47 -0600, Ed Carp <[EMAIL PROTECTED]> wrote:
>>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
Excellent! :)
Thunder Rain Internet Publishing
Providing Internet So
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.
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
Why not use something that's already created for you, and is probably
*much* faster than your solution :)
One example is ht://Dig (htdig.org).
Atle
On Sat, 24 Feb 2001, Vahan Yerkanian wrote:
> Greetings All!
>
> I'm in process of writing a web page indexer, which retrieves
> pages from a
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
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 @@
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: Foxe
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 command
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
>efficien
> > There can be another source of problems with REPLACE. As it has to
> > DELETE a row first, it might take a lot of time on huge table if MySQL
> > is not able for some reason to utilize index in order to locate rows.
>
> Now this seems like it might be related. On a variable sized row
> table,
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
> 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
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 wa
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 in
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 those tables not
all of them in the database. Is this pos
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
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 = $
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
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 :
"SQLState:
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 table
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 "";
echo $time;
echo "";
echo $name;
echo "";
sql_query("insert into calendar (id,
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
runni
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
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 e
According to the MySQL manual (section 7.7.1), CHAR columns defined to be greater than
3 chars in length are converted to type VARCHAR. I understand the space efficiency
issues involved here, but when the column is used in an index, doesn't that impose a
performance penalty? Or does MySQL han
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 t
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?
>
> http://www.mysql.com/downloa
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
--
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 seq_tabl
You are absolutely correct
But in some situations, using BLOBs inside the database is more convinient.
Consider for the example the case where you might want to migrate the data
to another location. If some of the data are existing as external files,
this might be a very difficult process.
And all
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 syntax near 'key, description FROM project'
at
line 1
If I try SELEC
Can anybody give a newbie some clear instructions on how to upgrade a Cobalt RaQ4i
server running 3.22.32-1 to the latest 3.23.33 version. The Cobalt MySQL server
installation originally used a .pkg file but cobalt have indicated a new .pkg install
will screw up - its apparently not that simple
hey all,
I'm getting the following error when i try to compile 3.23.33 -
ha_berkeley.cc:105: type specifier omitted for parameter
ha_berkeley.cc:105: parse error before `)'
ha_berkeley.cc: In function `bool berkeley_init()':
ha_berkeley.cc:143: no matching function for call to `__db_env::set_not
THis is a known problem. Upgrade to 3.23.33.
"J.A. Romero L." wrote:
>
> >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:
>
Hi ppl,
is there a way I can have a LISP function talk to mysql (inserts/updates)? A
search at the Mysql page for 'LISP' only revealed Monty's resume :-)
TIA,
thalis
-
Before posting, please check:
http://www.mysql.
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
t
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
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
=
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 MySQL?
> "d" == drew <[EMAIL PROTECTED]> writes:
d>Just 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. Wh
Maybe because text doesn't have a fieldlenfth.
Daniel Alsén 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
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
>> probability of defuncting increases. with 350 connections the bug occurs
>> really seldom (once a week or so), with 360 threads in the next hour and
>> with 370 threads nearly immediately.
>Did you try to increase system resources available for MySQL : number of
>sockets (per process as well a
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 mai
>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
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,
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 key
On Fri, Feb 23, 2001 at 11:29:21AM +0200, Tõnu 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
> probability of defuncting increases. with 350 connections the bug occurs
> really seldom (once a week or so), with 360 threads in the next hour and
> with 370 threads nearly immediately.
Did you try to increase system resources available for MySQL : number of
sockets (per process as well as tot
Hi there!
If any of you have tried the following with ASP/ADO and MySQL, please inform
me of how you did it:
I use ASP and adodb.recordset to connect to a MySQL-database.
I use the following code to insert into the db:
[CODE START]
set rsGroup = server.CreateObject("adodb.recordset")
sql = "tbl
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 impossible to do this?
I am using MySQL 3.23.25.
Thanks in advance.
Yong Li
Hi!
You have probably missed the original message. I have pointed that
I have build Mysql 3.23.33 from the original TAR ball on
FreeBSD 4.2-STABLE using comiler options which are used
in the port of MySQL for FreeBSD, so it does not crush
on high loads. After all this i am getting server crushed
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 t
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 T
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 co
>Description:
The manual says that starting from MySQL 3.23.6, any combination
of characters is allowed for a database name (excluding '/', ASCII(0) and
ASCII(255)). I created database that name consist only of numbers
using mysqladmin tool, but I was unable to drop it using mysql command
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 stategy
>Description:
on heavy use (350-370 mysql threads, connections opened by multiple
apache webservs) one of the mysql threads suddenly defuncts and mysql does
not accept or serve any connections anymore. if more threads are opened the
probability of defuncting increases. with 350 connections
[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
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 (previ
>Description:
>How-To-Repeat:
<./mysql -D unal -p>
>Fix:
>Submitter-Id:
>Originator:Super-User
>Organization:
>MySQL support: [none ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mysql-3.22.32 (TCX bina
Hardy Merrill writes:
> 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 My
Hi,
I'm working under Windows 98 with MySQL version 3.23.29.
I tried to connect to a database that is on a different disk from the data
directory (g:\mysql\data).
So I created a file g:\mysql\data\pfi.sym containing the path
e:\databases\pfi.
I compiled with the USE_SYMDIR option and launched the
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.
-
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 incorpor
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
2.95,
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 Ki
I hearterly concur ...
-Original Message-
From: Mikel King [mailto:[EMAIL PROTECTED]]
Sent: 23 February 2001 03:46
To: Barry Radloff
Cc: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
Subject: Re: Saving pictures in MySql
Greetings,
In most cases you will find that the storage of pictures
Greetings,
In most cases you will find that the storage of pictures and mp3's for
instance are better left to the host fs rather than the dbs. Then you would
only store the link to such files. Some will argue that this slows down access
to the perticular file et cettera, blah blah blah...but
On 23.02.2001 11:52:27 Software by ScuoLavoro wrote:
> 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?
With such a "descriptive" error message?
Please also post the line 255 to the list.
But
Tis true Rolf but you can bet your bottom dollar that at somepoint a
confusion will arise
when it is most inconvenient.
There is always a conversion somewhere in the code even if it is not
visible.
> -Original Message-
> From: Rolf Hopkins [SMTP:[EMAIL PROTECTED]]
> Sent: 23 February 2001
1 - 100 of 123 matches
Mail list logo