Hi!
> "Andrey" == Andrey Kotrekhov <[EMAIL PROTECTED]> writes:
Andrey> #12 0x180e7cdc in mysql_real_connect ()
Andrey>from /usr/local/mysql/lib/libmysqlclient.so.10
Andrey> #13 0x1812f93c in MysqlConnection::real_connect (this=0x80c9c18,
Andrey> db=0x80fe8b0 "zzz", host=0x80fb040
Hi,
Go to /etc/init.d and type : ./mysql(d) restart
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Ian Phillips <[EMAIL PROTEC
After two days of trying I cracked it.
Modify
/etc/my.cnf
[client]
socket=/tmp/mysock.sock
[socket]
socket=/tmp/mysock.sock
Edit
/usr/local/lib/php.ini
"mysql.default_socket="/tmp/mysql.sock"
Type
mysqladmin --socket=/tmp/mysql.sock
--
This is quite easy. SciBit developed an ASP COM Object called MySQLX
(http://www.scibit.com/MySQLX) which does exactly what you want, this component is
almost two years old now and is very stable and used world-wide in many
applications/webs including real-time apps.
The help is a bit sparse
Hi,
I am sure this is an old chestnut, but a web search has revealed no answers.
I have:
table pubdata (
dkey smallint(5) unsigned NOT NULL default '0',
pubkey smallint(5) unsigned NOT NULL default '0',
title varchar(100) NOT NULL default '' )";
table ddata (
dkey smallint(5) unsigned NOT NULL
Hi,
I am sure this is an old chestnut, but a web search has revealed no answers.
I have:
table pubdata (
dkey smallint(5) unsigned NOT NULL default '0',
pubkey smallint(5) unsigned NOT NULL default '0',
title varchar(100) NOT NULL default '' )";
table ddata (
dkey smallint(5) unsigned NOT NULL
At 23:12 -0500 4/25/02, Barry C. Hawkins wrote:
>Clay,
> I am on remote assignment out of town, and I don't have my Mac
>or any of my MySQL books with me, so I am mostly going from memory. If
>I am not mistaken, Paul Dubois mentions in his book that the
>mysql_pconnect() function is definit
At 20:41 -0700 4/25/02, Clay Loveless wrote:
>Barry,
>
>Thanks for your input into this problem!
>
>
>1) That's an interesting point about the HFS+ filesystem -- I've read that a
>G4 won't boot unless the startup volume is formatted as HFS+ (so sayeth the
>10.1 Server Update "README FIRST.pdf") ..
Clay,
I am on remote assignment out of town, and I don't have my Mac
or any of my MySQL books with me, so I am mostly going from memory. If
I am not mistaken, Paul Dubois mentions in his book that the
mysql_pconnect() function is definitely preferred from a scalability
standpoint, and if
I have no problem with figuring out how to punctuate a field that contains a
single word, but how would I code a SQL query to proper-case each word in a
field when the field contains, for instance, a title? I want to convert,
"HOW NOW BROWN COW" to, "How Now Brown Cow"
Thanks,
Doug
Barry,
Thanks for your input into this problem!
1) That's an interesting point about the HFS+ filesystem -- I've read that a
G4 won't boot unless the startup volume is formatted as HFS+ (so sayeth the
10.1 Server Update "README FIRST.pdf") ... So, just for consistency's sake,
both drives in my
[EMAIL PROTECTED] wrote:
>The form "Select foo.id From foo, bar..." is giving you a cross-product. A
>cross-product emits a row for every combination of rows from each of your
>tables. The Explain results seem to be consistent with this. What I'd
>suggest is that you try a Join on your tables.
>
Clay,
I have only been running MySQL on Mac OS 10.1.3 on a PowerBook
G4 for development purposes, but a couple of things occurred to me:
1.) When the log says "Got error 9 from select" and that error
shows as "Bad file descriptor", I am reminded of the quirkiness that
sometimes ha
In the MySQL manual, the error codes are not available. This is a serious problem. I
have an error that keeps coming up and no way to solve it.
The error code is 1064. I believe for the syntax, but a THOROUGH check indicated there
is NO error in syntax, so it must be a bug in the MySQL server.
Okay, this just happened again, and this time I did get an error in the
logs.
020425 18:01:00 Error in accept: Resource temporarily unavailable
020425 18:01:00 mysqld: Got error 9 from select
'perror' says:
Error code 9: Bad file descriptor
... Which still leaves me a bit in the dark. Has
At 12:34 -0400 4/25/02, denonymous wrote:
>From: "Jonathan David Edwin Wright" <[EMAIL PROTECTED]>
>
>> Which turns '+php -perl' into:
>>
>> SELECT * FROM books WHERE title LIKE '%php%' AND NOT title LIKE '%perl%'
>>
>> The problem I get is that the query doesn't seam to work. One of the
>> bo
At 10:50 -0700 4/25/02, Clay Loveless wrote:
>Erik, et. al.--
>
>Thanks for all the helpful advice.
>
>I'll make a note that the MySQL mailing list welcomes messages from people
>shrieking "HELP!!!" even though they clearly haven't bothered to read the
>manual, but offers little to those who've ac
Ah, thanks for asking that -- I meant to include that in my original
description of the scenario, as it's another thing that's really odd about
the problem: there is NOTHING in the error logs at the time the problem
happens.
I've got a script running that checks the number of "visible" databases
Hi!
I've installed binaries of the following from the Bull site:
mysql-3.23.35.0
mysql.client-3.23.35.0
gnu.readline-4.1.0.1
I'm running AIX 4.3.2
The server starts up without problems.
When I try to run mysql I get:
exec(): 0509-036 Cannot load program mysql because of the following
errors
Hello, I am new to mysql - past the very basics - you may see a few silly
questions - here is the first.
I have a DELETE statement:
delete bond_master,bond_data from bond_data where
bond_master.cusip=bond_data.cusip and bond_master.maturity <= "2002/02/15";
That has syntax errors. I am issu
Hello folks,
here is a pretty original (I think) problem for your minds! :-)
I'd like to store a graph in a MySQL database. By graph, I mean the
graph theory meaning (i.e., "a set of connections between pairs of
nodes, which (the connections) may have a direction and/or weight"),
not the meaning
Thanks for your input!
It is fixed now, by using the , instead of an and however, the thing that
threw me was that it didn't complain about it!
Thanks Again.
Richard
-Original Message-
From: Chris Johnson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 5:10 PM
To: Salada, Dun
Hello,
My ISP installed MYSQL -max-3.23.49a-pclinux-gnu-i686 on our
dedicated server. They discovered they did not install their client
libraries after I had already created users with the Grant permissions.
Now that they have reinstalled I can not access mysqladmin in the shell.
I canno
Sorry about that. Set $sea_id="1"
I didn't include the whole database and script, just what I thought you
would need. So I didn't have all of the "Seasons" (sea_id's) in here. I
can get it down to that part. It is the ordering that I have problems with.
Thanks
Steve
At 04:51 PM 4/25/2002,
Modify
/etc/my.cnf
[client]
socket=/tmp/mysock.sock
[socket]
socket=/tmp/mysock.sock
Edit
/usr/local/lib/php.ini
"mysql.default_socket="/tmp/mysql.sock"
Type
mysqladmin --socket=/tmp/mysql.sock
--
On Thursday, April 25, 2002, at 04:40 PM, Steve Buehler wrote:
> Is there a way to use "ORDER BY", or something else, that will order
> the following in numerical order instead of alphabetical order? The
> column that the data is in is:
> short_description varchar(20) default NULL.
>
> 21UG3
I now have two mysqld processes running on my server (Freebsd / apache), and
no mysql (according to a ps command).
What is the safe way to kill these two, and restart mysql?
Ian
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April
Hi --
I have been trying to solve this problem with a left join, and wonder what
I am missing:
I have three tables:
- applicant (applicantid firstname lastname etc)
- courses(coursesid coursetitle etc)
- reservation (reservationid, applicantid,coursesid etc)
What I want to do is get a list of t
What does your MySQL error log say when this happens? (it should be in the
same directory with your databases and be your hostname plus a ".err"
extension). This information should shed some light on what's going on under
the hood.
-Mark
Original message:
Hi,
SELECT FROM table ORDER BY short_description+0; will do it..
Gurhan
-Original Message-
From: Steve Buehler [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 25, 2002 4:41 PM
To: mysql
Subject: Order by
Is there a way to use "ORDER BY", or something else, that will order the
>Description:
When dumping the 'mysql' database, the dump file contains syntax errors,
and I can't find where this has been rectified in later releases.
Example dump using 'mysqldump -cl mysql':
[snip]#
# Table structure for table 'db'
#
CREATE TABLE db (
Host char(60) NOT NULL default '',
MM.MySQL uses the table name provided by MySQL itself to produce the query
for updatable result sets, so it appears as if MySQL server is returning the
wrong table name for your query.
-Mark
Original message:
--
From: "Alan Jones" <[EMA
On Thursday, April 25, 2002, at 04:17 PM, Andrew Rich wrote:
>
> Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
>
>
> Any ideas ?
You might need to specify the path to your socket file when you start
MySQL... did you specify a specific socket location at compile time
Andrew,
Not trying to be a smart-ass, but give this link a try from the Mysql
website. Most likely covers your situation.
http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html
Don
-Original Message-
From: Andrew Rich [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 25, 2002 3:18 P
Is there a way to use "ORDER BY", or something else, that will order the
following in numerical order instead of alphabetical order? The column
that the data is in is:
short_description varchar(20) default NULL.
21UG3
10UB5
100UB6
1UG1
The way it comes out with "ORDER BY" is:
1UG1
10UB5
100U
Hi,
You haven't provided as enough information to be able to help you..
Send us your table structure and your PHP code..
Thanks.
Gurhan
-Original Message-
From: Gloria L. McMillan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 25, 2002 3:55 PM
To: [EMAIL PROTECTED]
Subject: A polite qu
Egor Egorov wrote:
>Nick,
>Wednesday, April 24, 2002, 10:52:28 PM, you wrote:
>
>NG> Nick Gilliam wrote:
>
>>>Egor Egorov wrote:
>>>
NG> I have encountered a problem with MySQL 4.0.0 and 4.0.1 in which
I am NG> unable to bet a lock on a table with any userid except root.
NG> He
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Any ideas ?
-Original Message-
From: Shaun Bramley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 25 April 2002 11:45 PM
To: [EMAIL PROTECTED]
Subject: Upgrade of mySQL on a Red Hat 7.2 - box
Ladies and Gentleman of
Dear Experts
>
>When ever i try to run MySQL under linux it gives me following error
>
>ERROR 2002 : can't connect to local MYSQL server through socket
'/var/lib/mysql.sock' (111)
>
>what could be possible remedy/rectification of the above ?
>
>million thx in advance
I would be interested in this too. With a corollary: does anyone know of
a small script other than java applets that would effectively place a
freehand drawtool on the webpage, and capture the resulting image for
insertion as a db blob?
Andrew Hazen
-Original Message-
From: Zill-e-Hassa
Hi,
Looking for advice on integrating database applications.
We are building a web app in php. Generally I use MySQL for everything.
But this app needs to integrate with, or at least exchange data with an
accounting package running PervasiveSQL db.
I think I can access Pervasive with php's buil
You can just add DEFAULT keyword followed by the default value in the column
definition and use it either when creating a new table or altering a table
to add/set a default value to its column(s)..
See: http://www.mysql.com/doc/C/R/CREATE_TABLE.html
http://www.mysql.com/doc/A/L/ALTER_TABLE.htm
Hi!
I'm a college english teacher and won't be able to stay on list for too
long due to my
student traffic, but here's my problem...
(Yes, I have spent days already trying this and that to try to get data
into the d-base.)
I am able to connect with my MySQL dbase, but nothing registers into the
How do I optimize the following query?
SELECT foo.id FROM foo, bar WHERE foo.id = bar.foo_id AND foo.field =
'baz' OR bar.field = 'baz';
Only a small number of records from each table match the query
conditions, but MySQL takes forever to execute it. No wonder, when
EXPLAIN says it needs to
/* Clay Loveless [[EMAIL PROTECTED]] writes: */
>I'll make a note that the MySQL mailing list welcomes messages from people
>shrieking "HELP!!!" even though they clearly haven't bothered to read the
>
Easy questions tend to get lots of answers, because many have read the
manuals and can pop off a
Dear All
I have been trying to find out if there is a way of actually storing
pictures as Blobs in MySql . Eventually i want to upload and download
pictures to/from the database through the use of ASP. I would also welcome
any suggestions that you guys may have regarding how to upload the image
f
Thanks for inspiring me to create a new mail filter!
On Thursday 25 April 2002 01:50 pm, Clay Loveless wrote:
> Erik, et. al.--
>
> Thanks for all the helpful advice.
>
> I'll make a note that the MySQL mailing list welcomes messages from people
> shrieking "HELP!!!" even though they clearly have
On Thursday, April 25, 2002, at 01:50 PM, Clay Loveless wrote:
> I'll make a note that the MySQL mailing list welcomes messages from
> people
> shrieking "HELP!!!" even though they clearly haven't bothered to read
> the
> manual, but offers little to those who've actually tried to resolve a
>
On Wed, Apr 24, 2002 at 12:45:43PM +0300, Michael Widenius wrote:
>
> I will add to our TODO to add to SHOW OPEN TABLES a list of threads
> that has locks on the table (or maybe a SHOW LOCKS command) to
> better cover this case in the future.
Could it be SHOW TABLE LOCKS? That way it is not con
How do I add defaults to a table? In SQL Server I can simply write
columnname bit null constraint defaultname default (0)
when I create the table.
Thanks,
Eddie
-
Before posting, please check:
http://www.mysql
On Thursday, April 25, 2002, at 01:29 PM, Clay Loveless wrote:
> I'm just trying to figure out why my carefully and thoughtfully
> researched
> help request has gone unanswered (or even commented on) for nearly a
> week.
> Based on the other responses I've seen to what are essentially "RTFM"
Your query reads: "SELECT * FROM books WHERE title LIKE '%php%' AND NOT
title LIKE '%perl%'" whereas it has to be "... AND title NOT LIKE '%perl%';"
I think you need to make some changes in your PHP code for the in the case
block for "-" .
Gurhan
-Original Message-
From: Jonathan David
Incident Information:-
Originator:[EMAIL PROTECTED]
Recipients:[EMAIL PROTECTED]
Subject: mysql Digest 25 Apr 2002 16:26:08 - Issue 1867
Message from [EMAIL PROTECTED] was quarantined because it
contained banned content.
Good day, everyone, and thank you for your time!
I am not a member of the mailing list (I had to swear them off as
addictive =o) but am posting this question in the hope that some
generous soul will assist me anyway.
I am building a database in which I want to restrict the values in one
column to
Hi,
When you connect from command line, you are logging as user@localhost ..
In your example, you said user@mybox thru PHP is not able to log in, I would
say check what hosts are allowed for that user in the user table..
See: http://www.mysql.com/doc/A/c/Access_denied.html
Gurhan
-Original
MySQL 'root' user has got nothing to do with Unix 'root' user. Quoted from
http://www.mysql.com/doc/C/h/Changing_MySQL_user.html is
"Note that accessing MySQL as root, by supplying -u root on the command
line, has nothing to do with MySQL running as the Unix root user, or,
indeed, as another Unix
Erik, et. al.--
Thanks for all the helpful advice.
I'll make a note that the MySQL mailing list welcomes messages from people
shrieking "HELP!!!" even though they clearly haven't bothered to read the
manual, but offers little to those who've actually tried to resolve a
problem on their own BEFOR
First, I would recommend upgrading to the latest release of mm.mysql --
which I think is 2.0.12. You can get the latest from sourceforge:
http://mmmysql.sourceforge.net/
2.0.4 is pretty old now.
--jeff
- Original Message -
From: "Alan Jones" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
My advice is that you adjust your attitude.
Admittedly, the signified meaning behind your requests for help are
completely open to interpretation, and this varies across different
cultures. So you may not even be aware that your first followup
post/request for help carries a certain sneering
How can I use Transation in MySQL with ASP?
I tried <%@TRANSATION = Required%>, like MSQL, but don't works.
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
On the contrary -- I *DO* like the fact that the help on this list is *FREE*
of charge, AND that the support on the list is better than most paid support
services.
I'm just trying to figure out why my carefully and thoughtfully researched
help request has gone unanswered (or even commented on) fo
Hello,
Does anyone have ideas for semi-efficient similar text matching
in SQL queries in mysql that account for human error?
e.g. I may have a record in my database that has the word 'color' in it.
Well, someone types in 'colour'so I make a query like
"select * from table where keywords lik
* Kim Cosgrove
> This should be an easy sql question for someone. I've got 2 tables that
> have a linked field (id) and I need to clean up records that are
> in table1,
> but no matching id in table2. This is how I can select them
>
> SELECT table1.* FROM table1 LEFT JOIN table2 ON table1.id=tab
Hi Clay Loveless,
As response to your loveless messages, I would like to browse :
http://www.mysql.com/support/index.html .
I have seen many times where people helped others for the matters that were
not documented on this list. Besides, when people are pointing help-seekers
to a documentation s
Hi !
Thank You for the response !
I wrote in my original message that the program
is running on Solaris 8 (sparc).
And I'm aware of Solaris quite special memory
handling. And if I got It right, Solaris never frees memory
to system but it still frees memory to same process that
originally alloca
Hi kapachov,
The maximum number of tables MySQL DB can have depends on your OS.
The maximum number of connections it can have is stored is max_connections
variable. By default it is set to 100, but you can of course change it .. Do
a "SHOW VARIABLES LIKE 'max_%';" to see what it is set to..
See: h
* kapachov
> what is the number max of tables that can have a data base MySql?
Limited by the OS and file system only, maximum number of files in a
directory, and unless you use InnoDb tables you must divide this number by
3.
Maybe you could use multiple databases? You can retrieve data from mul
This is a mail list for MySQL users.
If a user knows the answer to your problem, and feels like answering,
you may get a correct,
or incorrect answer.
If you REQUIRE quick response, pony up for a service contract like I did.
Clay Loveless wrote:
>At this point, I'd like to solicit tips on how
Hi,
After installation it's necessary to run mysq_install_db.sh.This script have
some routines to resolve the host,create system mySQL tables and write the
default option in this tables.For this reason, if you have some network
configuration problem, it's a good idea to use '-h' option and "said"
I am building a forum as part of a site, and the forum is broken into three
tables, a forum table, a thread table, and a post table.
All tables have indexes for common SELECT statements, to increase speed.
Example-
A user posts a new thread: One method would be 3 queries to insert/update
(insert
Shouldn't the NOT be right before the LIKE:
SELECT * FROM books WHERE title LIKE '%php%' AND title NOT LIKE '%perl%'
Duncan
--
Duncan Salada | Titan | www.titan.com/testeval
Email: [EMAIL PROTECTED] | Voice: 301-925-3222x375 | Fax: 301-925-3216
> -Original Message-
> From: Jonathan Davi
From: "Jonathan David Edwin Wright" <[EMAIL PROTECTED]>
> Which turns '+php -perl' into:
>
> SELECT * FROM books WHERE title LIKE '%php%' AND NOT title LIKE '%perl%'
>
> The problem I get is that the query doesn't seam to work. One of the
> books in the table is 'Professional PHP Programming', bu
Hi,
I just compiled Apache 1.3.24 with PHP 4.1.2 with ./configure'
'--with-mysql' '--with-apache=../apache_1.3.24' '--enable-track-vars'
MySQL was already installed on the system.
The problem, however, is that when I try to connect to a database
from PHP, I get the following error.
MySQL Error
Tom,
Thursday, April 25, 2002, 5:40:11 PM, you wrote:
TM> I am having the same problem and cannot find any document which can get
TM> me beyond Access denied...
TM> Could you explain the difference between Linux 'root' user and 'root'
TM> user in MySQL?
MySQL user 'root' is usual user, it's a u
At this point, I'd like to solicit tips on how I might get my support
related concern addressed. It seems like people panicking over things that
are actually documented get help quickly on this list, but when issues come
up that are NOT documented (as I've raised twice below), the issues are
ignor
dOMi writes:
>However, after only a week the memory usage ocf this process
>has been grown to 40 - 50 MB so there's have to leakage somewhere.
What you *may* be seeing is standard memory fragmentation that many
Unix' systems have with the standard allocator.. You don't mention
what platform you'
Hiya,
I'm writing a bit of code to add a bit of extra functionality to a basic search on a
web site.
When searching for items in a library, I want to be able to select what I want and
don't want to be searched for, i.e. +linux -beginner searches for all books on Linux,
but doesn't show any fo
hello,
i have a doubt and is :
what is the number max of tables that can have a data base MySql?
that so 1.000.000?
and tha number max de conections?
PD.no escribo muy bien el ingles, asi que espero que me
entiendan y me puedan ayudar.
translation
I do not write ingles very well, I ho
Thanks Everyone,
That's working now - This is my first time on this list and I have to say
I'm stunned how quickly my question has been answered!
I used Kim's code and it worked a treat!
:-)
Phil Clandillon
--
Graphic and Interactive Design
--
From: "Phil Clandillon" <[EMAIL PROTECTED]>
> I'm using a very simple PHP script with mySQL to load a news feed (url
> encoded) into flash. I've got it working but I would like the records to
> come out in the opposite order, with the newest one first.
At the end of your SQL query, simply add a
Agh... I apologize to all. Did not read the question asked correctly.
As far as order is concerned, you need to add "ORDER BY <> <>"
if you have a date field, this would probably be the best to use.
And example might be "SELECT field1, field2, field3 FROM news ORDER BY date
DESC"
Again, my apo
Hi Everyone,
This should be an easy sql question for someone. I've got 2 tables that
have a linked field (id) and I need to clean up records that are in table1,
but no matching id in table2. This is how I can select them
SELECT table1.* FROM table1 LEFT JOIN table2 ON table1.id=table2.id WHERE
Andrey Kotrekhov writes:
> Hi!
>
>
> I am not agree. I take _another program_ which work fine during ~2 year
> with previouse mysql version (mysql-3.23.44 for example).
> And I send dump from this program.
>
> Why I interested libmysqlclient_r?
> I have a program, which try to connect to mysql
FYI, concerning my previous email, it's solved. I upgraded the JDBC
drivers to the last ones and now it recognizes the unsigned data types.
Great! :-)
David
On Thu, 25 Apr 2002, David Collados Polidura wrote:
> Hi, I have a table in a MySQL database where some fields are declared
You should pass the data to be imported into Flash through urlencode().
Flash needs the data to be urlencoded in order for it to be able to read it,
particularly if the inputted data contains HTML, text with spaces, symbols,
etc.
Mike
-Original Message-
From: Phil Clandillon [mailto:[EMA
Greetings from Massachusetts (USA),
On Thursday, April 25, 2002, at 11:04 AM, Markus Ungersboeck wrote:
> I've tried both kinds, the binary package and the source installation.
> I've
> also the Developer Tools 10.3.1 (but a few days ago I've upgraded my OS
> to
> 10.1.4) on my computer and I
I am having the same problem and cannot find any document which can get
me beyond Access denied...
Could you explain the difference between Linux 'root' user and 'root'
user in MySQL?
Subject: Re: ERROR 1045: Access denied for user: 'root@localhost'
From: Victoria Reznichenko
Date: Tue, 23 Apr 20
On Thu, Apr 25, 2002 at 09:44:48AM -0400, Shaun Bramley wrote:
: Ladies and Gentleman of the list,
:
: I have been a member of the list for about two weeks now and I must say that
: I have learned a lot. Needless to say I am relatively new to the whole db
: scene.
:
: My question is that I inst
Hi everyone,
I'm using a very simple PHP script with mySQL to load a news feed (url
encoded) into flash. I've got it working but I would like the records to
come out in the opposite order, with the newest one first.
This is the script:
= $cur) {
$row = mysql_fetch_array($result);
$newsposte
Everyone,
I think I've got this licked on my own. Here's what I wound up with. Seems
to work ok.
select nodename, startdate, enddate
from history
where startdate >= concat(date_format(date_sub(now(), interval 1 day),
'%y-%m-%d'), ' 07:00:00')
and startdate <= concat(date_format(now(),'%Y-%m
I've tried both kinds, the binary package and the source installation. I've
also the Developer Tools 10.3.1 (but a few days ago I've upgraded my OS to
10.1.4) on my computer and I have the libpthread.dylib library in the
/usr/lib/ directory, but not libpthread.A.dylib.
As I'm a complete newbe c
Shaun,
Thursday, April 25, 2002, 4:44:48 PM, you wrote:
SB> Ladies and Gentleman of the list,
SB> I have been a member of the list for about two weeks now and I must say that
SB> I have learned a lot. Needless to say I am relatively new to the whole db
SB> scene.
SB> My question is that I inst
Chris,
Thursday, April 25, 2002, 3:47:22 PM, you wrote:
CB> I downloaded the binaries yesterday and installed on my WinXP
CB> laptop. I read the documentation that came with it but couldn't
CB> seem to get it to run. It seemed like any executable I ran, it would
CB> open up a DOS window which
Chris,
Monday, April 22, 2002, 7:21:58 PM, you wrote:
CJ> A test SQL script which duplicates this problem is available via anonymous
CJ> FTP at the following location:
CJ> Hostname: ftp.visi.com
CJ> Directory: /users/chris
CJ> Filename: test.sql
CJ> Run the script like this to see the error
bas,
Monday, October 22, 2001, 5:23:10 PM, you wrote:
b>Description:
b> the character '-' in username or hostname is not accepted by the GRANT sql
statement.
b>How-To-Repeat:
b> grant all on *.* to [EMAIL PROTECTED];
b>Fix:
b> don't use dashes, fixing the SQL parser.
It'
On Thursday, April 25, 2002, at 03:23 AM, Markus Ungersboeck wrote:
>
> I've tried to install the current release of MySQL on my Macintosh
> under OS
> X (10.1.4)
> and I've got the following error message:
>
> dyld: ./bin/mysqld can't open library: /usr/lib/libpthread.A.dylib (No
> such file
On Fri, Feb 22, 2002 at 11:39:55PM -0800, vijay khanna wrote:
> We are going into making the final changes to our
> production MySQL server.
> production server configuration is
> Free BSD PIII dual processor 800 mhz, 750 MB RAM.
Are you using MySQL package compiled with linux threads?
> Apac
Hello.
There appears to be a problem when using the JDBC driver on a
foreign database (i.e. not your "current" database).
MySQL version is : 3.23.49-max-debug
JDBC version is : mm.mysql-2.0.4-bin.jar
Consider the following situation:
use sales;
create table contacts (uid integer, name var
On Mon, Oct 22, 2001 at 04:23:10PM +0200, [EMAIL PROTECTED] wrote:
> >Description:
> the character '-' in username or hostname is not accepted by the GRANT sql
>statement.
> >How-To-Repeat:
> grant all on *.* to [EMAIL PROTECTED];
> >Fix:
> don't use dashes, fixing the SQL parse
Hi!
> > äÏÂÒÙÊ ÄÅÎØ.
> >
> > I think problem is in libmysqlclient_r.so
> > becouse I compile program which work fine many month with
> > libmysqlclient_r.
> > And program died in the same place.
> > #0 _db_enter_ (_func_=0x28252311 "mysql_real_query",
> > _file_=0x28251d48 "libmysql.c", _lin
1 - 100 of 138 matches
Mail list logo
