I think I may have gotten closer to the root of the problem. It seems that
the field named 'comments' is the one that crashes the server when it is
selected. Here is the output of the logs when I do 'select comments from
allusa':
040304 23:14:52 mysqld restarted
040304 23:14:53 InnoDB: Started
/
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 hours
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 w
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
tha
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 ta
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.
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 h
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 com
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 i
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
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
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 w
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: MySQ
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
- 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.datab
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:
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
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
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.
--
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 connec
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 double(18,6)
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 command
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 con
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
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
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 lin
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
>info
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 Acc
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
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 u
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)
DATE_
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
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 regardi
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 transfer/conv
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]
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 w
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 my
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 |
+--
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 tha
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:
OK, I found the answer.
CREATE TABLE ProductSums
SELECT DISTINCTROW IndenturedList.NSIPartNumber,
Sum(tblInvTransaction.Qty) AS SumOfQty
FROM IndenturedList;
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;
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 told
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 numb
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 b
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. W
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, C
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 produc
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: http:/
> 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 | s
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 one
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, 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
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
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
Produ
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
e
> 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]
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
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
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> v.V
>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:
>Or
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
> are
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, S
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;
+-+---+--
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 on
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: www.sqlyog.com
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: Re:
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 o
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 wi
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
ser
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 co
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 Vendor.Numb
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_na
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 fullte
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
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
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
transaction
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 ano
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, on
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 could
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.
T
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
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 |
+-+
>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:
Downl
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
> 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 AU
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~
--
|...|
|
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 da
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 KEY
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:
htt
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 w
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 PR
-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 sta
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 abou
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 perl:d
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
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 the
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
1 - 100 of 101 matches
Mail list logo
