i got an error msg. that this was not posted... hence i am doing
it once more
Praveen
On Mon, 06 May 2002 p j j wrote :
hi all,
I am using mysql on Win98 platoform. Am facing problems
using the Time field in SQL queries being executed from a VB
program. Would it be possible for
Hi !
Just read about the possibility of replicating two databses.
Can you tell me how to do it or send me a (link to a) manual?
Thanks,
Sven
On Monday, May 6, 2002, at 03:11 PM, Dicky Wahyu Purnomo wrote:
On Mon, 6 May 2002 07:44:04 +0200
Ewan Sadie [EMAIL PROTECTED] wrote:
I have installed
On Mon, 6 May 2002 15:21:54 +0900
Sven Bentlage [EMAIL PROTECTED] wrote:
Hi !
Just read about the possibility of replicating two databses.
Can you tell me how to do it or send me a (link to a) manual?
Actually is not only replicating 2 DB, but replication between several DB server.
You can
Hi!
As you can see below, SpamAssassin tags messages from the MySQL list as
spam. The main reason that this happens, is:
SPAM: Hit! (3.5 points) URI: URL of page called unsubscribe
That's because:
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Would it be possible
I use mysql to register data in an accounting system, comunications
happen in a 200 Mbit network and database is really fast, so lock
situation ( ie delete after a long select ... ) is really fast and
does not create problems. When I connect from a dialup connection
obviously query take the same
Hi,
I'm using MySQL4.0.1-alpha under linux and want to use my own udfs. I
tried to get working the udf_example and followed the MySQL manual.
Compiling the file and using the CREATE FUNCTION command didn't succeed.
I got the following error messages:
gcc -shared -o udf_example.so -rdynamic
hi,
I want to insert binary structure into the mysql blob column.
I have a my own structure called MSG_STRUCT msg_struct;
Now i want to insert the whole structure (binary) into table having a column
of blob data type. I tried by
end = strmov(query,INSERT INTO retry (msisdn, msg) values();
I have started all over again on a fresh Freebsd installation.
I have all the files in my /usr/local/mysql directory and I run
Scripts/mysql_install_db
After that I take the following action
$ chown -R root /usr/local/mysql
$ chgrp -R mysql /usr/local/mysql
$ chown -R mysql
Dear MySQL,
I am installing Mysql for Unix-3.23.49 for sun-solaris2.8-sparc
machine. While i am attempting to run the script called mysql_install_db
under scripts directory. It throws me the following piece of results and a
result no databases were created in mysql/data/mysql as well
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all, I'm getting intermittent 'Access denied' errors when running a
php script to admin a mysql db. I've looked in the manual but cannot
work out why I can connect in some parts of the script and not in others
Perhaps there is some common
Hi.
I've just installed MySQL 3.23.49 on Mac OS X.1.4. The installation went fine (into
/usr/local/) but now I'm having what I believe is a common permission problem. When
trying to add a database I get the following error:
[localhost:~] phil% mysql
Welcome to the MySQL monitor. Commands end
on my box the following helped:
(su to root)
chown -R mysql /usr/local/mysql/var (check if this is the path to your
mysql var )
(exit root)
that should do it.
also check in the user and host table if a connection from localhost is
allowed for the specific user..
Cheers,
Sven
On Monday, May
The file hostname.err description:
mysqld started
/usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
mysql ended
The file host.frm exists in /var/lib/mysql/mysql
I can't open mysql using 'mysql' from prompt.I see an error: Can't connect
to local MySQL server through
...Users are not recommended to switch their production systems to MySQL 4.0
until it is released in beta version later Q4/2001...
Source: http://www.mysql.com/products/mysql-4.0/index.html
Well, now it is Q2/2002 What is the new date for the beta release
?
On 6/5/02 at 19:53, [EMAIL PROTECTED] (Sven Bentlage) wrote:
on my box the following helped:
(su to root)
chown -R mysql /usr/local/mysql/var (check if this is the path to
your
mysql var )
(exit root)
that should do it.
also check in the user and host table if a connection from
Hi all,
How do I go about applying user quota on mysql databases, so that I =
can keep track of the disk space used by all the databases users.
I am using RH linux 7.0 =20
Mysql 3.23.40 installed on /var/lib/mysql/
quota-2.00pre3-7 applied on /home partation
Thanks in advance
Praful
[snip]
iduser | dtaccess
---
10 | '2000-10-02'
3 | '2000-12-04'
4 | '2000-10-09'
3 | '2000-12-04'
5 | '2001-02-10'
10 | '2001-03-01'
10
Hi,
Neil Bobstone wrote:
Hi,
cut
I Have compile Mysql 3.23.49 with : --enable-local-infile
But when I want to use LOAD DATA LOCAL its says : The used command is
not allowed with this MySQL version
cut
--enable-local-infile affects client library libmysqlclient
Can you check if client
Samuel,
Monday, May 06, 2002, 1:55:44 PM, you wrote:
SM REALFROM: Samuel Mendelowski [EMAIL PROTECTED]
SM HOUR: 2002050614
SM The file hostname.err description:
SMmysqld started
SM/usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
SMmysql ended
SM The file
Jack,
Monday, May 06, 2002, 7:40:08 AM, you wrote:
J Two Question :
J 1.
J I know that the 'LOAD DATA' command loads a bulk of data into a table, but
J what happen if i only want to load the data into specifc fields on a table
J instead of whole table.
J eg.
J Let say i had a file with 3 column
Praful,
Monday, May 06, 2002, 2:41:54 PM, you wrote:
PSHow do I go about applying user quota on mysql databases, so that I =
PS can keep track of the disk space used by all the databases users.
PS I am using RH linux 7.0 =20
PS Mysql 3.23.40 installed on /var/lib/mysql/
PS quota-2.00pre3-7
Phil,
Monday, May 06, 2002, 1:42:28 PM, you wrote:
PD I've just installed MySQL 3.23.49 on Mac OS X.1.4. The installation went fine
(into /usr/local/) but now I'm having what I believe is a common permission problem.
When trying to add a database I
PD get the following error:
PD [localhost:~]
Nick,
Monday, May 06, 2002, 1:30:22 PM, you wrote:
NW Hi all, I'm getting intermittent 'Access denied' errors when running a
NW php script to admin a mysql db. I've looked in the manual but cannot
NW work out why I can connect in some parts of the script and not in others
NW Perhaps there is
Sven,
Saturday, May 04, 2002, 4:52:00 PM, you wrote:
SB The mySQL DB I have to rebuild was only one big table. Afer developing a
SB new DB design for it, I ran into the problem of transfering the data
SB from the old to the new database.
SB I need to split up the records and insert them into
Doron,
Monday, May 06, 2002, 3:44:02 AM, you wrote:
D I got the above error when inserting a row into a heap table on linux
D mySQL version 3.23.49a from the Java JDBC driver. This is not reproduceable
D on a win32 DB. This does not appear to be space related as it failed after
D only about
I'm using DBTools Table Manager to make table changes in Mysql 3.23... I'm
trying to add an auto_increment ID field to 2 tables that already have data in
them.. 1 table worked fine, the other table I get Got Error 28 from Table
Handler
can anyone tell me why I get this?
TIA
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Egor Egorov declared
Access denied error occurs when you have no required privileges to
connect to the MySQL server. You gave incomplete error message and I
can't give you detailed answer. Please, check the following
link, you can
Hello,
Tim Carlson wrote:
Hello,
Newbie SQL person here. I am hoping to be able to do the
following. Given two dates, I would like to display all of the days
between them.
So if I had the dates 2002-02-08 and 2002-02-12, I would like to have
MySQL spit back
2002-02-08
2002-02-09
2002-02-10
When I try and insert a string into an integer field, instead of throwing
an error MySQL accepts the insert and set that field's value to zero (I
assume default value). I am using the php mysql module by the way (not
PEAR). I would like to get an error when I insert the wrong data type into
{snip]
When I try and insert a string into an integer field, instead of throwing
an error MySQL accepts the insert and set that field's value to zero (I
assume default value). I am using the php mysql module by the way (not
PEAR). I would like to get an error when I insert the wrong data type
Balteo,
MySQL/InnoDB-3.23.50 for Windows is available for download at
http://www.mysql.com/downloads/mysql-3.23-pre.html. The 'prerelease' status
only concerns Linux, where a new glibc and a new compiler are tested. For
other platforms this is a normal stable release.
For the InnoDB changelog
Have you checked the network connection? You should be running at
full-duplex so you don't get collisions. But more importantly, make sure you
aren't getting errors on the line. A poor crimp or pinched wire could really
slow things down, especially if you try running at 100MB.
Try copying a
You can use perror error_code to see what that error code is
perror 28
Error code 28: No space left on device
Seems like you ran out of space?
Gurhan
-Original Message-
From: Scott Raley [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 8:44 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL
Make sure that the user + host combination you are giving has privileges
in the MySQL server you are trying to connect. You may wanna check user
table in the mysql database.
Gurhan
-Original Message-
From: Nick Wilson [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 6:30 AM
To:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Gurhan Ozen declared
Make sure that the user + host combination you are giving has privileges
in the MySQL server you are trying to connect. You may wanna check user
table in the mysql database.
Well, there must be privileges
Is there anyway to see what bugs have been reported for fulltext search
in 4.0.1 alpha ? I know that Jeremy Zawodny has mentioned that a few bugs
were found in fulltext search in 4.0.1 , but didn't tell what they were.
I have installed 4.0.1 and ran it as second mysqld in my web server,
I have tried almost everything and nothing works.
The problem is, I have a server with different MySQL databases from
different people.
User 1 should not access database 2 and user 2 should not access database 1.
What is the easiest way to prevent user 1 to access database 2. I can't get
it
Nick,
Monday, May 06, 2002, 3:58:34 PM, you wrote:
NW * and then Egor Egorov declared
Access denied error occurs when you have no required privileges to
connect to the MySQL server. You gave incomplete error message and I
can't give you detailed answer. Please, check the following
link,
Hi!
Can I turn on logging of all SQL-Commands send by one particular client on
the server side? Turning on logging for all clients seems to be possible.
Does it work for one client only too?
--
Thomas
-
Before posting,
HI,
Praful Saijare wrote:
Hi all,
How do I go about applying user quota on mysql databases, so that I =
can keep track of the disk space used by all the databases users.
I am using RH linux 7.0 =20
Mysql 3.23.40 installed on /var/lib/mysql/
quota-2.00pre3-7 applied on /home partation
[snip]
The problem is, I have a server with different MySQL databases from
different people.
User 1 should not access database 2 and user 2 should not access database 1.
What is the easiest way to prevent user 1 to access database 2. I can't get
it right.
[/snip]
Hi!
On May 06, Gurhan Ozen wrote:
Is there anyway to see what bugs have been reported for fulltext search
in 4.0.1 alpha ? I know that Jeremy Zawodny has mentioned that a few bugs
were found in fulltext search in 4.0.1 , but didn't tell what they were.
I have installed 4.0.1 and ran it
Hi everybody,
Let's say I do not want to use any microsoft tool on my PC. Is it possible
to develop a desktop application using MySQL as database server without
having to program in C or C++ to access and display the Data?
My question probably should be: If not ODBC, what desktop database
You could use Kylix from Borland. It's a RAD tool - it's actually Delphi
ported to Linux.
- Carsten
-Oprindelig meddelelse-
Fra: Yvon Darang [mailto:[EMAIL PROTECTED]]
Sendt: 6. maj 2002 15:31
Til: [EMAIL PROTECTED]
Emne: Newbie Question
Hi everybody,
Let's say I do not want to
GRANT ALL PRIVILEGES ON databasename.* TO user IDENTIFIED BY 'password';
http://www.mysql.com/doc/G/R/GRANT.html
Gurhan
-Original Message-
From: Dennis [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 9:52 AM
To: [EMAIL PROTECTED]
Subject: Every user can access the databases
I
Hello,
Can someone tell me if there is an C++ API that works smooth with MYSQL on
linux.
So far I was trying msql++ and SQLAPI++.
SQLAPI++ seems to be good by there are problems when runing the program.
My system is Redhat 7.2 and Mysql 3.23.49
Thanks,
Hisseine
Hello,
Can someone tell me if there is an C++ API that works smooth with MYSQL on
linux.
So far I was trying msql++ and SQLAPI++.
SQLAPI++ seems to be good by there are problems when runing the program.
My system is Redhat 7.2 and Mysql 3.23.49
Thanks,
Hisseine
You can download MySQL++ from www.mysql.com
- Carsten
-Oprindelig meddelelse-
Fra: Hisseine Dj. [mailto:[EMAIL PROTECTED]]
Sendt: 6. maj 2002 17:24
Til: [EMAIL PROTECTED]
Emne: C++ API for Mysql
Hello,
Can someone tell me if there is an C++ API that works smooth with MYSQL on
I have before me what seems to be a very daunting task to someone with my
limited SQL knowledge. I'm upgrading our ad server which runs on MySQL
3.22.32 to a newer machine and MySQL 3.23.39. Right now there are 16GB worth
of databases that need to be transferred over, and the old server lacks
Hi,
The long awaited version 1.0.13 is now available for downloading. The list
of changes and new features is too long, so I will give you a short
description of what we changed:
- New relationship editor ( now it can handle add new, update and delete and
shows the SQL statement as an example)
Hi,
I'm using MySQL4.0.1-alpha under linux and want to use my own udfs. I
tried to get working the udf_example and followed the MySQL manual.
Compiling the file and using the CREATE FUNCTION command didn't succeed.
I got the following error messages:
gcc -shared -o udf_example.so -rdynamic
Hi,
It's not quite clear from the manual, but it appears that queries with
FULLTEXT search patterns like this:
MATCH (some_text_field) AGAINST ('(red pepper) (green bean)')
don't produce the result desired, that is, multiple .. elements are not
allowed, with or without parentheses...
Could
Greetings,
Upon reading into the user variables section of the mysql manual, I decided
to make my life easier inside several of my queries by specifying some user
variables. Note that I'm trying to have everything inside the select
statement - Primarily because I'm simply passing it through to
Of course, I forgot to mention 'IN BOOLEAN MODE'.
...
MATCH (some_text_field) AGAINST ('(red pepper) (green bean)' IN BOOLEAN
MODE)
...
Vadim P. wrote:
Hi,
It's not quite clear from the manual, but it appears that queries with
FULLTEXT search patterns like this:
MATCH
Hi
If you are developing for a Windows desktop, MyODBC with Access, Paradox or
Delphi all workm, from experience.
If you are developing for Linux desktop, then not sure, but perhaps others
have experience
Peter
---
Excellence in internet and
Dennis,
Monday, May 06, 2002, 4:51:50 PM, you wrote:
D I have tried almost everything and nothing works.
D The problem is, I have a server with different MySQL databases from
D different people.
D User 1 should not access database 2 and user 2 should not access database 1.
D What is the
Hi Carsten,
I've tried Mysql++ and SQLAPI.
I am asking if someone out there know about other best tools in C++ for
Mysql on linux.
Thanks,
Hisseine
- Original Message -
From: Carsten Gehling [EMAIL PROTECTED]
To: Hisseine Dj. [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, May 06,
-Original Message-
From: Peter Lovatt [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 12:09 PM
To: Yvon Darang; [EMAIL PROTECTED]
Subject: RE: Newbie Question
Hi
If you are developing for a Windows desktop, MyODBC with Access, Paradox or
Delphi all workm, from experience.
If
Gregg,
Monday, May 06, 2002, 6:57:55 PM, you wrote:
GG Upon reading into the user variables section of the mysql manual, I decided
GG to make my life easier inside several of my queries by specifying some user
GG variables. Note that I'm trying to have everything inside the select
GG statement -
Hi,
I have a table of jobs.
I would like user to search the jobs on three columns:
description,
location,
type,
on the search page, i have one text field, and one
drop down menu. the search field will be used for
keywords against the description and location columns.
the drop down will
MySQL keeps locking up (I get a Too many connections error.)
Is there a way that I can increase the number of connections that MySQL
will take?
SQL and Query
David McInnis
-
Before posting, please check:
Hi..
Rewrite it as:
WHERE MATCH (some_text_field) AGAINST ('red pepper' IN BOOLEAN MODE) AND
MATCH (some_text_field) AGAINST (green bean' IN BOOLEAN MODE);
Gurhan
-Original Message-
From: Vadim P. [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 12:07 PM
To: [EMAIL PROTECTED]
Get rid of percentage signs in your keyword...
See: http://www.mysql.com/doc/F/u/Fulltext_Search.html
Gurhan
-Original Message-
From: Shehryar Shafiq [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 12:46 PM
To: [EMAIL PROTECTED]
Subject: please help: search database - code
Hi,
Change the max_connections variable's value to a higher value. By default it
is set to 100. You can see what yours is set to with SHOW VARIABLES command.
See:
http://www.mysql.com/doc/T/o/Too_many_connections.html
http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html
Gurhan
-Original
Hi!
I have great trouble compiling MySQLGUI 1.7.5:
Missing headers:
FL/Enumerations.H FL/filename.H FL/fl_ask.H FL/Fl_Bitmap.H Fl/Fl_Box.H
FL/Fl_Box.H FL/Fl_Browser.H FL/Fl_Button.H FL/Fl_Check_Button.H
FL/Fl_Choice.H FL/Fl_Dial.H FL/Fl_Double_Window.H Fl/fl_draw.H
FL/fl_draw.H
Hello All,
I have created a MySQL database on Linux Mandrake 8.0, all is well.
I can add fields / tables ok.
I moved the contents of the database directory and the mysql directory to
another system (Same OS MySQL). I can access the database but can not add
fields.
Failed to save field :
Has someone done this before? What things do I have to take into
consideration
The following are things I know that may be issues
reading mysql.sock
reading my.cnf
database directory ( there is a parameter for command line operation )
I would suppose I would have to create a dual instance of
Check your permissions and fileowners one more time. You definitely have
permissions problem.. Make sure that all the datafiles are owned by mysql.
Gurhan
-Original Message-
From: Marko Palikko [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 13, 2002 1:00 PM
To: [EMAIL PROTECTED]
Subject:
Hi!
On May 06, Vadim P. wrote:
Hi,
It's not quite clear from the manual, but it appears that queries with
FULLTEXT search patterns like this:
MATCH (some_text_field) AGAINST ('(red pepper) (green bean)')
don't produce the result desired, that is, multiple .. elements are not
allowed,
Here is a puzzler for SQL jockies on a Monday afternoon. I have 2 tables,
each with what may or may not be a unique range of dates;
tblDate1
+++
| field1 | rDate |
+++
| 1 | 2002-03-01 |
| 2 | 2002-03-03 |
| 3 | 2002-03-05 |
| 4 |
If you have MySQL 4, you can use a UNION.
Otherwise you'll need a second table, because what you want is not
a join, but a concatenation of result sets.
At 12:47 -0500 5/6/02, Jay Blanchard wrote:
Here is a puzzler for SQL jockies on a Monday afternoon. I have 2 tables,
each with what may or may
I've been trying to import text files into MySQL, but I can't get it to
work. I'm new to MySQL and am still getting familiar with it, so
perhaps I'm missing something. I'm using the LOAD DATA LOCAL command
but I keep getting error 1148 The used command is not allowed with this
MySQL version.
We are designing an application that needs to use
a relational database to hold quite a large amount
of data.
In particular there is one table that has about 33
fields, 18 indexes, and 120 bytes per record.
Additionally, we are going to need to add about 2
million records per day to the table,
Wow,
Quick response... You guys ( gals) are Great !!
All files /var/lib/CRdb/* (Database Directory) are 777 (CHMOD)
and ownership mysql
All files /var/lib/mysql/mysql/* are 777 as well.
hmm. ( Very Puzzled )
Also the file #sql-6c4_a.frm in the error message does not exist.
Failed
[snip]
If you have MySQL 4, you can use a UNION.
Otherwise you'll need a second table, because what you want is not
a join, but a concatenation of result sets.
[snip]
Don't have 4.0 yet, probably going to wait until a production release comes
out. So if I need a second table I will have to do
Over here, we're doing an average of 95 queries per second (that's about
8 mill daily), on a Pentium III @ 900MHz with 768MB of ram. We're
working with smaller data sets, than 30 million records, tho. I imagine
that you could do well with a high end intel system, or a medium-end Sun
box.
A
To the originator of this thread:
While what you are asking is possible, Id like to put my two cents in and
ask you please not to do it.
If this is a production database, you have no idea how helpful it will be
for you to know by those missing pk numbers that something was deleted
manually
On 6 May 2002, at 13:06, Jay Blanchard wrote:
[snip]
If you have MySQL 4, you can use a UNION.
Otherwise you'll need a second table, because what you want is not
a join, but a concatenation of result sets.
[snip]
Don't have 4.0 yet, probably going to wait until a production release comes
At 12:56 PM 5/6/2002, you wrote:
We are designing an application that needs to use
a relational database to hold quite a large amount
of data.
In particular there is one table that has about 33
fields, 18 indexes, and 120 bytes per record.
Additionally, we are going to need to add about 2
Hi,
I using Macromedia UltraDev to develop my dynamic web site and would like to
use mySQL as the RDBMS. My hosting service folks are telling me that I
should only update my database on their server via update transactions. They
say this is for security reasons. UltraDev provides many good tools
Hi,
To run multiple mysqld servers, you at least have to specify a different
port number, different socket file path, different pid and error log file to
get it started. Different mysqld servers may point to the same database.
To do this, just define the necessary information for your new
On 6 May 2002, at 7:56, Alexander Skwar wrote:
As you can see below, SpamAssassin tags messages from the MySQL list as
spam. The main reason that this happens, is:
SPAM: Hit! (3.5 points) URI: URL of page called unsubscribe
It seems to me that that's a problem with SpamAssassin, not with
Hi
If the databases are not too big, and are on the same machine, you could
just copy the directory with the databases in.
If you need to restore the database just copy it back.
I think this is OK, though you might want to stop mysql to lock the
database.
I have only done this a couple of
more detail on this can be found here
http://www.mysql.com/doc/M/u/Multiple_servers.html
-Original Message-
From: Gurhan Ozen [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 3:10 PM
To: Luc Foisy; MYSQL-List (E-mail)
Subject: RE: Two database servers, same physical server
Hi,
To
Thanks Don, Gurhan, Peter!
uhg. I am sure I searched the docs first. *sigh*
-Original Message-
From: Don Vu [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 3:19 PM
To: Gurhan Ozen; Luc Foisy; MYSQL-List (E-mail)
Subject: RE: Two database servers, same physical server
more detail
[snip]
If you have MySQL 4, you can use a UNION.
Otherwise you'll need a second table, because what you want is not
a join, but a concatenation of result sets.
[snip]
Don't have 4.0 yet, probably going to wait until a production release
comes
out. So if I need a second table I will have to
Does anyone have a quick tip on how to format a float/numeric in the
following currency format with a query?
$xx,xxx.xx
Thanks!
Graeme
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I have these two tables;
mysql describe tblClass11;
+--+---+--+-+-++
| Field| Type | Null | Key | Default | Extra |
+--+---+--+-+-++
| ID | int(11)
Sergei, here:
RH7.2/2.4.9-31/Dual P-III 866MHz/MySQL4.0.2
A snapshot from a live database, sorry, couldn't prepare a more detailed
example:
--
select tdate, left(header,125) from archivel where match (header) against
('donald rumsfeld' in boolean mode);
== 188 rows in set (0.12
At 15:29 -0500 5/6/02, Jay Blanchard wrote:
I have these two tables;
mysql describe tblClass11;
+--+---+--+-+-++
| Field| Type | Null | Key | Default | Extra |
[snip]
Then I attempt to query;mysql select count(*) from tblCross1;
ERROR 1016: Can't open file: 'tblCross1.MRG'. (errno: 143)
perror 143
143 = Conflicting table definition between MERGE and mapped table
Can anyone help with this?
Drop the MERGE table, then try creating it with all the columns
Hi,
I using Macromedia UltraDev to develop my dynamic web site and would like
to
use mySQL as the RDBMS. My hosting service folks are telling me that I
should only update my database on their server via update transactions.
They
say this is for security reasons. UltraDev provides many good
Hi,
I've installed MySQL through the entropy.ch installer. Everything works fine
in the command line utillity but when I try to connect a php script i get
this error message:
Host 'localhost.127.in-addr.arpa' is not allowed to connect to this MySQL
server
I have tried various times to correc
At 15:44 -0500 5/6/02, Jay Blanchard wrote:
[snip]
Then I attempt to query;mysql select count(*) from tblCross1;
ERROR 1016: Can't open file: 'tblCross1.MRG'. (errno: 143)
perror 143
143 = Conflicting table definition between MERGE and mapped table
Can anyone help with this?
Drop the MERGE
SELECT FORMAT(yourvalue,2)
- Original Message -
From: Graeme B. Davis [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 06, 2002 10:16 PM
Subject: formatting currency in mysql
Does anyone have a quick tip on how to format a float/numeric in the
following currency format with
Gregg,
Monday, May 06, 2002, 6:57:55 PM, you wrote:
GG Upon reading into the user variables section of the mysql manual, I
decided
GG to make my life easier inside several of my queries by specifying some
user
GG variables. Note that I'm trying to have everything inside the select
GG
I am running mysql on solaris. This is a binary release. However, now I
would like to start my server with the innodb functionality. But I can't
start my server working for this.
I am not able to run the ./configure --with-innodb
I dont know how and where innodb_data_file_path should be
On Mon, 06 May 2002 12:56:52 -0400
Gurhan Ozen [EMAIL PROTECTED] wrote:
Hi,
Change the max_connections variable's value to a higher value. By default it
is set to 100. You can see what yours is set to with SHOW VARIABLES command.
See:
http://www.mysql.com/doc/T/o/Too_many_connections.html
Under normal operating conditions our v3.23.47 MySql db server handles about
60 queries per second using 50 threads or less. The host is a dual processor
700MHz Intel machine running the 2.2.14-5.0smp Linux kernel with 256M of
RAM.
Here's the problem: during spikes of activity where about 90-100
Hi MySql gurus,
We are using MySql for our database support in our project. It is
a multiserver environment. We are using a single table to store
info abt objects of each server. We want to know what is the
maximum number of rows that the MySql supports for a table.
In our case when the number
1 - 100 of 111 matches
Mail list logo