Is there some kind of pattern in fields containing
binary data - so you can be sure that is really IS
binary!?
I.e. if I in my database have a BLOB-field and
sometimes write a string, and sometimes a file?!
Regards David
-
hello mysql-team,
i am sorry if i do not correctly report this bug, but i do not know how i
should make it sure with a script, that you can verify or repeat this bug.
however i have a dump of my mysql-database attached to this mail and hope
it will be enough.
i am using mysql source distribution
Hello to all,
Is it possible to communicate with a database that is in a Internet server
without using PHP?
How can one make?
In "Host" it is necessary to put the primary server DNS?
Can it be carried out the communication with Delphi? What parameters is it
necessary to use?
Thank you.
Best Reg
I install the obdc driver for mysql and then anothers database what runing (way others
odbc drivers, as infomix) in my computer don´t runing more.
Please help
At 12:13 PM -0400 5/28/01, Nicu Popovici wrote:
>Hello guys,
>
> I managed to compile succesfully my C program but now when I run it I get
>something like the following
>---
>
>TEST1
>Failed in SELECT , Error: You have an error in your SQL syntax near ')' at
>line 1
>-
At 10:22 AM -0400 5/28/01, Nicu Popovici wrote:
>Hello,
>
>I took out the m_string.h file from include directive and I get the following
>error
Well, sure. You already know that you need that file; taking it out
won't help anything.
>
>
> gcc -g Bug_Report.c -O -o TEST1 -I/usr/
What does this mean and how do I fix it, I just finished installing from
source tar.
[root@Precious /]# mysql -u root -p
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
Dave
---
i would like to convert my sql server data into
mysql, how can i do ??
/---\
Confidential and/ or privileged information may be contained in this
e-mail and any attachments transmitted with it ('Message'). If you are
not
- Original Message -
From: "Daniele Iachini" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 28, 2001 6:50 PM
Subject: Help w/MySQL and Dreamweaver Ultradev
> I'm not able to manage dates correctly in dreamweaver, expecially when a
> form with dates is submitted to update a
I'm not able to manage dates correctly in dreamweaver, expecially when a
form with dates is submitted to update a record.
The singular -mm-dd format of MySQL in fact is correctly put in
dd/mm/ (that's ok for my country and is my locale) but when i submit the
form, even without changes, it
I just converted a 48meg 90,000 row dbf file using dbf2mysql off of the
MySQL site. Worked very nice for me on Win2K.
Cheers
Mike
-Original Message-
From: Pat Suwalski [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 28, 2001 6:25 PM
To: [EMAIL PROTECTED]
Subject: Help! How to use dBase wit
Martin,
You should try the following. It's work for me.
mysql> connect mysql;
mysql> update user set password=PASSWORD('newpassword') where user='auser';
mysql>FLUSH PRIVILEGES;
Regard,
Emanduel Chan
- Original Message -
From: "Martin RODOT" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]
Hello,
When trying to do a large select statement like the following this error
is returned:
select account.username,person.firstname,person.lastname,
person.company_name, person.street,person.city,person.state,
person.zip,person.franchise,
person.card_number,person.expires,account.date,tran
Hello,
I am running MySQL 3.23.37 on an OpenBSD 2.8 box. The db is working fine
and starts fine but I cannot seem to shut it down...
I do
mysql.server stop
and this is what I see in the logs:
010528 20:59:07 /usr/local/libexec/mysqld: Normal shutdown
but the command exits because it is takin
No, MySQL will not read dBase files.
I can think of 3 ways to do it off the top of my head.
1: Use Visual FoxPro. It will read dBase files and you can use the DBC to
open a connection to a MySQL database through an ODBC connection. (Been
there, done that)
2: Use a dialect of *Base to create an
Pat Suwalski wrote:
>
> I'm doing a school project for which I'm to write a PHP script with MySQL
> that searches a dBase database.
>
> I've got my code planned out, but the problem right now seems to be that
> mySQL can't directly read dBase databases.
>
> It's a fairly large database (9 megs)
I'm doing a school project for which I'm to write a PHP script with MySQL
that searches a dBase database.
I've got my code planned out, but the problem right now seems to be that
mySQL can't directly read dBase databases.
It's a fairly large database (9 megs), and so I ask: do I need to convert
>From http://www.mysql.com/doc/F/u/Fulltext_Search.html:
mysql> SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('MySQL');
Empty set (0.00 sec)
Search for the word MySQL produces no results in the above example. Word
MySQL is present in more than half of rows, and as such, is effectively
Hi,
Using MySQL 3.23.38, I have a table with a mediumtext field "contenu" and a fulltext
index on it.
The
field contains full HTML documents.
The following command usually works to find words:
select titre from sites where match(contenu) against ('virus')
The problem is, some words, like "Ne
Use fulltext indexes (http://www.mysql.com/doc/F/u/Fulltext_Search.html).
Queries with LIKE '%...%' will always be slow because they can't use
indexes, and you're doing SIX of them, of course it'll take a while. Only
drawback of fulltext indexes is (AFAIK) you can't match against fields in
separat
Hi to all of you!
The following query takes more than half an our to execute. I don't think
that is normal. Most time takes "copying to tmp table".
SELECT DISTINCT
Formular.titel AS formularTitel,
Formular.id AS formularId,
Anbieter.id AS anbieterId,
Anbieter.anbieterName AS anbieterName
FROM
Fo
I've (mostly) switched over from Win98 to Win2K on one of my home machines.
I have a Linux box sitting in a closet as a mail/web server, with Apache
logging its activity to a MySQL database. To browse the server logs, I
threw together a few lines of SQL in Access and had it use MyODBC to talk to
>I have a problem adapting a multiple select to MySQL.
>Can someone help me ?
>
>Here is my request (Oracle format)
>
>SELECT Tactic.teamCode FROM Tactic WHERE
>Tactic.teamCode NOT IN (SELECT Game.teamCode1 FROM Game, Turn WHERE
>Game.gameTurn = Turn.code)
>AND Tactic.teamCode NOT IN (SELECT Game.
Ryan wrote:
>
> Is it possible to store raw data (like image data) in mysql? If so, how can i
>accomplish it? (Should i need to make user-defined type?) Otherewise, what other
>databases support storing raw data?
You can use blob type.
--
_/_/ _/_/_/ - Rafał Jank [EMAIL PRO
Is it possible to store raw data (like image data) in mysql? If so, how can i
accomplish it? (Should i need to make user-defined type?) Otherewise, what other
databases support storing raw data?
-
Do You Yahoo!?
Yahoo! Auctions $2 Million Sweepstakes - Got s
If you are using only fixed-length (no VARCHARs, TEXTs or BLOBs) MyISAM
tables you can calculate it by finding the storage required for each row
(http://www.mysql.com/doc/S/t/Storage_requirements.html) and multiplying it
by the number of rows. If you are using variable-length MyISAM tables, you
sh
I need a way to determine the size of a single database on mySQL via an SQL
command.
I am running an application on a service provider that gives me a limited
amount of database space for my application. I want to be able to gauge the
percentage of that space that I am using. The only access I
Hello,
Normally, MySQL maintains a flat log file to write all queries passed to it.
Is it possible (any module or whatever) to get it to put this log into a
specific database, in order to be
processed more efficiently?
Thanks for the reply.
Maxim Pavlov
[EMAIL PROTECTED]
--
$newgoalquery = mysql_query("select players.PLAYERID, players.FIRSTNAME,
players.LASTNAME, COUNT(goals.SCORER) as TG FROM players, goals where
(goals.SCORER = players.PLAYERID) AND players.TEAMID = '$TEAMID' GROUP BY
PLAYERID ORDER BY players.LASTNAME");
I'm trying to fetch out the number of goal
Hello mysql,
I'm testing BDB tables in mysql to find out i'll be able to use
them in my application.
I was testing how does big tables work with BDB and so created table
which is about 10GB in size. I could easy make it with multiple
inserts from test-insert, so the problem with inse
> Please check the manual before sending a question to this list.. says
every
> messages.. So:
>
> http://www.mysql.com/doc/R/e/Reserved_words.html
I read it (please note the (*)):
A common problem stems from trying to create a table with column names that
use the names of datatypes or functions
On Tue, 22 May 2001, Jeremy Zawodny wrote:
> On Tue, May 22, 2001 at 10:37:20PM +0100, Nii Larnyoh wrote:
> > I have just loaded a MICROSOFT WORD document to be stored in a mySQL
> > blob column. I will like to know if the blob column that will be
> > indexed by the FULLTEXT indexer?
>
> Given
No, MySQL is neither PVM nor MPI aware and thus not a Beowulf application.
Had you asked this on the Beowulf mailing list they would have said too
because *by definition* Beowulf is solely intended for computational
clusters, not high availability or parallel database clusters.
Regards,
Gary "Sup
Paste EXPLAIN SELECT ... (your SELECT); from the mysql client.
> Hi!
>
> When I join 4 tables with about 3000 records in each mysql seems to work
> forever on "copying to tmp table".
>
> I wonder what that could be. I have enough free space in the tmp-dir and
> don't know what else could it be.
Please check the manual before sending a question to this list.. says every
messages.. So:
http://www.mysql.com/doc/R/e/Reserved_words.html
Workaround: give your table another name.
Bye,
B.
At 14:23 28-5-01 +0200, Alessandro Staltari wrote:
>Hello. I'm new to MySQL but I have a problem tha
Hi,
Excuse my english pleasei'll try to explain what i have to do.
I have two server running MySQL, at this time one is a master and the other a slave.
What I have to do is to make both master and slave together so if the master gows down
the system still work with the slavelike a cluster
Hi!
When I join 4 tables with about 3000 records in each mysql seems to work
forever on "copying to tmp table".
I wonder what that could be. I have enough free space in the tmp-dir and
don't know what else could it be.
The database-model is normalized and on another machine it takes me about 1
First, you need to REVOKE any existing priviledges for that user, then GRANT
the privileges you wish that user to have. This is detailed in the MySQL
Manual (http://www.mysql.com/doc/G/R/GRANT.html).
G. Jensen
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: M
Hello. I'm new to MySQL but I have a problem that appears serious, al least for me.
I can't create a table with a field named INFILE. I think mysql consider INFILE as a
keyword. Is there work around for this?
Shouldn't INFILE be used only within a LOAD statement? I think it is a bug in the
query
In fact this does not return me what I want :
If I have the tables
Tactic
teamCode 1
teamCode 2
teamCode 3
teamCode 4
Game
teamCode1 1 teamCode2 3 GameTurn 1
teamCode4 1 teamCode2 3 GameTurn 1
Turn
Code 1
My request would return me nothing
while your request would return me
different sets wit
Buyondo Charles writes:
> I'm running RedHat 7.0 with mysql-server-3.23.22-6. When I try installin the rpm I
>get the
> following message "MySQL-server is needed by mysqlgui-static-1.7.1-1"
>
>
Hi!
Please use our latest 1.7.5 static binary for Linux instead of RPM.
Regards,
Sinisa
On Mon, 28 May 2001, Lefebvre, Cedric wrote:
>
> I have a problem adapting a multiple select to MySQL.
> Can someone help me ?
>
> Here is my request (Oracle format)
>
> SELECT Tactic.teamCode FROM Tactic WHERE
> Tactic.teamCode NOT IN (SELECT Game.teamCode1 FROM Game, Turn WHERE
> Game.gameTu
Tiwonge Nathan Kawonga writes:
> Hi all;
> When I run the example in its original directory, I have no problems.
> When I wrap the example in my source, the source compiles but fail to
> link with a certain Library as shown in the output below. What I want is
> to get out the query results and use
hi
hope this is the correct list for questions...if not , sorry
i have a mysql server under linux, works fine but, if a user has an mysql
account eg: "XYZ" and connects then he can take a look into the other DB, of
other users ..he cant change any things. how i can set the permission for
read t
hello!
When I attempt to create a fulltext-index with the following code
ALTER TABLE press ADD FULLTEXT ruffsig (preamble)
everything seems fine. And the SHOW CREATE TABLE results ( see below )
seems
fine too!
Yet when I run a SHOW INDEX FROM press, the "sub_part" value
--- [EMAIL PROTECTED] wrote:
> Hi,
> I have a problem regarding Mysql database. how can
I insert more than 256 characters in a
> field
> of a table? Is it a limitation of Mysql database.
Actually I want to insert a large string
> which consists of more than 256 characters in a
> field.
> Pl let
Hi,
regarding
http://ep33.tp4.ruhr-uni-bochum.de/mlists/MySQL/May.2000/index.html#2025 , I
had the same problem with MySQL 3.23.30.
The following statement "Update Tree set left=left+2 where (left>$right and
right>=$right);" sometimes (not reproducable) locked up MySQL completely.
The "left" valu
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: my
Hi all;
When I run the example in its original directory, I have no problems.
When I wrap the example in my source, the source compiles but fail to
link with a certain Library as shown in the output below. What I want is
to get out the query results and use them in normal C++ environment.
Your hel
Hi all;
When I run the example in its original directory, I have no problems.
When I wrap the example in my source, the source compiles but fail to
link with a certain Library as shown in the output below. What I want is
to get out the query results and use them in normal C++ environment.
Your hel
Hi all;
When I run the example in its original directory, I have no problems.
When I wrap the example in my source, the source compiles but fail to
link with a certain Library as shown in the output below. What I want is
to get out the query results and use them in normal C++ environment.
Your hel
Hello mysql,
I've just upgraded my WEB-Server box (2xPIII-500Mhz, 1Gb mem) to
FreeBSD 4.3-RELEASE & update mysql to 3.23.38.
(mysql Ver 11.15 Distrib 3.23.38, for -freebsd4.3 (i386))
Usually mysqld was taken 8-20% of CPU usage (top results).
But after some days i'am notice that mysql takes all
Hi !
I'm a novice mysql administrator and acording to my Web Hosting Provider, my mysql
daemon is loading the CPU too much. The web has currently two main php scripts
regarding the MySQL daemon.
The first one shows a banner using the PHPAdServer application ( no clicks are
registered, only sh
Hello guys,
I managed to compile succesfully my C program but now when I run it I get
something like the following
---
TEST1
Failed in SELECT , Error: You have an error in your SQL syntax near ')' at
line 1
What I want to ask , I have to do
> The problem has been resolved. There is apparently an
> undocumented option
> (at least it's not documented in the HTML manual for 3.23.38)
> required in
> the my.cnf file - "use-symbolic-links". I was using all
> default values, so
> I wasn't even using a my.cnf or a my.ini file.
>
> Her
I was so excited to see that the latest FileMaker Pro finally supports SQL
stuff built in, but was disheartened to see that I could only use it with
Oracle and a couple other commercial servers. Is anyone out there working
on a mysql plugin for 5.5? FileMaker would seemingly be an awesome way to
I'm running RedHat 7.0 with mysql-server-3.23.22-6. When I try installin the rpm I get
the
following message "MySQL-server is needed by mysqlgui-static-1.7.1-1"
-
Before posting, please check:
http://www.mysql.com/manual.p
Did you
1. Use GRANT to create the user? If you didn't and inserted data
incorrectly into the grant tables, you could find problems later on.
2. Flush privileges after creating the user?
- Original Message -
From: "Martin RODOT" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monda
Hi,
I have used mm.mysql driver for jdbc connection. I've did all the neccessary
connection and the java application was able to load the driver, but there was this
problem. The java program was actually from the mm.mysql documentation.
Problem:
SQLException:Server configuratio
Subj.
Can I set it up on a cluster? I have so heavy load on my
MySQL server that I need to increase the power of my server.
I consider different ways of doing it and want to know if
somebody installed it successfully on a cluster.
Best regards,
Vinche mailto:[EMAIL PROTE
Hi !
I'm using MySql 3.23.38-nt on a test machine.
I'd like to create a new user and I tried :
--
mysql> connect mysql
Connection id:308
Current database: mysql
mysql> set password for auser = password("anewpassword");
ERROR 1133: Can't find any matching row
Hi all,
How to use MySQL LOAD DATA command to load comma separated text data
but one of the field can contains comma character as part of of the string context.?
In other word, I want LOAD DATA insert string with comma characters inside it but
without
adding slash character ('\')to distinguish i
Hello,
I took out the m_string.h file from include directive and I get the following
error
gcc -g Bug_Report.c -O -o TEST1 -I/usr/include/mysql -L/usr/lib/mysql
-lmysqlclient -lnsl
/tmp/ccWyxVrf.o: In function `main':
/home/nicu/QA/Bug_Report.c:15: undefined reference to `strmo
63 matches
Mail list logo
