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
[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:
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
similar?
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.
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
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 out of
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,
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
- 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
Which
-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/Arts/Food
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
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
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]
Cc: *MySQL
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
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
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
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
input type=text name=neve size=40
input type=submit value=Dend data
/FORM
/pre
The following script is running, but if I
- 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,
snip
Spam is people not interested in MySQL at all
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
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
* 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
table:
* 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
snip
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,
They sound
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
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
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:
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
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
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
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
-
* Javier Gonzalo Gloria Medina
How I crate this relational tables with mysql.
Using the CREATE TABLE statement:
URL: 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
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 the
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
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
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
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
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:
37 matches
Mail list logo