I have a brand new install of mysql . I have set every thing up just
like I have on many Linux server but this one I am getting an error
when I try to create a database from the Command line from and PHP
script or from phpMyAdmin. Could somebody tell me what this error
is and how I can fix it. I
Hello friends
Is there anyone using mysql with delphi5.0
I will be very thankful to get some tips to connect to a remote server
running mysql4.0.3-beta using delphi5.0 odbc dsn.
I am able to connect with a local server but can't with a remote server.
I can't find any help in the delphi sites.
Matthew,
- Original Message -
From: Matthew Fallshaw [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Tuesday, September 17, 2002 5:40 AM
Subject: Re: InnoDB Win2k Service doesn't start
[EMAIL PROTECTED] (Matthew Fallshaw) wrote in message
news:[EMAIL PROTECTED]...
Now,
hi,
i am having problems with mysql 3.23.52
compiled from the sources and being ran
on openbsd 3.1.
it ocassionaly (a few times a day) gets signal 11.
there is no specific query (most often its just
count(*) from a table) that causes that.
i tried recompiling with custom options (e.g. -O2
Hi there!
We are thinking about setting up a unified login system in our company. This
involves linux/ irix machines (possibly through nis), windows machines
(through samba) and mysql servers. The question is, how to integrate the
mysql user/ password system into our machine login system (nis),
Dyego,
- Original Message -
From: Dyego Souza do Carmo [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Monday, September 16, 2002 10:26 PM
Subject: The my.cnf and InnoDB tables
The options in my.cnf
record_buffer
join_buffer
sort_buffer
key_buffer
are used by InnoDB
Hi
I just installed a mysql 3.23.52. I want to set a password for root. But
when I execute :
C:\mysql\bin\mysqladmin -u root password aaa
system remind:
mysqladmin:connect to server at 'localhost' failed
error: Access denied for user:'root@localhost'(using password:No)
Please tell me
Take a look at the MySQL Changelog for the newer version:
Changed handling of gethostbyname() to make the client library thread-safe
even if gethostbyname_r doesn't exist.
So, get the new source, and it should compile without errors...
Michiel Klaver.
Hi,
Is there any other efficient way (--except using LIKE)of searching a keyword
in mysql ...
thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Hi,
Is there any other efficient way (--except using LIKE)of searching a
keyword
in mysql ...
thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi,every one:
pls help me.
i have downloaded a mysql 3.23.52 server and client linux rpm package.
i installed them on rh7.2
everything is ok.
and the mysqld daemon has also been started.
but when i try to change the root password using the folloing command:
/usr/bin/mysqladmin -u root
Thanks a lot Chris
It worked for me.
But I refered somewhere , that using excessive index will eat up resources.
So is it mandatory to use index even if I am not using them for something
like search?
regards
Kayamboo Suresh
- Original Message -
From: "Chris Tucker" [EMAIL PROTECTED]
To:
when will we be able to set our own word determination?
when will mysql support multibyte fulltext index
_
ÏíÓÃÊÀ½çÉÏ×î´óµÄµç×ÓÓʼþϵͳ¡ª MSN Hotmail¡£http://www.hotmail.com/cn
Using indices will slow down inserts/updates on columns, and will use
some amount of storage space (dependant on the size of the columns
indexed, the number of columns indexed, etc.). However, they
significantly improve performance when doing lookups in a table, which
is especially important
According to the manual, if INSERT IGNORE finds a row already present in
the table, it does not update the row with the new data. How can I get the
opposite behaviour? In my case, there shouldn't be a record with the unique
ID I am inserting. But if there is, my recovery behaviour is to delete
Hi,
I have a question on how to make a simple search...
I have two columns in a MySQLdb-table: item, price
I want to list all items with their prices. However, items with the same
price should be concatenated.
I've looked through the manual - but can't figure out how to concat
rows
Bryan Koschmann - GKT wrote:
Hi,
We have an accounting program that was writting in visual basic and runs
on microsoft sql. I was told it uses ADO by the programmer (please note,
I'm not all up on this subject as I should be). I'm wondering if it would
be possible to connect to it somehow from
Hi
I have this weird problem, any help is much appreciated. I tried a lot of
things and searched in the documentation, etc. but haven't found a solution
yet.
I have a table 'LogSessions' with a field 'dDateCreation' (datetime type),
which has a normal index on it. A simple query like the
FULLTEXT index, look in http://www.mysql.com/manual.php
Jannes Faber
- Original Message -
From: Meltem Demirkus [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 17, 2002 10:33 AM
Subject: search question
Hi,
Is there any other efficient way (--except using
Hi,
Look at REPLACE statement.
Regards
--
Joseph Bueno
[EMAIL PROTECTED] wrote:
According to the manual, if INSERT IGNORE finds a row already present in
the table, it does not update the row with the new data. How can I get the
opposite behaviour? In my case, there shouldn't be a record
At 10:24 17/09/2002 +0100, [EMAIL PROTECTED] wrote:
According to the manual, if INSERT IGNORE finds a row already present in
the table, it does not update the row with the new data. How can I get the
opposite behaviour? In my case, there shouldn't be a record with the unique
ID I am inserting.
Try with a self-inflicted left join on the field price.
select a.item,b.item,price
from table a
left join table b on a.price=b.price
and a.item!=b.item
You should have:
a.Item b.Item Price
---
Item 125
Item 2 Item 6 33
Item 3
Hello
Following is the description of the problem being faced.
Problem:
The first timestamp column in a table is set to current date-time value as soon as we
update one or more columns in the table.
Example:
The guest information is stored in a table named GUEST. The schema for it is as
Mysql Version::
Server version 3.23.47-nt
Protocol version10
Connection . via named pipe
UNIX socket MySQL
OS::
Windows NT 4.0 Workstation
Hello
Following is the description of the problem being faced.
Problem:
The first timestamp column in a table
Hello,
Sometimes, index file of tables (tablename.MYI) locked by sistem then i
cannot runt any query. So, i restart sytem.
Myodbc database used, Delphi based program with Myodbc, i think this problem
caused by it, but i did not find any solution without restarting my server.
Dou you know
hi
i faced a problem in connecting mysql with vb6
through odbc driver
sometime it works well but some time it gives error
message can't initialize provider. catastrophic
error
when i fulsh host then again it works for some time
but again gives same problems.
plz send me solution to my problem
Hi Klaus,
Thank you very much,
i have found the reason.
in fact ,my files and directory's properties are not correct.
i reinstall mysql according the doc
:http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#L
inux-RPM
and now everything is ok.
Best regards,
Roger
Prafulla,
please check documentation http://www.mysql.com/doc/en/DATETIME.html
...
The TIMESTAMP column type provides a type that you can use to automatically
mark INSERT or UPDATE operations with the current date and time. If you have
multiple TIMESTAMP columns, only the first one is updated
Hello,
I've just had a MySQL crash on a very simple operation. I have the
following table:
***
+---+---+--+-+-++
| Field | Type | Null | Key | Default | Extra |
help with Searching MySQL fields in PHP forms.
We have a couple of search pages on our site and I would like to know what
wild card characters can be used, for example % before or after a keyword.
If there is a list could someone please point me in the right direction.
Thanks.
-David
hello sir,,
I have downloaded Beta version of Mysql 4.0.3
I didnt find any source code in it..
Will u please inform me how can i get source code in
it
Thanking u...
Kalyan
__
Give your Company an email address like
ravi @
I have got the msql server running and now need to configure it. In
particular I want to set it up to use innodb tables. When I set up mysql on
win98 I used the mysql-max release which comes with built in Innodb support
and provides sample my.cnf files with the instructions for setting up
Hello,
The normal binary packages don't include source code. You have to download
the source code package (also available from those download pages). For
most users this will suffice, but the source is also available on
BitKeeper server (see the Technical Reference for installing from the
source
- Original Message -
From: Peter Goggin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 17, 2002 3:55 PM
Subject: Re: Re MySQL on Redhat 7.3
I have got the msql server running and now need to configure it. In
particular I want to set it up to use innodb tables. When
Is your win2k server networked? does it have multiple users? I would first
check the various profiles to ensure it was not moved to a different
profile. Next I would ask did the administrator install the server? if
another username installed the server even with admin rights that server is
now
Hello,
I cannot add an index to one of my tables. I get the following message:
mysql alter table devlog add index (dt_status);
ERROR 1030: Got error 127 from table handler
I've run 'myisamchk -o table' on the table in question.
What should I try next?
Version: Server version
Nod, the passwords are correct, I was attempting to hide my temporary bad choice of a
password, but did so poorly which you spotted.
The problem indeed was the master.info file. When I was originally setting this up I
had accidentally set the my.cnf file on the slave to look for a remote port
You may be only expecting one and only one row, but you should always
check if more than one row was retrieved for whatever reason. If more
than one row was retrieved, something went wrong and you should code
accordingly.
That said, you are interested in the LIMIT clause that someone else on
root,
Saturday, September 14, 2002, 9:55:54 AM, you wrote:
Description:
r I want to install MySQL-bench-3.23.52.1.i386.rpm with KDE RPM
r I get as answer: MySQL-DBI-perl-bin needed.
r I already had downloaded and installed this module:
r
rdkurth,
Tuesday, September 17, 2002, 9:43:37 AM, you wrote:
rasdn I have a brand new install of mysql . I have set every thing up just
rasdn like I have on many Linux server but this one I am getting an error
rasdn when I try to create a database from the Command line from and PHP
rasdn script
Roger,
Tuesday, September 17, 2002, 11:57:36 AM, you wrote:
RS i have downloaded a mysql 3.23.52 server and client linux rpm package.
RS i installed them on rh7.2
RS everything is ok.
RS and the mysqld daemon has also been started.
RS but when i try to change the root password using the
sufcrusher,
Monday, September 16, 2002, 11:28:37 PM, you wrote:
s I have this weird problem, any help is much appreciated. I tried a lot of
s things and searched in the documentation, etc. but haven't found a solution
s yet.
s I have a table 'LogSessions' with a field 'dDateCreation' (datetime
antispam,
Monday, September 16, 2002, 11:25:31 PM, you wrote:
aafdn my log file (hostname.log) was soo large and i just deleted it(back up) and
created a new file called hostname.log but mysql does not stores anything in the log
file.. (i did mysqladmin
aafdn log-flush and server stop and
Meltem,
Tuesday, September 17, 2002, 11:33:56 AM, you wrote:
Is there any other efficient way (--except using LIKE)of searching a
MD keyword
in mysql ...
REGEXP, full-text search depends on what you need. Why don't you like
'LIKE'?
http://www.mysql.com/doc/en/Pattern_matching.html
smudholkar,
Tuesday, September 17, 2002, 12:26:05 AM, you wrote:
saadc I am trying to write a delete query that will remove
saadc records from one table based on information from
saadc another table. In this example, there is a table called
saadc accounting which contains two fields: username
kayamboo,
Tuesday, September 17, 2002, 9:43:07 AM, you wrote:
k Is there anyone using mysql with delphi5.0
k I will be very thankful to get some tips to connect to a remote server
k running mysql4.0.3-beta using delphi5.0 odbc dsn.
k I am able to connect with a local server but can't with a
Prafulla,
Tuesday, September 17, 2002, 2:12:58 PM, you wrote:
PG Following is the description of the problem being faced.
PG Problem:
PG The first timestamp column in a table is set to current date-time value as soon as
we update one or more columns in the table.
It's a normal behaviour of
Mike,
Erro 127 means that the table is marked as crashed. You should run a
check and repair if necessary.
Error code 127: Unknown error
127 = Record-file is crashed
I hope this helps.
-Original Message-
From: Mike Lucente [mailto:[EMAIL PROTECTED]]
Sent:
Hello,
This error doesn't give any information on what is exactly wrong with
MySQL. See mysql\data\mysql.err or mysql\data\yourhostname.err logs for
more information. Also check your my.cnf.
Regards,
Iikka
On Tue, 17 Sep 2002, Chris Stanley wrote:
When I try to start Mysql service under
Thanks for your reply!
I had read about the 30% too, however in the SELECT query without the INNER
JOIN the EXPLAIN result is this:
table type possible_keys key key_len ref rows Extra
LogSessions range IDX_LogSessions_dDateCreation
IDX_LogSessions_dDateCreation 8 812548 where used; Using index
When I try to start Mysql service under services on a Win2000 machine I get
the following error message.
'Could not Start the MySql service on local computer.
Error 1067: The process terminated unexpectedly'
I am new to MySql so any help given will be much appreciated.
Thankyou in advance
Isn't that what 'myisamchk -o' does?
On Tue, 17 Sep 2002, Victor Pendleton wrote:
Mike,
Erro 127 means that the table is marked as crashed. You should run a
check and repair if necessary.
Error code 127: Unknown error
127 = Record-file is crashed
I hope this helps.
Description:
Heikki,
1) There is only one record with 'GARCIA MANCILLA,S.L'.
2) Mysql reported 53 scanned rows when I ran your mock-up query on your mock-up
table. This is ok.
3) I'm using mysql.exe client (sometimes I use front-end) and i don´t think it
removes the LIMIT 50
after install mysql
[root@localhost mysql]./scripts/mysql_install_db
bash:./scripts/mysql_install_db:no such file or directory
Is the files not install ?
_
MSN Photos is the easiest way to share and print your photos:
Hello,
Check your working directory (type pwd) and check if the scripts directory
exists at all (type ls).
What version did you install and on what operating system? Was it a binary
or a source release?
Regards,
Iikka
On Tue, 17 Sep 2002, Winnie Kwok wrote:
after install mysql
At 16:45 + 9/17/02, Winnie Kwok wrote:
after install mysql
[root@localhost mysql]./scripts/mysql_install_db
bash:./scripts/mysql_install_db:no such file or directory
Is the files not install ?
If you installed a binary distribution, look in the bin directory
where mysql and the other
Can anyone point me in the direction of some good doc on MYSQLGUI for Win2K?
Looking for Install/Setup notes.. Also is the Flash Light Tool Kit needed
to run the GUI?
Thanks,
DK
David Kramer
Software Developer
Reflect.com
Direct: 415.369.4856
Cell: 650.302.7889
Hello...
You'll have to excuse my ignorance, I'm new to MySQL and I've been hunting
online for hours yesterday and couldn't find the answer. Maybe you out
there can help. I'm wondering if it's possible to upload external documents
ie: (word, pdf's,etc) into a MySQL database? We've been able
I'm installing the mysql-max-3.23.52-pc-linux-gnu-i686 version. But I don't
have the root permission, and don't have the /var/lib/ access permission.
And I got the following error when I ran the ./configure commend. Do anyone
know how to change the /var/lib/mysql directory to something else?
My query:
SELECT
count(id),
count( IF(call_end - call_start 5, id, NULL) ),
count( IF(call_end - call_start = 5, id, NULL) )
FROM
t_calllog_calls;
My result:
1994
1956
35
However, 1956 + 35 != 1994.
Running MySQL 3.23.49-nt
Cheers,
Rich
On Tue, Sep 17, 2002 at 11:59:42AM -0700, Richard Unger wrote:
My query:
SELECT
count(id),
count( IF(call_end - call_start 5, id, NULL) ),
count( IF(call_end - call_start = 5, id, NULL) )
FROM
t_calllog_calls;
My result:
1994
1956
35
However, 1956
Hi,
I think you should try to use 0 instead of NULL
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Richard
I _thought_ it was the fault of the aggregate function, but now I'm really confused!
When I produce them as 3 separate queries, I still get numbers that don't add up:
mysql select count(id) from t_calllog_calls;
+---+
| count(id) |
+---+
| 1994 |
+---+
1 row in set
That would just give me 1994 for all 3 columns of output. What I want to know is how
many calls were longer than 5 seconds, how many were = 5 seconds, and the total
number of calls.
Cheers,
Rich
-Original Message-
From: Gelu Gogancea [mailto:[EMAIL PROTECTED]]
Sent: Tuesday,
id is the primary key. There are no entries in the DB where id=NULL
Cheers,
Rich
-Original Message-
From: Brian Reichert [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 17, 2002 12:16 PM
To: Richard Unger
Cc: [EMAIL PROTECTED]
Subject: Re: aggregate functions producing bad
In the last episode (Sep 17), Brian Reichert said:
On Tue, Sep 17, 2002 at 11:59:42AM -0700, Richard Unger wrote:
My query:
SELECT
count(id),
count( IF(call_end - call_start 5, id, NULL) ),
count( IF(call_end - call_start = 5, id, NULL) )
FROM
what does
Select count(id) from t_calllog_calls where id IS NULL
give you?
On Tue, 17 Sep 2002, Richard Unger wrote:
That would just give me 1994 for all 3 columns of output. What I want to know is
how many calls were longer than 5 seconds, how many were = 5 seconds, and the total
number
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 17, 2002 12:31 PM
To: Brian Reichert
Cc: Richard Unger; [EMAIL PROTECTED]
Subject: Re: aggregate functions producing bad data
In the last episode (Sep 17), Brian Reichert said:
On Tue, Sep
mysql Select count(id) from t_calllog_calls where id IS NULL;
+---+
| count(id) |
+---+
| 0 |
+---+
1 row in set (0.00 sec)
-Original Message-
From: mtoth [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 17, 2002 12:39 PM
To: Richard Unger
Cc:
On my server the MySQL database decided to die on me. So I killed it and
restarted and that didn't work. So I just rebooted the machine. Now I'm
getting this error below.
Invalid SQL: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=1
mysql error: Can't open file:
Hi,
One thing I'd check: what happens if t_calllog_calls.id is NULL?
...is not count.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
-
...or you can try :
SELECT
count(*),
count( IF(call_end - call_start 5, id, NULL) ),
count( IF(call_end - call_start = 5, id, NULL) )
FROM
t_calllog_calls;
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL
Using DESC on an index only works with V 4.
Philip Smolen wrote:
I'm trying to make a query faster. It seems simple, but I can't make it
work.
This is a common case for me:
SELECT *
FROM very_large_table
WHERE (simple_condition)
ORDER BY an_indexed_field DESC
LIMIT 5;
For simple queries this
Hello,
We are thing about moving from MS-SQL to MySQL. We are in the very early
planning of creating a data warehouse. Does anyone have any information
regarding the +/- of using MySQL vs MS-SQL. The db will at most be 20gb
with about 100 users.
A few questions would be:
Is there a way to
Description:
When doing a 'gmake install' with DESTDIR= set, 'libs' directory
is not installed properly
How-To-Repeat:
(build MySQL)
gmake DESTDIR=`pwd`/.install
Notice that a directory '.install..' gets created in the current
directory.
Is call_end - call_start a integer, maybe the range is to big and it is
eval'd as NULL or false. shrug.
On Tue, 17 Sep 2002, Gelu Gogancea wrote:
Hi,
One thing I'd check: what happens if t_calllog_calls.id is NULL?
...is not count.
Regards,
Gelu
MySQL -- to defeat the spam filter
-Original Message-
From: Richard Unger
Sent: Tuesday, September 17, 2002 1:46 PM
To: 'Dan Nelson'
Cc: [EMAIL PROTECTED]
Subject: RE: aggregate functions producing bad data
Thanks, I figured it out. It turns out there were some calls for which
Hi.
Could you run the following query:
SELECTIF(call_end - call_start 5, id, NULL) AS long,
IF(call_end - call_start = 5, id, NULL) AS short,
COUNT(*)
FROM t_calllog_calls
GROUP BY long, short
Given that I have not made any mistake, that should list all rows
Don't run myisamchk while the server is running.
Mike Lucente wrote:
Isn't that what 'myisamchk -o' does?
On Tue, 17 Sep 2002, Victor Pendleton wrote:
Mike,
Erro 127 means that the table is marked as crashed. You should run a
check and repair if necessary.
Error code 127: Unknown
Hi,
I may get in position to protect
my choice of MySQL being confronted
by completely non-technical
management. Management is likely
to argue in favor of MSSQL (nice GUI,
many people who know it, they are
used to it, you can do any project
on any DB, blah blah blah). All this
crap.
Anyone has
- Original Message -
From: Yuri [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, September 18, 2002 12:37 AM
Subject: Marketing materials ??
Hi,
I may get in position to protect
my choice of MySQL being confronted
by completely non-technical
management.
This is for anyone out there storing Japanese characters along with
English characters. I've searched everywhere for anything that has to do
with my particular situationwith no progress. I'm stuck.
SUMMARY:
The client recently requested that Japanese be stored in an otherwise
standard
This is for anyone out there storing Japanese characters along with
English characters.
SUMMARY:
The client recently requested that Japanese be stored in an otherwise
standard English (Latin) MySQL database. Whereas all rows in the table
used to be Latin only, now some rows store Latin and
Storing JP and EN data in the same table has worked for me ever since I
started using MySQL. Unlike Oracle, you don't need any specific charset
configs (I may stand corrected). The idea is to use the correct
character encodings when you *display* the data after pulling it out. In
your case, I'd
Thank you Thank you.
Are you running MySQL on Windows and using ASP on the web server?
When I display the data after pulling it out, I use Shift_Jis.
Yes, I mean the DOS prompt. My default language is English. I fear
changing my locale because I wouldn't be able to change it back without
a
Right. The simple example listed at the bottom of this message works great
under version 4. Version 3 gave the right answer, but it was very slow.
That made me upgrade to version 4.
However, even with version 4, I run into the same problem as soon as I add a
join. MySQL always wants to find
I am trying to get mysql-server installed from the FreeBSD port but keep
getting this dog-gone error -
mysqld started
Can't start server: Bind on unix socket: Permission denied
Do you already have another mysqld server running on socket:
/tmp/mysql.sock?
Aborting
Okay, so, I do a ps -aux | grep
On Tue, 2002-09-17 at 16:30, Robert Citek wrote:
Hello Chip,
Try 'rm /tmp/mysql.sock' MySQL creates a new one at startup.
- Robert
Tried that, it didn't create a new one. It still gives the same error
also, as if it is there.
I've installed previous versions of mysql a dozen times and
vinita vigine Murugiah wrote:
HI
I'm having problem with the AUTO_INCREMENT, we are using ver 3.23.33
This is the definition of table software_machineOSs
++--+--++-++
| Field | Type | Null | Key | Default |
I'm using MySQL v3.23.52.
I want to update a column in one table to be based on a calculated expression
from a column in another table.
Specifically I want something like this:
mysql update a set a.f1=b.f1 where a.f2=b.f2;
mysql update a, b set a.f1=b.f1 where a.f2=b.f2;
The first says table
I recently installed version 4 and converted my large tables to InnDB
format, after looking over the benchmarks. I ran my hour long read
only dB 'exerciser', only to discover it now took 132 minutes, or
about four times longer than I expected. I'm befuddled, I used the
same configure as
91 matches
Mail list logo