> To Whom it may concern,
>
> I've noticed a bug with the Billionium. Now that we have hit 1 Billion
> seconds since the beginning of the Epoch mysql will NOT work properly with
a
> MIN clause involving seconds before the Billionium.
>
> To clarify, I have a script that keeps track of the seconds
To Whom it may concern,
I've noticed a bug with the Billionium. Now that we have hit 1 Billion
seconds since the beginning of the Epoch mysql will NOT work properly with a
MIN clause involving seconds before the Billionium.
To clarify, I have a script that keeps track of the
Hello,
I read that version 3.23 and later do accent insensitive searches when
using LIKE in the query.
However, I'm still having problems getting accent insensitive searches to work.
I made a test page: http://www.sedl.org/accents.html
to search a small database of names. There are four nam
huh. almost surprised China lets it's citizens get out this far in the
Internet...
John
|-Original Message-
|From: aDragon [mailto:[EMAIL PROTECTED]]
|Sent: Saturday, September 08, 2001 11:14 PM
|To: [EMAIL PROTECTED]
|Subject: How to purchase MySQL License In China (People's Republic
https://order.mysql.com/ is where you order it from. Fill in the blanks and
enjoy!
M;)
-Original Message-
From: aDragon [mailto:[EMAIL PROTECTED]]
Sent: Saturday, September 08, 2001 9:14 PM
To: [EMAIL PROTECTED]
Subject: How to purchase MySQL License In China (People's Republic of
China
On Sat, Sep 08, at 07:29pm, Kenneth Wells ([EMAIL PROTECTED]) wrote:
> $ACID_VERSION = "0.9.6b6";
> /* Path to the DB abstraction library */
> #$DBlib_path = "../../adodb";
> DBlib_path = "c:\snort\adodb";
^^^ missing $ before variable name DBlib_path is probably confusing things.
This isn't rea
At 9:09 PM -0500 9/8/01, Deryck Henson wrote:
>How do I select all of the tables in a database and use a whre clause like
>this??::
>
>SELECT * FROM alltables(substitute with command) WHERE User = 'username'
You can't.
>
>I need this for my site (Code Cafe- Free source code) so that the user can
hi, everyone,
is there any easy way to buy mySQL in China?
Is there any company who manage the OEM for MySQL in China,
I am in Beijing, please Contact with me.
My tel: 86-10-62209449
email: [EMAIL PROTECTED]
aDragon
[EMAIL PROTECTED]
-
It's about $208.00 in USD or 1725 CNY (Chinese Currency). You can buy it
from anywhere I THINK. You might want to check me on that one. Just buy it
straight from MySQL's website ( http://order.mysql.com ) . And, in my
opinion, I'd just use the free version. Not as much to worry about, but, if
hi,Everyone,
I have a great problem now,
I'm building a web site, using MySql as my Database under windows 2000 Advanced
Server, and BEA weblogic Server as my server.
I don't whether we should buy the license in order to public our web site for
commercial purpose.
And What's the pric
How do I select all of the tables in a database and use a whre clause like
this??::
SELECT * FROM alltables(substitute with command) WHERE User = 'username'
I need this for my site (Code Cafe- Free source code) so that the user can
see all the code he has uploaded. It is done in ASP, but all I
Can not find the problem and we are down!
Here the question again (Any advice on replication of "LOAD DATA INFILE"
is very appreciated.)
I setup a mster-slave. My master does a lot of :
LOAD DATA INFILE 'path-to-file'
REPLACE INTO TABLE TABLE-NAME FIELDS
TERMINATED BY '\t
Can anyone help me?
I'm trying to install Snort on a windows2000 box and in the final step I
get this error:
Here is my error in my web viewer:
Parse error: parse error in c:\inetpub\wwwroot\acid\acid_conf.php on
line 7
Analysis Console for Intrusion Databases
Invalid Database Type Spec
On Sat, Sep 08, 2001 at 06:15:22PM -0400, Kenneth Wells wrote:
>
> I don't know why it is read-only, that is my problem.
But you've checked neither file permission nor the MySQL database
permission after having read my note? How to you expect to find the
solution?
Jeremy
> -Original Me
It might be easier to see what is happening if you do something like this:
echo "select name from pairings where fid=0 and pid=1 and name != 'One';" |
mysql -u... -p... yourdatabase | hexdump -c
this will show you exactly what data is being returned. Chances are there is
a funky character in the
I don't know why it is read-only, that is my problem.
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Saturday, September 08, 2001 5:05 PM
To: Kenneth Wells
Cc: 'MySQL-mailinglist'
Subject: Re: Database read only
On Sat, Sep 08, 2001 at 04:41:42PM -0400, Ke
I was just reviewing MySQL and was delighted to find support for
transaction tables. However, I discovered that there are 2 different
table types: Berkley DB and InnoDB. Which table type would you
recommend using for transaction support?
Thank you
Matt Harting
---
---
Outgoing mail is cert
Does anyone know what happened here? Notice the strangely formatted
output from the second command. I did a "repair table" but it doesn't
seem to detect any table corruption.
mysql> repair table pairings;
+---++--+--+
| Table | Op | Msg_type
It is tough for those who have never typed a command. It is analogous to
learning to drive a standard transmission - it is very easy to transfer to
an automatic but not visa versa. My first computer was an 8088 with a 4o
meg harddrive, DOS 5.2 with Turbo C as my compiler. Switching to Unix w
On Sat, Sep 08, 2001 at 04:41:42PM -0400, Kenneth Wells wrote:
>
> Does any one know how to turn off read only for a database?
Why is it read-only? File permissions? MySQL database permissions?
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-78
Does any one know how to turn off read only for a database?
KEnny
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread
Ville,
as you are probably aware, there are no subselects in MySQL. Therefore, you
will probably have to retrieve the additional waypoints through a second
query. (As an aside: there may exist a solution using self-joins, but from
looking at the problem I don't think so)
I assume you will be usi
> Does anyone know of a QBD (query by design) interface for MySQL? What I
> mean is the same thing that MS Access has where you can drag fields, create
> joins and have it generate SQL syntax.
>
> Right now I am using MS Access via MyODBC. but Access has its own
> peculiarities.
Data Architect
hi,
use sql statement like "alter table tablename add column ..."
for details, have a look at:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#ALTER_TABLE
hope this helps,
michael
Nuno Lopes wrote:
>
> Hi everybody,
>
> I have an answer. Can you answer it?? Thank
Hello List,
I have a question?
how can i add a few fields from a mysql database to another mysql database?
I mean, i use "mysqldump" to copy the information of a database or of a
table to a file, but, if i want to copy just a few fields from a table to
another table, how can i do this?
Thanks
Hi everybody,
I have an answer. Can you answer it?? Thanks! Here is it: I have a db in
mysql (off course!) with a lot of data. Can I add a new column (a new
variable) to an existing table??? If yes, what's is the sql query?? Thanks!
Thanking in Advance,
Nuno Lopes
P.S.: When you reply to the
I setup a mster-slave. My master does a lot of :
LOAD DATA INFILE 'path-to-file'
REPLACE INTO TABLE TABLE-NAME FIELDS
TERMINATED BY '\t' LINES TERMINATED BY '\n';
I changed from "LOCAL" because the docs states:
LOAD DATA INFILE will be handled properly as long as the file still resides
on the
Hi there,
This is my problem now... I have a table containing different paths, like this:
+--++---++
| Path | X | Y | WaypointNr |
+--++---++
| P1 | 1 | 5 | 1 |
| P1 | 2 | 6 | 2 |
| P1 | 3 | 7 | 3 |
| P1 | 8 | 3 |
Hi
Does anyone know of a QBD (query by design) interface for MySQL? What I
mean is the same thing that MS Access has where you can drag fields, create
joins and have it generate SQL syntax.
Right now I am using MS Access via MyODBC. but Access has its own
peculiarities.
Has anyone created or d
heloo I installed the binary verison of mysql
mysql-max-3.23.41-sun-solaris2.8-sparc.tar.gz on solaris box.
I could not found libmysqlclient.so file in lib directory Instead i fould
libmysqlclient.a file how can get libmysqlclient.so ?
srini
---
Simple Use MySQL-Front
The interface is a ton better than MySQL Admin and you can do a lot more
with it.
http://www.anse.de/mysqlfront/
- Original Message -
From: "Kenneth Wells" <[EMAIL PROTECTED]>
To: "'Farzad Faramarzi'" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, Septe
Can anyone help me? I'm trying to set up Snort and I have downloaded
MySQl shareware 3.23.40
I have a few questions. First, after I install I don't get the icon
automatically on my taskbar, but I can start it myself and it is there,
is that normal?
Second, When I try to add a database via
Aleksandar Pavic writes:
> HI, when I try to compile mysql, I get message.
> c++ can not write output files.
> What should I do?
>
> Thanks.
>
Re-install compiler.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\
[EMAIL PROTECTED]
ysql.com To: [EMAIL PROTECTED]
Hey there, no one knows this. Are there also Mysql developpers in this
community. If so, I think this is one for them :
One last question : The Fulltext search only matches those rows who match
teh exact word, so if I search for "bank", the query wont find banking.
(this would work with "like '%
if(redhat){
Fear RPM install's
} else {
./mysqladmin -uroot -hlocalhost password
}
Farzad Faramarzi wrote:
>
> Hi
> I tried to set the password to mysql by using mysqladmin
> and I received the following error message
>
Hi
I tried to set the password to mysql by using mysqladmin
and I received the following error message
-
./mysqladmin -u root password
./mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through
37 matches
Mail list logo
