Below is the ER diagram in an exercise I am trying to do.
It's been going well so far, and several ColdFusion pages written already.
Need to do one for a Purchase Order Report for ...
- given SupplierCode
- given StartDate and EndDate of Orders
My problem is in the CFquery - unders
MySQL converts MYSQL_TYPE_LONG to float before storing
http://dev.mysql.com/doc/refman/5.1/en/c-api-prepared-statement-datatypes.html
you may want to consider FIXED size datatypes for that requirement e.g.
unsigned long *length
HTH
Martin
__
Verzich
Mike,
It's not a connection pooling issue per say. We have several boxes running
spam assassin, sqlgrey and postfix (via mysql). Normally these components work
great. SA and sqlgrey both have a fixed number of connections, around 16, that
they are generally actively using unless we get a bu
At 10:39 AM 4/7/2009, Gary Smith wrote:
I have system that is generating a larger than normal number of connection
errors. We know why the errors are occuring and are working to resolve
them (connectivity and load issue on the client). The question is, how
can I tweak mysql to tolerate a high
Thank you everyone for your solutions.
I have found one, which may be of use to you.
It relies on the ability to rename a table from one database to another:
mysql> rename table old_db.tabname to new_db.tabname
You would first need to drop all triggers, then recreate them.
So, I placed these co
Alright guys,
I just solved the problem. I read from somewhere that if you're using a foreign
key, it should be the either the primary key in the table or the index so since
I already used auto increment on table2_id and I've already made it my Primary
key, I just made table1_id the index and
I have system that is generating a larger than normal number of connection
errors. We know why the errors are occuring and are working to resolve them
(connectivity and load issue on the client). The question is, how can I tweak
mysql to tolerate a higher level than normal of bad connections b
On Tue, Apr 7, 2009 at 11:17 AM, Martijn Tonies wrote:
> Alex,
>
> Please respond to the list instead of my personal address.
sorry I thought i was.
>
>
>
> Nevertheless, if MYSQL_TYPE_LONG is the datatype for a table field,
> it would always -have- to be the same size, cause different clients c
Alex,
Please respond to the list instead of my personal address.
Nevertheless, if MYSQL_TYPE_LONG is the datatype for a table field,
it would always -have- to be the same size, cause different clients can
connect (if not being embedded), wouldn't it?
With regards,
Martijn Tonies
Upscene Produc
What is the size of MYSQL_TYPE_LONG in a 64bit machine? I am trying to
save
pointers. If this type is 4 bytes on a 32bit machine and 8 bytes on a
64bit
machine will make it much easier.
Ehm, wouldn't that like, totally fail if -saved- by a 64bit machine
and -read- by
a 32bit machine if tha
In the last episode (Apr 07), Alex Katebi said:
>If I have a mysql client application that passes a bad MYSQL*
> connection pointer to the server. How does the server cope with that.
> Does the server crash? Or does the server drops the client connection?
> Or does the server ignore the fun
Hi,
If I have a mysql client application that passes a bad MYSQL* connection
pointer to the server. How does the server cope with that.
Does the server crash? Or does the server drops the client connection? Or
does the server ignore the function call and return error?
If it returns error what i
I've done that but it still gives the same error message.
Date: Tue, 7 Apr 2009 16:25:15 +0200
Subject: Re: PHP-MYSQL Question
From: spa...@googlemail.com
To: defati...@hotmail.com
CC: mysql@lists.mysql.com
it is not the ENGINE as Eugene mentioned above, is that you need to use
UNSIGNED
Hi,
What is the size of MYSQL_TYPE_LONG in a 64bit machine? I am trying to save
pointers. If this type is 4 bytes on a 32bit machine and 8 bytes on a 64bit
machine will make it much easier.
Thanks,
-Alex
it is not the ENGINE as Eugene mentioned above, is that you need to use
UNSIGNED when creating the second table
CREATE TABLE table2 ( table2_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
table1_id INT UNSIGNED NOT NULL,
name VARCHAR(100) NOT NULL,
school VARCHAR(100) NOT NULL,
comment TEXT NOT NULL,
Hi
How can I specify 'unprintable' characters is a MySQL regexp ?
Query is (example only):
SELECT something FROM table WHERE column REGEXP 'Ã\\xA0';
I'm looking for an equivalent of the search part of a sed expression like
this:
s/Ã\xA0/à/g
which means I want to include a character with co
I've tried it and i still got the same error. I even dropped table1 and
recreated it to include the ENGINE=InnoDB and it was successful but table2
remains unsuccessful.
> Date: Tue, 7 Apr 2009 17:56:49 +0400
> From: evge...@kosov.su
> To: defati...@hotmail.com
> CC: mysql@lists.mysql.com
> Su
Hi guys,
Please can anyone tell me what I'm doing wrong with the code below? It keep
returning unsuccessful.
$result=mysql_query("CREATE TABLE table2(table2_id INT NOT NULL PRIMARY KEY
AUTO_INCREMENT,
table1_id INT NOT NULL,
name VARCHAR(100) NOT NULL,
school VARCHAR(100) NOT NULL,
comment T
I suppose the problem is that table1.table1_id and table2.table1_id are
of different types. The first one is INT UNSIGNED and the second is just
INT.
abdulazeez alugo wrote:
Table1 is as below:
CREATE TABLE table1(table1_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY(tabl
Table1 is as below:
CREATE TABLE table1(table1_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY(table1_id),
entrytitle VARCHAR(100) NOT NULL,
entrytext TEXT NOT NULL,
entrydate TIMESTAMP NOT NULL)" );
I did not put the engine. Could that
# perror 150
MySQL error code 150: Foreign key constraint is incorrectly formed
What does table1 look like?
abdulazeez alugo wrote:
Yeah I used the mysql_error and it returned Can't create table
'.\website\table2.frm' (errno: 150). So what does that say?
Date: Tue, 7 Apr 2009 17:38:
Yeah I used the mysql_error and it returned Can't create table
'.\website\table2.frm' (errno: 150). So what does that say?
> Date: Tue, 7 Apr 2009 17:38:59 +0400
> From: evge...@kosov.su
> To: defati...@hotmail.com
> CC: mysql@lists.mysql.com
> Subject: Re: PHP-MYSQL Question
>
> Perhap
Perhaps you don't have permissions to create tables?
It would have been much clearer if your script was like this:
$result=mysql_query($your_create_table_statement);
if($result){ print"Successful";}
else {print "Unsuccessful: ".mysql_error()}
abdulazeez alugo wrote:
Hi guys,
Please can anyo
Hi,
I'm trying to migrate an application from 4.1 to 5.1, theres a bunch of
queries that seem to be failing and it looks like the order of INNER
JOIN's... for example...
SELECTetc
INNER JOIN tablex AS x ON y.foo = a.bar
INNER JOIN tablea AS a ON y.foo = b.bar
... works in 4.1, but in
> Date: Mon, 6 Apr 2009 10:07:01 -0500
> From: peter.braw...@earthlink.net
> To: defati...@hotmail.com
> CC: mysql@lists.mysql.com
> Subject: Re: One to many relationship
>
> Abdul,
>
> Is this what you mean?
>
> CREATE TABLE Table1 (
> table1_id INT UNSIGNED PRIMARY KEY AUTO INCREMENT,
> en
Hi shuly,
1 Use innodb_file_per_table.
2 Create new database.
3 Take the dump of old database.
4 Restore in new database.
5 Drop old database.
On Mon, Apr 6, 2009 at 9:50 PM, Shuly Avraham wrote:
> Hi,
>
> I need to rename a database having InnoDB tables.
> MySQL version is: 5.0.24-standard - s
hi,
I have a solution. Please my blog's http://www.fire9.cn/?p=132.
good luck.
-
Ding Hao/Fire9 DB Architect
Email&msn>alk: fire9di...@gmail.com
My Blog:http://www.fire9.cn
My Twitter: http://twitter.com/fire9
在 2009-4-7，上午12:20， Shu
27 matches
Mail list logo
