On Sun, 12 Mar 2006, Michael Stassen wrote:
> To: [EMAIL PROTECTED]
> From: Michael Stassen <[EMAIL PROTECTED]>
> Subject: Re: Checking for good update
>
> [EMAIL PROTECTED] wrote:
> > looks a bit strange to me.
> >
> > > $result = mysql_query($query) or die('Query couldn\'t
> > > executed:'.my
Hi Rithish,
Thank you all for your suggestion, I would definitely give it a shot.
Regards,
Ryan.
On 3/13/06, Rithish Saralaya <[EMAIL PROTECTED]> wrote:
>
> Hello Ryan. I am more of a developer than a MySQL administrator. Hence, I
> would always favour applications logging query errors rather th
[EMAIL PROTECTED] wrote:
On Sun, 12 Mar 2006, Michael Stassen wrote:
[EMAIL PROTECTED] wrote:
looks a bit strange to me.
$result = mysql_query($query) or die('Query couldn\'t
executed:'.mysql_error());
please try something like this:
Why? There's nothing wrong with the above statement.
2006/3/11, Truong Tan Son <[EMAIL PROTECTED]>:
> Dear Sir,
>
> On RedHat Enterprise 4, and MySQL 5.0.18, I did :
>
> mysql> set autocommit=0;
>
> mysql> savepoint abc;
>
> mysql> insert something
>
> mysql> rollback to save point abc;
>
> Query OK, 0 rows affected, 1 warning (0.00 sec)
> ^
Rob,
- Original Message -
From: ""Rob Brooks"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Sunday, March 12, 2006 6:02 PM
Subject: InnoDB Commit question
--=_NextPart_000_0033_01C645BC.03223720
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encodi
Thankyou for that explanation Michael.
I shall look into using that construct in my own code now!
Apologies to fbsd_user for my previous comments on his
coding style.
Regards
Keith Roberts
In theory, theory and practice are the same;
In practice they are not.
On Mon, 13 Mar 2006, Michael S
Hallo,
I'm using MySQL MigrationsToolkit 1.0.23rc and while transfering big
Table (MySQL 4.0.x to MySQL 5.x, > 4.000.000 entries) I get this message:
The SQL create statements could not be created (error: 0).
MigrationMysql.dataBulkTransfer :Java heap space
Details:
What can I do?
Best Rega
At 12:31 13.03.2006, Rafal Kedziorski wrote:
Hallo,
I'm using MySQL MigrationsToolkit 1.0.23rc and while transfering big
Table (MySQL 4.0.x to MySQL 5.x, > 4.000.000 entries) I get this message:
The SQL create statements could not be created (error: 0).
MigrationMysql.dataBulkTransfer :Java h
Rafal Kedziorski wrote:
The SQL create statements could not be created (error: 0).
MigrationMysql.dataBulkTransfer :Java heap space
What can I do?
That is Java memory related problem. Check out where it invoke the Java
VM if possible and add memory parametars like -Xms256m -Xmx900m (it
assume
I try to update multiple rows in a federated table with one query, where field
a=x and field b=x..
There are 4 rows that match these criteria (selecting returns 4 rows) but
trying to update using the following query updates only one record.
calling the same query 4 times, updates only one record
Hi, all
I have a table which has a column with "time". It's format is like
"-00-00 00:00:00" (default value). I want to get the minimum and
maximum values for this cloumn. Obviously, "-00-00 00:00:00" isn't the
minimum value I want.
What I did for the "minimum" time, suppose the column na
Hope this helps:
select min(ctime), max(ctime) from tbl_a where ctime != "-00-00
00:00:00"
Best regards,
Diego
- Original Message -
From: "Xiaobo Chen" <[EMAIL PROTECTED]>
To:
Sent: Monday, March 13, 2006 11:17 AM
Subject: simple query
Hi, all
I have a table which has a co
Dear All,
I had some issues in past with timestamp fields as a result I am unable to
upgrade to mysql 4.1 version. I am sure below the query recommended by Josh
works with 4.1 or above. Would it be possible to rewrite this query for 3.23
version?
Again, thank you Josh and all others for
I am building mysql5 latest from source on Solaris.
The location of the options file is very confusing and does not work
according to the online documentation. For example, I have --basedir
of /opt/csw/mysql5 and --datadir of /opt/csw/mysql5/var. If I put
my.cnf in datadir or in basedir, the fil
"Robert DiFalco" <[EMAIL PROTECTED]> wrote on 03/11/2006 12:43:43 PM:
> In a previous database engine I was using an IN was more optimal than a
> <>. So, for example:
>
> SELECT * FROM table WHERE table.type IN (1,2,3);
>
> Where the possible values of type are 0-3, was appreciably faster th
Yesmin Patwary wrote:
Dear All,
I had some issues in past with timestamp fields as a result I am unable to upgrade to mysql 4.1 version. I am sure below the query recommended by Josh works with 4.1 or above. Would it be possible to rewrite this query for 3.23 version?
Again, thank yo
Thank you Michael. I learned a lot from your detailed explanation
of how the update and select functions work in relation to
checking for good execution.
I used
if (mysql_affected_rows() == 1)
and got the results I was after.
I am stilling having problem with users browser
caching the screen, bu
You could rotate the output... basically get 1 row
with 11 columns (CA01_count,CA02_count,...,CA12_count)
(leaving out CA10) joining all 12 tables together...
Or... perhaps we can help with the timestamp issues
you are having and get you upgraded to later version
of mysql that supports nested SEL
All,
We are using circular replication now on db's that were originally stand
alone. One problem we have is that all the primary index fields for
most of the tables are auto increment fields. This prevents us from
writing to both db servers because of confilicting INDEX entries. Is
there some w
Hi,
I am searching for a query where i can have pattern matching without
considering the cases.You can consider the following example for detailed
description of what i want exactly.
Let my table X consists of following data
Name
---
venu
venup
venugopla
VenugOpal
VENU
pap
hi,
after migration from MySQL 4.0.26 to MySQL 5.0.18 I'm missing
auto_increment on MySQL 5 side in appropriates tables.
Best Regards,
Rafal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> -Original Message-
> From: VenuGopal Papasani [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 13, 2006 10:33
> To: mysql@lists.mysql.com
> Subject: Help regarding a simple query
>
>
> Hi,
> I am searching for a query where i can have pattern
> matching without considering the cases.
Shawn,
Any performance gains for specifying "type > 0" than "type <> 0" ?
R.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, March 13, 2006 6:37 AM
To: Robert DiFalco
Cc: mysql@lists.mysql.com
Subject: Re: Query Optimization Question
"Robe
Yes, a ranged query should respond faster than a negation. In some cases
you can seriously improve query performance for a negation query if you
split it into two range queries unioned together. Here is a pseudo
example:
This query should be slow due to the table scan it takes to test the
cond
Interesting, that seems like an optimization the query optimizer could
do itself when it sees a <> operator on a indexed numeric.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, March 13, 2006 8:01 AM
To: Robert DiFalco
Cc: mysql@lists.mysql.com
S
Now i need to get all the records which consists of the string
venu(case should not be considered either case should be).i.e i should get
1,2,3,4,5,8 records
A simple way is ...
...
WHERE LOCATE('venu', col_name ) > 0
...
or if the column is [VAR]BINARY, LOCATE('venu',CAST(col_name
Please refer to these two links, they would give you a clear explaination.
there is also an example in the second link which you can easily test .
http://dev.mysql.com/doc/refman/5.0/en/replication-auto-increment.html
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html ( scroll
Now I know what I am going to talk about is not directly related to
this mysql list, but I am in need of some concept ideas.
To set the background. Its a very common practice in the
registration process of a new user to verify the users email address
is valid by sending a email to the entered ema
Hi,
I am searching for a query where i can have pattern
matching without considering the cases.You can consider the
following example for detailed description of what i want exactly.
Let my table X consists of following data
Name
---
venu
venup
venugopla
VenugOpa
Hello ,
Is there a mysql or any other tool that generates a E/R diagram using an
existing mysql database.
Thank You
Vinay
Dear All,
First of all, I would like to thank to Josh and Peter Brawley for their kind
help on previous issue.
Here is another Issue:
There are many tables that have timestamp field with 8 char (mmdd). I use
this format all over our website and to create various reports. Below
Dear All,
First of all, I would like to thank to Josh and Peter Brawley for their kind
help on previous issue.
Here is another Issue:
There are many tables that have timestamp field with 8 char (mmdd). I use
this format all over our website and to create various reports. Below
Hello ,
Is there a mysql or any other tool that generates a E/R diagram using an
existing mysql database.
Thank You
Vinay
Hi Alex. It seems that mysqld and all the client
programs insist on reading /etc/my.cnf first.
To overide this behaviour for a particular instance of
mysqld you need to pass the --defaults-file option as the
FIRST parameter to mysqld_safe or mysqld if you are not using mysqld_safe.
--defaults
>-Original Message-
>From: VenuGopal Papasani [mailto:[EMAIL PROTECTED]
>Sent: Monday, March 13, 2006 11:48
>To: Jeff
>Subject: Re: Help regarding a simple query
>
>
>Hi Jeff,
> This is venu again.Last mail i did not include a constraint that is
what irritating me most.Actually if i got
fbsd_user wrote:
Now I know what I am going to talk about is not directly related to
this mysql list, but I am in need of some concept ideas.
To set the background. It’s a very common practice in the
registration process of a new user to verify the users email address
is valid by sending a emai
I can connect to mysql with
mysql -u dbname -p
When I start MySQL Administrator v 1.1.6 it says
Could not connect to host 'localhost'.
MySQL Error Nr. 2002
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
...then I Click on Details and enter, '/var/lib/mysql/mysql.so
http://www.thekompany.com/products/dataarchitect/
There are free evaluation copies to download, and it's not
that dear to buy a copy, very good value actually.
I'm not sure if there is a free Linux version that
theKompany have released as well.
Keith
In theory, theory and practice are the sa
"Jim Douglas" <[EMAIL PROTECTED]> wrote on 03/13/2006 12:24:56 PM:
> I can connect to mysql with
>
> mysql -u dbname -p
>
> When I start MySQL Administrator v 1.1.6 it says
>
> Could not connect to host 'localhost'.
> MySQL Error Nr. 2002
> Can't connect to local MySQL server through socket '/
I am scripting out the creation of a database so I can make changes and then
run the script to generate a clean copy (by running it in MySQL Query
Browser).
The script DROPs all the tables, then CREATEs them again along with all the
indices and whatnot. However, if I run the script after having r
Sure is...
SELECT DATE_FORMAT(dateField,'%Y%m%d') as dateField
Take a look at:
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
-Josh
--- Yesmin Patwary <[EMAIL PROTECTED]> wrote:
> Dear All,
>
> First of all, I would like to thank to Josh and
> Peter Brawley for their
Alternatively, you might be able to re-render times and dates in their
"condensed" format by auto-converting them to a numeric value. Try adding
zero to your date columns in your select clauses. Once condensed, your
substring code should begin working as before.
SELECT datecol +0 as datecol
FR
In my mysql 4.4 table definition the default attributes are (ON
UPDATE CURRENT_TIMESTAMP). Reading the manual my understanding is
this is saying that the auto timestamp update feature is active. The
manual does not say what the trigger is to make the timestamp in the
row to be bumped to the current
"fbsd_user" <[EMAIL PROTECTED]> wrote on 03/13/2006 01:10:17 PM:
> In my mysql 4.4 table definition the default attributes are (ON
> UPDATE CURRENT_TIMESTAMP). Reading the manual my understanding is
> this is saying that the auto timestamp update feature is active. The
> manual does not say what t
Excellent DB design tool Peter. Thanks for posting the
information.
http://www.fabforce.net/dbdesigner4/
I have bookmarked that, and will be checking that out soon!
Regards
Keith
In theory, theory and practice are the same;
In practice they are not.
On Mon, 13 Mar 2006, Peter M. Groen wrot
On Monday 13 March 2006 17:37, Vinay wrote:
> Hello ,
> Is there a mysql or any other tool that generates a E/R diagram using
> an existing mysql database.
>
>
> Thank You
> Vinay
Try fabforce for DbDesigner4MySQL. Very good tool.
--
Peter M. Groen
Open Systems Development
Klipperwerf 12
23
Hi
I am using visual studio C++ 6, with SDK, my mysql database is 4.1.18, i
downloaded mysql++ 1.7.1 as this is the compatiable version for vc++6.
the example program compiles and runs. when i go to make my own project i use
the wizard and create a basic dialog MFC app. at the top of the main
> the example program compiles and runs. when i go to make my own
> project i use the wizard and create a basic dialog MFC app. at
> the top of the main cpp file i add #include and then in
> the program call Connection con("login","localhost","root","abc");
>
> in the mysql++ download there is man
[EMAIL PROTECTED] wrote:
Excellent DB design tool Peter. Thanks for posting the
information.
http://www.fabforce.net/dbdesigner4/
It has become MySQL Workbench
(http://forums.mysql.com/read.php?10,73820,73820#msg-73820), but it
isn't production-ready yet.
PB
--
No virus found in this o
thanks for the reply Jason, i have now added mysql++.lib to the linker and also
copyied the libmysql.dll to the system folder. the program complies now with a
few performance warnings but no errors.
there is one link error
LINK : warning LNK4098: defaultlib "LIBC" conflicts with use of other lib
Keith Lee wrote:
there is one link error
LINK : warning LNK4098: defaultlib "LIBC" conflicts with use of other libs; use
/NODEFAULTLIB:library
In the settings if i do as it says above, i get over 200 errors!! so i revert
back.
Visual C++ is very picky about the way programs are built when li
Thanks for your comments!
I ran my entire script (DROP DATABASE and all) with the command-line client,
and got no errors. Perhaps there is something with the Query Browser that
is causing this problem.
I added the IF EXISTS and IF NOT EXISTS in appropriate places (although I
can see the database
On Mon, 13 Mar 2006 16:52:03 + (GMT)
[EMAIL PROTECTED] wrote:
>
> Hi Alex. It seems that mysqld and all the client
> programs insist on reading /etc/my.cnf first.
>
> To overide this behaviour for a particular instance of
> mysqld you need to pass the --defaults-file option as the
> FIRST
Trying to bump the count_of_logons by 1 using this update.
Phpmyadmin shows the count staying at zero.
I think that this SET count_of_logons = 'count_of_logons + 1'
is not coded correctly, but I get no errors so can not tell.
Anybody have any ideas?
The table def has count_of_logons INT,
Hi Derek,
You never gave us a "SHOW CREATE TABLE simple1", which would have
helped. To replicate your problem, I did the following, on a linux
box (it looks like you're using Windows), using mysql
5.0.18-standard-log:
CREATE DATABASE cars;
use cars;
CREATE TABLE `simple1` (
`one` char(10) de
OK TY Peter.
I have downloaded both DBDesigner and MySQL Workbench.
Looking forward to workbench reaching GA status.
Regards
Keith
In theory, theory and practice are the same;
In practice they are not.
On Mon, 13 Mar 2006, Peter Brawley wrote:
> To: [EMAIL PROTECTED]
> From: Peter Brawley
Which binary did you use, and where did you download it from?
what is the result of "uname -a" ? are they both 64 bit machines?
32-bit machines? where is libstdc++ on both machines? It's possible
one machine has a library linked to another location, or they have
them in different locations. Sp
fbsd_user wrote:
Trying to bump the count_of_logons by 1 using this update.
Phpmyadmin shows the count staying at zero.
I think that this SET count_of_logons = 'count_of_logons + 1'
is not coded correctly, but I get no errors so can not tell.
Anybody have any ideas?
The table def has coun
What does SHOW CREATE TABLE give you?
-Sheeri
On 3/11/06, Holger Sunke <[EMAIL PROTECTED]> wrote:
> Hallo,
>
> is there a way of maintaining Memory tables or rebuilding indexes?
>
> I have a "big" memory table with about 300k rows, 12 Attributes, 7
> BTREE-Indexes and a PRIMARY KEY (Hash index).
In your global /etc/my.cnf fle, you should be able to split
that into sections for each client program that you want to
set specific options for.
Eg.
# /etc/my.cnf
# MySQL client program configuration file
# last updated 2006-03-05
# mysqld server configuration file lives in
# /usr/local/m
Replicate your databases to another server, and take your dumps from
that, so you can lock your replication slave and take your dumps while
your site is still running. As an added bonus, you get a server
suitable for manual failover should anything happen to your master
database.
-Sheeri
On 3/10
On Mon, 13 Mar 2006 23:05:30 + (GMT)
[EMAIL PROTECTED] wrote:
> Exactly what are the problems you are having with the server
> specific my.cnf file?
Sorry, I thought that I had described the problem. A quick example was
'my_print_defaults mysqld' returning only the options defined in the
gl
Dear Sir,
I could not find table of innoDB in mysql.
mysql> show tables;
+--+
| Tables_in_mysql |
+---+
| columns_priv |
| db |
| func |
| host |
| tables_priv |
| user
I guess you are saying that trying to have my php script send
the users browser html headers to stop caching is not
really going to solve my problem. I did put a block rule in
my firewall for the attackers ip address and that stopped
the attach from recurring.
But to make sure it don't happen agai
Robert DiFalco wrote:
> In a previous database engine I was using an IN was more optimal than a
> <>. So, for example:
>
> SELECT * FROM table WHERE table.type IN (1,2,3);
>
> Where the possible values of type are 0-3, was appreciably faster than:
>
> SELECT * FROM table WHERE table.type <
I get the same results as you do using this:
karsites:/usr/local/mysql-5.0.18/bin # ./my_print_defaults mysqld
karsites:/usr/local/mysql-5.0.18/bin # ./my_print_defaults client
--socket=/var/lib/mysql/mysql.sock
--port=
karsites:/usr/local/mysql-5.0.18/bin #
It seems like the last parameter
2006/3/14, Truong Tan Son <[EMAIL PROTECTED]>:
> Dear Sir,
>
> I could not find table of innoDB in mysql.
>
Tables in the mysql are MyISAM and should stay that way.
Odds are that there is a skip-innodb in your my.cnf on your RHE, and not you XP.
what produces a "show status" ?
> mysql> show tabl
67 matches
Mail list logo
