Well, if you want to get unstuck in time, maybe you need to call Billy
Pilgrim ;-)
Andy Wallace wrote:
We've been having some issues with one of our MySQL servers lately,
and currently
the dang thing is stuck. For at least the last hour, NOW() is
returning the same
value:
mysql select now();
On 2/5/2010 5:15 AM, Suresh Kuna wrote:
In the mysql prompt, execute the below
use mysql ; select user from user ;
will show all the accounts in a MySQL database.
Alternatively, you can use myphpadmin. I guess it all depends upon what
you need the information for and to what purpose.
On 1/28/2010 3:21 AM, changuno wrote:
Hi folks,
Read a blog which states 50 things to know before migrating from Oracle to
MySQL. Any comments on this?
would it have been too much to just link to it?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
On 1/28/2010 4:52 PM, Brian Dunning wrote:
Hey all -
I need a few million sample contact records - name, company, address, email,
web, phone, fax. ZIP codes and area codes and street addresses should be
correct and properly formatted, but preferably not real people or companies or
email
If I may recommend:
http://www.generatedata.com/#download
On 1/28/2010 8:11 PM, Carlos Proal wrote:
Google for data generator, there are free and commercial solutions
available.
Carlos
On 1/28/2010 5:52 PM, Brian Dunning wrote:
Hey all -
I need a few million sample contact records - name,
On 1/19/2010 7:49 AM, Mark Goodge wrote:
On 19/01/2010 14:44, Tompkins Neil wrote:
Hi All,
Following on from my earlier email - I've the following question now :
I can enforce that the user can't use the same password as the
previous four
- when they change their password. However, the user
On 1/18/2010 5:52 PM, Colin Streicher wrote:
On January 18, 2010 01:34:15 pm Tompkins Neil wrote:
Hi
I'm in the process of designing a login system to a secure web page using
MySQL. One of the features is we need to record and ensure that the user
password is different from any of the last
I want to get a list of all users who haven't posted in a week. But when I
use the following function.
select user_id, max(tweet_createdat) from tweets where
datediff(now(),max(tweet_createdat)) 7;
Is producing the error:
Invalid use of group function
[mailto:mdyk...@gmail.com]
Sent: Sunday, November 08, 2009 8:35 AM
To: John Meyer
Cc: mysql@lists.mysql.com
Subject: Re: Finding users who haven't posted in a week
the function max(), among others, makes no sense in the absence of a
GROUP BY clause.
try adding GROUP BY user_id
- michael dykman
having
datediff(now(),max(tweet_createdat)) 7;
-Original Message-
From: John Meyer [mailto:johnme...@pueblocomputing.com]
Sent: Sunday, November 08, 2009 9:45 AM
To: 'Michael Dykman'
Cc: mysql@lists.mysql.com
Subject: RE: Finding users who haven't posted in a week
Thanks, morning coffee
Mark Phillips wrote:
I am new at database design, and my question relates to the trade-offs
between putting all data in one database or several for mysql. For example,
say I have an application where a users login from their mobile phones and
read/write data to a database. Say there are roughly
John,
Thanks. The data is private to each user; there is no sharing of data.
I am not sure what you mean by are the actions related Each user is
reading/writing independently of each other. Would that argue for
separate databases?
Mark
Are the actions of a similar nature (i.e. they're
Mark Phillips wrote:
On Sat, Oct 3, 2009 at 3:06 PM, Martin Gainty mgai...@hotmail.com wrote:
depends on the relationship of the Data Tables and the Users that use them
for instance if I was to setup a table of outgoing calls from 2 distinct
individuals :
Me calls to
Johan De Meersman wrote:
On Thu, Sep 17, 2009 at 3:46 AM, John Meyer john.l.me...@gmail.com wrote:
Alternatively, you can skip the A_ID and have a compound key of USER_ID and
A_NUMBER on the ASSOC_NUMBERS table. I prefer the A_ID, though.
Note that this would be marginally faster
I'm trying to pull up a list of users who haven't tweeted in 7 or more
days, and I'm trying to use this statement:
SELECT USER_NAME, MAX(TWEET_CREATEDAT) FROM USERS NATURAL JOIN TWEETS
WHERE DATEDIFF(NOW(),MAX(TWEET_CREATEDAT)) 7 GROUP BY USERS.USER_ID
But it says invalid group function. How
Gavin Towey wrote:
Hi John,
You can't use aggregate function in the WHERE clause, because they aren't
evaluated until after the WHERE clause is applied.
Wouldn't it be much easier to simply keep a last_tweet_date field updated
somewhere then simply do
SELECT USER_NAME FROM USERS WHERE
Pete Wilson wrote:
Hi folks --
What would be the right approach in MySql 5.0?
My table, USERS, has columns NAME and IP. Associated with each user is also a
collection of from 0 to 50 INTs. What's a reasonable way to put these 50 INTs
in the table without using 50 separate columns,
Pete Wilson wrote:
Break them out into a separate table linked via the primary
key.
How elegant! Thanks.
-- Pete
it's nothing not taught in Database Design 101. Typically you would
have a setup like this
USERS
USER_ID --primary key
USER_NAME
USER_IP
ASSOC_NUMBERS
A_ID
I'm pulling in a date with the following format
9/14/2009 2:12:48 PM
And using this mask to convert it using the str_to_date() function:
%e %m %Y %r
but it keeps giving me an error. Do I have the right mask?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Dan Nelson wrote:
In the last episode (Sep 14), John Meyer said:
I'm pulling in a date with the following format
9/14/2009 2:12:48 PM
And using this mask to convert it using the str_to_date() function:
%e %m %Y %r
but it keeps giving me an error. Do I have the right mask?
Nope
Two tables:
USERS:
USER_ID (PK)
. . .etc
TWEETS:
TWEET_ID (PK)
USER_ID (FK)
Trying to get the user information and the number of tweets each person has:
SELECT USERS.USER_NAME, COUNT(TWEETS.TWEET_ID) AS 'TWEETCOUNT' FROM
TWEETS NATURAL JOIN USERS;
But it seems to be just rolling up all the
Thanks. That worked.
Jason Trebilcock wrote:
Methinx you need a GROUP BY in there. See below.
-Original Message-
From: John Meyer [mailto:john.l.me...@gmail.com]
Sent: Thursday, September 10, 2009 6:48 PM
To: mysql@lists.mysql.com
Subject: Natural join problem
Two tables:
USERS
BobSharp wrote:
As a complete newbie in MySQL, I need a database
to store URLs related to Tenpin Bowling.
There are several Categories ... Equipment Manufacturers,
Organistations, (UK) ProShops, (UK) Bowling Centres, Personal
Websites, Misc., Coaching Instructional websites, etc.
There
Kelly Jones wrote:
Many sites let you search databases of information, but the search
queries are very limited.
I'm creating a site that'll allow arbitrary SQL queries to my data (I
realize I'll need to handle injection attacks).
Are there other viable ways to query data? I read a little on
create our own table with a cached copy of the results of show tables,
but we would prefer to avoid that because it is kludgy.
thanks!
-larry
Larry Meyer lar...@soe.ucsc.edu
UCSC Genome Bioinformatics Group http://genome.ucsc.edu
--
MySQL General Mailing
Here's the query:
INSERT INTO
USERS(USER_ID,USER_NAME,USER_SCREENNAME,USER_DESCRIPTION,USER_FOLLOWERS,USER_IMAGE,USER_FRIENDS,USER_LOCATION,USER_CREATEDAT)
VALUES('31264066','Justin Wienkers','BabyVegaz','I’m your secondhand
news/yeah. That and an (aspiring) screenwriter, trained journalist,
Ken Menzel wrote:
Dan Nelson wrote:
In the last episode (Jul 06), Blog Tieng Viet said:
I have been using MySQL on FreeBSD for 3 years and encounterd a lot of
problems related to thread management. And 1 year ago, I found that my
FreeBSD box does not go well with any MySQL revision after
Carlos Williams wrote:
On Wed, Jul 8, 2009 at 12:21 PM, John Meyerjohn.l.me...@gmail.com wrote:
Do we really need to bash OS's for MySQL. Rather than questioning what
OS is best for MySQL we should ask how we can optimize MySQL for each OS.
Did I mis-read an email or can someone please
Janek Bogucki wrote:
Hi John,
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-types.html includes
some information about acceptable literal forms for dates and times.
'Thu May 21 03:15:28 + 2009' is not an acceptable literal form but
this is how to parse it APART from the time zone
Janek Bogucki wrote:
Hi John,
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-types.html includes
some information about acceptable literal forms for dates and times.
'Thu May 21 03:15:28 + 2009' is not an acceptable literal form but
this is how to parse it APART from the time zone
Is Thu May 21 03:15:28 + 2009 a valid date/time string?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
I haven't had a problem with Hostgator yet. Prices are fair and
reasonable Also I've installed web apps through their portal and on my
own and haven't had a problem yet.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I'm wondering what the DOJ is going to think of that deal.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Yep. In particular the anti-trust division of the DOJ.
Kaushal Shriyan wrote:
On Mon, Apr 20, 2009 at 11:14 PM, John Meyer john.l.me...@gmail.com
mailto:john.l.me...@gmail.com wrote:
I'm wondering what the DOJ is going to think of that deal.
--
MySQL General Mailing List
Yep.
Per Jessen wrote:
John Meyer wrote:
I'm trying to help out a friend with repairing myisam tables. Does
anybody know the best freeware solutions if CHECK TABLE and REPAIR
TABLE don't do the job?
Did you try myisamchk ?
/Per Jessen, Zürich
--
Pueblo Bicycling
http
I'm trying to help out a friend with repairing myisam tables. Does
anybody know the best freeware solutions if CHECK TABLE and REPAIR TABLE
don't do the job?
--
Pueblo Bicycling
http://www.pueblobicycling.com
Actually looking forward to the daily commute
--
MySQL General Mailing List
For
Or, you can use cron/at to schedule the task
Mauricio Tellez wrote:
Hi Aaron, I'm not sure if what you want can be done with MySQL, but what you
can do is a little script in python, php, etc, that query your database for
the members that expire at a given date, and then email them. Then you tell
I'm trying to start a connection to a mysql database, but even though
I've installed the connector I don't see where the option to choose that
data type of connection exists.
I'm using Connection/NET v 5.1, btw
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Brett Harvey wrote:
http://www.reuters.com/article/mergersNews/idUSWNAS661820080116
No offense, but this is definitely not off topic when it comes to MySQL
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Given that FEHLGESCHLAGEN means failed and coupled with the proceding
text, I would assume that you don't have mysql installed in the first
place. If you are on an rpm based system, try the following:
rpm -q mysql
If you don't get anything back, you need to reinstall.
Ananda Kumar wrote:
if u
Afan Pasalic wrote:
hi,
I have a employees table (first name, last_name, address, city, state,
zip, phone,...).
though, I got a requested to add additional info about people, like
phone_extension, zip+4, nick, DOB... that will not be used very often.
what would be better solution:
a) add
David T. Ashley wrote:
Also, I have to say this to be complete ...
You were aware, of course, that nearly every modern copyright for books
prohibits digitizing the book and using it in any kind of document
retrieval
system? In fact, I believe a violation has occured even if it is scanned
Eddy D. Sanchez wrote:
Hello Everyone.
I want to scan a large quantity of books and documents and store these
like images inside or outside a database, I want use mysql, anyone
have any experience with this kind of systems, can you suggest me an
opensource solution ??
First question I would
Eddy D. Sanchez wrote:
Thanks for your answer.
I'm searching an opensource project (based on mysql obviously) that I
can hack for my needs, but if I can't find anything, I must make one,
my intention for technology is:
-Java for application server and framework
Might I ask why you need Java
Weiqi Wang wrote:
Dear everyone:
I start mySQL by a shotcut in windowsXP so that I don't have to input my
username, just password is required. That brings in a problem: I don't know
my user name(I suppose it to be root) and the server host, etc. Is there
anyway I can find it out? (I
Ananda Kumar wrote:
Hi Pelle,
I dont have enough space on any other storage, so i was thinking if we
would
just restore one database from dump that would save lot of time , rather
than restoring all the database.
regards
anandkl
Well, if only one database is important enough to back up,
I'm still searching online, but does anybody know of a script that will
input a tellico database into MySQL?
--
The NCP Revue -- http://www.ncprevue.com/blog
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Officelink wrote:
Hi everyone,
I¹m trying to set up a database with information that will be used in a
garment slideshow in flash.
The information to be included as part of the slideshow would be:
code, optional title, description, colours, sizes, garment image, fabric
swatch image
Each
J Trahair wrote:
Hi Everyone
I have set up a scheduled backup using MySQL Administrator. Stored
connection, database, dates and time, even the Windows user password (in
fact, blank). It doesn't start at the correct time, or indeed any time.
Have I missed something?
Thanks for your help.
Mike Blezien wrote:
Hello,
- Original Message - From: John Meyer [EMAIL PROTECTED]
To: MySQL General mysql@lists.mysql.com
Sent: Monday, May 14, 2007 10:26 AM
Subject: Re: Scheduled backups
J Trahair wrote:
Hi Everyone
I have set up a scheduled backup using MySQL Administrator
John Kebbel wrote:
For years, I've been using FileMaker Pro to generate a staff photo
gallery and staff phone directory from the same table of staff
information. I'm switching to PHP/MySQL for the year ahead. In STEP 1
below, I concatenate a name for the teacher/staff person image and in
James Tu wrote:
The database server and the web server are on separate machines.
Table A contains a record for each user.
Let's say Table B contains 'relationship' information. They can be of
type 'friend' or 'family'.
If a user knows another user, this relationship would be kept in this
John Comerford wrote:
Thanks for the replies guys, banging my head against the wall for not
thinking of using an auto increment integer to handle the sequence,
I've got to cut back on those Friday night beers
Okay, color me confused, but what exactly are you wanting to do anyway?
John Kopanas wrote:
I have a query that looks something like this:
SELECT (c_o_w_inst_rev - c_o_w_estcost)/c_o_w_inst_rev
FROM tmpGovernmentSummaries
The problem is that sometimes c_o_w_inst_rev is 0 and dividing by zero
returns a NULL.
If c_o_w_inst_rev == 0 how can I return 0 for the SELECT
Mahmoud Badreddine wrote:
Hello to all
I had an old MySQL 4.0 running on a Windows Machine.
I removed that version and I installed the MySQL 5.0 .
When I went to run phpMyAdmin this is the error I receive.
#1251 - Client does not support authentication protocol requested by
server;
consider
Hi
Bing Du wrote:
In our situation, we have three or four separate MySQL servers running.
Each has 'skip-networking' configured. So mysql don't accept requests
coming from outside via network. Each mysql server also runs as web
server. 'Localhost' is used for communication between web
Hi John
John Nichel wrote:
The db is MySQL 4.1.20 and the column synonyms_misspellings has a
FULLTEXT index on it (the db is set to index on 3 characters). Can
anyone help me understand why it's not rating the one with the match
three times higher than the one with the match twice, and point
Hi Xian,
xian liu wrote:
ERROR 1295 (HY000): This command is not supported in the prepared statement
protocol yet
mysql drop procedure ct_tb//
Query OK, 0 rows affected (0.00 sec)
the same, drop function/trigger xxx is also not supported in prepare
statment.
Is it a lack of
Hi,
abhishek jain wrote:
I am having a database with varchar(255) columns named title,
extra_info1,extra_info2,extra_info3 .
I want to search all these columns with a search string given to me via a
form ,I am using PERL, the string will be like
+abhishek jain -abcd this should be exact
I
Jonathan Trahair wrote:
Hi Everyone.
I have just upgraded a Visual Basic 6 project which used an Access database as
a data back end, using DAO and SQL strings. The Access database was exceedingly
slow, and prone to glitches. I have changed the VB code to ADO, and set up a
MySQL database in
Grant Griffith wrote:
I am trying to add an autoincrement field to a table that already exists
and I keep receiving errors when trying to do it. Can someone point me
in the right direction on how I can do this? I have access via Webadmin
and phpMyAdmin, so I can try it however I need to.
Hi Murthy,
murthy gandikota wrote:
Can someone please tell me how to manage multiple disk partitions in mysql?
BTW, the mysql is version 4 or something like that.
When using InnoDB you can just add another tablespace on /var [1]. With
MyISAM it gets a bit more difficult, at least in pre
Hi,
Michael Fernández M. wrote:
2 CPU Pentium III 700 Mhz Aprox.
4 GB RAM.
Redhat 7.2
Mysql version: 4.0.14-standard-log
Kernel: Kernel 2.4.18-17.7 (highmem)
It is possible that mysqld could use up to key_buffer_size +
(read_buffer_size + sort_buffer_size)*max_connections = 3666809 K bytes
of
Hi JM,
JM wrote:
i got this results from show processlist
| 11186 | unauthenticated user | 192.168.1.106:36198 | | Connect | NULL |
login | |
| 11187 | unauthenticated user | 192.168.1.106:36200 | | Connect | NULL |
login | |
That's just
Hi,
Micol lupen wrote:
FOREIGN
KEY(of_idvillaggio),REFERENCES villaggio(idvillaggio)
^^^ check here!
ON UPDATE CASCADE ON DELETE RESTRICT)ENGINE=INNODB;
No comma before REFERENCES. REFERENCES is part of the foreign key
definition.
regards
Nils
--
MySQL General
Hi,
Jean-Sebastien Pilon wrote:
I would like to grow my innodb table space, the only problem that I have
is that I did not declare any size in the config file since we were not
using it to start with. If I modify the config file, will this override
the current innodb file or will it grow it ?
Hi,
Michael Fernández M. wrote:
key_buffer_size=402653184
read_buffer_size=2093056
max_used_connections=323
max_connections=800
threads_connected=55
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections
= 3666809 K
bytes of memory
Hi,
Michael Fernández M. wrote:
i use 32 Bits kernel.
Remember that you have to stay under 2GB total memory allocation! I
think you hit that limit.
innodb_additional_mem_pool_size = 500 MB.
innodb_buffer_pool_size = 8 MB
Before the innodb_additional_mem_pool_size was 1 MB, (the default
Michael Fernández M. wrote:
Remember that you have to stay under 2GB total memory allocation! I
think you hit that limit.
Sorry, but why do you say that?, because of the 32 bits kernel?
Yes exactly. Depending on kernel version you can allocate something
between 2 or 2.7GB. Until 2GB it's
Hi,
Nuno Oliveira wrote:
When I set the RS.Source to the first SELECT statement and open it, it
run OK but I need to close the RS and open it again using the second
SELECT statement.
After any of this operations I get a Recordset-RecordsCount = 1
That is actually a correct figure, SELECT
Nils Meyer wrote:
SELECT
SQL_CALC_FOUND_ROWS doesn't make much sense without a where clause by
the way.
LIMIT, not where.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Neil Tompkins wrote:
Following on from the email below, if I run the query
SELECT * FROM database1.table, database2.table
I get the data back, but all the data is in the same row.
How can I seperate the records ?
Regards
Neil
Barring an upgrade, it seems your best bet would be to
Hi Js,
js wrote:
Is there any easy way to implement 'NOT EMPTY' constraint?
There currently is no support for CHECK Constraints in MySQL, at least
to my knowing. So you'd have to go with a trigger.
regards
Nils
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Phil Butterworth wrote:
Can anyone please tell me what the Max size a myISAM file can grow too?
Thanks
Best Regards
Phil Butterworth
mailto:[EMAIL PROTECTED]
http://lists.mysql.com/mysql/204119
Funny what google can do for you, wot say?
--
MySQL General Mailing List
For list
Hi Faygal,
Fagyal Csongor wrote:
for (1..5) {
$dbh = DBI-connect($dsn, $user, $password, {'RaiseError' = 1} );
my $sth = $dbh-prepare('SELECT * FROM users');
}
I think you are simply running out of available outgoing ports with
that. Here is some more insight on that topic:
Hi Manuel,
Manuel Vacelet wrote:
I have query that joins 2 tables. I have an index on each part of the
join but unfortunately the 2 columns don't have the same type so the
index is not used for the join (I guess it's the reason why). On one
hand I have an INT and on the other and a VARCHAR.
Hi Kim,
Kim Christensen wrote:
The error I get while trying executing is Unknown column
'products.product_id' in 'on clause'. Since I am selecting all
columns from that table (products), I can't really see why there's a
fuss about it!
I'm thankful for every tip I can get, and please let me
Anybody in here think of http://www.vbmysql.com?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Nuno Vaz Oliveira wrote:
Hello John,
Anybody in here think of http://www.vbmysql.com?
The site is not working correctly :(
I've found a lot of references to that site but the articles are all
missing.
This article isn't missing:
Hi Shain,
Shain Lee wrote:
Now , i have to think about any perfect load balancing method , i can't
duplicate the databse in another machine. It's directly conflict with serving
contents for each request.
Why not use replication? If you don't want to do it on application level
(seperate
Hi Shain,
Shain Lee wrote:
ERROR 1 (HY000): Can't create/write to file '/home/shaine/Music_Details.csv'
(Errcode: 13)
I faced a problem as mentioned above. really got stucked. how can i solve that
problem ? is it a bug ?
Error 13 is Permission Denied. The MySQL daemon cannot write to your
Hi Richard,
Richard Reina wrote:
I am trying to update from one table to another but I get a syntax error when I
try:
UPDATE from maindb.orders o, altdb.orders ao SET o.price=ao.price WHERE o.ID=a.ID;
If update does not support aliases, is there another way to do this query? I am usin
Hi,
Nishant Gupta wrote:
[/usr/local/mysql-5.1.12-beta-hpux11.11-hppa2.0w]scripts/mysql_install_db
--user=mysql
chown: unknown user id mysql
Installing all prepared tables
061212 19:39:30 [ERROR] Fatal error: Can't change to run as user
'mysql' ;
Please check that the user exists!
Did you do
What is the best way to UPDATE a row only if values are different? We
have a mainframe extract that literally has 100,000 rows and am worried
about the performance of just running INSERTs each night.
Is there a simple comparison command or would you have to nest a SELECT
statement? Thank you,
Hi Charles,
Charles Danko wrote:
Each entry consists of 2 medium_int and 1 tiny_int variables, and the
table
contains just over 100,000,000 rows. By my count, this makes just over
700MB of data. The machine I am using has 2GB, but I am still getting an
out of memory error. What am I doing
David Blomstrom wrote:
I just downloaded MySQL Administrator and am now trying to set it up. Can anyone tell me what stored
connection and Server Host mean? I'm using Apache on Windows XP, but I'm not sure what they
mean by Server Host. 3306 is listed under Port by default.
Also, what are the
David Blomstrom wrote:
OK, I'm halfway there. But I don't understand what you mean by saved
settings. Is there some sort of default value I can try?
Also, if I can't recover my password, is there a file I can open and retrieve
it from?
I tried it with localhost, Port 3306, Username: root and
[EMAIL PROTECTED] wrote:
I have something like this:
?php
$query = mysql_query(
SELECT col_1, col_2
FROM table
);
$result = mysql_fetch_array($query);
if ($result['col_1'] == 'value_1')
{
// do something
}
if ($result['col_2'] == 'value_2')
{
[EMAIL PROTECTED] wrote:
Why do you want to use a switch in this particular instance. You're
comparing apples and oranges (in this case, col_1 and col_2). You use
swithc to evaluate one variable against a number of choice, not multiple
variables against variable choices.
I'm not
, but it's what I've worked with so far.
That and naming the primary key on a table with the suffix ID. Foreign
Keys have the same name as they do on primary keys. Simple, strong,
ugly, and dignified
--
John Meyer
http://pueblonative.wordpress.com
http://pueblonative.110mb.com/board
--
MySQL
, maybe that's what Ravi was referring to. In which case,
I'd direct ravi to the auto_increment attribute for an INT and the
primary key.
--
John Meyer
http://pueblonative.wordpress.com
http://pueblonative.110mb.com/board
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
One table,
USERS
Another table
MESSAGES
With a foreign key referencing users.
Maybe a second foreign key referencing the destinating user as well.
-Original Message-
From: James Tu [mailto:[EMAIL PROTECTED]
Sent: Monday, August 07, 2006 1:56 PM
To: mysql@lists.mysql.com
Subject:
If you're using Myphpadmin, you can turn this option off when generating the
dump file.
-Original Message-
From: Chris White [mailto:[EMAIL PROTECTED]
Sent: Friday, August 04, 2006 12:14 PM
To: mysql@lists.mysql.com
Subject: Re: Backup SQL
On Friday 04 August 2006 10:35 am, Daniel da
I think equating a tagline indicating something's been spam-checked
with a full out message for a web product is a little absurd.
On 8/3/06, Ian [EMAIL PROTECTED] wrote:
You say you hate spam then spam the list with an advert for McAfee!
Ian
--
I'm American, fatboy. What's your excuse?
--
SELECT DISTINCT username, time, download
FROM table
ORDER BY time DESC
GROUP BY username
André Hänsel wrote:
Hi Dan, hi Obed,
of course I have no specific username, I want the last 5 downloads of each
distinct username in the table. :)
Regards,
André
-Ursprüngliche Nachricht-
of usernames, how can that be of any
help?
all right, here's how this goes.
Create a stored procedure
WHERE YOU SELECT DISTINCT username.
Then for each user,
retrieve the five 5.
Put them in a union,
enjoy.
--
John Meyer
http://pueblonative.wordpress.com
http://pueblonative.110mb.com/board
Have you checked out MyConnector/NET and the MySqlException class?
-Original Message-
From: Asif Lodhi [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 02, 2006 6:17 AM
To: mysql@lists.mysql.com
Subject: Database Return Errors
Hi,
I am developing a VB6 app with a MySQL-5.0.22/WinXP
I have two tables:
MEMBERS:
MEM_ID
...
GROUPS:
GRO_ID:
...
And one joiner
MEM_GRO:
MEM_ID, GRO_ID
I want to print out a list like this
GROUP_NAME, NUMBER_OF_MEMBERS
Even when the number of members is 0, how do I do that?
--
MySQL General Mailing List
For list archives:
You know this might be a little bit more convincing if you gave the name of the
product and a little bit more personal reason why you recommended it other than
check out brand x product I vote this is spam.
-Original Message-
From: itguy321 [mailto:[EMAIL PROTECTED]
Sent: Wednesday,
I've dealt with this in terms of Books and Titles. Those two are separate:
one title can have many book editions published in it. Also, you can have a
book with multiple titles (anthology, for instance).
I suppose it is possible for album not to be the same as cd title,
particularly if you have
1 - 100 of 210 matches
Mail list logo
