>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:MySQL server
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Relea
Thanks Luciano.
It works.
Iago.
-Mensaje original-
De: Luciano Barcaro [mailto:[EMAIL PROTECTED]]
Enviado el: martes 28 de mayo de 2002 19:21
Para: Iago Sineiro
CC: MySql Mail List
Asunto: Re: Error 1114 when import mysqldump in InnoDB table
Hi,
the internal space for innodb is full.
MySQL Version: 3.23.48-log
OS/RedHat 7.2 / gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98)
Hi, this are the versions of my mysql and OS, i compiled them thru source.
I am aware of the problem that exists on mysql ver 3.23.49 and w/ gcc
version 2.96.
So i de-graded by only 1 version of mysq
Hi to all,
I am new in MYSQL.I use powerbuilder 6.5.1 with Mysql (v.4.01 with Innodb
tables) and I am not sure if the compatiblility is good enough. No rows are
returned during retrieve of a datawindow with retrieval arguments.
Can anyone help me?
---
Hi all.
When is released mysql 3.23.50?
I received in the announce mail list an announce of a pre-release of mysql
3.23.50 one month ago.
This release has some enhancements on InnoDB table type (specially the
autoexten capability).
The announcement mail says than this prerelease it will moved
Hi all,
I'm developing financial analysis app in MySQL. Since I want it to be
portable and purely client-server I'm coding (nearly) all calculations in
SQL, and came across weird optimization issue. The following query
calculates one of my ratios using financial data from TQRPE table (some 5K
rec
On Wed, May 29, 2002 at 12:13:49AM -0700, Jeremy Zawodny wrote:
> Heikki,
>
> After a good 6-8 hours of runnning, the server just restarted itself
> (running the most recent build from the 3.23.xx tree, as you
> suggested).
Just for the record, it happened again. So it's reproducable to a
dregr
Does anyone have a way to export data from a table into a tab delimited text
file? Can't seem to see the option in mysqldump.
For bonus points - how could I achieve this via PHP?(!)
TIA,
ollie
or-media.com | design |
http://phpmyadmin.sourceforge.net/
/Peter
- Original Message -
From: "ollie" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Wednesday, May 29, 2002 11:57 AM
Subject: Tab delimited dump?
> Does anyone have a way to export data from a table into a tab delimited
text
> file? C
Hi All
i am running MySql 3.23.49 Max on Win 2K
Does this version of MySQL supports subqueries.
Also does this support transaction..
Where can i get the details reg this..
Regards,
Arul
-
Before posting, please check:
http
Jeremy,
I think this happens because the InnoDB transaction handle has already been
freed in end_thread when MySQL still writes one log item for the connection.
Please test the following patch. Replace the function
innobase_close_connection with the one below. I forgot to set innobase_tid
to NULL
Hi all.
Anybody knows how to see innodb messages at startup or shutdown of mysql
server?
Is there any log of messages?
Thanks in advance.
Iago.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manua
Hello!
specifying a column as unique or primary in MySQL
creates indices automatically or do we need to do it
explicitly using INDEX(unique/primary_colname) in
CREATE TABLE command of MySQL??
Thanx in advance..
Ritu Singla
>
>
__
u can see the InnoDB messages in 'hostname.err' file in the data dir.
On Wed, 29 May 2002, Iago Sineiro wrote:
> Hi all.
>
> Anybody knows how to see innodb messages at startup or shutdown of mysql
> server?
>
> Is there any log of messages?
>
> Thanks in advance.
>
> Iago.
>
>
>
>
> Hello,
> i could not understand what is the content of log
> files in InnoDB in MySQL...is it the log of the
database,i
> mean, the data, or the transaction log??
>
> Thanx in advance..
> Ritu Singla
>
>
> Everything y
On Wed, 29 May 2002 11:24:36 +0100 (BST)
ritu singla <[EMAIL PROTECTED]> wrote:
> Hello!
>
> specifying a column as unique or primary in MySQL
> creates indices automatically or do we need to do it
> explicitly using INDEX(unique/primary_colname) in
> CREATE TABLE command of MySQL??
yes, you ha
Jeremy,
it looks like this crash can happen if you use MySQL 'user level locks'
which are kind of semaphores. In that case MySQL will write a binlog entry
even after THD::cleanup where the transaction handle is freed.
>From the manual:
"You can also solve some cases by using the user-level lock
Ed,
Wednesday, May 29, 2002, 2:24:40 AM, you wrote:
EL> I'm not sure how to phrase this. Please excuse the crudeness of my description.
EL> I'm storing calendar data in a MySQL database and I'm wondering, is there a
EL> way to specify a day, such as the 28th, and "fourth" "Tuesday" as search
E
Trevor,
Wednesday, May 29, 2002, 3:29:43 AM, you wrote:
TF> Running MYSQL 3.23 can the date mmdd be reversed when using Access or VB
TF> frontend so that users can enter it as they are used to eg. ddmm.
MySQL stores data in mmdd format, but you can use DATE_FORMAT()
function to displ
Arul,
Wednesday, May 29, 2002, 1:05:02 PM, you wrote:
A> i am running MySql 3.23.49 Max on Win 2K
A> Does this version of MySQL supports subqueries.
Nope. How to re-write queries read in our manual:
http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
A> Also does this support transac
weng,
Wednesday, May 29, 2002, 2:15:11 AM, you wrote:
wc> Thanks for your prompt reply!
wc> Egor Egorov
wc> actually i alrdy followed the manual..the error is
wc> whenever i type in the command prompt -> mysqld-nt
wc> -install FAILURE TO START SERVICE is the error i
wc> encounter.. but if i run
ritu,
Wednesday, May 29, 2002, 1:24:36 PM, you wrote:
rs> specifying a column as unique or primary in MySQL
rs> creates indices automatically or do we need to do it
rs> explicitly using INDEX(unique/primary_colname) in
rs> CREATE TABLE command of MySQL??
PRIMARY and UNIQUE are indexes. Look at:
Hi!
On May 23, Przemyslaw Popielarski wrote:
> "Sergei Golubchik" <[EMAIL PROTECTED]> wrote:
> > > 1 row in set (0.00 sec)
> >
> > Works fine for me (that is "No rows" - and no bug).
> > Probably, it's one of numerous fulltext-related bugs that were fixed
> > since 4.0.1 release.
>
> Will you fi
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: "ritu singla" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, May 29, 2002 2:31 PM
Subject: Re: Log Files in InnoDB (MySQL)
> Ritu,
>
> the ib log files contain records of every change to database pages in the
>
Hello Outthere!
Maybe this is a very simple question, but I'm a Rookie so lets see. I've tried to load
BLOBs into my MySQL-DB, but I could not find a documentation how to do this. How can I
load a BLOB, for example a PDF-File from my local filesystem into the database (which
SQL-commands do I
Christian,
It's pretty easy, you can do it with a normal INSERT statement, all
you've got to remember is that NUL (ascii 0) needs to be escaped as
"\0", and that double quotes and single quotes should also be escaped
(i.e. \" and \').
Getting the data back again is even easier, because it'll une
Hello
I have a question,
is possible to search on mysql 4.0 in fulltext index
the exact phrase ?
thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (t
On Wed, May 29, 2002 at 02:10:07PM -0700, ddd wrote:
> I have a question, is possible to search on mysql 4.0 in fulltext
> index the exact phrase ?
http://www.mysql.com/doc/F/u/Fulltext_Search.html suggests that it is
possible. Here is the relevant excerpt:
The boolean full-text search capabilit
ddd,
Thursday, May 30, 2002, 12:10:07 AM, you wrote:
d> I have a question,
d> is possible to search on mysql 4.0 in fulltext index
d> the exact phrase ?
"Phrase search" will come in 4.0.2...
d> thanks
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email
Peter,
Wednesday, May 29, 2002, 4:39:52 AM, you wrote:
PM> I have just installed mysql 3.23.49 onto my Mandrake installation using the RPMs.
PM> How can I get the mysql server to start as the PC is booting ??
If you installed MySQL server from RPMs mysqld should automatically
run at the boot ti
Victor,
Wednesday, May 29, 2002, 12:01:31 AM, you wrote:
VSA> Tells a great deal about how confused I am...
VSA> I've a database with three tables, one with image data, one with
VSA> categories and one table which helps me to have several categories per
VSA> image...
VSA> The following SQL gi
Jeremy,
Actually support is something I would like to explore. As of current,
Yahoo! does not have an active support contract with MySQL so we should
remedy that soon. Although I believe Yahoo receives our highest level of
support because of the tight relationship, we should at a minimum get bo
I deleted my database today by mistake and I have a backup from yesterday
made as follows:
mysqldump -A >> backup.txt
How can I restore this database?
Thanks for your help in advance.
Scott
-
Before posting, please check:
Hi Chris,
See the code how load BLOB into a MySQl
String saveSql = "INSERT INTO Table (DataCol) VALUES (?)"
try {
bos = new ByteArrayOutputStream();
oos = new ObjectOutputStream(new BufferedOutputStream(bos));
fileObj.writeObjectData(oos);
oos.
You should be able to do this:
mysql < backup.txt
-Original Message-
From: Hathaway, Scott L [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 8:49 AM
To: Mysql (E-mail)
Subject: database restore - please help
I deleted my database today by mistake and I have a backup from yeste
You wrote::
deleted my database today by mistake and I have a backup from yesterday
made as follows:
mysqldump -A >> backup.txt
How can I restore this database?
Thanks for your help in advance.
Scott
Do get the backup write the command
mysql databasename < backup.txt
Regards
Daya Krishan
Hallo
I cant use phpMyAdmin, or any of my other (php) pages as I get the error
cannot connect to MySQL via 110 (111)
I had this in the past and what I did then was to check if mysql.sock
was in the temp directory (or a link to it)
I do see it there now but I cant seem to get any connection to M
Hi,
I am about to set up a network which has a central "main" server, and
several (up to 30) "shop" servers (it is for a retail chain). I'm intending
to link install mysql on all of them and link them up using the method
described below. What I'd like to know is (a.) Can anyone see a fatal flaw
ok. my admin guy installed the linux rpm of mysql. however, i can't locate
the mysqladmin and mysql bins. do i have to install an additional rpm that
include those?
Luke
-
Before posting, please check:
http://www.mysql.com/m
Peter,
Tuesday, May 28, 2002, 7:10:28 PM, you wrote:
PE> How can I do a fulltext search on several tables
PE> with just one SQL query?
You can use full-text search in boolean mode on several tables without
full-text index.
SELECT * FROM table1, table2 WHERE MATCH(table1.column1,
Christopher,
Wednesday, May 29, 2002, 5:18:25 PM, you wrote:
CLW> ok. my admin guy installed the linux rpm of mysql. however, i can't locate
CLW> the mysqladmin and mysql bins. do i have to install an additional rpm that
CLW> include those?
Yes, you should install MySQL-client package. You can f
Hi,,
I'm looking for a way to create a table with a ID columns (PRIMARY KEY)
generated automatically...
The only probleme is that i cannot use a AUTO_INCREMENT field because I have
thousand of lines added each day (and all lines older than a week are
deleted)With AUTO_INCREMENT, one day or a
Since I did the backup with a |, it appended. I had to go through the file
and remove the older instances of the backups and then it worked ok.
Thanks for the help! You all saved me.
Scott
-Original Message-
From: D.K.Dubey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 9:14
- Original Message -
From: "Anton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 29, 2002 3:51 PM
Subject: MySQL not connecting over 110
> Hallo
>
> I cant use phpMyAdmin, or any of my other (php) pages as I get the
> error cannot connect to MySQL via 110 (111)
Well,
You can use timeval struct and create a field in your Database as double,
and then use these two value tv_sec, and tv_usec to build you PK.
Hisseine
- Original Message -
From: "Jonathan Pelletier" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 29, 2002 10:45 AM
Subj
Hello all, I posted this question yesterday but received no feedback so
I decided to ask again.
I am new to MySQL and I am trying to access binary data stored in a
MySQL table using a C program. The table looks like this:
date date
double firstfield
double secondfield
double thirdfield
My
Hi list!
I have a problem when trying to read data into tables with LOAD DATA LOCAL
INFILE.
I get this error:
ERROR 2013: Lost connection to MySQL server during query
When looking at the MySQL site it says that I should increase the
max_allowed_packet=# option (default 1M). However, my file is
This query seems to be quite easy, but I still cannot figure
out how to do it.
I have a randomly ordered table. And I want to SELECT that table
by ORDERing it in specific row, and when I'm done I want to
find out numeric position of a raw where the first raw is 1, second is 2
etc.
Of course
--- Reçu de VITEUR.BUNTERMA 04 72 96 57 77 29/05/02 17.27
2nd attempt.
Date: Wed, 29 May 2002 17:17:25 +0200
Subject: Re: Dates in a table
Your message cannot be posted because it appears to be eith
[snip]
I have a randomly ordered table. And I want to SELECT that table
by ORDERing it in specific row, and when I'm done I want to
find out numeric position of a raw where the first raw is 1, second is 2
etc.
Of course I could iterate over each row. But I want to do it for a
specific raw only. A
Michael Flora wrote:
> Hello all, I posted this question yesterday but received no feedback
> so I decided to ask again.
>
> I am new to MySQL and I am trying to access binary data stored in a
> MySQL table using a C program. The table looks like this:
>
>
> date date
> double firstfield
> dou
> I'm looking for a way to create a table with a ID columns (PRIMARY KEY)
> generated automatically...
> The only probleme is that i cannot use a AUTO_INCREMENT field because I
have
> thousand of lines added each day (and all lines older than a week are
> deleted)With AUTO_INCREMENT, one
Hi,
mysql_fetch_row returns a MYSQL_ROW, that is an array of byte strings.
look at
http://www.mysql.com/doc/C/_/C_API_datatypes.html
Frederic
- Original Message -
From: "Michael Flora" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 29, 2002 5:32 PM
Subject: Problem wit
* BUNTER MATTHEW
> I'm putting together a table that has dates of reign for a monarch.
>
> What I eventually want to do is to be able to ask the question :
>
> Who reigned during 1585? And get an answer of : King Joe
>
> This info will be outputted in a php form on a web page.
>
> So if the da
I am trying to compile MySQL 3.23.49 on the following system:
Compaq Tru64 Version 5.1 1885 alpha
gnu gcc 3.1
make 3.79
I keep getting the error shown below. Any trouble shooting insight will be
greatly appreciated.
Thanks
Dean
mv -f .libs/mf_cache.lo mf_cache.o
(cd . && ln -s mf_cache.
Hi,
I am trying to learn about indexing and have a few questions.
1. Does index only apply to query that use = operator in the where clause?
2. Does operators such as >, like and between will result to full table
scan?
3. For example, In the following table:
tbl_A
id int primary key
Hi,
I am new to this list and new to mySQL and PHP so please excuse the
simplicty of my questions.
Is it possible to create your own shopping cart program with just mySQL and
PHP?
Right now I am building a database for my companies new web page. I am
looking to build an e-commerce site, but I pr
I have an application database that I'm unable to drop after a period of running
several applications against that are using the MySQL++ api.
Wondering if anyone has seen this, if it's a known bug and/or if there is a fix.
mysqladmin -uroot -p drop and rm -rf /var/lib/mysql/ do succesfully
re
[snip]
Is it possible to create your own shopping cart program with just mySQL and
PHP?
[/snip]
Yep.
[snip]
1) I am trying to build my own shopping cart. When building an orders
database, is it possible to make room for an infinite number of items in the
order?
[/snip]
Ideally you should have t
Hi all.
In the innodb directory I have these files (prototipo is the name of the
computer):
-rw-rw 1 mysql mysql 86 May 28 09:56 prototipo-bin.001
-rw-rw 1 mysql mysql 86 May 28 10:00 prototipo-bin.002
-rw-rw 1 mysql mysql 86 May 28 10:13 prototipo
* Andy Cheng
> I am trying to learn about indexing and have a few questions.
>
> 1. Does index only apply to query that use = operator in the where clause?
No.
> 2. Does operators such as >, like and between will result to full table
> scan?
No. LIKE "%whatever%" will not use the index, but LIK
Hello,
Can someone tell me what is the difference between MyODBC and iODBC?
My understanding is that in order for an application to be able to "talk" to
a database it needs a "protocol", and that protocol would be ODBC.
What I'm trying to do is have the Tango2000 application server
(www.witan
when MySQL 4.0.2 will be out? We'd like to play around with InnoDB's
autoextend feature on v.4.
Thanks,
--Walt Weaver
Bozeman, Montana
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http:/
I've been trying to solve this problem for a couple of days now.
I've only started with DB's a month ago so I am no expert in SQL.
So, I present this problem to you guys in hopes of getting a solution.
Thanks in advance,
Mike
=
Question:
=
Using the query below I get the result
Hello,
I created a blank table in MS Access 2000 for recieving data from mysql
and tried to compile importsql.txt in Access module but I still got the
error saying "user defined-type not defined". I copy pasted exportsql.txt
to the module and got the same error.
I have a coworker who told me sh
Hi,
This error make reference to a variable which is not correctly defined.I
suppose that you have in routine which make "import" a variable like :
Dim myvar as lon
insted
Dim myvar as long
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e
SELECT cols FROM tbl INTO OUTFILE '/someflie';
ollie wrote:
>
> Does anyone have a way to export data from a table into a tab delimited text
> file? Can't seem to see the option in mysqldump.
>
> For bonus points - how could I achieve this via PHP?(!)
>
> TIA,
>
> ollie
>
>
Hello,
I'm using InnoDB tables, is there a way to know which foreign key constraint
was violated? Oracle gives me the constraint name in the error message, so
that I can seek in the data dictionary. I'm porting an web application
developed for Oracle to MySQL, so I need a solution with the smalle
I was hoping for some help with this -- I'm not sure if I can use just
one SQL statement to pull this data out, I think I need to use two
separate statements. Can someone clarify for me?
My tables:
+-+ +---+
| people | | projects |
+-+
Hi All,
I am new to MySQL ( using on Solaris )
I wrote my first program to do the insertions in a table. If a row is already
there then the program crashes instead of just throwing an exception.
I have a catch (... ) handler also so I am sure that the Query.Execute
("Insert.." ) is not throw
I have the following table;
++--+++
| id | wtn | dueDate| ageAmt |
++--+++
| 1 | 210-212-3871 | 2001-12-01 | 0.51 |
| 2 | 210-212-3871 | 2001-12-01 | 0.49 |
| 3 | 210-212-3871 | 2001-12-01 | 0.50 |
| 4 |
Hello,
We currently have two MySQL server/clients running on a RH/Linux 6.2 box,
3.23.40(production) and 3.23.49(development) We would like to setup the .49 with
a TCP/IP host instead of a socket. The .49 is using the port 3307, the default
server hostname is justlightening.justlightening.net(216
Hi All,
I am new to MySQL ( using on Solaris )
I wrote my first program to do the insertions in a table. If a row is already
there then the program crashes instead of just throwing an exception.
I have a catch (... ) handler also so I am sure that the Query.Execute
("Insert.." ) is not thro
"hitesh_mittal"@itginc.com wrote:
>Hi All,
> I am new to MySQL ( using on Solaris )
> I wrote my first program to do the insertions in a table. If a row is already
>there then the program crashes instead of just throwing an exception.
>I have a catch (... ) handler also so I am sure that the Qu
sql> reset master;
Ric
- Original Message -
From: "Iago Sineiro" <[EMAIL PROTECTED]>
To: "MySql Mail List" <[EMAIL PROTECTED]>
Sent: Wednesday, May 29, 2002 6:14 PM
Subject: Can I remove innobd binarie files?
> Hi all.
>
> In the innodb directory I have these files (prototipo is the n
Hey there,
I know this might sound like a stupid question to a lot of you guys out
there but please keep in mind I come from an oracle background and am new to
this:
I am accessing MySql from PHP, I have two questions regarding Auto_Increment
1) how to create an auto_increment?
create table MyT
Hi
I am using
-mysql 3.23.59,
- Solaris 2.6
the program is in C++, using gnu C 2.95.3 .
The table does have primary key constraint and the program should throw an
exception when I try to insert and the the row aready exists, But instead It
crashes.
Any suggestions ??
Thanks
Hitesh
"Thi
Hi guys,
Does anyone have any thoughts on using MySQL for a datawarehousing application?
Problems I've run in to are with mining data from a data warehouse because of the lack
of sub-selects, stored procs, and views.
Should I be looking more at InnoDB or MyISAM table types?
any thoughts are a
Hi list, can someone here give me a quick and dirty example of how there
connecting to a database via sockets? I see the data in the man page
but I'm uncertain as to implementation. Thanks, justin
Sql,query
-
Before posting,
Hi
I am using mysql 3.2133b, Sun Solaris 2.6, JHTML and Apache. I have been
getting Time-out requesting db connectionUnable to connect to database
server where url was jdbc:z1MySQL://localhost:3306 error whenever the JHTML
is initialized for the first time. It works fine when i click on the ref
manual_Reference.html#CREATE_TABLE
>create_definition:
> col_name type [NOT NULL | NULL] [DEFAULT default_value] [AUTO_INCREMENT]
>[PRIMARY KEY] [reference_definition]
create table MyTestTable(cno int AUTO_INCREMENT, name varchar(20));
can't seem to find the ref right now, but
< i
I don't know if this is just weirdness on my system but I thought I would
pass this on in case anyone runs into this problem. I'm converting some
Java/JDBC code from a commercial DBMS to MySQL. The existing code executed
the SQL statement "Select @@identity" after an INSERT to retrieve the
autoi
Has anyone architected an oltp database using mysql where downtime is
virtually eliminated? I understand it's fairly simple to set up a readonly system
using mysql replication or another type of replication to maintain the
uptime, but I have yet to see how to do this with a heavy transaction
syst
"hitesh_mittal"@itginc.com wrote:
>Hi
>I am using
>-mysql 3.23.59,
>- Solaris 2.6
>the program is in C++, using gnu C 2.95.3 .
>The table does have primary key constraint and the program should throw an
>exception when I try to insert and the the row aready exists, But instead It
>crashes.
>Any s
Greetings guys,
Special greetings to all of you who helped me in the last question, one
last
one
in a timestamp field, do I have to provide the values?
eg
create table ryan(t_imestamp timestamp(8), name varchar(30));
how do I insert? do I have to specify the value? if so how do I g
> -Original Message-
> From: Richard Davidson [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 29, 2002 1:31 PM
> To: MySql List; [EMAIL PROTECTED]
> Subject: FYI: @@IDENTITY
>
>
>
> I don't know if this is just weirdness on my system but I
> thought I would
> pass this on in case a
I dont think the types of tables will really help you, because as I understand it
mySQL doesnt yet have stored procs, views, and sub-selects, regardless of table type...
I may be wrong though...
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
"Help Wanted. Seeking Telepat
It seems I cannot use an alias in WHERE clause, but I can use it in ORDER BY.
An examples:
this doesn't work
SELECT field1 AS ABC, field2 AS XXX, field3 AS QQQ FROM mytable WHERE ABC =
'abc' ORDER BY ABC
this works
SELECT field1 AS ABC, field2 AS XXX, field3 AS QQQ FROM mytable WHERE
field1 =
"hitesh_mittal"@itginc.com wrote:
>I am using MYSQL ++.
>Hitesh
>
>
>
Then, I would suggest posting your question over on the plusplus list
(see http://www.mysql.com/documentation/lists.html), as the developers
for MySQL++ hang out over there.
-Mark
---
The thing is I'm looking for a solution with guaranteed transaction success. I have
thought about building a layer that would guarantee transaction success. Say I had
two duplicate databases and if a transaction failed on one it would still succeed
on the other. Once the transaction failed it shou
Hi,
It's more comfortable(and sure) if you use C API of MySQL.Order of (few of
the main) functions to be executed is :
mysql_init-initialise MYSQL struct
mysql_options-set options for connection
mysql_real_connect-this function make all for you, from connection
On Wed, May 29, 2002 at 02:06:19PM +0300, Heikki Tuuri wrote:
> Jeremy,
>
> it looks like this crash can happen if you use MySQL 'user level locks'
> which are kind of semaphores. In that case MySQL will write a binlog entry
> even after THD::cleanup where the transaction handle is freed.
>
> >F
See:
http://www.mysql.com/doc/P/r/Problems_with_alias.html
Gurhan
-Original Message-
From: Massimo Colurcio [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 5:09 PM
To: mySQL List
Subject: Alias & WHERE
It seems I cannot use an alias in WHERE clause, but I can use it in ORDER
Hi,
I am evaluating InnoDB's Foreign Keys and am stuck.
Using the sample tables I want to add records in the Child table with a NULL
parent_id (this being referenced to the Parent table) as follows:
CREATE TABLE parent(id INT NOT NULL,
PRIMARY KEY (id)) TYPE=INNODB;
CREATE TABL
> CREATE TABLE parent(id INT NOT NULL,
> PRIMARY KEY (id)) TYPE=INNODB;
>
> CREATE TABLE child(id INT, parent_id INT,
> INDEX par_ind (parent_id),
> FOREIGN KEY (parent_id) REFERENCES parent(id)
> ON DELETE CASCADE) TYPE=INNODB;
OI!!! I'm goin
Hi all,
I apologise if this question has been asked recently; I have checked the
list archives and could not see anything. This is my problem:
I am trying to convert and import a fairly convoluted Filemaker Pro 5
database to MySQL. I have exported the filemaker records as tab delimited
files a
Hi
I am using mysql 3.2133b, Sun Solaris 2.6, JHTML and Apache. I have
been getting Time-out requesting db connectionUnable to connect to
database server where url was jdbc:z1MySQL://localhost:3306 error whenever
the JHTML is initialized for the first time. It works fine when i click on
the refr
Do you have any experience with Perl? Perhaps a quick script would convert your tab
delimited files to the proper format?
Bradley
Cameron Murdoch wrote:
> Hi all,
>
> I apologise if this question has been asked recently; I have checked the
> list archives and could not see anything. This is my
> OI!!! I'm going to sound like a complete ass now (I know) But since
> when does MySQL support FOREIGN keys?? *gasp* MAN this is going to
> make my life S much easier *curses at phpMyAdmin for not having the
> option*
Do remember that this is only valid for mysql 3.23.50+
>>If you start MySQL server from MS DOS prompt as:
>> C:\mysql\bin>mysqld-nt --standalone --debug
>>
>>mysqld shows you warning message.
hi! i tried this already.. but whenever i type
mysqld-nt -install to install mysql as a service.. an
error messge "Failed to install service" occurs..
usi
1 - 100 of 122 matches
Mail list logo
