Here is what I am doing now...
SELECT id, first_name, last_name, password FROM account WHERE password =
ENCODE(1234, 'foobar') ORDER BY last_name LIMIT 0,10
I need to do a where password LIKE '%1234%' instead, I can not seem to get
this to work, is there some trick?
--
Hi all
I would like to try and implement the MySQL socket protocol (or what ever
you would call it), so that I can do all kinds of communication with a MySQL
server, like normal SQL, MySQL environment variables, performance status,
tables helth checks, and what ever is possible.
The reson I need
Cliff,
please run
CHECK TABLE ...
on your table and look if mysqld prints anything to the .err log. Send the
WHOLE .err log to me.
What is your operating system version?
amount of changes since today. I am trying all I can to recover the data
from this table because I know it is in there.
Currently, everything you listed can be done via queries to the server. Take
a look at the MySQL manual for all the queries and their requisite responses.
And I'm quite sure what you want to do has already been done. Please take a
look at MySQL CC and MySQL Administrator (both available from
Hello list, I am trying to find a way to retrive the time a certain select statement
took for debug purposes. If I execute a select statement in the mysql console I get
the time that select statement took to execute. I am searching for a way to retrive
that value. Right now I am using the
Manda Sairam [EMAIL PROTECTED] wrote:
Hello Sir,
I have a file with the name doc.db.001 It is a binary file and it is a mysql file.I
tried opening the file using load data file command but failed with errors .Actually
the problem is i donot know about the columns or the details about the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 04 March 2004 08:58, Jonas Lindén wrote:
Hello list, I am trying to find a way to retrive the time a certain
select statement took for debug purposes. If I execute a select
statement in the mysql console I get the time that select
It sounds like the file is actually a MySQL database. Possibly an innodb file?
You will need to create the requisite table definition so MySQL knows how to
read it, then you might be able to read it.
j- k-
On Thursday 04 March 2004 12:08 am, Egor Egorov wrote:
Manda Sairam [EMAIL
Scott Haneda [EMAIL PROTECTED] wrote:
Here is what I am doing now...
SELECT id, first_name, last_name, password FROM account WHERE password =
ENCODE(1234, 'foobar') ORDER BY last_name LIMIT 0,10
I need to do a where password LIKE '%1234%' instead, I can not seem to get
this to work, is
charles kline [EMAIL PROTECTED] wrote:
Oh I see... so how would I get balance_amt to have a running balance?
- You can calculate it in your application
- You can run an additional query
- From version 4.1.1 you can use WITH ROLLUP modifier with GROUP BY clause to get
summary info:
All - Running MySQL 4.0.17 under Red Hat 9, using MyISAM tables.
I'm trying to add the auto_increment attribute to column in a table that
already has a primary key defined. Here is the table I'm trying to create:
CREATE TABLE IF NOT EXISTS dataTypes (
id int unsigned NOT NULL AUTO_INCREMENT
Mark Riehl [EMAIL PROTECTED] wrote:
All - Running MySQL 4.0.17 under Red Hat 9, using MyISAM tables.
I'm trying to add the auto_increment attribute to column in a table that
already has a primary key defined. Here is the table I'm trying to create:
CREATE TABLE IF NOT EXISTS dataTypes
would you mind being morew specific?
On Wed, 2004-03-03 at 23:20, Elly Wisata wrote:
Hi *,
How to query records that most of the fields are the same value? Izit
possible?
Thanks in advance
~Elle~
--
|...|
| _
All - Running MySQL 4.0.17 under Red Hat 9, using MyISAM tables.
I'm trying to add the auto_increment attribute to column in a table that
already has a primary key defined. Here is the table I'm trying to
create:
CREATE TABLE IF NOT EXISTS dataTypes (
id int unsigned NOT NULL
All - Running MySQL 4.0.17 under Red Hat 9, using MyISAM tables.
I'm trying to add the auto_increment attribute to column in a table that
already has a primary key defined. Here is the table I'm trying to
create:
CREATE TABLE IF NOT EXISTS dataTypes (
id int unsigned NOT NULL
Hello,
I am new to Linux, and mySQL. I am currently a MsSQL Server 2000 and VB
programmer, but trying to break away from that side. I have my database set
up and working great, but I am really struggling on how to perform scheduled
updates, and data imports. Can anyone please point me to a good
Description:
When updating a table with a fulltext index, the fulltext index becomes
corrupted. The Error ERROR 1034 at line 76: Incorrect key file for table: 'test'; try
to repair it is dislpayed. The error is not produced when there is no fulltext index.
How-To-Repeat:
Download
Hi all,
I need some advice as to how to manage a user login system using PHP and
MySQL. Currently, I have the following table:
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
There exists the possibility of doing a SELECT where the list of IN() clause
is the result of another select ?
Like this for example
Select Number from Phone where Number not in
(
SELECT Number from Vendor, Clients
where Vendor.Number=Clients.Number
)
Thank in advance
Todd,
I'm also pretty new to MySQL and Linux but I have years of DB2 experience on
various platforms.
I've bash scripts very useful and cron them when I have something that I
want to automate, such as a daily backup of my databases. Here are some
examples of bash scripts that I use with MySQL.
Rhino,
I know this is an off topic; however I see that you have DB2 experience.
Most of the information I have a question you might be able to answer. Are
you using PHP with MySQL? If so, have you tried to use PHP with DB2? I'd
like to know what functions you call to connect or anything that
Why don't you try it yourself? That's the best way to learn. It's also much
faster than waiting for replies on mailing lists ;-)
Also, when you send a note like this about SQL, you should indicate which
version of MySQL you are using; different versions have different
capabilities. For example,
YEAP! ver. 4.1.x supports subselects. One thing i should say is that it
is still in beta, but it seems to be quite stable! =)
Best Regards!
On Thu, 2004-03-04 at 10:07, Gabriel Alessandria wrote:
There exists the possibility of doing a SELECT where the list of IN() clause
is the result of
Heikki,
Thanks for your reply.
As you said I have attached trace collected for SHOW INNODB STATUS.
Please point me the things which are going wrong.
Do you mean I have to use auto-commit transactions?
What changes should I do (or) take care when using MySQL through ODBC to avoid old
This functionality exists in 4.1.x versions of MySQL
Original Message
On 3/4/04, 8:07:15 AM, Gabriel Alessandria [EMAIL PROTECTED] wrote
regarding Sintax - Where xx not in (another Select structure):
There exists the possibility of doing a SELECT where the list of IN()
clause
is the
Wow... ROLL UP looks great! Thanks.
- Charles
On Mar 4, 2004, at 5:28 AM, Victoria Reznichenko wrote:
charles kline [EMAIL PROTECTED] wrote:
Oh I see... so how would I get balance_amt to have a running balance?
- You can calculate it in your application
- You can run an additional query
- From
Did you use a MySQL binary or one that you compiled? What version of 4.0
did you test against?
Original Message
On 3/4/04, 7:43:02 AM, [EMAIL PROTECTED] wrote regarding Corrupt full text
index:
Description:
When updating a table with a fulltext index, the fulltext index
becomes
WHERE password = password('1234');
Curtis
On Thu, 4 Mar 2004, Victoria Reznichenko wrote:
Scott Haneda [EMAIL PROTECTED] wrote:
Here is what I am doing now...
SELECT id, first_name, last_name, password FROM account WHERE password =
ENCODE(1234, 'foobar') ORDER BY last_name LIMIT
Gabriel Alessandria [EMAIL PROTECTED] wrote:
There exists the possibility of doing a SELECT where the list of IN()
clause
is the result of another select ?
Like this for example
Select Number from Phone where Number not in
(
SELECT Number from Vendor, Clients
where
At the moment we have 6 webservers (RedHat) behind a loadbalancer which use
one dedicated MySQL server (plus two smaller dedicated MySQL servers for a
few special sites) for their data.
On setting that seems to cause headaches is MySQL's max connecterrors. We
cannot find which conditions cause
I think that will help, I'll give it a try, I have had a lot of trouble
finding good tutorials for bash also. Having been a windows person for so
long it seems very foreign to me. I see how you connect to the local data
base, does anyone know how to import data from another non mySQL database
There's a whole list of all the functions at http://www.php.net
Curtis
On Thu, 4 Mar 2004, James Marcinek wrote:
Rhino,
I know this is an off topic; however I see that you have DB2 experience.
Most of the information I have a question you might be able to answer. Are
you using PHP with
Here are two suggestions:
1) One option is to use source database to dump data into a MySQL
readable format, then import/load the data into MySQL.
2) Another option is to use a language like C++/or Java and open
simultaneous connections to each database. One dumping data, format the
data then
Hi,
I am using the precompiled binaries from mysql.com for both 4.1 and 4.0
releases.
For the 4.0 release I used version 4.0.18.
Dave.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 04 March 2004 14:56
To: Dave Kirkpatrick
Cc: [EMAIL PROTECTED]
Subject:
HI!
ODBC is a nice, cheap and easy way. JDBC is a nice option also (i am a
java guy, forgive me! =)
There are a few utilities around that may help, including some gui
managers for mysql, better yet, sitted behind your comfortable windows
desktop =)
A few utilities to try:
sqlyog:
Sorry, I don't know anything about PHP except that is supposed to be
somewhat Java-like. My main language these days is Java but I don't know PHP
at all.
For what it's worth, I checked my V7.2 DB2 manuals just now to see if PHP is
mentioned in the Application Development Guide. I found chapters
Hi all,
I have a problem with a select returning duplicates, even though there
aren't any duplicates in the database.
select
e.EventID,
date_format(e.EventDate, '%c/%d/%y') as EventDate,
e.EventTime,
v.VenueName,
v.VenueID
from
events e,
venues v;
I too am a Java guy. The nice part of Java is that it's cross platform
and cross database. Using JDBC and pure java JDBC drivers you can move
your applications to different databases on just about any relevant
platform. This will allow you to run your java applications on Windows,
Mac, Linux,
You have no join criteria between your tables.
Original Message
On 3/4/04, 9:23:41 AM, Erich Beyrent [EMAIL PROTECTED] wrote
regarding Duplicates returns in query?:
Hi all,
I have a problem with a select returning duplicates, even though there
aren't any duplicates in the database.
Description:
I keep getting the same old can't connect to mysql.sock error. I have revied
many of the sites and forums and tried most (if not all) solutions. Is there
something I have missed? Thanks in advance for any help.
How-To-Repeat:
Fix:
Submitter-Id:
Hello Erich,
Thursday, March 4, 2004, 3:23:41 PM, you wrote:
EB I have a problem with a select returning duplicates, even though there
EB aren't any duplicates in the database.
EB select
EB e.EventID,
EB date_format(e.EventDate, '%c/%d/%y') as EventDate,
EB e.EventTime,
EB
Does the socket actually exists? Are you able to connect via port?
Original Message
On 3/4/04, 9:04:02 AM, root [EMAIL PROTECTED] wrote regarding Can't
seem to get to run properly - Checked by Vexira -:
Description:
I keep getting the same old can't connect to mysql.sock error. I
What operating system are you using? What does your my.cnf look like for
the sections
[mysqld]
...
socket=
...
Can you connect to the MySQL server?
Original Message
On 3/4/04, 10:14:26 AM, Scott Bounds [EMAIL PROTECTED] wrote
regarding RE: Can't seem to get to run properly - Checked by
What operating system are you using? What does your my.cnf look like for
the sections
--8--
Please don't overquote like that.
--
Martijn
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You have no join criteria between your tables.
Of course. I am so stupid...
select
e.EventID,
date_format(e.EventDate, '%c/%d/%y') as EventDate,
e.EventTime,
e.EventDetails,
e.VenueID,
v.VenueName,
v.VenueID,
v.VenueURL,
v.Directions
from
events e,
venues v
where
Your problem is that you are doing a join of two tables but you haven't
stated the joining condition (what the two tables have in common). When you
join tables without stating a joining condition, every row of the first
table joins with each row of the second table. This is called a Cartesian
Can you do a ps -ef | grep mysql and post the results? Also can you log
in using mysql --user=mysql -p -P3306
Original Message dated 3/4/04, 10:43:26 AM
Author: Scott Bounds [EMAIL PROTECTED]
Re: mysql reply - Checked by Vexira -:
I have attached my my.cnf file. I am not sure how to connect
Hi, I ran CHECK TABLE with the EXTENDED option on the table and it reports
everything ok:
mysql check table allusa extended;
+---+---+--+--+
| Table | Op| Msg_type | Msg_text |
+---+---+--+--+
| bb.allusa | check | status | OK
Sp. Raja,
you have 3 dangling transactions that have been active for almost 2 hours.
They prevent purge from removing those delete-marked rows.
---TRANSACTION 0 832338, ACTIVE 6027 sec, OS thread id 65
MySQL thread id 41, query id 1036449 localhost root
Trx read view will not see trx with id = 0
Hi Ware Adams,
thanks for your answer. Here's another question:
Is it possible to set MySQL to save all the changes that can happen, for
example, if some one insert a new record into table X, MySQL save a log
about this task performed and all data that was inserted. I another person
update
Hi, I ran CHECK TABLE with the EXTENDED option on the table and it reports
everything ok:
mysql check table allusa extended;
+---+---+--+--+
| Table | Op| Msg_type | Msg_text |
+---+---+--+--+
| bb.allusa | check | status
Hi,
We are developing in Microsoft's C++.NET with MS SQL Server as the underlying DBMS. We
are planning to move to MySQL.Please kindly advise if there is a OLEDB provider for
MySQL? or do I have to stay with ODBC?
Many thanks.
Gilbert Wu
--
MySQL General Mailing List
For list archives:
Hi!
On Mar 04, [EMAIL PROTECTED] wrote:
Description:
When updating a table with a fulltext index, the fulltext index
becomes corrupted. The Error ERROR 1034 at line 76: Incorrect
key file for table: 'test'; try to repair it is dislpayed. The
error is not produced when
Dear list,
I wish to know if anyone have any experience in querying several
databases at the same time. Today the company that I work for have
about three different databases and I really feel that's fine because of
the logic around it. We have one Customer database with customerData
table,
MyODBC/MySQL connections can be made DSN less.
Original Message
On 3/4/04, 11:28:19 AM, Gilbert Wu [EMAIL PROTECTED] wrote
regarding OLEDB Provider for Mysql:
Hi,
We are developing in Microsoft's C++.NET with MS SQL Server as the
underlying DBMS. We are planning to move to MySQL.Please
Sasha Pachev wrote:
Daniel R. Anderson wrote:
Whenever I start up mysql through mysqld (in my rc.d file), I get the
following error:
Warning: asked for 196608 thread stack, but got 126976
(Note: numbers vary)
Is this bad, and what (if anything) should I do about it?
In theory, it could be
According to the C API docs on mysql_get_metadata:
If a statement passed to mysql_prepare() is one that produces a result
set, mysql_get_metadata() returns the result set metadata in the form of
a pointer to a MYSQL_RES structure that can be used to process the meta
information such as total
Hi everyone,
I have a table where I would like members of a uid field to be limited
by the range of values that are in another field. What I am looking for
would be taken care of with the enum() operator except I need the range
of values to be dynamic - because uid will change. I've been
Table ProductSums has not been created. Can you create this table when
you insert data into it?
INSERT INTO ProductSums
SELECT DISTINCTROW IndenturedList.NSIPartNumber,
Sum(tblInvTransaction.Qty) AS SumOfQty
FROM IndenturedList;
OK, I found the answer.
CREATE TABLE ProductSums
SELECT DISTINCTROW IndenturedList.NSIPartNumber,
Sum(tblInvTransaction.Qty) AS SumOfQty
FROM IndenturedList;
I was unable to reproduce the error on 4.0.17 using the supplied data.
Original Message
On 3/4/04, 11:42:56 AM, Sergei Golubchik [EMAIL PROTECTED] wrote regarding
Re: Corrupt full text index:
Hi!
On Mar 04, [EMAIL PROTECTED] wrote:
Description:
When updating a table with a
Hi,
I have a table where I would like members of a uid field to be limited
by the range of values that are in another field. What I am looking for
would be taken care of with the enum() operator except I need the range
of values to be dynamic - because uid will change. I've been told that
Erich Beyrent wrote:
Hi all,
I need some advice as to how to manage a user login system using PHP and
MySQL. Currently, I have the following table:
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
The MySQL server is not running. Did you start the MySQL server?
Original Message
On 3/4/04, 1:19:28 PM, Scott Bounds [EMAIL PROTECTED] wrote
regarding RE: mysql reply - Checked by Vexira - - Checked by Vexira - -
Checked b:
I ran the ps -ef | grep mysql with the following results:
Jigal van Hemert wrote:
At the moment we have 6 webservers (RedHat) behind a loadbalancer which use
one dedicated MySQL server (plus two smaller dedicated MySQL servers for a
few special sites) for their data.
On setting that seems to cause headaches is MySQL's max connecterrors. We
cannot find
Test Email - Disregard
-:Kevin Carpenter
CHOP - Biomedical Engineering
(215) 590-5762
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Test Email - Disregard
-:Kevin Carpenter
CHOP - Biomedical Engineering
(215) 590-5762
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Greeting to the list.
I am running MS Access as a front end to data stored on MySql in
a Redhat 7.3 box.
I have about 95% functionality so far!
(The Database is of a Youth Soccer league).
I am having one problem though with one of my tables.
The table seems to double itself when I
Are you using ODBC Links or are you importing the table into MS Access
from MySQL? Are there unique constraints on the table to prevent
duplicate data from being entered?
Original Message
On 3/4/04, 1:57:15 PM, Steve Siesel [EMAIL PROTECTED] wrote regarding MS
Access and MySql:
Greeting
Hi,
I have a question about 'create table'.
If two persons create table both name 'table1' at the same time in same
database, what would happen?
Thanks in advance.
Dan
Dear Friends
Running the follow query
select max( sr_recno) from test_table down work for re
the error id returned by mysql_errno is 3731792
server is 4.1.1a-alpha
Table structure is
SR_DELETEC char(1)
SR_RECNO bigint(15) PRI auto_increment
VALUE double(18,6)
OBS text
ENABLE tinyint(4)
Once more - Dear list,
I am doing some research on a CRM-tool which my company bought that uses
msSQL.
The setup looks something like this
User -- CRM -- MsSQL }
User -- Webform -- MySQL } The same data entered
What would be optimal is if would be possible, that when a user
I am using ODBC links to move the data. There were multiple
tables in the database and this is the only one effected.
Steve
- Original Message -
From: [EMAIL PROTECTED]
To: Steve Siesel [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, March 04, 2004 3:03 PM
Subject: Re: MS Access
What is `special` about this one? If you are using ODBC links why are you
needing to convert the table? MS Access is merely your GUI to the
underlying data.
Original Message
On 3/4/04, 2:28:31 PM, Steve Siesel [EMAIL PROTECTED] wrote regarding Re:
MS Access and MySql:
I am using ODBC
Andre MATOS wrote:
Is it possible to set MySQL to save all the changes that can happen,
for example, if some one insert a new record into table X, MySQL save
a log about this task performed and all data that was inserted. I
another person update one field from table Y, MySQL save all the
The Database was originally made in Access
- Original Message -
From: [EMAIL PROTECTED]
To: Steve Siesel [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, March 04, 2004 3:35 PM
Subject: Re: MS Access and MySql
What is `special` about this one? If you are using ODBC links why
How did you originally populate the MySQL database with this table in
question? Did you export the table via MS Access and load the data with
either LOAD DATA or mysqlimport?
...
Out of curiosity why did you use Access to create and populate the
tables, export them to MySQL and are using Access
Gilbert
You might want to look at the ByteFX provider
Freddie
-Ursprüngliche Nachricht-
Von: Gilbert Wu [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 4. März 2004 18:28
An: [EMAIL PROTECTED]
Betreff: OLEDB Provider for Mysql
Hi,
We are developing in Microsoft's C++.NET with MS SQL
Randy
Thanks but I am not really sure where the connections are kept alive or
'asleep'
I am quite sure that I am closing my objects, setting them to nothing and
disposing them in my script (actually, ASP.NET is not relly script) but I
don't know if IIS is keeping the connection objects in the
Mark Maggelet wrote:
Since I didn't get an answer to this, I'll try asking it another way:
has anybody gotten a binlog with binary data (images) to load from one
server to another? And if so, what version are you using?
Thanks,
- Mark
Mark:
If the latest does not work, it is a bug in mysql
Luiz Rafael Culik Guimaraes wrote:
Dear Friends
Running the follow query
select max( sr_recno) from test_table down work for re
the error id returned by mysql_errno is 3731792
server is 4.1.1a-alpha
Table structure is
SR_DELETEC char(1)
SR_RECNO bigint(15) PRI auto_increment
VALUE
Freddie Sorensen wrote:
Randy
Thanks but I am not really sure where the connections are kept alive or
'asleep'
I am quite sure that I am closing my objects, setting them to nothing and
disposing them in my script (actually, ASP.NET is not relly script) but I
don't know if IIS is keeping the
Dan Liu wrote:
Hi,
I have a question about 'create table'.
If two persons create table both name 'table1' at the same time in same
database, what would happen?
It cannot happen at the same time. Whoever does it second will get an error
unless the table is created with create temporary table.
Bernd Jagla wrote:
Hi everyone,
I have XML data with a corresponding DTD, and I want create the necessary tables and
load the data.
Does anyone has experience with this?
Are there any tools to help me?
Thanks for your advice.
I would use the XML module in Perl + DBD/DBI and write the loader if I
Lee Chalupa wrote:
The documentation I find describes the slave contacting the master
to initiate the replication service.
I need the master to be able to contact the slave. Is this possible.
Not with the standard MySQL code. You could, however, write wrapper scripts and
even modify the source
Cliff,
- Original Message -
From: Cliff [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, March 04, 2004 7:07 PM
Subject: Re: Major problem converting MyISAM to InnoDB
Hi, I ran CHECK TABLE with the EXTENDED option on the table and it reports
everything ok:
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 04, 2004 1:24 PM
Subject: Re: Major problem converting MyISAM to InnoDB
Cliff,
- Original Message -
From: Cliff [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
I have found my problem...the problem was with access
asking for unique identifiers in each table. I might have had the
same identifier for two tables. Now it seems to be working.
Thanks for all who helped
STeve
- Original Message -
From: Steve Siesel [EMAIL PROTECTED]
To: [EMAIL
Hi Andre,
I think you are looking for this:
http://www.mysql.com/doc/en/Binary_log.html
Hope it helps,
Ken
- Original Message -
From: Andre MATOS [EMAIL PROTECTED]
To: Ware Adams [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, March 04, 2004 12:09 PM
Subject: Re: MySQL Backup
I am having trouble undertanding a few things with mysql.
OS X 10.3, MySql 4 current stable
I cp'd my-large.cnf to /etc/my.cnf
This is the first time I have ever had this file in use, I have just over a
Gig of ram, so I thought it would be a good idea to use this setting.
All seems to work fine
So I have made a table called 'uid' where on uid is the only field in
the table. Then I make another table called 'users' where there are two
fields, 'uid1' and 'uid2' and both uid values have foreign key
constraints referencing the 'uid' field in the uid table.
No problem, tables are created
Some key in the table is null when it shouldnt be, or the type of the join
keys isnt the same. i have had issues when importing data from a dump so
i've had to do a FORIEGN_KEY_CHECKS=0
So I have made a table called 'uid' where on uid is the only field in
the table. Then I make another table
Is there a way to disable this 'max_connect_errors' thing?
http://www.mysql.com/doc/en/Blocked_host.html
Tried max_connect_errors=0 but then it shows up as max_connect_errors=1
What is the 'max' that this value can be in case?
We have it set to 10,000 now, but that only buys us time.
When is
in case someone hasn't answered you yet..
do you know that you can specify a database.tablename.column syntax in
your queries to go across multiple databases?
Daniel Ek wrote:
Dear list,
I wish to know if anyone have any experience in querying several
databases at the same time. Today the
In fact it seems to be just to opposite. I toggled the default values to
be null and allowed for the null option and poof it worked! I don't
really understand this very well. Wish I did.
Some key in the table is null when it shouldnt be, or the type of the join
keys isnt the same. i have
I am using MySQL 5 issuing the following query when the application died on me three
times.Query: Select name, year_of_birth from players where year_of_birth = ALL(select
year_of_birth from players)
Note: If I only use the first part of the query (i.e. without the subquery) it runs no
problem.
Hi Dave,
- Original Message -
From: [EMAIL PROTECTED]
Sent: Thursday, March 04, 2004 7:43 AM
Subject: Corrupt full text index
Description:
When updating a table with a fulltext index, the fulltext index
becomes corrupted. The Error ERROR 1034 at line 76: Incorrect key file
for table:
Hi there, i happened to be peering into the Sybex book on Mysql4 , it was
pretty expensive about 100 AUD is it a good one ? Anyway i had reference to
be able to compile c code into Mysql to add functions into it. Is there
anyway posible to avodi doing this and add it using queries ? Let me know
I am having trouble undertanding a few things with mysql.
OS X 10.3, MySql 4 current stable
I cp'd my-large.cnf to /etc/my.cnf
This is the first time I have ever had this file in use, I have just over a
Gig of ram, so I thought it would be a good idea to use this setting.
All seems to work fine
OS X 10.3 and mysql 4.x, I have a situation where after time certain queries
get really slow, in the area of 30 seconds. I seem to have pinned it down
to my use of my-large.cnf. If I remove this file and let just the mysql
defaults in, then I seem to not have the trouble, at least, I have 8
1 - 100 of 101 matches
Mail list logo