I have Redhat 7.2 - clean install
When I try to compile my own mysql 49a version, I get a hostname error and
it said it can't use the resolveIP function. It also says it might be that
mysql isn't 100% compatible with the libc (or glibc) version I have. I also
saw on the www.mysql.com homepage that
Hi.
I have following rpm packages from redhat.com:
glibc-2.2.2-10.i386.rpm
glibc-2.2.2-10.i686.rpm
compat-glibc-6.2-2.1.3.2.i386.rpm
glibc-common-2.2.2-10.i386.rpm
glibc-devel-2.2.2-10.i386.rpm
I get this packet to upgrade my glibc 2.1 running on my RH 6.2 system, but
it fails.
Do i have missed s
Richard,
> Thanks. Interestingly enough, pulling records without a sort was
rather
> random (rather, influence by the last sort) - but once I placed a
primary
> key on the table, the order of unsorted records is always constant,
even
> after a sort (based on numerous tests yesterday and today wi
On Tue, 5 Mar 2002 [EMAIL PROTECTED] wrote:
> I'm trying to understand how can I use 'C' programs accessing a MySql
> DataBase, please, could you send me a small program or so that creates
> a Table or two and make some changes on them. I read so many examples
> but all of them only contain part
>Description:
in file libmysql.c, function mysql_read_default_options,
which is executed at every start of any mySQL client
is a string conversion subroutine, which causes stack overflow
Line 715
for (end = *option ; (end = strcend(end,'_')); )
*end= '-';
BUT! strcend
> On Mon, 28 Jan 2002, Sinisa Milivojevic wrote:
> > =?iso-8859-2?Q?Martin MOKREJ=A9?= writes:
> > > On Mon, 28 Jan 2002, Sinisa Milivojevic wrote:
Hi,
I am retrying to an answer to my question from January. Could please
someone from the developers have a look into this?
http://lists.mysql.com
on 6/3/02 9:41 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query
>
> If you just reply to t
I know in at least 2 e-mails I did indeed mention that I executed
safe_mysqld -u root, So I did it using your syntax, safe_mysqld --user=root,
I had the same text returned which again said the following.
Starting mysqld daemon with databases from /var/lib/mysql
020305 17:46:10 mysqld ended
I pre
Hello,
We are running a mysql database version 3.22.32.
I have an simple table:
id, int(10) unsigned, PRI, default 0, auto_increment
usernummer, int(10) unsigned, default 0
productcode, char(10), default ''
monat, tinyint(3) unsigned, default 0
jahr, mediumint(8) unsigned, MUL, 0
and two indize
Hi!
> "Sasha" == Sasha Pachev <[EMAIL PROTECTED]> writes:
Sasha> On Monday 04 March 2002 02:41 pm, Vladimir V. Kolpakov wrote:
>> --
>> P.S. so far, it's helpful bug: I use it as catch
>> for poor queries!:)
Sasha> This actually gives me an idea for a feature. --disable-disk-temp-table
Dear group.
(Debian 2.4.19, MySQL 3.23.49)
I have problem with starting multiple servers on one machine.
According documentation it is enough to start each another then first
server using ex.:
safe_mysqld --socket=/..path../mysql.socket.x --port=numberx &
and so on.
And this is enough when the
I'm relatively new to MySQL but "think" I am getting a grip on it.
However, I am seeing some strange behavior when I perform an update
command (through PHP). This following query not only results in the
sessionLastTime column updated but also another column sessionStartTime
(key, auto_increment)
Do you mean: You can forget upgrading on RH6.2 the glibc 2.1 to 2.2.
Maybe one did it succesful, so now he has RH.6.2 with glibc 2.2.
I still waiting for these persons.
P.S: I don't understand word: cos. Is it: Computer Operating System ?
regards.
- Original Message -
From: "Ben Edwards"
Hi,
small problem. I have a table set up like so. It has a number of entries
that were added on a certain date, I use TIMESTAMP to keep track of the date.
+-+---+--+-+-+--
--+
| Field | Type | Null | Key | Defau
"[EMAIL PROTECTED]" wrote:
>
> Hi,
>
> small problem. I have a table set up like so. It has a number of entries
> that were added on a certain date, I use TIMESTAMP to keep track of the date.
>
> +-+---+--+-+-+--
> --+
> | Field
Dear listmembers
My problems are: jokers appear not to work as expected in boolean
fulltext search and I can't figure out how to order results according to
any relevance. I need someone to point me into the right direction.
I run MySQL 4.0.1:
> mysqladmin version
mysqladmin Ver 8.23 Distrib 4.
Hi,
I a seting up a php page that will let me delete a record from my mysql
database, but I want it be able to match to fields before it will let a user
delete that record. I know the basic sql command is
DELETE FROM $table WHERE field 1 = "$value"
But I don't know how to write the state fo
Dear Sirs and Madams,
EMS HiTech company is announcing the next version (1.65) of MySQL
Manager -- A Powerful MySQL Administration and Development Tool for
Windows95/98/ME/NT/2000/XP.
You can download the latest version from
http://www.mysqlmanager.com/download.phtml
What's new in version 1.65
Hello all,
I am having some problems with installing 3.23.49 from source. Below is the
output from mysqlbug with my additions to help explain the problem. Any
help would be great - my experience with this kind of stuff is not that
great.
>Description:
I am trying to upgrade from 3.20.3
Maybe not. MySQL won't auto-maintain a date field.
I can't count the number of times that some unanticipated issue was solved
through having separate modifydate and createdate fields, with the
modifydate being maintained by MySQL (which means that I don't have to worry
about it going out of sync
Hi!
On Mar 06, Thomas Spahni wrote:
> Dear listmembers
>
> My problems are: jokers appear not to work as expected in boolean
> fulltext search and I can't figure out how to order results according to
> any relevance. I need someone to point me into the right direction.
>
> According to the Very
Please ignore my original message. I was finally able to get it to work
using:
CC=gcc CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors
-fno-exceptions -fno-rtti" ./configure
--prefix=/usr/local/mysql-3.23.49
--with-low-memory --enable-assembler
Duncan
--
Duncan Salada | Titan |
Yes, I did flush the privileges when nothing else worked but that didn't do
the trick either. Thanks for trying.
-Original Message-
From: James Housley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 6:00 PM
To: Thi Cao
Cc: MySQL
Subject: Re: MySQL Database Replication
Thi Cao
try running safe_mysqld without any options
I wouldn't know why you would need to specify a user name to start the
daemon
-Original Message-
From: Intrex [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 06, 2002 5:55 AM
To: [EMAIL PROTECTED]; 'Mysql'
Subject: Re: mysql on Linux
I know
Dear group.
(Debian 2.4.19, MySQL 3.23.49)
I have problem with starting multiple servers on one machine.
According documentation it is enough to start each another then first
server using ex.:
safe_mysqld --socket=/..path../mysql.socket.x --port=numberx &
and so on.
And this is enough when th
Hi
I am running Mysql-3.23.38 on Slackware 8 with Kernel-2.4.17.
This morning I suddenly had a problem where when I start Mysql server at
startup it uses all cpu available and the machine freezes. To fix the
problem I had to remove the complete installation and install mysql from
scratch. Anyo
When I grant privileges as follows, the slave gets updated:
GRANT FILE ON *.* to repl@'%' identified by 'some_password';
Could someone please tell me why I must grant the FILE privilege on all
databases for the repl (slave) to be able to update one particular database?
Thanks everyone.
Thi
--
Adam,
Tuesday, March 05, 2002, 10:14:28 PM, you wrote:
A> I have compiled/rebuilt the MySQL 3.23.49 Source RPM under kernel
A> 2.4.17, and glibc 2.1.
A> Using gcc version 2.95.4 20010319 (prerelease). I had 2.96 on there and
A> headed the warnings and downgraded to 2.95.
A> Randomly I get the
bipin,
Wednesday, March 06, 2002, 9:56:53 AM, you wrote:
bvc> I have a requirement of storing and retrieving data in 2 languages - namely
English and Arabic.
bvc> From what I have been able to understand, that would require me to have 2 MySQL
servers running simultaneously.
bvc> Can somebody
Elissa,
Wednesday, March 06, 2002, 6:44:26 AM, you wrote:
E> I'm a newie to SQL, and to Linux, so please forgive my blaring blunders...
E> I know I have an x86 Linux machine, running Redhat 7.2, and I know that I
E> like RPMs better than binary installations
E> When I get to the Stable Ve
Amit,
Wednesday, March 06, 2002, 6:38:30 AM, you wrote:
AL> What I want to do is import data from some other
AL> database to Mysql. For this the requirement is that,
AL> each record before being added to Mysql database,
AL> should pass through a loop say 5 times. This I want to
AL> do using only
Stephan,
Wednesday, March 06, 2002, 1:24:37 PM, you wrote:
SB> We are running a mysql database version 3.22.32.
SB> I have an simple table:
SB> id, int(10) unsigned, PRI, default 0, auto_increment
SB> usernummer, int(10) unsigned, default 0
SB> productcode, char(10), default ''
SB> monat, tinyin
rob,
Wednesday, March 06, 2002, 2:19:01 PM, you wrote:
recu> small problem. I have a table set up like so. It has a number of entries
recu> that were added on a certain date, I use TIMESTAMP to keep track of the date.
recu> +-+---+--+-+-+--
*mysql, to please stupid filter*
On Wed, 6 Mar 2002, Trond Eivind Glomsrød wrote:
> On Wed, 6 Mar 2002, Ireneusz Piasecki wrote:
>
> > Hi.
> > I have following rpm packages from redhat.com:
> > glibc-2.2.2-10.i386.rpm
> > glibc-2.2.2-10.i686.rpm
> > compat-glibc-6.2-2.1.3.2.i386.rpm
> > glibc-c
Yes thank you for these links. I have already read the documentation as
the first thing I did. The second thing I did was recompile. The third
thing I did was subscribe to the list.
I can write a php script like this:
I will run this. A lot of the time I wont get anything to the screen.
Oth
Hello,
This is a good question for when you are sipping coffee or tea and are
inspired to write some code. I require additional functionality for my SQL
search:
MY CURRENT SEARCH
SELECT ID, Authors, Year, Title FROM libraryTable
WHERE (Authors LIKE '%" + varAuthor + "%')
OR (Keywords LIKE '%" +
Hi.
Yopu wrote.
>You can find info about MySQL installation on Linux if you check
> the following links:
> http://www.mysql.com/doc/L/i/Linux-RPM.html
> http://www.mysql.com/doc/L/i/Linux.html
>
The section: linux-rpm.html it seems to bee out of date:
" The MySQL RPMs are cu
Hello folks,
I do not succeed to install the patch in order to compile the mysql++-1.7.9
with the GCC-3.0.3.
I use the command
/usr/local/src/mysql++-1.7.9-patched# /usr/local/bin/patch -p0 -i
mysql++-gcc-3.0.patch
but the output is:
can't find file to patch at input line 17
Perhaps you used t
* Chuck "PUP" Payne
> I know the basic sql command is
>
> DELETE FROM $table WHERE field 1 = "$value"
>
> But I don't know how to write the state for a second field. Can some one
> tell, but one field seem to give too much choose and would make it to easy
> to delete the wrong record.
I think
If I create a temporary heap table from a select statement, does the new
table also inherit the indexes (indices?) from the original table. Or will
I have to add an index to the temporary table after it is created?
For example, if I use:
CREATE TEMPORARY TABLE tempstudents TYPE=HEAP SELECT s
sorry. I made mistake. Cite should be like this:
" The MySQL RPMs are currently being built on a RedHat Version 6.2 system
but should work on other versions of Linux that support rpm and use
glibc." - from http://www.mysql.com/doc/L/i/Linux-RPM.html
I. Piasecki.
- Original Message -
I'm assuming your users arnt using a MySQL client directly to perform
the queries... And your using middleware like PHP or something.
So your PHP code can parse the users responses and then design your SQL
queries around your parsed data.
-Original Message-
From: BadgerBay [mailto:[EMAI
"Ireneusz Piasecki" <[EMAIL PROTECTED]> writes:
> Do you mean: You can forget upgrading on RH6.2 the glibc 2.1 to 2.2.
> Maybe one did it succesful, so now he has RH.6.2 with glibc 2.2.
> I still waiting for these persons.
Don't do it. You will do bad things to your system. If you want to
upgrad
Hello,
I feel i am dead in the water with this problem, it appears that
libncurses.so.5 is a linux library, i downloaded mysql-3.23.45
from sunfreeware and did pkgadd on it on Soalris 8 Sparc box, i was able to
start mysqld daemon and i can run mysqladmin commands but when i try to
connec
Does mysql jdbc driver support table quailified column names?
For example, this seems to work:
select id from people
But this doesn't:
select people.id from people.
Thanks.
Dave Ford
Smart Soft - The Developer Training Company
http://www.smart-soft.com
-
hi
i get a strange "can't create table 'databasename\bigdata1.frm' error 140" when i try
to run the following create query:
DROP TABLE /*!32200 IF EXISTS*/ bigdata1;
CREATE TABLE /*!32300 IF NOT EXISTS*/ bigdata1 (
IDData bigint(20) unsigned NOT NULL auto_increment,
REFLang char(2) NOT NULL
On Tuesday 05 March 2002 10:15 pm, Amit Lonkar wrote:
> hi
> Does Mysql support Transat SQL???
Assuming you mean Transact SQL, no. 'Transact SQL' is Microsoft's name for
their proprietary extensions to SQL. Only Microsoft SQL Server supports it.
But then again, MS SQL doesn't support MySQL's
Could someone, please, provide me with a link and/or facilitate some
suggestons for configuration of the following components for a new DB server
hosting MySQL 4.01MAX? I'm only looking to get a start and don't expect
"THE" answer since all things are relative and I will have to further test
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> gunzip < mysql-VERSION.tar.gz | tar -xvf -
shell> cd mysql-VERSION
shell> ./configure --prefix=/usr/local/mysql
Receiving message: ./configure: not found
Should this script be included in the unzipped directory. Or is it native
to t
This is not a MySQL question, it's a Solaris question. :) But anyway, you
need to get and install ncurses (version 5). You can find more information
at:
http://www.gnu.org/software/ncurses/ncurses.html
On Wednesday 06 March 2002 8:57 am, Atif Faruqui wrote:
> Hello,
>
> I feel i am dea
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
gaouzief,
Wednesday, March 06, 2002, 6:28:01 PM, you wrote:
g> i get a strange "can't create table 'databasename\bigdata1.frm'
g> error 140" when i try to run the following create query:
g> DROP TABLE /*!32200 IF EXISTS*/ bigdata1;
g> CREATE TABLE /*!32300 IF NOT EXISTS*/ bigdata1 (
g> IDData
Where can I find most recent (ie; 4.0.2 builds ;Nightly/CVS) at?
Thank You,
Anthony
sql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (t
hi,
the ncurses library is available as a solaris binary package at
sunfreeware, too. look for "ncurses-5.2".
Christopher Thompson wrote:
>
> This is not a MySQL question, it's a Solaris question. :) But anyway, you
> need to get and install ncurses (version 5). You can find more informati
On Wed, 6 Mar 2002, Sergei Golubchik wrote:
> Hi!
>
> On Mar 06, Thomas Spahni wrote:
> >
> > My problems are: jokers appear not to work as expected in boolean
> > fulltext search ...
> >
> > mysql> SELECT doc FROM plaintext WHERE MATCH(bgetxt) AGAINST('placi*' IN
> > BOOLEAN MODE);
> > Empty
Can someone tell me how to find the previous record in C (with mySQL API
function). I do a SELECT statement, read it with mysql_store_result(), read
the first record with mysql_fetch_row(), the next record with
mysql_fetch_row(), etc.. . But what about reading the previous record ?
(sorry for my
Hi.
I am using MySQL 3.23.44-max and InnoDB tables.
I also using foreign key in my tables.
I have problem, I couldn't alter my table and add any foreign keys.
SQL like this: alter table data_entry add FOREIGN KEY (data_task_id) REFERENCES
data_task(identity);
give me any error but key doesn't crea
mysql_row_seek().
On Wednesday 06 March 2002 10:26 am, JOUANNET, Rodolphe wrote:
> Can someone tell me how to find the previous record in C (with mySQL API
> function). I do a SELECT statement, read it with mysql_store_result(), read
> the first record with mysql_fetch_row(), the next record with
> > deletes, and other) as is possible with the Com_ status variable
in
> > the later versions of MySQL (no documentation though..)?
>
> I've got a bunch of improvements planned now that I'm regularly using
> MySQL 4.x. Having all those counters is handy. :-)
The counters are in 3.23.47 as
"Ray" wrote:
>
> I have been going out of 'my' mind. I am trying to install mysql on a
> Macintosh OS X server. Can anyone give me instructions on how to do
> this? I have been to numerous sites with no luck. We run OS 10.1.2
> server, I have mySQL 3.23.49 running (from entropy). During the
> Starting mysqld daemon with databases from /var/lib/mysql
> 020305 17:46:10 mysqld ended
This is written by safe_mysqld. It seems that mysqld was never started
successfully. I've had this issue before. Every time it was a
permissions issue.
> > > When I execute mysqld -u root -p
> > > I am pr
Marek,
Wednesday, March 06, 2002, 4:19:28 PM, you wrote:
MW> (Debian 2.4.19, MySQL 3.23.49)
MW> I have problem with starting multiple servers on one machine.
MW> According documentation it is enough to start each another then first
MW> server using ex.:
MW> safe_mysqld --socket=/..path../mysql
Erminio Efisio Riezzo writes:
> Hello folks,
> I do not succeed to install the patch in order to compile the mysql++-1.7.9
> with the GCC-3.0.3.
> I use the command
>
> /usr/local/src/mysql++-1.7.9-patched# /usr/local/bin/patch -p0 -i
> mysql++-gcc-3.0.patch
>
>
> You can help me? Thanks in ad
The /var/lib/mysql contains the following files:
linux-bin.001
linux-bin.002
linux-bin.003
linux-bin.004
linux-bin.005
linux-bin.006
linux-bin.007
linux-bin.008
linux-bin.009
linux-bin.index
linux-bin.err
the directory mysql
the directory test
directory mysql contains
columns_priv.MYD
columns_p
http://www.mysql.com/doc/I/n/Installing_source_tree.html
Ken
- Original Message -
From: "Anthony W. Marino" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 06, 2002 12:12 PM
Subject: MySQL Availability
> Where can I find most recent (ie; 4.0.2 builds ;Nightly/CVS) at?
>
> MW> safe_mysqld --socket=/..path../mysql.socket.x --port=numberx &
>
> You may also add --datadir= ... to separate data directories.
>
Don't need to. Servers can work on the same datas.
( Obviously it is comon solution to separate)
> MW> and so on.
>
> "so on" - please, specify.
>
Ups. My eng
On Wednesday 06 March 2002 01:37 pm, Ken Menzel wrote:
> http://www.mysql.com/doc/I/n/Installing_source_tree.html
Someone, replying earlier, mentioned that MySQL AB folks don't grant
permission to nightly stuff. I'll test it out, regardless.
Thank You,
Anthony
> - Original Message -
>
At 7:46 -0500 3/6/02, Chuck \"PUP\" Payne wrote:
>Hi,
>
>I a seting up a php page that will let me delete a record from my mysql
>database, but I want it be able to match to fields before it will let a user
>delete that record. I know the basic sql command is
>
>DELETE FROM $table WHERE field
Thanks I have now five ways to try.
| Chuck Payne |
| Magi Design and Support |
| [EMAIL PROTECTED] |
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 06, 2002 10:43 AM
To
Does anyone have any good tools for putting a trace on an MySql server. I
want to be able to see what is happening on the server.
Thanks,
Eddie
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Victoria Reznichenko wrote:
> recu> small problem. I have a table set up like so. It has a number of entries
> recu> that were added on a certain date, I use TIMESTAMP to keep track of the date.
>
> recu> mysql> UPDATE deerfield SET version = '2.1' WHERE product = 'WinGate LITE';
>
> recu> and
We have a very high volume site (3 million page views a day) that's run
on 16 Apache / PHP web servers & 2 MySQL servers. We are using PHP with
persistent connections. Each MySQL serves 8 web servers & is supposed to
act as a failover machine for the other group of 8 web servers.
The failover
On Wed, Mar 06, 2002 at 11:52:30AM -0500, Anthony W. Marino wrote:
> Could someone, please, provide me with a link and/or facilitate some
> suggestons for configuration of the following components for a new DB server
> hosting MySQL 4.01MAX? I'm only looking to get a start and don't expect
> "
this is an obvious 'newbie' question, so please bare with me.
i'm parsing a lot of data from file, and a good deal of this data is in the
form of nested C structs. within any given struct, you might have an array
of 256 floats, or an array of 256 structs, with 256 floats, etc, etc.
i'd like to
Perhaps you can create a function to serialize the array into text and
dump it into a blob in the DB, and have another field(s) with the data
you want to search on.. Then unserialize the array when you take it out.
-Original Message-
From: Hresko, Christian A. [mailto:[EMAIL PROTECTED]]
Fournier Jocelyn [Presence-PC] writes:
> I believe the problem occurs only when I execute the DELETE when someone is
> inserting a records at the same time.
> Perhaps the hash index is not updated properly whereas the data are deleted
> properly, which entails a mismatch between data and index ?
>
> We pay for MySQL support but haven't had much help from them.
You could pay me, I need work... :) Seriously...
> We have a very high volume site (3 million page views a day) that's
run
> on 16 Apache / PHP web servers & 2 MySQL servers. We are using PHP
with
> persistent connections. Each My
Hello,
In my application I would like to update a MySQL record where one
column
is the largest value. Do I have to create a separate SELECT sql query
statement
to get that value and then update it? Or, is there a function that
allows me to specify it as part of my WHERE clause. I scanned th
Hello,
I am encountering one problem. I am using mysql as the
dabase for my application.
I create a table like takeexam as following:create
table takelabexam( sid varchar(10) not null,
cid varchar(20) not null,
marks integer
foreign
Hi!
We have a fix for the problem that you have hit.
It is a temporary one. Final one will come in the nexe MySQL release:
*** tmp/libmysql.c Wed Mar 6 22:00:00 2002
--- tmp/fixed.c Wed Mar 6 21:59:34 2002
***
*** 737,743
*end=0;
Sam Iam wrote:
>
> We have a very high volume site (3 million page views a day) that's run
> on 16 Apache / PHP web servers & 2 MySQL servers. We are using PHP with
> persistent connections. Each MySQL serves 8 web servers & is supposed to
> act as a failover machine for the other group of 8 web
> When I execute mysqld -u root -p
> I am presented with the default variables.
Which are? How about showing what mysqld --user=root displays?
Also, you see linux-bin.* files? That indicates that mysqld was running
at some point (maybe nine times). Can you get the directory listings
with
ls
Hi,:
I heard that when we use MySQL on windows, we need to
pay fees. But I can't find anything on MySQL document
to talk about this.
Do you know this problem?
Thanks a lot!
Zengfa
__
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest f
On Wednesday 06 March 2002 02:40 pm, Petro wrote:
> On Wed, Mar 06, 2002 at 11:52:30AM -0500, Anthony W. Marino wrote:
> > Could someone, please, provide me with a link and/or facilitate some
> > suggestons for configuration of the following components for a new DB
> > server hosting MySQL 4.01MAX
http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#MySQL_server_licenses
On Wednesday 06 March 2002 1:17 pm, Zengfa Gao wrote:
> Hi,:
>
> I heard that when we use MySQL on windows, we need to
> pay fees. But I can't find anything on MySQL document
> to talk about this.
>
At 16:10 2002-03-06, BadgerBay wrote:
>Hello,
>
>This is a good question for when you are sipping coffee or tea and are
>inspired to write some code. I require additional functionality for my SQL
>search:
>
>MY CURRENT SEARCH
>
>SELECT ID, Authors, Year, Title FROM libraryTable
>WHERE (Authors LIK
when you run mysqld -u root -p and it gives you the list of
default variables.
You can get this same message by typing mydqld --help, which might indicate
some error in the command line arguments.
This file also shows you configurations supplied on the command line as well
as configurations foun
All releases of MySQL were GPL'd, see article:
http://www.mysql.com/news/article-23.html
John
On Wednesday 06 March 2002 15:17, Zengfa Gao wrote:
> Hi,:
>
> I heard that when we use MySQL on windows, we need to
> pay fees. But I can't find anything on MySQL document
> to talk about this.
>
> Do
Hi Zengfa:
No. The operating system has nothing to do with it BUT there are
requirements for buying a license.
Visit http://www.mysql.com/support/arrangements.html for more details.
Thx,
Craig
At 12:17 3/6/02 -0800, you wrote:
>Hi,:
>
>I heard that when we use MySQL on windows, we need to
>p
Anthony,
I'd be careful with the IDE Raid controller.
We just built a lab machine with a Promise IDE Raid controller and the assumption that
we could get it and XFS to co-exist.
I'm not doing the work, but the engineer that is tells me that the Promise Patch Kit
only works with a very limited
If you can turn on the query log the amount of disk space it takes would be
well worth troubleshooting the problem.
Try and discern the last queries run on them, in order to help.
Perhaps do this twice and you could check for consitency. How much disk
space is in use on the drives related to it?
R
Also, I forgot these questions:
- What is Apache's http.conf value of MinSpareServers?
- What is Apache's http.conf value of MaxSpareServers?
Steven Roussey
Network54.com
sql,query
-
Before posting, please check:
http://w
Hello,
I am encountering one problem. I am using mysql as the
dabase for my application.
I create a table like takeexam as following:create
table takelabexam( sid varchar(10) not null,
cid varchar(20) not null,
marks integer
foreign
Im convertinga couple of fully functioning access databases to mysql,
however I had problems converting the data over using a number of tools
because of illegal characters especially a colon : in the table & column
names. Now I can change these names to import the data ok but all of the
queries &
>
> Hello,
> I am encountering one problem. I am using mysql as
> the
> dabase for my application.
> I create a table like takeexam as following:create
> table takelabexam( sid varchar(10) not null,
> cid varchar(20) not null,
> marks integer
>
Hi,
Trying to figure out how to convert Sybase ASA syntax to MySQL. Need to
select alpha ranges as in:
SELECT *
FROM table
WHERE name LIKE '[A-Z]%'
but this doesn't work.
Appreciate your help,
Erik Schwartz
Systems Engineer
InfoUSA
818-428-1040
[EMAIL PROTECTED]
---
Outgoing mail was sniffed
Christian,
> this is an obvious 'newbie' question, so please bare with me.
If you had ever seen me without my clothes on, you would not be asking
me to do this!
Pardon me for joking at the expense of your English, but I've seen this
wording/spelling so often on the lists...
Bare = unclothed.
Bea
To all: This is in response to a request for more information. I thought
others may find it useful.
> Thanks so much for your reply. It's good news to hear that
> someone is relying on MyODBC for an important purpose, much of the
> usage I've seen seemed rather small.
Like I said, we h
Doesn't version 4 support Unicode? - isn't this a solution or am I
missing something?
DA
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: 06 March 2002 14:48
To: [EMAIL PROTECTED]
Subject: Dual Languages??
bipin,
Wednesday, March 06, 2002, 9:56:53 AM,
Hi,
On Thu, 2002-03-07 at 08:20, bin cai wrote:
> I am encountering one problem. I am using mysql as the
> dabase for my application.
> I create a table like takeexam as following:create
> table takelabexam( sid varchar(10) not null,
> cid varchar(20) not null,
>
1 - 100 of 114 matches
Mail list logo
