Jimmy Guerrero wrote:
Hello,
Although not open-source, our partner Embarcadero Technologies offers one of
the best ER tools out there for design, diagraming, documentation and
reverse/forward engineering.
ERStudio www.embarcadero.com/products/erstudio/index.html
Thanks,
Jimmy Guerrero
Sr Prod
You could use the mysql CAST or CONVERT functions
Byron.Albert wrote:
Hey all,
This should be a relatively simple question but after looking through
the manual for a while I didn't see how to do it. I am working in php
and need to store a large binary number in the database. When I try and
co
Hey all,
This should be a relatively simple question but after looking through
the manual for a while I didn't see how to do it. I am working in php
and need to store a large binary number in the database. When I try and
convert it to a int in php its too big so it converts it to a float and
I lo
Dan,
>I want to get a particular users 'rank' or row number from the query.
SELECT 1+COUNT(*) AS Rank
FROM results r1
INNER JOIN results r2 ON r1.points
I have a regular query lets say:
SELECT user, points FROM results ORDER BY points DESC
so I get:
userpoints
---
john23
s
Solved it by:
SELECT table_a.name , if( table_a.id = table_b.table_a_id, 1, 0 ) AS
theindicator
FROM table_a
LEFT OUTER JOIN table_b ON ( table_a.id = table_b.table_a_id )
/Peter
Hi,
I have a table table_a and table_b:
table_a {
id
name
}
table_b {
table_a_id
b_value
}
Table
On 6/1/06, Patrik Wallstrom <[EMAIL PROTECTED]> wrote:
Easy setup: two mysql 5 servers, one running master, the other one is
slave. The database have triggers to create history of rows in history
tables.
What is expected from the slave? Is it expected to run the triggers,
as well as receiving th
Dan wrote:
I have a regular query lets say:
Better to show the real query, rather than a simplified version. Simplified
requests get you simplified answers. What seems like a simplification to you,
may in fact hide a crucial piece of information, thus preventing anyone from
giving you a so
> versions for the same release series of MySQL. If you change the character
> set when running MySQL, you must run myisamchk -r -q
> --set-collation=collation_name on all MyISAM tables. Otherwise, your
> indexes may not be ordered correctly, because changing the character set
> may also change t
Easy setup: two mysql 5 servers, one running master, the other one is
slave. The database have triggers to create history of rows in history
tables.
What is expected from the slave? Is it expected to run the triggers,
as well as receiving the new row in the history table? Or should it
really run t
On 6/1/06, Lukasz Budnik <[EMAIL PROTECTED]> wrote:
name column is:
`name` varchar(50) NOT NULL default 'NN'
and table is DEFAULT CHARSET='latin2' but as I wrote before
all those names have only latin1 characters
I am not able to reproduce it on 5.0.16 on WinXP.
mysql> DROP TABLE IF EXIS
Thank you for your help. I will try using chars instead of
varchars. That should be fairly
easy to try. I already do have a table for symbols, though the key
is varchar not integer.
I was using shares and value as varchar because there was some weird
rounding happening when I
used decima
Lew E. Lefton wrote:
> Hi,
>
> I hope this is an appropriate place to ask this question, if you think
> it is better suited for another list/forum, please let me know.
>
> I have a table that looks like this:
>
> mysql> select polynomial_id, term_id from polynomial;
> +---+-+
by 'value', you mean variable, right? is it a filepath?
On Jun 1, 2006, at 9:17 AM, Cory wrote:
Ed Curtis wrote:
I have a column in a table I need to replace a value of certain
records
in. The current value is /realtors/Value/. I need to change them to
/realtors/This_Value/. Is there an easy
Ed Curtis wrote:
I have a column in a table I need to replace a value of certain records
in. The current value is /realtors/Value/. I need to change them to
/realtors/This_Value/. Is there an easy way to do this. There are way too
many records to do it one record at a time.
Thanks,
Ed
UPDATE
are you using it with MySQL 5.*?
On Jun 1, 2006, at 8:42 AM, David Griffiths wrote:
Embarcadero, who in my humble opinion make the best database tools
around, have added MySQL to some of their tools.
Their tools (DBArtisan for database management, and ER Studio for
diagramming and chang
On Thursday 01 June 2006 03:05, Mathieu Bruneau wrote:
> Harish TM a écrit :
> > hi...
> > I need to store something like a couple of million rows is a MySql
> > table. Is that ok or do I have to split them up. I intend to index each
> > of the columns that I will need to access so as to spee
Embarcadero, who in my humble opinion make the best database tools around, have
added MySQL to some of their tools.
Their tools (DBArtisan for database management, and ER Studio for diagramming and change-management) are phenomenal in quality and
features. They are also very very expensive.
h
UPDATE Query
Tip No. 1: Manuals, Google etc
Tip No. 2: Posting a question like this may result in sarcastic
responses and possibly mass flaming
Ed Curtis wrote:
I have a column in a table I need to replace a value of certain records
in. The current value is /realtors/Value/. I need to ch
Hello,
Although not open-source, our partner Embarcadero Technologies offers one of
the best ER tools out there for design, diagraming, documentation and
reverse/forward engineering.
ERStudio www.embarcadero.com/products/erstudio/index.html
Thanks,
Jimmy Guerrero
Sr Product Manager
MySQL, Inc
You can do this:
update table set colum="/realtors/This_Value/" where
colum="/realtors/Value/";
But, it´ll replace all records at once.
"Ed Curtis" <[EMAIL PROTECTED]> escreveu na mensagem
news:[EMAIL PROTECTED]
>
> I have a column in a table I need to replace a value of certain records
> in
On Thursday 01 June 2006 17:02, Ed Curtis wrote:
> I have a column in a table I need to replace a value of certain records
> in. The current value is /realtors/Value/. I need to change them to
> /realtors/This_Value/. Is there an easy way to do this. There are way too
http://dev.mysql.com/doc/refm
I have a regular query lets say:
SELECT user, points FROM results ORDER BY points DESC
so I get:
userpoints
---
john23
steve 17
bill14
From this I want to get a particular users 'rank' or row number from
the query. I was hoping for a single line elegant query for t
On Thursday 01 June 2006 15:52, Miles Thompson wrote:
> Is there a tool, preferably open source, that can read database schema
> scripts (for lack of a better term) or connect to the database, and
> generate a diagram? This for a MySQL 5.x database.
I use dbVisualizer, but it isn't a free tool.
Hi,
Do you think there is any difference in the speed of select()
statements done on a big table depending on whether one of the columns
of this table is defined as char(17) or char(18)? That is, will the
select speed depend on the parity of the number of chars?
More generally, are char(2^n) widt
I have a column in a table I need to replace a value of certain records
in. The current value is /realtors/Value/. I need to change them to
/realtors/This_Value/. Is there an easy way to do this. There are way too
many records to do it one record at a time.
Thanks,
Ed
--
MySQL General Mailin
At 19:12 +1000 6/1/06, Mark Sargent wrote:
Hi All,
if a table has an auto_incremented primary key why does the below
code require the people_id to be manually inserted? I got this from
Beginning PHP, Apache, MySQL Web Development book from Wrox.
Curious, as it seems to defeat the purpose of a
Is there a tool, preferably open source, that can read database schema
scripts (for lack of a better term) or connect to the database, and
generate a diagram? This for a MySQL 5.x database.
I've been working with MySQL Workbench, and if I used it as a dumb device
it was OK. As soon as I sta
On 6/1/06, Neeraj <[EMAIL PROTECTED]> wrote:
Hi all..
Hi, try not to put 8 line breaks on each paragraph please ;-)
I have a scenario of many client databases and one central database..
Implemented or project?
Is there any way to get a unique ids across all databases (by any way) ,
be
Isn't UUID() unique for each system it runs on??
--
Chris
Quoting Dan Buettner <[EMAIL PROTECTED]>:
> Neeraj -
>
> One idea might be to use both a client ID field and a record ID field to
> uniquely identify records. This approach has benefits (easy to add
> clients, doesn't require as much
Neeraj -
One idea might be to use both a client ID field and a record ID field to
uniquely identify records. This approach has benefits (easy to add
clients, doesn't require as much client setup or planning) and a
potentially big drawback (no one unique record identifier).
Another would be
Hi all..
I have a scenario of many client databases and one central database..
Is there any way to get a unique ids across all databases (by any way) ,
because records from all the databases are finally get stored on a central
database. And the ids of transaction (a record) mus
Thanks for replaying
That is what I am not able to figure out what to use in FIELDS TERMINATED
BY, LINES TREMINATED BY
My fields are terminated by Ü and my lines are terminated by '¢ and that
I have clearly mentioned in my query
LOAD DATA LOCAL INFILE 'd:\\data3.txt' INTO TABLE dsc
Lukasz Budnik wrote:
Hi Remo,
just a thought... Can you try OPTIMIZE TABLE... or REPAIR TABLE ...
[EXTENDED] first
then try those queries again HTH
I've just run those statements, results:
optimize | status | OK
repair | status | OK
but like 'Szczec%' still returns 1 row
(now I know tha
Hi Remo,
> just a thought... Can you try OPTIMIZE TABLE... or REPAIR TABLE ...
> [EXTENDED] first
> then try those queries again HTH
I've just run those statements, results:
optimize | status | OK
repair | status | OK
but like 'Szczec%' still returns 1 row
(now I know that it should return
Hi Brendan,
On Thu, June 1, 2006 02:54, Brendan Bouffler wrote:
> I would try dumping it using 'mysqldump -c' and inspecting the insert
> statements ... seems awefully suspicious to me. I'm thinking you might
> have a line feed character (or some other invisible) in there somewhere...
>
I did jus
Lukasz Budnik wrote:
Hi All,
I'm using 5.0.21 on Gentoo.
I've got very strange problem.
I have clients table with id_c and name columns.
I'm running simple selects:
mysql> select id_c, name, concat('#',name, '@'), length(name) from clients
where name like 'Szczec%';
+---+--+-
Hi Mark
People_id is the column with auto increment? You can verify that it
really does have auto_increment by using the "describe" command. For
example:
mysql> describe checks;
+-+--+--+-+-
++
| Field | Type
Hi All,
if a table has an auto_incremented primary key why does the below code
require the people_id to be manually inserted? I got this from Beginning
PHP, Apache, MySQL Web Development book from Wrox. Curious, as it seems
to defeat the purpose of auto_increment, no? Cheers.
$people = "INSE
> Dear friends
Please do not send your messages as "urgent" to a mailinglist.
It might be urgent to you, but not to the hundreds of people
receiving your e-mail.
> Im having some problems with this queries on mysql 4.1.15
> "SELECT * FROM scg00_scga2800_dbf WHERE taxdvig >= '20050302' OR (taxdv
Hi,
I am using mysql-5.0.21 version. This issue was discussed in the bugs
list 4.x.x version and I believe the same has been closed(only for windows).
Problem:
1. Connection is established to the server
2. sever goes down.
3. The read at the client hangs.
The timeout has been implemented for wi
40 matches
Mail list logo
