Hello all,
I have several questions in general since I recently started using MySQL.
From the manual I cannot find where these questions are covered. I hope
someone can assist me.
Firstly though, if this is not the correct mailing list for my questions,
please advise correct one.
Secondly,
Dear List,
My question is about this error message obtained during a query from word
to mySQL:
[MySQL AB][MyODBC] ERROR: Unknown MySQL Server Host thinkhost 11001
Hello all,
I have several questions in general since I recently started using MySQL.
From the manual I cannot find where these questions are covered. I hope
someone can assist me.
Firstly though, if this is not the correct mailing list for my questions,
please advise correct one.
Secondly,
Here's the simplified query:
SELECT members.name, group.id, group.name
FROM members
LEFT JOIN members AS group
ON group.id = members.group_id
WHERE members.id = 6
And here's the error I get:
You have an error in your SQL syntax near 'group ON group.id =
Hi,
Try to change the alias - group is a reserved word and it is causing the syntax error
This one should work
SELECT members.name, gr.id, gr.name
FROM members
LEFT JOIN members AS gr
ON gr.id = members.group_id
WHERE members.id = 6
Dobromir Velev
Web developer
http://www.websitepulse.com/
HI,
The 127 error message is Record-file is crashed - use
myisamchk -r table_name
to fix it.
For further information on this topic check
http://www.mysql.com/doc/R/e/Repair.html
Hope this helps
Dobromir Velev
Web Developer
http://www.websitepulse.com/
-Original Message-
From:
Hi,
using LIMIT can speed up the things significantly. If you know the aproximate number
of rows in your query just add LIMIT
number_of_rows at the end of your query - it will look like
SELECT products.return
FROM products,prodcat
WHERE products.prodno=prodcat.prodno
AND products.Store=0001
I have a .sql file that I want to use to create tables and load data via
the MySQL utility. The source command seems to be the way to do this but
I haven't been able to discover where to copy the .sql file to in order to
make it accessible to MySQL.
Example;
MySQL- source path?MyFile.sql
Do
Just a thought.
It is a well known fact that MySQL is being used as the backend software for
Yahoo Finance.
However, the response as mentioned in this mail is also typical from a customer
looking at commercial application development.
How can the larger business community perception be changed
Dear List,
As I don't seem to get MySQL data from my server to my local drive into
word, where I would be printing envelopes for a mailing, I wonder what
other options are out there?
I can easily get the data into EXCELbut I haven't figured out if
EXCEL prints envelopes or labels?
Hi,all MySQL teams:
First let me wish you all happy new year!
Wish Mysql win more victories in DB area.
I am a programmer in CA. I know Mysql supports
multiple instances. One way is to install different servers,
on each server, runs an instance. The other way is to
use one server, one
Peter
I suggest getting hold of the MyODBC drivers (you'll find reference to it in
the mysql manual)
Once installed you can attached to mysql tables in MS Access, then use the
report wizard in there to create your labels or if you are more confortable
in word you can open the access mdb file
To whom it may concern,
I am trying to use the following statement, select table1.* from table1,
table2 where table1.id=table2.id;
This just ends up in what looks like the computer hanging, but all my
computers resources get used up, so something must be going on.
I am running mysql version
Peter,
You can create a link to M$ Access or M$ Excel via ODBC and then use this in
your M$ Word as a MailMerge data source.
There is no option in Word to use an ODBC data source.
HTH
Norman
-Original Message-
From: Peter Reck [mailto:[EMAIL PROTECTED]]
Sent: 29 December 2001 09:56
Thanks for your reply.
I have read the mysql manual, but i can only found
how to setup multiple servers not multiple instances in
one server.
BTW, can you tell me can different mysql instances
share one dictionary --mysql database?
Thanks.
Robert Li
Computer Associates
Programmer, RD
I am writing an application which requires FULLTEXT indexing capability,
and ACID transaction support would also be a plus. I am currently
developing on MySQL 4.0.1.
As I understand it, MyISAM tables support FULLTEXT indexing but do not
support ACID transactions. Also, InnoDB tables support ACID
Hank,
I suspect some of the NetBSD threading comments you found in the archives
may be mine.
We run NetBSD/Alpha for our site (motorsport.com) on the web server, our
work server, plus several other boxes. We originally did the same for the
database server, but, at the time (this being early
Matthew,
Without any more information, I would put money on this being either a
database design issue or a query design issue. I really expect that
database optimization would buy you a lot of performance.
But without knowing what kind of database structure you have, what kind of
queries you
Thomas Zehetbauer writes:
I mistakenly set the value of a DATETIME column to the value of
UNIX_TIMESTAMP(). I know that this is not good practice and I would have even
expected it to fail.
But what has happened was totally unexpected for me, invalid date values like
'2000-10-09 55:17:71'
I like using compound indexes, but they make the database
VERY big, and slow to load. The last 2 million entries took over
24 hours to load using mysqlimport, normally a fast program.
The data file has swollen from 580M to 2G.
The index file from 180M to over 3G.
I can't help but think that a
Jeff Costanzo writes:
with this code:
Query myQuery = pDatabase-query();
myQuery Select * from repdata;
myQuery.store();
I get an
Debug Assertion Failed
in file dbgheap.c
line 1017
Expression: _BLOCK_TYPE_IS_VALIDE(pHead-nBlockUse)
pDatabase is a pointer to a connection object.
Thank you for the fix.
We are still using 6.3
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
___/
* Emmanuel van der Meulen
1. Assuming the website grows very large with high volumes and a database
exceeds disk space, please advise what is the remedy?
Add HW or remove data...? Not sure if I understand your question...
2. Seeing as for the said website I use transactions, thus also the
I wonder if mysql uses indexes in temporary tables(when making a join on
temp tables etc.)?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Goran Krajacic writes:
I wonder if mysql uses indexes in temporary tables(when making a join on
temp tables etc.)?
MySQL treats temp tables same as normal ones, except when the thread
ends ...
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic
Hello Roger,
Thank you for your note and replies. Please see my further points inline;
On 29 December 2001 16:21, Roger Baklund wrote;
* Emmanuel van der Meulen
1. Assuming the website grows very large with high volumes and
a database
exceeds disk space, please advise what is the
I've got a database already populated with data and need to add a
sequential numerical id field as a key. (as one would with an auto
increment field)
Is there a straightforward sql statement that will do this?
Gawain
-
A novice-level question... i've just installed the binary version of mySQL
4.0.1-Max for darwin ... but gives me the following error when i try to run
the mysql_install_db script:
sorry the host 'myhostname' could not be looked up.
.etc.
hints?
: I've got a database already populated with data and need to add a
: sequential numerical id field as a key. (as one would with an auto
: increment field)
:
: Is there a straightforward sql statement that will do this?
ALTER TABLE t_name ADD id INT UNSIGNED NOT NULL AUTO_INCREMENT
At 12:04 PM -0600 on 12/29/01, Sherzod Ruzmetov aka sherzodR wrote:
: I've got a database already populated with data and need to add a
: sequential numerical id field as a key. (as one would with an auto
: increment field)
:
: Is there a straightforward sql statement that will
At 12:04 PM -0600 on 12/29/01, Sherzod Ruzmetov aka sherzodR wrote:
: I've got a database already populated with data and need to add a
: sequential numerical id field as a key. (as one would with an auto
: increment field)
:
: Is there a straightforward sql statement that will
Hello all,
I need to write a query that will insert data into a table if there is no
row matching a pre-specified ID, but will update a row if it matches a
pre-specified ID.
Any pointers would be great.
-
Before posting,
Hello !
what I want to do is :
display all the NOT NULL fields of 1 row, this row being selected with
a key [ for example : tabID.login='john' ] .
I DO NOT KNOW IN ADVANCE WHICH FIELDS ARE SUPPOSED NOT NULL,
since it varies along with the key [ tabID.login='jack' would give other
NULL fields ]
hi there,
I was writing a MS VB 6 code and I have added to the form a DBGIRD component
(unbound) to display the data, which was retrieved by an sql statment to the
from from a MySQL database into a recordset.
But I got an error in the VB mentioned the following:
Rowset not Bookmarkable
I
Hi,
-Original Message-
From: yousif shams [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 29, 2001 7:34 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Vb DbGird Limitation
hi there,
I was writing a MS VB 6 code and I have added to the form a DBGIRD component
* Emmanuel van der Meulen
Roger, assuming the database space as allocated is used up and I
do not want to remove the data, but I have lots more space to
allocate, is there a way to extend allocated space in flight?
Or, does MySQL automatically (and inflight) extend beyond
allocated space
Hi,
Is it possible to store binary files ( .jpgs, .gifs, .zips, etc) in mysql
tables? If yes, can you point me to any direction?
Thank you very much.
Gurhan
-
Before posting, please check:
* Gurhan Ozen
Is it possible to store binary files ( .jpgs, .gifs, .zips, etc) in mysql
tables? If yes, can you point me to any direction?
Yes, it is possible, see the url below. In general it is recomended to keep
the binary files in the OS file system, and only store the path to the file
in
* Joel Wickard
I need to write a query that will insert data into a table if there is no
row matching a pre-specified ID, but will update a row if it matches a
pre-specified ID.
Any pointers would be great.
The REPLACE statement:
URL: http://www.mysql.com/doc/R/E/REPLACE.html
--
Roger
I have a record that keeps track of averages, now when I say
SELECT * FROM tblname ORDERBY 'average' DESC;
It returns the one with the largest amount of intergers...
I.E.
It will say that 52.50 is a larger number than 358, why is that? Is that a
table column setting of a datatype?
Todd, this result is perfectly correct if they are both strings:
52.50 is greater than 358. To make them interpreted as
numbers instead, see the manual page:
http://www.mysql.com/doc/C/o/Comparison_Operators.html
Steve
Todd Williamsen wrote:
I have a record that keeps track of averages,
I found an easier way... switch the datatype to decimal, WHAMMO!! works
beautifully!
- Original Message -
From: Steve Rapaport [EMAIL PROTECTED]
To: Todd Williamsen [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, December 29, 2001 7:03 PM
Subject: Re: Select statement with
I have searched the net and mysql site and ran accross this list. I'm sure
I have a simple problem. BTW, does this list have a searchable archive? I
hate to post something which I'm sure is common.
Any way, I have a freash install of slackware and I selected the mysql
option.
If I just
Hi,
I'm trying to install DBD::MYSQL on Windows 2000 Pro.
I've already install DBI
Using ppm for ActivePerl
I downloaded DBI and extracted it to a folder.
Then i ran
ppm intall DBI
It installed fine.
I did the exact same thing for DBD::MYSQL but i get the following error
Does anyone have the location of a php-mysql-4.0.3 version that I could
download?
Tobe
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
If you're looking for php. suft on over to the PHP homeworld:
http://php.net current version is 4.1.1
David
Does anyone have the location of a php-mysql-4.0.3 version that I could
download?
Tobe
-
Before posting,
Hi,
I'm trying to compile and link a small program on Win98 with borland's
free C compiler (version 5.5.1)
Here is the code:
(test.c)
#include winsock.h
#include windows.h
#include mysql.h
#include stdlib.h
#include stdio.h
int main()
{
MYSQL *mysql;
mysql = malloc(sizeof(MYSQL));
Description:
See earlier emails from me. Same problem.
How-To-Repeat:
Fix:
Submitter-Id: [EMAIL PROTECTED]
Originator:[EMAIL PROTECTED]
Organization: Auctionwatch.com
MySQL support: login
Synopsis: Mysql crashing.
Severity: critical
Priority: high
Category: mysql
Did you do install mysql or install DBD-mysql?
Here's what the activestate page has to say:
ActivePerl offers a PPM archive of DBD::mysql. All you need to do is typing
ppm
install DBI
install DBD-mysql
This will fetch the modules via HTTP and install them. If you need to use a
WWW
As far as I can tell, mysqlhotcopy does not provide a way of specifying
the password anywhere other than the command line (e.g. it doesn't seem
to read .my.cnf).
Isn't this a security risk? I noticed that mysqlhotcopy *does* change its
ps entry after it starts in order to mask the arguments, but
You can usually try providing an empty -p parameter and be asked for the
password afterwards.
Bogdan
Philip Mak wrote:
As far as I can tell, mysqlhotcopy does not provide a way of specifying
the password anywhere other than the command line (e.g. it doesn't seem
to read .my.cnf).
On Sun, 30 Dec 2001, Bogdan Stancescu wrote:
You can usually try providing an empty -p parameter and be asked for the
password afterwards.
Doesn't seem to work:
[mysql@lina mysql]$ mysqlhotcopy -u root -p test .
DBI-connect(;host=localhost;mysql_read_default_group=mysqlhotcopy)
failed:
mysqlhotcopy -uroot -p test .
Philip Mak wrote:
On Sun, 30 Dec 2001, Bogdan Stancescu wrote:
You can usually try providing an empty -p parameter and be asked for the
password afterwards.
Doesn't seem to work:
[mysql@lina mysql]$ mysqlhotcopy -u root -p test .
Ooops! Sorry, I tested it and it doesn't work! Sorry for misleading you... ;-)
Bogdan
Bogdan Stancescu wrote:
mysqlhotcopy -uroot -p test .
Philip Mak wrote:
On Sun, 30 Dec 2001, Bogdan Stancescu wrote:
You can usually try providing an empty -p parameter and be asked for the
Hello,
I'm fairly new to MySQL and I was wonder if there was a way to, well let's
say encrypt a password in a column? I would like to have a users table in my
database and in it I would like to have a password column, but I don't want
the password in plain text. Is this possible?
Thanks,
- Tom
I am using a binary installation of MySQL for Linux 7.1...how do I tell what
database it is configured to use for the backend? InnoDB or something else?
-bryanw
.BIZ, .INFO, .CC .COM, .NET, .ORG
Pre-register your .NAME address now!
http://www.halfpricenames.com/
- Original Message -
From: Philip Mak [EMAIL PROTECTED]
To: Tom Jones [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, December 29, 2001 11:56 PM
Subject: Re: A password column
On Sat, 29 Dec 2001, Tom Jones wrote:
I'm fairly new to MySQL and I was wonder if there was a
If you are using PHP and do not want to pass clear-text passwords over a network to a
remote MySQL server, you can use the crypto
libs in PHP for one-way hashing too (I use MD5, for example).
- Original Message -
From: Philip Mak [EMAIL PROTECTED]
To: Tom Jones [EMAIL PROTECTED]
Cc:
Hello Roger,
Thank you for your note and feedback. With your assistance and reading up
on InnoDB, I'm getting closer. Further inline;
On 29 December 2001 22:21, Roger Baklund wrote;
[snip-1]
I think you would need to restart the mysqld server daemon, but
this is very
fast, and can be
59 matches
Mail list logo
