-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 06 September 2002 06:22, Chugh Shalini wrote:
Can my user defined functions work well if I have installed mysql from the
binary source??
It depends on which binary you mean. We try to link our binaries statically on
platforms that
By binary menas.. I have downloaded the mysqlmax binary version 3.23.52 on
solaris 2.8.
I have created a user defined function and when I try to create that
function in the mysql databse I get the following error
ERROR 1126: Can't open shared library 'PosMax4SubsDll.so' (errno: 0 ld.so.1:
/us
Hi,
I notice that lots of mysql gui's all can find out the contents (tables)
of any given database, how do they do this?
Is it an sql command?
I hope so, I need to know what the SQL command is so I can pass it to
perl DBI.
M.
--
Mark Worsdall
https://www.paypal.com/refer/pal=LS79YHQ9VUGLJ
show tables from database;
- Original Message -
From: Mark Worsdall [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 06, 2002 2:42 PM
Subject: How to read table names within database?
Hi,
I notice that lots of mysql gui's all can find out the contents (tables)
of any
The command show tables;
will give you what you want.
See: http://www.mysql.com/doc/en/SHOW.html
Gurhan
On Fri, 2002-09-06 at 02:42, Mark Worsdall wrote:
Hi,
I notice that lots of mysql gui's all can find out the contents (tables)
of any given database, how do they do this?
Is it an
On Fri, 6 Sep 2002, Mark Worsdall wrote:
Hi,
I notice that lots of mysql gui's all can find out the contents (tables)
of any given database, how do they do this?
Is it an sql command?
I hope so, I need to know what the SQL command is so I can pass it to
perl DBI.
M.
Try show
Mark,
I notice that lots of mysql gui's all can find out the contents (tables)
of any given database, how do they do this?
Is it an sql command?
Parse the contents of SHOW DATABASES and then use the ouput of that to
SHOW TABLES...
mysql, query.
DSL
Hi Heikki,
one more question please about innodb_flush_log_at_trx_commit: if there
was some way of increasing the delay between log flushes more than 1 sec,
can you estimate will it bring any real effect in performance? I know
it'll raise the risk of losing some last transactions if something
I wrote:
I apologize for asking such a basic SQL question, but I am failing in finding
the solution...
Consider the following table:
id | option
---
1 | a
2 | a
2 | b
I want to find the ids with only a specific set of options.
For example, if I wanted to get the ids which have option
Alexander,
- Original Message -
From: Varshavchick Alexander [EMAIL PROTECTED]
To: 'Heikki Tuuri' [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, September 06, 2002 10:08 AM
Subject: RE: Performance Problems with InnoDB Row Level Locking...
Hi Heikki,
one more question please
Joe,
- Original Message -
From: Joe Shear [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Sent: Friday, September 06, 2002 2:13 AM
Subject: Re: Performance Problems with InnoDB Row Level Locking...
Hi,
On a side note, are there any plans to backport the spurious insert
deadlock
Amy,
- Original Message -
From: Amy [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Friday, September 06, 2002 1:14 AM
Subject: lost connection when modifying indexes
Hi -
I'm using MySQL Max 4.0.1-alpha. Whenever I create or drop
an index on a table that is being
Hi!
- Original Message -
From: PR [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, September 05, 2002 5:31 PM
Subject: innodb questions about message board apps
Hi all, I've been reading a bit on the innodb table type for mysql here
and
on the site and some other
for a gui running on your local system the ISP has to open a remote connection which is
already security problem.
Also the data-flow between your client and the server is not encrypted.
Tools like phpMyAdmin run on the ISPs webserver with a local connection and so there
is no problem with a
here instructions how to use udf_example.cc on VC++.
Assuming that the user has VC++ 6.0, the Windows MySQL source and
running a MySQL server with the same version.
- Open the mysqld.dsw workspace.
- Add New project to the workspace
- Project name: udf_example
- Select Win32 Dynamic-Link
Heikki, thank you for the answer. So on the systems other than Linux or
Solaris the best flush method should be fdatasync, is it correct? In this
case, if I don't specify innodb_flush_method option, fdatasync will not be
used - it'll be fsync be default instead? My system is FreeBSD, so which
Hello,
How can i stocking pictures in mysql database ?
i've tried to open a file as binary, i've replaced ascii(0) by '\O', etc.
i've done an 'insert into table set field='datas'' but doesn't work
please help me
Pierrot
Hi!
Is it's possible to execute such query in MySQL?
update table_name set table1.field1=table2.field2 where
table1.key=table2.key
Thanx
Andis
-
Before posting, please check:
http://www.mysql.com/manual.php (the
query, mysql, sql
A very basic question as I have no other options left but to ask.
I need to download source distribution package of mysqlmax version 3.23.52
for solaris 2.8
but on the www.mysql.com site I always find the binary package version for
mysqlmax for solaris.
Please let
A number of people have asked about this, and some have figured it out
and posted info somewhere, but not in the www.mysql.com docs.
Perhaps, I need to report it on this list for it to get into a distro,
yes?
In configure, there is a bit that starts at line 7514:
*darwin*)
if test
Thank you very much for your answer.
I am sorry to have misled you by my incomplete question. I asked you about
build MySql from src earlier and that message was mistakingly associated
with the previous one.
I meant building not dll containing UDF, but MYSQL itself.
I built it as specified in
Pierrot:
Do a search on the archive (http://lists.mysql.com/) for this list ... look
for images and blobs ... you should find numerous topics with the info you
are looking for.
Gerald Jensen
- Original Message -
From: navarra/mail.satori.fr [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
Hi!
I have just installed MySQL 3.23.52 in a Windows2000. This machine is connected in a
network.
I would like to now if it is possible to install the datadir directory in another
machine but the one that I have installed the MySQL Server.
I have tried using in the my.cnf file the option
Greetings,
I'm new to this list but not to MySQL. I've been using MySQL on
Linux with PHP for the past year or two. I've always managed to sort out
any problems by looking at the documentation on the website but my
current problem has me perplexed.
I need to be able to send
hello,
i have a table with 10 500 000 rows on a mysql database
how can i find doubles ?? i know how to do it using php, but maybe there
is a way using only queries?
tks
JF leoni
-
Before posting, please check:
JF,
You could try this, if I understand you correctly
===
SELECT count(field_name), field_name
FROM table_name
GROUP BY field_name
HAVING count(field_name) 1
===
or HAVING count(field_name) = 2 , to find records that are
I´m inserting 6.000.000 records on a table... but in 3.500.000 the
mysql print:
The table is full.
The tables of mysql have a record limit to insert ?
My system is MySQL 3.23.52/InnoDB
My table handler is InnoDB but in MyISAM the mysql print the message
too...
tnks.
Hi,
There's no table size limit, but if you use InnoDB, maybe you need to
extend the size of your tablespaces, because they CAN be full. Check out
your my.cnf
Good luck,
Daniel
At 08:21 2002.09.06._ -0300, you wrote:
Im inserting 6.000.000 records on a table... but in 3.500.000
Hi,
What you request i think it can become like this :
SELECT SUM(IF(HOUR(start)'02:00:00' AND
HOUR(stop)='08:00:00',50*sessiontime,0)+IF(HOUR(start)'08:00:00' AND
HOUR(stop)='14:00:00',100*sessiontime,0)+IF(HOUR(start)'14:00:00' AND
HOUR(stop)='02:00:00',150*sessiontime,0)) from YOUR_TABLE
Hi,
You have to use LOAD_FILE() function to load a file into a blob column.
See:http://www.mysql.com/doc/en/String_functions.html
Gurhan
On Fri, 2002-09-06 at 04:57, navarra/mail.satori.fr wrote:
Hello,
How can i stocking pictures in mysql database ?
i've tried to open a file as binary,
Alex,
- Original Message -
From: Varshavchick Alexander [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, September 06, 2002 11:49 AM
Subject: Re: Performance Problems with InnoDB Row Level Locking...
Heikki, thank you for the answer. So on the
I've got apache in Win32 system and MySQL 3,32...
intall also.
As far as i know mysql admin needs a server (loclhost)
to work. The ODBC@localhost apears to me when i havn't
give permisions to a user to select a database. You
should check mysql database where you choose
permisions.
Nikos
---
On Thu, 5 Sep 2002, Darryl Hoar wrote:
Greetings,
I downloaded the mysql-max-3.23.42-pc-sco3.2v5.0.6-i386 from MySQL website.
I installed it per the INSTALL-BINARY readme file.
When I try (from /usr/local/mysql) issue:
bin/safe_mysqld --user=mysql
It starts and immediately stops mysqld.
Keith Burke [Experience IT] wrote:
Greetings,
I'm new to this list but not to MySQL. I've been using MySQL on
Linux with PHP for the past year or two. I've always managed to sort out
any problems by looking at the documentation on the website but my
current problem has me
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Friday 06 September 2002 11:15, Chugh Shalini wrote:
I need to download source distribution package of mysqlmax version 3.23.52
for solaris 2.8
but on the www.mysql.com site I always find the binary package version for
mysqlmax for
Put the server on the machine with the data.
You don't want your server doing full table scans
across the network.
Jaime JLO. López Ortega wrote:
Hi!
I have just installed MySQL 3.23.52 in a Windows2000. This machine is connected in a
network.
I would like to now if it is possible to install
Write it in perl.
Perl has modules for MySQl and Email.
Keith Burke [Experience IT] wrote:
Greetings,
I'm new to this list but not to MySQL. I've been using MySQL on
Linux with PHP for the past year or two. I've always managed to sort out
any problems by looking at the documentation on
Hi Daniel,
So what would be a good solution within MySQL to store large amounts of data if they
have to go into a single table?
InnoDB seems to be the right table type to use (especially as they support
transactions as well) but you do not have controll over the used tablespace. They are
just
Hi,
I think youd should make an UDF which that execute in shell what you need.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original
Hi,
I have compiled 4.0.3-beta onto SuSE Linux 7.0. The configure, make and make
install go fine, but then when I try to run the mysql_install_db script I
get a failure.
Here's the error:
backup:/usr/local/mysql-4.0.3-beta # ./scripts/mysql_install_db
Preparing db table
Preparing host table
Keith Burke [Experience IT] wrote:
I need to be able to send Emails to people from MySQL command
line.
May I rephrase your comment?
I need to send E-mails to people from MySQL data.
I recommend just doing a SELECT on the data in question and generating
the E-mails from PERL or PHP
Hi all,
I am completely new to MySQL. I am trying to install
MySQL on SUN SPARC Solaris 2.8.
I downloaded mysql-3.23.52-sun-solaris2.8-sparc.tar.gz
and did gunzip to unzip the file and then did
gtar.
When i try to run mysql_install_db, i get the
following error :
Hello!
walt wrote:
Keith Burke [Experience IT] wrote:
Greetings,
I'm new to this list but not to MySQL. I've been using MySQL on
Linux with PHP for the past year or two. I've always managed to sort out
any problems by looking at the documentation on the website but my
current
Walt,
Sorry, let me explain in a little more detail.
I have an Access front end ODBC'd to a Foxpro database [I hate
Foxpro :-p No choice, another company developed it for our customer.] on
a Windows server. I get it to export the data to couple of files, tar,
gzip, then ftp to
...or a good alternative is PAGER.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Gelu Gogancea [EMAIL
I'm locked out of mysql database - it seems that all my users can't access
it, through lack of privileges, even root. This means that I can't get
through and change the privileges.
How can I start with a fresh users database?
I'm only setting the database up at the moment, so there's no data to
hi
What version combinations of mysql and php should be used?
regards
anil
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
Please forgive me if this has been addressed (please refer me to the
docs and I will rtfm) or if I'm just being a bobo.
I am running a 3.23.39 client/server on FreeBSD 4.6S system. I am
getting a very peculiar query behavior.
I have a cgi program using the Perl DBI. The programin in question
Mysql creates over 900 files at an installation.
I want to reinstall my Mysql. How can I remove all these files?
Where does Mysql creates files?
Is it possible to install 2 versions of mysql on the same machine?
ilyas
-
Michael T. Babcock wrote:
May I rephrase your comment?
I need to send E-mails to people from MySQL data.
I recommend just doing a SELECT on the data in question and generating
the E-mails from PERL or PHP or whatever other language you are using.
No you may not ;-)
*joke*
It needs to be
Hi all,
I am completely new to MySQL. I am trying to install
MySQL on SUN SPARC Solaris 2.8.
I downloaded
mysql-3.23.52-sun-solaris2.8-sparc.tar.gz
and did gunzip to unzip the file and then did
gtar.
When i try to run mysql_install_db, i get the
following error :
Hello!
You must use version 1.0.0 of MySQL and 0.6 of PHP, since I assume you
are using ZX-81 machine
OK, was a joke, but without information I can say: Use the stable
version for your machine (3.23.x), if you don't need the features of the
unstable ones (4.x). I think migrating should
I don't have a master.info file in my /usr/local/mysql/data dir, only 2
directories: mysql and test, neither of which contain master.info.
What is supposed to be in the master.info file? I don't recall any reference
to a master.info file in the replication setup procedure described in the
MySQL
http://www.entropy.ch/software/macosx/mysql/remove-old-mysql.html
--
* Stephen Rosenberg
* http://www.lifug.org
* [EMAIL PROTECTED]
* [EMAIL PROTECTED]
On 9/6/02 11:02 AM, Ilyas Keser [EMAIL PROTECTED] wrote:
Mysql creates over 900 files at an installation.
I want to reinstall my
Heikki,
Yep. That's why I use seperate connections for holding the lock and
to do the subsequent locking attempts. Besides, if that were the
problem, I would see the lock disappear at the very first failed
locking attempt, but that's not the case.
I thought it might be a connection timeout,
...
I'll also have to read up on those UDF's. Sounds interesting.
...or PAGER.
Try to do a test:
\P mail root@localhost;
select User,Host,Password from mysql.user;
\n
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL
Sorry, my bad.
What is this PAGER and where do I run your test script from?
Regards
**
* K e i t h B u r k e*
**
* Experience IT
Hi,
Does the next MySQL 4.x version will support cross replications between several
master servers in cluster ?
Thanks in advance.
Sam.
--
Sam Przyswa - Chef de projet
Arial Concept - Intégrateur Internet
36, rue de Turin - 75008 - Paris
Tel: 01 40 54 86 04 - Fax: 01 40 54 83 01
Web:
Dear list,
I have a version of a shared lib, say udf_test.so, written in C, that
loads using mysql CREATE FUNCTION ... without a problem. Now say I
create another lib, udf_test1.so, that's written in C++ and includes code
from udf_test.so (declared using extern C{}), MySQL complains ERROR 1127
Hi Keith,
It's very simple.
type from console : mysql -u root -h your_hostor whatever you need to
start mysql client and after this just type :
mysql\P mail root@localhost;
mysqlselect User,Host,Password from mysql.user;
mysql\n;
...after this you can look in the root e-mail box and you can
Wouter,
the Lock Monitor output tells that trx 370099 has been committed or rolled
back by the user. That is why the locks have disappeared.
Have you taken into account the following:
8.5 When does MySQL implicitly commit or rollback a transaction?
a.. MySQL has the autocommit mode switched
I'm running server version: 3.22.32, on SunOS 5.6 Generic_105181-17.
The code is perl 5.6.1, using DBI and DBD::mysql as the interface. We
have code that prepares a group of statement handles for use in doing
various queries and inserts in a loop that is executed anywhere from
1-3 times per
Hi,
If you use another library for linking with your code and the library is not
in the right place(after compiling)...this error occur.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
Hi list,
I am developing a program in visual basic, ans as I am brand new to mysql
database, I would like to know from you which are the proper ways to access
the database from my vb program. I know there could be using odbc, but I
would rather not to use it at all.
We´re working for windows,
If you're in VB and want to connect to a mySQL database then why not use
myODBC? it's what it's there for.
A simple connection string would be:
strConnectionString=DRIVER={MySQL}; SERVER=server;
DATABASE=database; UID=username; PWD=password;
To access and manipulate the data use ADO:
Thanks very much Jed,
I did as you suggested but theres a problem somewhere
I implode like so
$toString = implode($toArray, ,);
then perform query...
$result = mysql_query(SELECT emailAddress FROM subscribers_html WHERE
mailingGroup IN ('$toString'));
I have checked that $toString has the
Derrell Durrett wrote:
I'm running server version: 3.22.32, on SunOS 5.6 Generic_105181-17.
The code is perl 5.6.1, using DBI and DBD::mysql as the interface. We
have code that prepares a group of statement handles for use in doing
various queries and inserts in a loop that is executed
Hi,
If you don't wish to use ODBC you can try GMySQL Type Library(Extension
library for libmysql.dll).Interface between VB or VBA and MySQL API
functions.
You can download it from :
http://www.a1vbcode.com/app.asp?ID=1764
or
http://www.simtel.net/pub/pd/59731.html
Regards,
Gelu
Might want to look at writing either a shell script or doing it in C, if it
has to be non-interactive. Escapade can also do thos sort of thing
interactively, and it's as simple as 4 lines of code.
- Original Message -
From: Keith Burke [Experience IT] [EMAIL PROTECTED]
To: 'Michael T.
Perhaps your array items don't have quotes? For example...
Is this what your array looks like: $toTxt = array(a,b,c)
Or is it this: $toTxt = array(\'a\',\'b\',\'c\')
For this to work, it needs to be the second one. If necessary, you can just
walk through the array, adding the quotes:
?
$toTxt
You have to create a mysql user and
chown -R mysql /usr/local/mysql
then run
./scripts/mysql_install_db --user=mysql
Tony Butcher wrote:
Hi,
I have compiled 4.0.3-beta onto SuSE Linux 7.0. The configure, make and make
install go fine, but then when I try to run the mysql_install_db script
Try the manual.
It has a section on resetting the root password.
Basically you restart the server with --skip-grant-tables option
Check out chapter 20.11
Adam Cripps wrote:
I'm locked out of mysql database - it seems that all my users can't access
it, through lack of privileges, even root.
I have seen this post 3 times today.
The message is telling you it can't find
libz.so.1
Obtain and install zlib.
( I run Linux, so I can't tell you where to get it. )
Shravan Durvasula wrote:
Hi all,
I am completely new to MySQL. I am trying to install
MySQL on SUN SPARC Solaris 2.8.
I
Hi,
You could do the partitioning logic on the application side.
For example you can create a new table every month with a
different suffix corresponding to the year/month number.
Then you add the info about this new table into a master
description table, which holds one row per created table,
Hi there, I am pretty new on MySQL. I am running a website, it needs a
fulltext search on the message board.
The message board table is setup without the fulltext column now. So when I
ALTER TABLE to add a new column FULLTEXT(title, body)? The index will be
created?
In my table, the 'body'
Hi,
I have hundreds of mysql databases on a server, mostly filled with
newspaper articles for web sites.
For one particular database, I have about 10,000 archived articles I
want to load in. I want to do this without affecting the performance of
the live site (or any other sites using this
I have tables as follows
Work
zoneday
1 Tue
2 Thr
3 Mon
4 Thr
5 Thr
ZoneZip
zonezip
1 98006
1 98007
I have a Master MySQL server which does not listen publicly, and it
distributes a database to my publicly accessible MySQL servers via
rdist/ssh every 15 mins or so by copying the table files. Is there any
flushing that has to be done for the newly rdist'd files to be used by
the public MySQL
You need to throttle back the inserts.
You are doing 5-10 inserts per second, but
that is fully loading the server.
Do 1 or 2 inserts, and sleep a second.
Monte Ohrt wrote:
Hi,
I have hundreds of mysql databases on a server, mostly filled with
newspaper articles for web sites.
For one
Wouter,
now that I read the query log more carefully I notice that it was thread 23
who was holding the row locks.
From the query log wee see that thread 23 says 'Quit' around 14:47.
Could it be that you have some 5 minute timeout for a silent connection?
When the connection is terminated,
Just shut down all the servers before copying the files.
Check out live replication.
It may be a better solution.
Mark Hennessy wrote:
I have a Master MySQL server which does not listen publicly, and it
distributes a database to my publicly accessible MySQL servers via
rdist/ssh every 15 mins
Shutting down the servers is not an option unfortunately, is there any
program to run that can force the files to be rechecked without shutting
down the entire server and restarting it?
--
Mark P. Hennessy [EMAIL PROTECTED]
On Fri, 6 Sep 2002, Gerald
Is there any way to just force the MySQL server to reload from the table
data on disk? The recipient servers are read-only, and the sending server
has a relatively infrequent rate of change, but just enough that it's important
to make sure that things are flushed on the recipient servers every
Thanks for the quick reply Gerald.
What specifically is being loaded? The system load certainly isn't the
problem. Is it a buffer that fills, or a lock queue, or something else?
Although the inserts are done in rapid succession, there is only one
connection at a time so it shouldn't be a # of
I don't want to use replication as IIRC it would require that the sending
MySQL server be listening externally.
--
Mark P. Hennessy [EMAIL PROTECTED]
On Fri, 6 Sep 2002, Jeremy Tinley wrote:
Date: Fri, 6 Sep 2002 15:26:45 -0500
From: Jeremy Tinley
Well, you can't overwrite the data files while the server is running.
Mark Hennessy wrote:
Shutting down the servers is not an option unfortunately, is there any
program to run that can force the files to be rechecked without shutting
down the entire server and restarting it?
--
Mark P.
With many indicies, inserts can be slow, and since you are queueing
them up as fast as possible, no other queries have a chance to get in.
Monte Ohrt wrote:
Thanks for the quick reply Gerald.
What specifically is being loaded? The system load certainly isn't the
problem. Is it a buffer
Another Mac OS X problem... verified in 10.1 and 10.2
I'm guessing that the mysql client libraries don't support the port
option (-P or --port=)... On both 10.1 and 10.2, I can't get mysql,
mysqladmin, or mysqlshow (the on three I've tried) to connect to a mysql
server on any port other than
Sorry, user mysql and group mysql already exist, and permissions were
already set correctly. It didn't work.
Any more ideas?
Thanks again.
Tony
From: Gerald Clark [EMAIL PROTECTED]
Organization: Supplier Systems Corporation
Date: Fri, 06 Sep 2002 13:30:29 -0500
To: Tony Butcher [EMAIL
What is the following error? how do I fix it?
Thanks,
--Clemson
mysql alter table message1 add FULLTEXT (Title,Body);
ERROR 1121: Column 'Title' is used with UNIQUE or INDEX but is not defined
as NOT NULL
mysql desc message1;
+-+-+--+-+-++
|
I see. Is there a way to avoid the query queue and wait for a commit on
each insert, or must I guess at it and insert a few, sleep, repeat ?
TIA
Monte
Gerald Clark wrote:
With many indicies, inserts can be slow, and since you are queueing
them up as fast as possible, no other queries have a
At www.mysql.com I can download the source or the binary for macosx.
My question is what is the difference between the source and the
binary? I haven't found a description of the installation with the
binary or with the sourcecode.
Thanks for any help...
ilyas
What I also not understand is that one can also compile Mysql with
MIT-Pthreads. What is a MIT-Pthread? Where can I read more about this?
Thanks
ilyas
-
Before posting, please check:
http://www.mysql.com/manual.php (the
an indexed column cannot have null values, so it must be defined as 'not
null'
To fix alter the table so the two fields are not null
ALTER TABLE `message1` CHANGE `Title` `Title` varchar(64) NOT NULL
etc
then run your alter table
hth
Peter
---
'Body' column was converted from BLOB to TEXT as it shown in the
description.
How come the FULLTEXT still thinks it is a BLOB?
Please tell me if you know any work around. Thanks,
--Clemson
mysql desc message1;
+-+-+--+-+-++
| Field | Type
Hi,
First time here, hope someone can understand me and help me.
I have a field wich type that is int(4), and I'm updating it from a form. it
is working ok, unless the formfield is empty. When it's empty I'm receiving
an SQL error number 51().
In the db the field is setup to receive empty
Clemson Chan wrote:
=
!-- This HTML file has been created by texi2html 1.52 (hacked by
[EMAIL PROTECTED])
from manual.texi on 12 August 2002 --
Clemson Chan wrote:
The MySQL 3.23.52-nt (FTP image) I just downloaded from USA [UUNET]
(appointed by MySQL.com).
http://www.mysql.com/downloads/download.php?file=Downloads/MySQL-3.23/mysql-
3.23.52-win.zip
I realized that these two html (manual.html and manual_toc.html) files in
the docs
Thanks.
I will try to relax now.
But I didn't do any work today. :)
--Clemson
Do you know the answer to my BLOB/TEXT question I posted earlier.
I altered a BLOB column to TEXT, but FULLTEXT still thinks it's a BLOB.
What do I do to use this column in FULL TEXT? Thanks.
-Original
Restart mysqld with --skip-grant-tables option and reset password and
flush privileges..
See: http://www.mysql.com/doc/en/Resetting_permissions.html
Hope this helps..
Gurhan
On Fri, 2002-09-06 at 10:37, Adam Cripps wrote:
I'm locked out of mysql database - it seems that all my users can't
1 - 100 of 106 matches
Mail list logo