According to what I read in the manual, I'm lead to believe that MySQL
on Windows can read from either C:\my.cnf or systemdir\my.ini. Which
will it read first?
The manual also seems to say that you can only use one. So if you
create both, which will it prefer?
Here's the part I'm reading:
T
Hello *.*,
The new Version (2.0) of MySQL-Front is available: Download at
http://www.anse.de/mysqlfront/download.php
Again, this version comes with some new features, many bugfixes and
improvements, which were requested by some users.
--
Changes to the last
I would /strongly/ advise that you discontinue the use of
the Isam table type in mysql. The Isam table type is a legacy of the mysql 3.22.x
series. If you are using the stable 3.23.x series Myisam is the new default type.
One of the cool things about Myisam is that you CAN repair it while the data
At 3:24 + 1/14/02, Curtis Gordon wrote:
>Hi! I'm storing a date in this format :
>
>2002-01-13 11:08:40
>-mm-dd hh:mm:ss
>
>This is great because it gives me the date and the time, which I need.
>I want to compare this date from the database to the current DAYOFYEAR()
>
>but when I do this
I came up with my own work around, I am now storing the date and time
separately like this:
CURDATE(),CURTIME()
Then selecting my data with this WHERE statement:
WHERE DAYOFYEAR(CURDATE()) = DAYOFYEAR(mdate)
(mdate being the name of my CURDATE() field)
I just thought I would pass that on inc
Hi! I'm storing a date in this format :
2002-01-13 11:08:40
-mm-dd hh:mm:ss
This is great because it gives me the date and the time, which I need.
I want to compare this date from the database to the current DAYOFYEAR()
but when I do this
select DAYOFYEAR('2002-01-13 11:08:40')
I get this
On Sun, Jan 13, 2002 at 09:15:37PM +0100, Frans Englich wrote:
> I'm writing an adminstrative program for a hotel located in
> Sweden. This program uses an mysql database as backend(the
> implementation is not in use yet, but my intention is to use mysql).
>
> To be really sure about this: Do th
* Javier Gonzalo Gloria Medina
> How I crate this relational tables with mysql.
Using the CREATE TABLE statement:
http://www.mysql.com/doc/C/R/CREATE_TABLE.html >
> where the two tables must be related by id ok
You combine the tables with the SELECT statement, you don't need to do
anything sp
I think Tony was having a laugh
-Original Message-
From: Marjolein Katsma [mailto:[EMAIL PROTECTED]]
Sent: 13 January 2002 21:01
To: Tony Buckley [EMAIL PROTECTED] [RegSoft/mysql]; MySQL
Subject: Re: Spam - a possible cause ?
Tony,
You have the same info on these opportunities as I had
Hi people :
How I crate this relational tables with mysql.
Table users
| id | user name| e-mail | password | carrier| semester |
table assignments
| id | assignments |
where the two tables must be related by id ok
thanks for the help...
The following SELECT should produce your table
mysql> Select id,
->Max(CASE TimeSlot
-> WHEN 1 THEN Subject
->ELSE ""
->END) AS TS1,
->Max(CASE TimeSlot
-> WHEN 2 THEN Subject
->ELSE ""
-
Frans:
Legalities aside, why not let fairness and common decency prevail? The MySQL
team has a created a powerful, functional DB server. If you use their
product(s) in a commercial application for which you are being paid, why
would you NOT want to purchase a license?
If the US$200 price is too
Tony,
You have the same info on these opportunities as I had, and any other subscriber,
since they were all posted on (um, spammed to) this list. (If you're a *very* recent
subscriber you should be able to find them in the archives or Google.) I gave literal
quotes from messages sent to the li
Hi,
I knew that already.
But when I have a database connection in a application server configuration
file
and I want to use the file on different machines I need localhost as the
name
for the mySQL Server.
And the App.-Server is using TCP/IP.
Why does even the Telnet access not work ?
How can
Hi!
Unfortunately, I get too many e-mails to handle help requests
which are sent directly to me.
If you have purchased MySQL support, you may write to
[EMAIL PROTECTED], and will get an answer quickly. If you
would like to purchase support, please see the Support
section of our web site:
h
I'm writing an adminstrative program for a hotel located in Sweden. This program uses
an mysql database as backend(the implementation is not in use yet, but my intention is
to use mysql).
To be really sure about this:
Do the hotel _have_ to get an MySql database License or will they stay lega
> Hello,
>
> I use MySQL running as a service on Windows XP.
>
> My host has the name excalibur and the IP 66.121.159.212 which is the same
> machine as localhost (127.0.0.1).
>
> when I use the following command to connect to the database:
>
> mysql --user=dummy --password=dummy --host=localhost
Hello,
I use MySQL running as a service on Windows XP.
My host has the name excalibur and the IP 66.121.159.212 which is the same
machine as localhost (127.0.0.1).
when I use the following command to connect to the database:
mysql --user=dummy --password=dummy --host=localhost
I cannot not c
>
> Spam is people not interested in MySQL at all posting a "Business
> opportunity" ("Dear mysql, Join today for FREE and a chance to win a $100
> Shopping Spree at The DHS Club Outlet Center!") or "Golden Investment
> Opportunity" or "Great Growth Potential" stock scams.
> >
>
> Marjolein,
>
>
* Roleigh Martin
> -> from words w, events e, LEFT JOIN events e2 on ( e.url_id =
Try removing a comma:
from words w, events e LEFT JOIN events e2 on ( e.url_id =
The comma is actually a 'synonym' for 'INNER JOIN', the statement fraction
above is the same as:
from words w INNER JOIN e
* Roleigh Martin
> mysql> insert h2
> -> select h1.word, ' ', 0
> -> from h1 left join h2 ah2 on h1.word = ah2.word
> -> where ah2.word is NULL;
> ERROR 1093: INSERT TABLE 'h2' isn't allowed in FROM table list
You can not select from the table you are inserting to. Use a temporary
I am able to get what I want with one workaround but am unable to insert the
selected data into the target table - note below:
mysql> select h1.word, ' ', 0
-> from h1 left join h2 ah2 on h1.word = ah2.word
-> where ah2.word is NULL;
+---+---+---+
| word
Hello all, my first mysql posting. I've been a Sybase SQL Server
programmer for
10 years and the following select I know I have to translate as MySQL does not
support nested selects.
My version:
mysql Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386)
insert h2
select w.word,' ', 0
from
* Steger Andras
> $result = mysql_query("SELECT * FROM employees WHERE first = $neve",$db)
You need quotes. try "... WHERE first = '$neve'"
--
Roger
-
Before posting, please check:
http://www.mysql.com/manual.php (the man
- Original Message -
From: "Marjolein Katsma" <[EMAIL PROTECTED]>
To: "[EMAIL PROTECTED] [RegSoft/mysql]"
<[EMAIL PROTECTED]>; "MySQL"
<[EMAIL PROTECTED]>
Sent: Saturday, January 12, 2002 12:44 PM
Subject: RE: Spam - a possible cause ?
> Matthew,
>
Spam is people not interested in MyS
I am trying to write a query that gets the name of every
personr who has a neme: $neve
This parameter come from a form like this:
FORM ACTION="sqlphp.php" METHOD="post">
The following script is running, but if I write in the 7-th row:
$result = mysql_query("SELECT * FROM employees
I'd like to have precisions regarding MERGE TABLE.
Let's say we have a MERGE on jan, feb, mar.
If I do a DELETE FROM mar.
Every thing seems to work correctly, however the manual says that
this request have some unexpected results. I don't understand why.
Emptying a MERGE component doesn't seem
> Hi,
>
> I got a VB program running on Windows 2000 Pro Workstations
> against a Linux mySql database. The Workstations got JET 4.0
> installed, ADO(used by the vb program) and Service Pack 2. The
> program connects via MyOdbc.
> MySql has a database named "hotel" which the program opens and
Hi,
I would like to thank everyone (esp Carsten and Jocelyn) who helped me solve
this problem. It now seems that the db now works ok.
For the record, I suggest that isamchk should contain a warning in the help text
that you should not run it when mysqld is running. This combined with isamchk -i
>From the perl side, you could also split on / and then put each element in a
hash with the value being a hashref for the next element's hash.
- Original Message -
From: "Jon Shoberg" <[EMAIL PROTECTED]>
To: "Carsten H. Pedersen" <[EMAIL PROTECTED]>; "Beginners
(E-mail)" <[EMAIL PROTECTED]
Thanks !
Glad I asked for some other thoughts on this. I totally over looked this
and given how my indexes are setup, this will work much better.
Thanks again,
Jon
-Original Message-
From: Carsten H. Pedersen [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 13, 2002 11:26 AM
T
Hi,
I got a VB program running on Windows 2000 Pro Workstations against a Linux mySql
database. The Workstations got JET 4.0 installed, ADO(used by the vb program) and
Service Pack 2. The program connects via MyOdbc.
MySql has a database named "hotel" which the program opens and writes to(atlea
> -Original Message-
> From: Jon Shoberg [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, January 13, 2002 4:47 PM
> To: Beginners (E-mail)
> Cc: *MySQL mail list; Jon Shoberg
> Subject: Regexp Help !!!
>
>
> Ok,
>
> I have a list/database of words that follows as ...
>
> Top
> ...
> Top/A
Shit no. Thanks, I did backup :)
Tarjei
"Fournier Jocelyn [Presence-PC]" wrote:
>
> Hi,
>
> Did you run isamchk with mysql shut down ? (it's needed otherwise you'll
> corrupt your table)
>
> Regards,
> Jocelyn
> - Original Message -
> From: "Tarjei Huse" <[EMAIL PROTECTED]>
> Cc: <[E
> - At what size of the DB does it fail?
?? do you mean the size of the database?
> - Do you have enough disk space for all those records?
Yes.
> And then:
>
> Have you run CHECK TABLE on your tables?
midgardstaging.topic check error The handler for the table doesn't support
check/repair
> W
Ok,
I have a list/database of words that follows as ...
Top
...
Top/Arts/Food
Top/Arts/Food/Country
...
Top/World/America
Top/World/Japan
Top/World/Japan/Economy
Top/World/Japan/Food
Top/World/Japan/Food/Country
Top/World/Japan/Food/Country/By_Chef
...
How can I setup a regexp query/fi
> I have a couple of questions relating to limits on columns.
>
> First, is it OK to use numbers (1,2,3, etc.) as the names of columns? A
> quick scan of the manual doesn't turn up any such restrictions, but that
> doesn't mean that there isn't one.
Try scanning a bit slower:
6.1.2 Database
> I am having problems with my mysq db. The symthoms are many I'll
> list them:
>
> 1. some select statements return error when the dataset grows to
> a certain size,
> I think this is because of defect records.
You do not provide a lot of information to go by.
Getting the obvious questions o
I have a couple of questions relating to limits on columns.
First, is it OK to use numbers (1,2,3, etc.) as the names of columns? A
quick scan of the manual doesn't turn up any such restrictions, but that
doesn't mean that there isn't one.
Second, I know that there is a 255 character limit pe
Hi
I am having problems with my mysq db. The symthoms are many I'll list them:
1. some select statements return error when the dataset grows to a certain size,
I think this is because of defect records.
2. Mysqldump does not dump the compleat tables.
Of cource this is a BIG problem for me. Do
rc,
> off topic topic of mysql databaseperl
>
> i need to know how to build a linux timestamp from a date given to me in
> the following format 01-18-99 (m-d-y) i am using mysql to store this as an
> int(11).
>
> i know php has a mktime function, does anyone know if perl has something
> simil
[Please CC me, I'm not subscribed]
Does someone know if there's a native C# implementation
available OR a wrapper around libmysqlclient for C#?
thx,
Markus
-
Before posting, please check:
http://www.m
Oganes,
are your really using disk partitions as InnoDB data files? If you use raw
disk partitions, then the operating system may put a limit on the number of
them, for example, 16.
But usually InnoDB data files will be just ordinary files of the file
system. The number of data files is restrict
Hi Carsten,
Thanks. Your close.
Im searching on depart and arrive - not the times. so I want to go from Los
Angeles to NewYork.
So the standard query would be -
SELECT depart, arrive
FROM flights
WHERE depart = 'LA' OR arrive = 'NY';
Now from this query I should have all of the records where de
44 matches
Mail list logo
