Does anyone know where I mind find a table to look up alternate forms of
a certain given name? For example; if I give it Bob it gives me Robert
and if I give it Bill it gives me Will and William. Or if I give it
either Dick, Rick or Richard it gives me back the other two. Also, once
I have
[EMAIL PROTECTED] wrote:
I am a phpmyadmin user and have never really used mysql query browser before. I
have a database sitting on my localhost and I want to export the whole thing
via mysql query browser to the host. What is the easiest way to do it?
Ross
Use the MySQL admin tool, not
Shaun wrote:
I have stored the dimensions as decimal(4,2), does this make a difference?
not a very good way to do it if you ask me but here is how to do the
calculation.
SELECT ((FLOOR(X) + ((X - FLOOR(X))/0.12)) * (FLOOR(Y) + ((Y -
FLOOR(Y))/0.12))) as SqFt.
FLOOR(X) gives you 6
As many have pointed out, the arguments on both sides of the mailing
list ReplyTo behavior have serious flaws. There is a good reason for
that. Both arguments are week and use a lot of spin, in a futile
attempt to make their solution appear to be the ideal one. In reality,
both solutions are
Martin Gallagher wrote:
Hi,
I'm trying to find the most efficient way of linking members to one
another in a social networking application.
Currently I link them using 2 separate fields for the members: id1, id2. So,
to find people in your network you would do:
I'm not sure exactly what it
I want an On Duplicate Key do nothing feature which obviously doesn't
exist. However, will this be any faster than actually updating the row.
INSERT INTO table (a,b) VALUES (1,2)
ON DUPLICATE KEY UPDATE b=b;
BTW each row is made up of only 2 columns and those to columns make up
the key so
Is there a way with mysqldump to instead of dumping the contents of a
table dump the contents of a select so if you import that sql back in
you will get a new table that looks like the select?
--
Chris W
KE5GIX
Gift Giving Made Easy
Get the gifts you want
give the gifts they want
One stop
This is probably going to sound like an odd request, but is there a way
to return empty columns in Mysql. For example a roll call sheet I want
to do a select of names from my table and then add a column for each of
the next 12 weeks. I tried this.
SELECT `Call`, concat(FName, ' ',
Andrew Burrows wrote:
Hi MYSQL users,
Just started playing with mysql apache php and other tricky stuff and have a
few question to get me going after many years.
Was wondering what the best GUI based administration tool is used today, I
lasted used phpMyAdmin, is this still used or are there
I have two independently built tables of people. I am trying to match
people from one with people from the other. The problem is that in one
table they may have used Ron and in the other Ronald. What I want
to do is have a match if on something like if 'Ronald is like 'Ron%'
but obviously
I just tried to use the output of the export function on phpmyadmin and
got a million errors. After looking at the file I found that certain
columns that are strings were not quoted at all. I can't find any
reason why some are and some are not quoted. Anyone have any idea why
this is
John Taylor-Johnston wrote:
Which version? Which export type? Strings TEXT, VARCHAR would be
quoted. INT would not, I think.
Their forum might be a better place. www.phpmyadmin.net.
I am using phpMyAdmin 2.6.1-rc. I have no control over that as I am not
the admin on the server. All the
[EMAIL PROTECTED] wrote:
Claire Lee [EMAIL PROTECTED] wrote on 09/27/2005 03:48:11 PM:
I need to order a few names by the number following
the main name. For example swap2, swap3, swap10 in the
order of swap2, swap3, swap10, not in swap10, swap2,
swap3 as it will happen when I do an order
Brian Dunning wrote:
I got a 12-hour invoice from a consultant who was tasked to do the
following:
- Install a Red Hat machine from absolute scratch for PHP/MySQL/Apache
- Copy over some MySQL databases
- Have mod_rewrite working via htaccess, and have wildcard DNS
I'm a programmer, not a
Wigs @Claw wrote:
Hi guys , sorry for responding if this message is a bit off topic!
Id have to say that you are assuming no glitches come into play with
that response.
I just recently had to do a Red Hat install , with Apache , MySQL and
the works. The install of Redhat ran into some
Andrew stolarz wrote:
Hello Everyone,
Hopefully easy question,
What is the Max size of a MySQL server database?
The answer to that question depends more on your OS than mysql. A quick
search of the contents page of the documentation clearly list the
limitations of this kind.
--
Chris W
Pat Adams wrote:
However, in answer to your question, there is no way to get TRUE
randomness in a computer system. Even cryptographically secure random
number generators can be predicted under absolutely identical
circumstances.
While technically that is true, there is a method that will
Eric Bergen wrote:
This does make his code fall under the limitations of unix timestamps.
In 30 years or so when we are all retired millionaires ;) some poor
intern is going to have to figure out why the hour diff calculation is
failing.
Long before then we will all be using 64 bit
Can someone tell me why this query works...
SELECT UserKey
FROM(
SELECT UserKey, Count(GiftKey) Gifts
FROM Gift
Group BY UserKey
) GC
WHERE GC.Gifts = 3
And this one doesn't?
SELECT UserKey, UserID,
FROM User
WHERE UserKey IN
(SELECT UserKey
FROM(
SELECT UserKey, Count(GiftKey) Gifts
to do it in one just to
reduce the code some what. I have other uses for similar queries but
this is the main reason.
Chris W
2wsxdr5 [EMAIL PROTECTED] wrote on 01/13/2005 01:57:31 PM:
I have these 2 queries.
SELECT count(*) gifts
FROM gift g
WHERE g.this and g.that
SELECT count
Steve Grosz wrote:
I had tried to load a group of records from a Excel spreadsheet, and
for the most part it seems to have worked.
The problem is that I know there were more than 1000 rows of data to
be input, and it stopped at 1000 exactly.
I'm not 100% sure but this is what I think happened.
I have these 2 queries.
SELECT count(*) gifts
FROM gift g
WHERE g.this and g.that
SELECT count(*) events
FROM events e
WHERE e.this and e.the other thing
is there a way to put these into one query.
SELECT count(g.*) gifts, count(e.*)
FROM gift g, event e
WHERE . . . .
so far nothing seems
22 matches
Mail list logo