Hello,
I am planning to install 2 mysql servers on the same box whish runs Win2K.
Has anyone experianced this before?
Regards
Okan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lis
hi guyz
im stuck bad
i cant create tables, the tables which had NO foreign keys or they didmt
refer to another table were created fine
but the ones WITH foreign key ... refferring to fieldz in other table(s)
cant be created
mysql>create table lang ( lang_id int auto_increment primary ke
"ÕÅÉƽð" wrote:
>
> I'm sorry that my English is very week!I come from Chinese ! My computer OS is
>RedHat Linux 7.2 and the machine is intel celeron 300A 64M memory!
> the bad command message is :
> NOTE: This is a MySQL binary distribution. It's ready to run, you don't
> need to configure it!
I'm sorry that my English is very week!I come from Chinese ! My computer OS is RedHat
Linux 7.2 and the machine is intel celeron 300A 64M memory!
the bad command message is :
[root@guanqun zsj]# cd /usr/local/src/zsj
[root@guanqun zsj]# cd mysql-4.0.1-alpha-pc-linux-gnu-i686
[root@guanqun mys
Consider taking a look at the manual:
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
Perhaps read parts of it, too.
Fix your PC's date (the current year for most of us is 2002). Many of us who
receive e-mail dated in the past filter it to /dev/null.
Van
--
Hi, Can anybody tell me how i can calculate the months between two dates in
mysql.
thanks in advance
Regards
D K Dubey
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
I couldn't ./configure and make mysql.The mistake is:
the ./bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!
You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &
You can test the MySQL daemon with the benchmarks in the 'sql-bench' d
I couldn't ./configure and make mysql.The mistake is:
the ./bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!
You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &
You can test the MySQL daemon with the benchmarks in the 'sql-bench' d
See below:
> oops, Mac OS X.
>
> on 6/23/02 10:16 PM, Danny, typed:
>
> > Hello,
> >
> > What version of UNIX are you running?
> > Solaris, Linux, FreeBSD, BSDI?
> >
> > You can find that out my typing in uname -a
. . .
> >
> >> Hi,
> >> I hope I'm at the right list!
> >>
> >> I'm trying t
oops, Mac OS X.
Lloyd
on 6/23/02 10:16 PM, Danny, typed:
> Hello,
>
> What version of UNIX are you running?
> Solaris, Linux, FreeBSD, BSDI?
>
> You can find that out my typing in uname -a
>
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monda
hi,
i checked the manual, but i want a confirmation here: Mysql for window
doesn't have UDF, right?
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
Hello,
What version of UNIX are you running?
Solaris, Linux, FreeBSD, BSDI?
You can find that out my typing in uname -a
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 24, 2002 11:01 AM
Subject: help starting up mysql
> Hi,
> I hope I'm at t
I'm trying in vain to build the latest version of MySQL 3.23.51 (downloaded
today) on a new AIX box we've recently setup. It has the latest IBM
patches for the VisualAge C++ compiler v5, bringing it up to rev 5020.
When building, there are two problems.. One is that the configure script
impro
Hi,
I hope I'm at the right list!
I'm trying to start mysql -I have installed the db.
Now I'm getting the following:
[localhost:~] lloyd% sudo safe_mysqld --user=root &
[1] 630
[localhost:~] lloyd% Starting mysqld daemon with databases from
/usr/local/mysql/data
020623 20:25:20 mysqld ended
m
OOPS sorry
I found the answer by myself
It was just the % symbol that was misplaced
:))
-Message d'origine-
De : Alexandre Zglav [mailto:[EMAIL PROTECTED]]
Envoyé : dimanche, 23. juin 2002 23:09
À : [EMAIL PROTECTED]
Objet : RE: MySQL Query using ASP
-Message d'origine-
De :
-Message d'origine-
De : Alexandre Zglav [mailto:[EMAIL PROTECTED]]
Envoyé : dimanche, 23. juin 2002 23:07
À : [EMAIL PROTECTED]
Objet : MySQL Query using ASP
Hi all !
once again thanks for the help you provide me by being so active on this
mailing list :)
I have a litle problem query
I wrote earlier:
>select b.id, a.aid, a.wid, a.start, a.length
>into outfile 'newindex.txt'
>from wordindex a, wordforms b
>where a.wordform = b.wordform
>order by b.id, a.id, a.wid, a.start;
I've actually sat down and tried this at the mysql command line.
P
On Sun, Jun 23, 2002 at 08:02:45PM +0100, Paul Roberts wrote :
> php will close the connection when the script finishes unless
> you are using mysql_pconnect which opens a persistent
> connection.
Yup, ever resource besides persistent ones are cleaned up
upon script termination.
> From:
php will close the connection when the script finishes unless you are using
mysql_pconnect which opens a persistent connection.
http://za2.php.net/manual/en/ref.msql.php
Paul Roberts
[EMAIL PROTECTED]
- Original Message -
From: "Joseph Bueno" <[EMAIL PROTECTED
Markus Fischer wrote:
> [Please CC: directly to me, I'm not subscribed]
>
> Hi,
>
> maybe a pointer to the documentation is sufficient, but does
> mysqld uses linux-threads or processes?
mysqld uses threads (you already found the right documentation).
>
> And is there way
Hi, members,
I'm relatively new to mySQL. I have several databases up and running but
am facing one recurring, and quite annoying, problem: mysqld is shutting
itself down. Here's the sequence that results in the shutdown:
020623 0:29:23 /usr/libexec/mysqld: Binlog closed, cannot RESET MASTER
S
OK< I must say I don't think much of this filter if it couldn't tell
it was a relevant question. After all, there's a select statement in
it!! Anyway, any help or comments appreciated. Since initially
sending this, I've learned why my predecesser did it this way -- eight
hours later, and it's
I'm trying to extract information from MySQL with Microsoft Access but
it will not pull a query with BIGINT columns correctly. I'm using the
newest ODBC driver, version 3.51.03 and MySQL Server Alpha 4.0.1. I've
installed the ODBC driver, configured the DSN, and can access all other
types of colum
SELECT id, songname FROM tablename WHERE TRIM(BOTH ' ' FROM songname)="One";
See: http://www.mysql.com/doc/S/t/String_functions.html
Gurhan
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Jan Peuker" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, June 23, 2002 8:58 AM
Sub
* Chris Beasley
> I tried posting this on the bug list and it rejected it.
>
> I've got this bug in a php script of mine and I think it's
> because of MySQL.
> I have a value I am inserting into a database and above and below
> my query I
> can echo out the value and it is correct, but the query k
I don't think this is a bug, you probably choose TINYINT datatype for the
column, and the maximum value a TINYINT column can have is 127, so anything
over 127 will automatically be changed to 127 silently by MySQL. Choose an
appropriate column datatype for your field.
See: http://www.mysql.com/doc
Hi,
Your column comid is probably declared as a tinyint which has a range
between -128 and 127 (for not UNSIGNED column).
If you want to allow larger values, change the column type accordingly.
(Take a look here :
http://www.mysql.com/doc/C/o/Column_types.html
)
Regards,
Jocelyn Fournier
---
* [EMAIL PROTECTED]
> Thanks, that worked for song named "Empire", however,
> when I checked other song names such as songname
> called "One" I get two results:
>
> | id | songname |
> +++
> | 35 |
> You're Still The One |
> | 57 |
> One |
I tried posting this on the bug list and it rejected it.
I've got this bug in a php script of mine and I think it's because of MySQL.
I have a value I am inserting into a database and above and below my query I
can echo out the value and it is correct, but the query keeps assuming it is
"127" No
* toby -
> im working with some unicode data , store it in mysql db and retrieve it
> now its storing the data fine when i use longtext or mediumtext
> EXCEPT for a few characters
Try using longblob or mediumblob.
--
Roger
sql
well I have problem and I don´t know where ask for help,
so i´m trying you.
My problem is i´m developing my project using mysql
4.0.1, in a single computer (not net), OS windows 98,and
using Delphi 5. well SOMETIMES (NOT IN ALL RECORDS) when
i try to edit a record the program send me an exceptio
Thanks, that worked for song named "Empire", however,
when I checked other song names such as songname
called "One" I get two results:
| id | songname |
+++
| 35 |
You're Still The One |
| 57 |
One |
+++
2 ro
I do not understand string comparison. Why doesn't the
following work:
SELECT id, songname FROM songs WHERE songname = "Empire";
All I get is: Empty set (0.00 sec)
I know the string exists in the database:
In record 135 exists:
Empire |
| 135 |
Do I have
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Cal --
...and then Cal Evans said...
%
% TjL,
%
% To start with:
Thanks for the titles!
...
% Work your way through both books in a couple of months and then spend every
% waking hour organizing data into tables for a couple of years and you'll
[Please CC: directly to me, I'm not subscribed]
Hi,
maybe a pointer to the documentation is sufficient, but does
mysqld uses linux-threads or processes?
And is there way to control them? After I start up mysqld I
see 3 processes with ps. After some time (e.h. 12 hours) I
On Sat, Jun 22, 2002 at 05:25:59PM -0700, Steven Roussey wrote:
> Hi all,
>
> I have MySQL 3.23.47 running on our sever. I skipped 48 through 50 and
> tried 51. No dice. It does not handle load, CPU and the load average go
> through the roof. I'm using Red Hat Linux 7.2 and the official mysql
> b
Hi there,
I must start out by saying that i am a newbie in the Mysql arena. If i
can i will give a bit of background information. Where i work we
currently have a MS SQL 7.0, It has a database on there of support calls
(100,000 records) that i would like to take and import into Mysql. Thus
Hi all:
I am running mysql-max 3.23.51 on linux 2.4.x and
my shell is bash. The 'huponexit' shell option
is off. The mysqld (mysql-max daemon) is
probably not important for this discussion, any
other daemon would do as well.
Firstly, I can start mysqld (or other programs)
asynchronously by sa
Ruben I Safir wrote:
>
> I recently installed mysql on a new system and the client on works with root?
>
> Whats up?
>
> ruben@www2:~> !mys
> mysql -p
> Enter password:
> ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
> ruben@www2:~>
>
mysqld isn't runn
You can achieve a similar thing with the WHERE column IN (SELECT column FROM
table WHERE ..) subselect. In the current version of MySQL, this is not yet
supported, but I've heard fearies tell that it will be in version 4.1, or
else some other version to be released in the somewhere near future.
Of course it's running. I can only get in as the root user
of the system
On 2002.06.23 03:51 Brandon McCombs wrote:
>
>
> Ruben I Safir wrote:
> >
> > I recently installed mysql on a new system and the client on works with root?
> >
> > Whats up?
> >
> > ruben@www2:~> !mys
> > mysql -p
> >
Hi all,
I have MySQL 3.23.47 running on our sever. I skipped 48 through 50 and
tried 51. No dice. It does not handle load, CPU and the load average go
through the roof. I'm using Red Hat Linux 7.2 and the official mysql
binaries. It appears to be slow to connect, causing 0.5 to 1.0 second
delay o
42 matches
Mail list logo
