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
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
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
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
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
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:
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
Yeah, I just figured it out ten minutes ago, one of those stupid little
oversites on my part.
-Original Message-
From: Martin Jespersen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 02, 2006 3:40 PM
To: John Meyer
Cc: mysql@lists.mysql.com
Subject: Re: Doing a join
select
Sorry, but that's how I was normally trained to use SQL and to name
variables. I know netiquette, it's just how I was trained on the system.
-Original Message-
From: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 02, 2006 11:35 AM
To: John Meyer
Cc: mysql@lists.mysql.com
on of mysql 4?
--
John Meyer
Programmer, Database author
Here's something to think about: How come you never see a headline
titled Psychic Wins Lottery---Jay Leno
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Joko Siswanto wrote:
Dear All
if myqsl service can't start, where can i found the file and back up it?
[under windows and linux]
Thanks,
Joko Siswanto
What file are you looking for?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Chris White wrote:
On Sunday 02 July 2006 12:22 pm, Kirti S. Bajwa wrote:
I have very little knowledge of either PostgreeSQL or mySQL. Please advise
me as to which of these two software package to use? I need some specific
examples as to superiority of one package over the other. I prefer using
Ian Barnes wrote:
Is this possible? Or would the best way be to import the dumped file into a
temp table and then select out of the temp table into my correct table ?
Anyway to use a trigger?
--
Online library -- http://pueblonative.110mb.com
126 books and counting.
--
MySQL General
tomáz rezistänz wrote:
I wish I could uninstall mySQL and start over but I don't know how..
On 6/7/06, tomáz rezistänz [EMAIL PROTECTED] wrote:
Do you know how to dump your mySQL databases?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Chris Sansom wrote:
At 19:44 +1000 31/5/06, Logan, David (SST - Adelaide) wrote:
I would agree, I have found it useful as well. It does have a few
limitations (well the versions I've used)
BTW, what are the limits on OpenOffice's Base being used as a front end?
--
MySQL General Mailing List
tedd wrote:
Yes, I was wondering that myself considering the onslaught of no-no's one
gets by suggesting placing images into a dB. A PDf file is really not that much different
and probably better served via file system.
tedd
On the other hand, you get control of the images, as opposed to
Setup
TITLES:
TITLE_ID
AUTHORS:
AUTHOR_ID
TITLE_AUTHOR:
(TITLE_ID,AUTHOR_ID)
Problem:
Given a title, I need to find all the authors who aren't connected with
that particular book.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Rhino wrote:
- Original Message - From: John Meyer [EMAIL PROTECTED]
To: List: MySQL mysql@lists.mysql.com
Sent: Tuesday, May 30, 2006 5:09 PM
Subject: Query problem
Setup
TITLES:
TITLE_ID
AUTHORS:
AUTHOR_ID
TITLE_AUTHOR:
(TITLE_ID,AUTHOR_ID)
Problem:
Given a title, I need
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, I'm trying to develop my own book database, and I have a question
about ISBN: Is that number linked to a book or to a title? That is, can
one title (say, Huckleberry Finn) have several ISBNs associated with it
through several book releases?
Jon Miller wrote:
Having an error in a script that I cannot figure out why it's not working. The problem
is on line 15 while ($row = mysql_fetch_object ($result)).
What, exactly is the error?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Mike Blezien wrote:
Yes, after some further research, I found a Perl Modules that handles
this queit nicely.
thx's
Please tell me where this module is, if you would.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
On Friday 30 December 2005 3:31 pm, Scott Baker wrote:
How can I prevent this?
Scott
You know when I deal with users like this, I like to think about what Dennis
Leary said about spanking children; I don't need to spank them, I find that
waving the gun around works just as well.
--
On Tuesday 27 December 2005 2:34 pm, Jesse wrote:
I'm trying to write a trigger that will update the age of a camper when
ever a record is updated or inserted. I have a table named Campers which
contains basic information about the camper as well as their birthday. I
have another table named
On Saturday 24 December 2005 1:05 pm, James Lumb wrote:
Hi,
I am new to mySQL and have mac OS X. Please could any other Mac users or
anyone for that matter tell me the best way of connecting to a mySQL
database?
Should I use terminal or a program like PHPmyAdmin?
Cheers,
James
James,
On Saturday 24 December 2005 1:05 pm, James Lumb wrote:
Hi,
I am new to mySQL and have mac OS X. Please could any other Mac users or
anyone for that matter tell me the best way of connecting to a mySQL
database?
Should I use terminal or a program like PHPmyAdmin?
Cheers,
James
James,
Just to let people know. And BTW, you have to say that you want the
account. Reply off list.
Onlist, I'd like to know how most people back up their Mysql dbs? XML
or direct SQL file? I prefer the latter, although I'd like to hear
from proponents of the former.
--
MySQL General Mailing List
Still have GMail invites, for anybody that is interested. E-mail me.
(reply off list)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1. What is the user or connection limit for both versions of MySQL
(Database
Server and MaxDB)?
Search the web site
2. How much memory does MySQL take when started up?
Search the web site
3. Does MySQL take advantage of dual CPU systems?
Search the web site
4. Define referential integrity.
Do a
Go into the bin directory and startup winmysqladmin.exe That will give you a
graphical control over the server.
- Original Message -
From: Andrew McHorneymailto:[EMAIL PROTECTED]
To: [EMAIL PROTECTED]mailto:[EMAIL PROTECTED]
Sent: Saturday, June 19, 2004 4:20 PM
Subject:
Hi,
I'm writing a database for an online candle store. Here's the situation. This store
sells all sorts of items including candles. Now the gist is that some of the candles
can be made in different types of waxes and some only have one wax. My question is
how do I resolve this when I write
BTW, when I start Winmysqladmin from a new installation, it always asks me
for a username and password. Since this is a single-user machine I simply
use root and a password. Does this setup those passwords in MySQL?
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: I
Try MySQL/PHP Database applications by Jay Greenspan and Brad Bulger.
It's a great buy and gets into a lot of the practical applications you'll be
doing a lot of coding for.
At 13:41 3/28/2004, A Mathias wrote:
Preferably one that is for begginers to medium and thats covers both
mySQL
and
This may sound a little bit off, but what programming language are you using
to print this. It might be easier to simply use a language like perl to
print out the output that you are suggesting.
From: Seena Blace [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: ORDER BY WITH NO PRINT
Date:
1 - 100 of 146 matches
Mail list logo