Hello, all.
when I direct telnet to mysql server the mysql daemon is down or restarted
like this.
telnet my.mysql.server 3306
[root@www tmp]# /usr/local/mysql/bin/mysql.server start
[root@www tmp]# Starting mysqld daemon with databases from
/usr/local/mysql/var
and telnet to mysql port at th
As a novice in (My)sql I encounter this problem:
I would like to select from a table first the 39 records with the highest
variable1 and order them on variable2.
So I need something like a subselect and I can't figure out a way around it.
Ideally something like:
select * from table1 order by va
Hello members,
I'm new to mysql and need to conect to from ASP pages.
I have written the following code in ASP script
<%
dim email,objrs,strsql,strconn
email=Request.Form ("email")
strconn = "DSN=ebyte"
strsql="select * from log where email=('" & email & "');"
set objrs=server.CreateObject (
Hello all,
I have problem with ORDER BY in MySQL if I have some characters in iso-8859-2
and windows-1250. What I should do for fix it.
Thanks
Radek
-
Before posting, please check:
http://www.mysql.com/manual.php (
Check out how to get around subselect queries in the manual. But incase
your query is a little complex and cannot be solved as explained in the
manual, use temporary table(s).
When I had this problem I went round it using MySQL Temporary tables.
So in your case, you can do something like:
>CREAT
Hi!
This SQL works perfect when running the command line tool mysql.exe
SELECT exe, sum(duration) FROM data GROUP BY exe ORDER BY 2
BUT when running from the C API, the "ORDER BY" part doesn't seem
active, why?
Please help.
/Christer
-
Hello
I've got mysql 3.23.47 running on a freebsd 4.5 box for long time without
problems, until now that consumes nearly all available CPU.
Also, I am unable to stop the server using mysqladmin -u root shutdown (the
process freezes) neither can restart it. If I kill -9 the process it
restarts and
Christer Holmström (at Home) wrote:
> Hi!
>
> This SQL works perfect when running the command line tool mysql.exe
>
> SELECT exe, sum(duration) FROM data GROUP BY exe ORDER BY 2
>
> BUT when running from the C API, the "ORDER BY" part doesn't seem
> active, why?
>
> Please help.
>
> /Christer
>
>
Pada Mon, 4 Nov 2002 11:55:59 +0100
"Toni" <[EMAIL PROTECTED]> menulis:
> Hello
>
> I've got mysql 3.23.47 running on a freebsd 4.5 box for long time without
> problems, until now that consumes nearly all available CPU.
>
> Also, I am unable to stop the server using mysqladmin -u root shutdown (
Hi,
I've got a problem that I'm hoping someone can help with. I need to do
a query against a text column in order to extract entries that will
match whole words only - for example, a search for "cat" should match
any of:
The cat sat on the mat
It was a large cat.
Cat food is interesting.
Hi, and thanks for the response, but unfortunately the same problem with
both below
SELECT exe, sum(duration) FROM data GROUP BY exe ORDER BY 2 DESC;
SELECT exe, sum(duration) AS s FROM data GROUP exe BY ORDER BY s DESC;
Works from mysql.exe but not from C API.
/Christer
-Original Message-
On Mon, 2002-11-04 at 11:58, Dicky Wahyu Purnomo wrote:
> Pada Mon, 4 Nov 2002 11:55:59 +0100
> "Toni" <[EMAIL PROTECTED]> menulis:
>
> > Hello
> >
> > I've got mysql 3.23.47 running on a freebsd 4.5 box for long time without
> > problems, until now that consumes nearly all available CPU.
> >
>
A table using Berkeley Tables should have 55000 records. The mysql server
crashed.
When running this query:
select id from customers;
returns 16000 records
running:
select count(id) from customers;
returns 16000 records
however running a specific query on an specific id i.e.
select * from custom
Mark,
It looks like you should be using full-text indexes and the match and
against functions to me.
Check out section 6.8 in the manual.
Andy
mysql query
> -Original Message-
> From: Mark Goodge [mailto:mark@;good-stuff.co.uk]
> Sent: 04 November 2002 11:21
> To: [EMAIL PROTECTED]
> Su
Hi
You could use either normal or fulltext searches. Regexp may well be a good
answer (not used it myself). The following should also work
SELECT *
FROM table
WHERE
field LIKE "% cat %"
OR field LIKE "% cat. %"
OR field LIKE "% cat, %"
(note the spaces to make sure you get only complete words)
I have a problem when I load a text file using the sentence "load data
infile" as long as decimals are separated by commas and mysql ignores those
decimals, is there any way to specify that decimal separator is comma or
point?
-
Hi Group,
I made some changes to user privileges in mysql and now I cant log in.
Can anyone provide a step by step guide as to how I can fix the issue below,
without reinstalling mysql?
And if I reinstall, will I lose all of the databases created?
Warning: Access denied for user: 'root@localho
Stop mysqld and start it again using the --skip-grant-tables command line
option.
--
FROM THE MANUAL AT http://www.mysql.com/doc/en/Command-line_options.html
This option causes the server not to use the privil
At the moment, the files for tables in a database are
all stored in mysql/data/databasename/.
Is it possible to distribute the table-files to
different discs, or even better, different machines,
and still keep the flexability of having everything in
one database.
Example 1:
Prefs:
1 Database
5 ta
I would love to do that, but I am getting access denied errors when I do:
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'nhbhost@localhost'
everything I do gives me an access denied...
Steve
- Original Message -
From: "Erwi
Hi Everybody
I just downloaded the MyCC program from the MySQL website. Does it have the
capability of being able to select an external text editor, as I would like
to edit inserted HTML.
Thanks for any reply
Kevin Ratcliffe
Bolton 6th Form College
Bolton, UK
--
You can't just subtract datetime fields. Check the date and time functions
in the manual.
Jim Hogan wrote:
Hello!
I am working on an analysis that is very much dependent on calculating
time differences in seconds. The most simple example:
I have 3 variables: time_begin (DATETIME) time_end (D
Hello.
I'm running version 3.23 of MySql server for Windows on a Win2K machine.
I'm using the standard "C" API in my client software. A single client
connects succesfully, but when I run a number of concurrent clients on the
same machine (more than apr. 32), the connection (mysql_real_connect()
fu
I have a huge problem. I have several remote machines that connect to a
mysql server. On Friday, the mysql server started returning ERROR 2013:
Lost connection to MySQL server during query
Any idea.
Michael Gargiullo
Network Administrator
Warp Drive Networks
590 Valley Health Plaza
Paramus NJ
I am using Qt 3.0.5's QSql database classes to store
information in a MySQL database. MySQL is at version
3.23.49. I am trying to store binary data into a
column marked as MEDIUMBLOB (or even LONGBLOB) but am
having difficulties. Whenever I insert data that is
around 1 Megabyte in size, I get an
See this thread :
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75128
- Original Message -
From: "Michael Gargiullo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 04, 2002 9:26 AM
Subject: connecting to mysql server from other machines
> I have a huge proble
Then I would suggest you check your C code.
The program 'mysql' uses the C API.
Christer Holmström (at Home) wrote:
Hi, and thanks for the response, but unfortunately the same problem with
both below
SELECT exe, sum(duration) FROM data GROUP BY exe ORDER BY 2 DESC;
SELECT exe, sum(duration) AS
There are too many exceptions for this to be usefull.
What about lines ending in cat. or cat,
Your example won't match them.
Perhaps "% cat.%" and "% cat,%" patterns might be more helpfull,
but what about lines that begin with cat?
Peter Lovatt wrote:
Hi
You could use either normal or fulltext
Compiling the 4.0.4 source seems to have solved the problem.
Regards,
Tomek
Heikki Tuuri wrote:
Tomek,
then it is best to either test 3.23.53a or wait for 4.0.5. But please
report if those were able to solve the thrashing.
Regards,
Heikki
- Original Message -
*From:* To
How about mysqldump?
Stephen Hitchner wrote:
A table using Berkeley Tables should have 55000 records. The mysql server
crashed.
When running this query:
select id from customers;
returns 16000 records
running:
select count(id) from customers;
returns 16000 records
however running a specific
The code works in that sence that I get resultsets, the only thing that
does not work is the "ORDER BY" option for the SELECT statement. The
resultset is ordered by the exe column instead.
Should I run MyODBC instead?
Is the sourcecode for mysql.exe available?
Is there any miss-usage of mysql_q
- Original Message -
From: "Steven Nakhla" <[EMAIL PROTECTED]>
To: "QT" <[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAIL PROTECTED]>
Sent: Monday, November 04, 2002 3:47 PM
Subject: MySQL and binary data
> I am using Qt 3.0.5's QSql database classes to store
> information in a MySQL database. MyS
On Mon, Nov 04, 2002 at 12:37:15PM +0100, Nicolas MONNET (Tech) wrote:
>
> We get the same thing on FreeBSD machines quite often, and it's not
> related to the actual work being done; MySQL can sit idle but use up
> all CPU. It happens after a few days/weeks of uptime.
That's a known bug in FreeB
> Whenever I insert data that is
> around 1 Megabyte in size, I get an error saying
> "MySQL server has gone away". It doesn't happen with
> smaller data, and even if I change the column type to
> LONGBLOB I still have this problem.
You've hit the default maximum packet size of 1 MB.
This is a pr
I tried to send this Friday, but was a bit frazzled and probably didn't
give enough information. So, I'll try again and see if anyone can help.
My RedHat 7.3 system running MySQL 3.23.52 crashed. On reboot,
everything came up normally except MySQL. When safe_mysqld is run, I
get the followi
I am using MySQL V4.0.2alpha and I have set MAX_BINLOG_SIZE to 2M in order to
not have to run a CRON job or something similar to do a "FLUSH LOGS"
intermittently. This should cause the binary log file to be rotated after it
has reached 2M according to the documentation. This hasn't been happening a
Hi,
REGEXP is much more powerful than LIKE; you can match full words
with this syntax:
SELECT *
FROM TABLE
WHERE field REGEXP "[[:<:]]cat[[:>:]]";
(Easy, isn't it ? ;) )
You can find more examples in the manual:
http://www.mysql.com/doc/en/Regexp.html
Regards,
Joseph Bueno
NetClub
gerald_clar
I have the following problem after installing MySql version 3.23.53-max on the Windows
NT Server.
1. When I start winmysqladmin.exe, I get a error as follows,
- Entry Point not found.
The procedure entry point CreateToolhelp32Snapshot
could not be located in the dynamic library
KERNEL32
You can move the files and then set up symlinks to them in the
/mysql/data/dbName directory.
Arthur
-Original Message-
From: Michelle de Beer [mailto:michelledebeer@;yahoo.com]
Sent: Monday, November 04, 2002 8:21 AM
To: [EMAIL PROTECTED]
Subject: Distributing table-files to other machine
Hi,
I've recently made the move over from Access to MySQL.
So far, everything has been fine.
I'm using:
Win2K server (ASP)
WinMySQLadmin 1.4,
MyCC 0.8.4-alpha,
MyODBC 3.51 and
MySQL 3.23.51-nt
First problem:
Description:
Hello,
I have a deadlock problem when I try to execute some update sentences
using 'Lock For Update'.
I need to create a new document which is identified by a unique number,
which is stored in the field 'Ped' of the table 'Pedidos'.
To obtain a new document number I add 1 to the co
Hi,
I am just a starter. Anyone can suggest me good web resources for learning SQL command
that I can
use (compatible) with mySQL ?
I read from www.mysql.com documentation, but it's not complete ...
Well, if you have collection for beginner, please :)
Thanks,
kapot
__
The problem is that you are starting mysql with the wrong
arguments. I think you need to set the max_allowed_packet
parameter to something larger than the default 1 M. I got
mine to do that by using this command:
safe_mysqld --user=mysql -O key_buffer=16M -O table_cache=128 -O sort_buffer=4M -O
r
I have tried compiling the latest 3.23 version of mysql under Solaris 9
using gcc 3.2 and keep getting the following error:
g++ -DMYSQL_SERVER
-DDEFAULT_MYSQL_HOME="\"/usr/local/mysql\""
-DDATADIR="\"/usr/local/mysql/var\""
-DSHAREDIR="\"
http://hotwired.lycos.com/webmonkey/backend/databases/
might be a good place, haven't read it, but I send people that want to learn
HTML to webmonkey, and they liked it.
> -Original Message-
> From: Admin-Stress [mailto:meerkapot@;yahoo.com]
> Sent: Monday, November 04, 2002 10:50 AM
> To
On Mon, 4 Nov 2002, Alston, Tony wrote:
> Kip,
>
> Do you use RedHat's 'up2date' program?
No, but it was a problem with glibc (sort of) anyhow. The problem is
resolved. For posterity, here's what we did.
1.) Per the bug report at
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75128,
Robert,
Monday, November 04, 2002, 12:39:34 AM, you wrote:
RGp> I've tried an EXPLAIN of the SELECT below.
RGp> Please can anyone tell me why it's
RGp> "Impossible WHERE noticed after reading const tables"
RGp> ?
RGp> I've droped and created the table - but the error/message occurs.
RGp> When I
Jochen,
Saturday, November 02, 2002, 3:49:18 PM, you wrote:
JK> when I try to connect to a remote computer running mysql
JK> I always get the following error on the remote machine:
JK> Number of processes running now: 1
JK> mysqld process hanging, pid 7262 - killed
JK>
> There is no row number in MySQL. You should use ORDER BY to
>> retrieve data in particular order.
handf> What about the following info in the manual p. 55?
handf> Add a PRIMARY KEY or UNIQUE key to the table and use this. New in Version
handf> 3.23.11: If the PRIMARY or UNIQUE key consists of o
Bc.,
Monday, November 04, 2002, 12:14:53 PM, you wrote:
BRK> I have problem with ORDER BY in MySQL if I have some characters in iso-8859-2
BRK> and windows-1250. What I should do for fix it.
Set up corresponding default-character-set in my.cnf.
--
For technical support contracts, goto http
Juan_Andres_Torregrosa,
Monday, November 04, 2002, 1:44:11 PM, you wrote:
Jaedddc> I have a problem when I load a text file using the sentence "load data
Jaedddc> infile" as long as decimals are separated by commas and mysql ignores those
Jaedddc> decimals, is there any way to specify that decimal
Paul,
Saturday, November 02, 2002, 5:11:43 PM, you wrote:
P> I am kind of new to MySQL. I have ordered MySQL Cookbook but I still
P> have a week before it arrives. In the meantime, I am looking for some
P> basic help.
P> I am looking to store the text/description for the purpose of retrieving
P>
aman,
Saturday, November 02, 2002, 6:18:58 PM, you wrote:
am> If I have an old copy of Mysql on the system and want to uninstall that, how
am> would I make sure that all the database associated should get deleted, or do
am> I do it manually?
If you uninstall MySQL server, data directory will not
Jim,
Sunday, November 03, 2002, 8:44:43 PM, you wrote:
JH> I am working on an analysis that is very much dependent on calculating
JH> time differences in seconds. The most simple example:
JH> I have 3 variables: time_begin (DATETIME) time_end (DATETIME) and elapsed_
JH> seconds (INT). The dat
Try this:
http://www.devshed.com/Server_Side/MySQL
-
Hi,
I am just a starter. Anyone can suggest me good web resources for learning
SQL command that I can
use (compatible) with mySQL ?
I read from www.mysql.com documentation, but it's not complete ...
Well, if you hav
On Mon, 4 Nov 2002, gerald_clark wrote:
> You can't just subtract datetime fields. Check the date and time
functions
> in the manual.
Thanks,
I should know I run the risk of posting a RTFM/FAQ when I'm tired!
I got off track by misinterpreting "In MySQL Version 3.23, you can use +
and - inste
Having some other folks helping me out here with this
MySQL problems that I am having.
I have found out that I am missing the my.cnf from the
/etc directory and I am trying to create the file from
scratch, this is what I have so far and also MySQL is
installed from .tgz in this directory.
/usr
At 19:15 +0200 11/4/02, Egor Egorov wrote:
Paul,
Saturday, November 02, 2002, 5:11:43 PM, you wrote:
P> I am kind of new to MySQL. I have ordered MySQL Cookbook but I still
P> have a week before it arrives. In the meantime, I am looking for some
P> basic help.
P> I am looking to store the text/d
Jeremy Zawodny wrote:
On Mon, Nov 04, 2002 at 12:54:17AM -0500, Bob Lockie wrote:
That fixed it, thanks.
What did it use since I didn't specify an @'localhost'?
It used '%' which matches everyhing *except* localhost. The manual
explains this.
Jeremy
It's not obvious in the MySQL manu
Hmm, sorry, but it works! Found the problem, it was all my misstake. It
was my win32 dialoglist that was sorted :-(
Thanks!
/Christer
-Original Message-
From: Christer Holmström (at Home) [mailto:Christer.Holmstrom@;home.se]
Sent: den 4 november 2002 15:59
To: 'gerald_clark'
Cc: 'Joseph
I and my friend will do a test with SQL Server, Oracle and MySQL
We´ll start with a table with 2.000.000 rows.
What´s the best table type to do it?
I thought to do in InnoDB but how much do I set the size? Maybe 200MB?
Regards
Alexander
sql, query
_
Luis Sanches wrote:
Hi,
I've recently made the move over from Access to MySQL.
So far, everything has been fine.
I'm using:
Win2K server (ASP)
WinMySQLadmin 1.4,
MyCC 0.8.4-alpha,
MyODBC 3.51 and
MySQL 3.23.51-nt
First problem: (fixed)
--
I had used some keyword
> sql,query
Would it be possible to supply BETWEEN in any order (or rather to allow to do that)?
Such as
WHERE timestamp BETWEEN 2002100100 AND 20021031235959
would get the same results with
WHERE timestamp BETWEEN 20021031235959 AND 2002100100
or any other case where BETWEEN can be u
I've found that previous build-attempts that have failed (IE did you have a
bad/nonexistant LD_LIBRARY_PATH, fix it, and then try 'make' again?) cause
this, and even a make distclean doesn't fix it. Try starting from a freshly
untarred source ... that's always done it for me.
-=| Ben
- O
Hello Everyone,
I have been going through the documentation on MySQL and on Berkeley DB
looking for an answer for my question for several weeks and have yet to come
up with one, so I figured I post it.
I have a situation where the customer that I have wants to use their current
Berkeley DB, altho
If you have installed MySql in some
non-standard location, or if the original
installation was from the OS install, it
may be that you need to link the socks.
I have done this, others will probably
complain. I had this problem on many
systems newly installed. I fixed it with
ln -s /var/lib/path/t
Typically if your OS runs, the mysql will too.
You should only be worried with hardware
if you are running large database apps
on a slow system.
-Original Message-
From: Stephen Hitchner [mailto:steve@;number41media.com]
Sent: Friday, November 01, 2002 9:40 PM
To: Mysql
Subject: mysql die
Use the ROUND statement
ROUND(sum(CLICKS),sum(IMPS)/sum(CLICKS)*100.0,0),2);
-Original Message-
From: David Garamond [mailto:davegaramond@;icqmail.com]
Sent: Sunday, November 03, 2002 2:31 AM
To: [EMAIL PROTECTED]
Subject: rounding behaviour
hi,
mysql> select 1/29;
+--+
| 1/29 |
+-
I'm looking into options to improve performance of mysql in our app
and have a question about replication. I need the following
guarantee, which I believe is not possible with replication ...
If a client successfully updates the master, any subsequent read from
a slave must reflect that update.
I have two databases (rt2 & jobs) and within each of these DBs tables
that autoincrement email Ticket #'s and Work Request #'s respectively.
I'm looking for the best way to maintain the numbers between the
databases (e.g. if I had a rt2, jobs, then rt2 requests: rt2 issues
ticket #1024, then jo
Hi,
I'm trying to access mysql shared library. mysql_init() function returns
the address of MYSQL structure . I need to know what the structure looks
like.? can all mysql structure parameters be configured in /etc/my.cfg ?
Thanks
--
Hi sql query wizards!
I need some help.
Is there a way I can take this query here =>
mysql> SELECT cell, sector,
-> sum(att) as att,
-> sum(lc) as lc,
-> sum(csh) as csh,
-> ROUND((SUM( lc + csh ) * 100 ) / (SUM(att) - SUM(tccf + bpp + bpc +
suf)),2) AS drops,
-> sum(tccf) as
On Mon, Nov 04, 2002 at 02:04:35PM -0500, Ray Zimmerman wrote:
> I'm looking into options to improve performance of mysql in our app
> and have a question about replication. I need the following
> guarantee, which I believe is not possible with replication ...
>
> If a client successfully update
Hi everyone,
On my local machine I had mysql installed, and I was able to log in and
doing a test on it.
but today as I am trying to login using >mysql or >mysql -u root -p, I
got the error message saying; ERROR 2002: Can't connect to local MySQL
server through socket '/tmp/mysql.sock' (2), I h
Any suggestions?? I just installed and compiled mysql 3.23.53 and I get
this error:
[root@Alpha mysql-3.23.53]# scripts/mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepar
> mysql> SELECT cell, sector,
If you only want one row, then selecting cell doesn't make any sense.
Cell is different in each row you've selected. If you only want one
row, don't select cell.
> -> sum(att) as att,
> -> sum(lc) as lc,
> -> sum(csh) as csh,
> -> ROUND((SUM( lc + cs
Sounds like mysql service hasn't started yet.
> -Original Message-
> From: David Wu [mailto:dwu@;stepup.ca]
> Sent: Monday, November 04, 2002 2:59 PM
> To: [EMAIL PROTECTED]
> Subject: (beginner) mysql connection problem!
>
>
> Hi everyone,
>
> On my local machine I had mysql installe
create a sequence table. (Possibly in a third database?)
sequence
sequenceID bigint
label varchar(25)
NextValue bigint
Put 1 record in the table for each autoincrement field using the fieldname
as the label.
Then use it instead of the built-in autoincrement fields.
begin;
select @nextID:=NextVa
Any suggestions?? I just installed and compiled mysql 3.23.53 and I get
this error:
[root@Alpha mysql-3.23.53]# scripts/mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepar
Rafa,
- Original Message -
From: <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Monday, November 04, 2002 6:06 PM
Subject: DeadLock bug using mysql/Innodb
> Description:
> Hello,
>
> I have a deadlock problem when I try to execute some update sentences
> using 'Lock For U
Hello,
I have a table with only ips in it. I want to get all networks the ips
belong to:
Example:
123.123.123.1
123.123.132.2
123.123.123.3
1.1.1.4
1.1.1.5
1.1.1.6
12.12.12.1
12.12.12.2
12.12.12.10
The result should be:
123.123.123.0
1.1.1.0
12.12.12.0
Instead of converting on matching row (f
Hello.
On Sun 2002-11-03 at 10:44:43 -0800, [EMAIL PROTECTED] wrote:
> Hello!
>
> I am working on an analysis that is very much dependent on calculating
> time differences in seconds. The most simple example:
>
> I have 3 variables: time_begin (DATETIME) time_end (DATETIME) and elapsed_
> sec
Hi.
On Mon 2002-11-04 at 11:56:40 +0100, [EMAIL PROTECTED] wrote:
> Christer Holmström (at Home) wrote:
[...]
> > This SQL works perfect when running the command line tool mysql.exe
> >
> > SELECT exe, sum(duration) FROM data GROUP BY exe ORDER BY 2
> >
> > BUT when running from the C API, the "OR
On Mon, 4 Nov 2002, Alexander Newald wrote:
> Hello,
>
> I have a table with only ips in it. I want to get all networks the ips
> belong to:
>
> Example:
>
> 123.123.123.1
> 123.123.132.2
> 123.123.123.3
> 1.1.1.4
> 1.1.1.5
> 1.1.1.6
> 12.12.12.1
> 12.12.12.2
> 12.12.12.10
>
> The result shoul
Same thing here. Local sockets are working find. Remote connections
segfault. Getting ready to try the *workaround*. I am using mysql from
the stock install of RH8.0
Chris
-
Before posting, please check:
http://www.mysql
Whats the workaround?? How should I start with mysql with defualt
setting in a command line???
Thanks guys
On Monday, November 4, 2002, at 01:33 PM, Chris West wrote:
[EMAIL PROTECTED]
-
Before posting, please check:
http:/
Or, you could use distinct and substring_index instead of my last convoluted answer :)
> -Original Message-
> From: Kip Turk [mailto:kipt@;wcc.net]
> Sent: Monday, November 04, 2002 4:17 PM
> To: Alexander Newald
> Cc: mySQL Mailing Liste
> Subject: Re: Difficult query
>
>
> On Mon, 4 No
You might also need to add hostname.
It depends on what GRANT sql statement was
used to add the user id.
Something like
mysql -u userid -p -h hostname dbasename
should work.
If not, check that mysqld is in fact running. You can
use
ps -aux | grep mysql
Regards,
~Kelly W. Black
-Orig
More appropriately, use curdate()feature from within sql.
select * where date= < curdate()-1;
for example
~Kelly W. Black
-Original Message-
From: Benjamin Pflugmann [mailto:benjamin-mysql@;pflugmann.de]
Sent: Monday, November 04, 2002 1:06 PM
To: Jim Hogan
Cc: [EMAIL PROTECTED]
Subject
This simply returns me to the documentation.
Thanks
-Original Message-
From: James Northcott [mailto:jnorthcott@;dpmg.com]
Sent: Monday, November 04, 2002 12:13 PM
To: Mysql (E-mail)
Subject: RE: Interesting Challenge
> mysql> SELECT cell, sector,
If you only want one row, then sel
Try using
mysql>show variables;
Some variables can be exported to the sql server via the environment table.
For example:
shell>ulimit=2046
shell>export ulimit
shell>mysqld restart
Hope this helps,
~Kelly W. Black
-Original Message-
From: Nissim Lugasy [mailto:lugasy@;lerc.nasa.gov]
S
If it was a problem with mysql permissions you would get an access denied
for user@host using password(YES/NO) error. Since the error is cannot
connect through socket, either the socket is not in the specified directory
or you do not have permission to it or mysqld is not running.
-Original M
Hello,
How do you enable logging of slow queries in the MY.INI file under Windows?
Also, does anyone have a reasonably good MY.INI file for a configuration under
Windows 2000 for a local MySQL host?
Thanks,
Dan Cumpian
-
Befor
After playing around with 'test' database, then I would like to create my own database.
I logged in into mysql using root account and created a database.
But, when I logged in using regular user, I got his error :
ERROR 1044: Access denied for user: '@localhost' to database 'card'
What necessar
Hello,
I am running MySQL on my local Windows 2000 box and I am experiencing extreme
slowdowns. I have an application that writes query data to MySQL using two,
separate threads. After writing 2000-3000 records, all of a sudden, MySQL goes
to 98% CPU usage and throughput drops to 1 update every 2
Mark:
Once of the great things about MySQL is the prompt
attention and response on this list. Thanks for
replying to this email so quickly. Read on...
--- Mark Matthews <[EMAIL PROTECTED]> wrote:
> j.random.programmer wrote:
> > Hi:
> >
> > Thought I'd mention this (using the latest dev
> > J/co
At 17:27 -0500 11/4/02, <[EMAIL PROTECTED]> wrote:
Hello,
How do you enable logging of slow queries in the MY.INI file under Windows?
It's not Windows-specific:
[mysqld]
log-slow-queries
or
[mysqld]
log-slow-queries=filename
In the former case, the default name is HOSTNAME-slow.log in the d
Hi!
I have a rather large problem. I run a multi-process-robo-data-collector
wich are connected to a single database.
To make things faster, it runs on several machines leeching on the
processor-power that machines can spare.
The problem is to make them do diffrent things all the time!
This is a
try www.mysql.com, i heard they have docs there you can read...:)
-Original Message-
From: Admin-Stress [mailto:meerkapot@;yahoo.com]
Sent: Monday, November 04, 2002 1:41 PM
To: [EMAIL PROTECTED]
Subject: newbie: creating database error
After playing around with 'test' database, then I w
At 11:56 +0100 11/4/02, Joseph Bueno wrote:
Christer Holmström (at Home) wrote:
Hi!
This SQL works perfect when running the command line tool mysql.exe
SELECT exe, sum(duration) FROM data GROUP BY exe ORDER BY 2
BUT when running from the C API, the "ORDER BY" part doesn't seem
active, wh
1 - 100 of 131 matches
Mail list logo
