Hi.
On Friday 18 May 2012 18:21:07 Daevid Vincent wrote:
Actually, I may have figured it out. Is there a better way to do this?
I don't see why you need the dvds table when the dvd_id is in the scene table:
SELECT a.dvd_id
FROM scenes_list a, moviefiles b
WHERE a.scene_id = b.scene_id
AND
Hi.
On Thursday 10 Mar 2011 at 20:09 mos wrote:
[snip]
Let's say I have a Document_Id column and the url is
www.mydocuments.com/public?docid=4
to retrieve document_id=4, I don't want someone to write a program to
retrieve all of my public documents and download them. I want them to go
Hi all,
I've got a fairly large set of databases I'm backing up each Friday. The
dump takes about 12.5h to finish, generating a ~172 GB file. When I try
to load it though, *after* manually dumping the old databases, it takes
1.5~2 days to load the same databases. I am guessing this is, at
Gavin Towey wrote:
There are scripts out there such at the Maatkit mk-parallel-dump/restore that
can speed up this process by running in parallel.
However if you're doing this every week on that large of a dataset, I'd just
use filesystem snapshots. You're backup/restore would then only take
Consider a wiki that lets you edit rows in a db table. Each page is a
row in the table, and has fields that anyone can edit. Like all wikis,
it keeps a history of edits (including who made the edits), and lets
you revert an edit, or even delete a row (page) completely.
Has anyone implemented
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
Business System 12
I have a directed graph (nodes and edges) that I want to store
efficiently: given two nodes, I want to quickly find the shortest
path between them. The graph is NOT acyclic (it's not a tree), is
fairly sparse (about 1 edges for 2500 nodes), and changes
occasionally.
I know PostgreSQL/MySQL
Hi
Is there any way to restrict access to the tcp port on mysql. I only
want my 5 class C's to be able to access the port but it is a public
server.
Any help would be greatly appreciated.
Kelly
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hi.
On Wednesday 08 August 2007 18:39, Jason Pruim wrote:
Did some more testing, made a new table and matched the field names,
now it will load it without any errors, it's just only importing the
first row... Not the rest of the 934 records...
You are using ENCLOSED BY '' in your SQL, which I
Hi.
On Thursday 05 July 2007 17:35, you wrote:
I want to delete from the 'Item' table
all the items identified by the folowing query:
If you have MySQL 5+, you can do it using a sub-query:
DELETE FROM
Item
WHERE
ProductID IN (
SELECT
Item.ProductID
FROM
Item, ItemTag
Hi
I want to delete from the 'Item' table all the items identified by the
folowing query:
SELECT
Item.ProductID
FROM
Item, ItemTag
WHERE
ItemTag.TagID = '168'
AND
ItemTag.ItemID = Item.ProductID;
but I'm not sure how to go about it. Can anyone help?
Thanks
Mark
--
Keith,
The definitive way is to turn on the query log and watch it for a few days
or weeks.
In your my.cnf under [mysqld] add the line:
log=mysql-query
Then restart your server.
In your server's data directory (e.g. /usr/local/mysql/data/), there will
now be a log file called
Apologies for the mass cross-posting: I haven't been able to find a single
answer or reference for the problem below (googling didn't help), and
was hoping someone could point me to something helpful. I'm convinced
there's a well-known answer here that I just can't find :(
We're modeling a
In PostgreSQL, the following SELECT statement will return all the
columns for 'tabname':
SELECT x.attname FROM pg_attribute x, pg_class y WHERE
x.attrelid=y.oid AND relname='tabname';
Does MySQL have anything similar?
I know about SHOW COLUMNS FROM tabname, but am looking for something
more
I have some data in a regular MySQL table called usplaces:
city |state|country|latitude |longitude |population|comments
-+-+---+-+---+--+
New York |NY |USA|40.704234| -73.917927|8008278 |Big Apple
Chicago |IL |USA
...
Kelly
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
=//SOFTWOODSERVER/SharedDocs/mydata/data
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
#set-variable=max_allowed_packet=3M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=PTurk
password=password
--
Kelly Solakofski
Softwood
I have three tables (x, y, and z) with the same 3 fields (id, name,
number). If I do:
SELECT * FROM x, y, z WHERE ...
each row of my result will contain 3 id fields, 3 name fields, and 3
number fields.
Of course, I can/should do:
SELECT x.id AS x_id, x.name AS x_name, x.number AS x_number,
ownership.
The group owner is different. Any ideas? Thanks,
Kelly
Script:
#!/bin/sh
date=`date -I`
sudo su -
mkdir /usr/local/mysql/bakups/$date
chown root.mysql /usr/local/mysql/bakups/$date
chmod 770 /usr/local/mysql/bakups/$date
/usr/local/mysql/bin/mysqldump --tab=/usr/local/mysql/bakups/$date
mysqlhotcopy
chmod 700 mysqlhotcopy
Any ideas would be greatly appreciated. I would really like to add this
to a cronjob to have it run automatically. Thanks in advance!
Kelly S. Brace
Information Technology Exchange Center
Twin Rise 200
1300 Elmwood Avenue
Buffalo, NY
Thanks guys! I did follow the procedure, but somewhere during the first
and second attempt I mucked it up. Followed the directions slowly and
carefully a third time and we are up and running. Thanks for your help!
Kelly
Kelly S. Brace
Information Technology Exchange Center
Twin Rise 200
server
What do I need to do to allow the host to connect? Thanks,
Kelly
Kelly S. Brace
Information Technology Exchange Center
Twin Rise 200
1300 Elmwood Avenue
Buffalo, NY 14222
http://www.itec.suny.edu
Main: 716-878-4832
Fax: 716-878-3485
Office: 716-878-3984
Cell: 716-432-4978
[EMAIL
Good good.
On 24 Feb 2005, at 20:46, [EMAIL PROTECTED] wrote:
BINGO!!!
Thanks Dan!
Kelly
Daniel Walker [EMAIL PROTECTED]
What version of MySQL are you using? 4.1.1 uses an enhanced password
hashing system that isn't compatible with clients built for older
versions.
This page
need to do to make it start properly? Thanks in advance!
Kelly S. Brace
Information Technology Exchange Center
Twin Rise 200
1300 Elmwood Avenue
Buffalo, NY 14222
http://www.itec.suny.edu
Main: 716-878-4832
Fax: 716-878-3485
Office: 716-878-3984
Cell: 716-432-4978
[EMAIL PROTECTED]
I have a table of full URLs and IPs and am using the following query to return
distinct web requests by domain. Using SUBSTRING_INDEX it only returns the
domain part of the URL:
SELECT SUBSTRING_INDEX(url, '/', 3) as topsites, count(distinct ip) as count
from tablename WHERE SUBSTRING_INDEX(url,
Hi, I have a table full of logged urls and ip addresses. The following query
returns all the urls and the number of requests. How would I modify it to return
unique requests based on distinct ip addresses?
select url, count(*) as pageviews from table group by url order by pageviews
desc
--
- Original Message -
From: Daniel Clark [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 2:33 PM
Subject: Re: Need help constructing query ...
: Hi, I have a table full of logged urls and ip addresses. The following
: query returns all the
: -Original Message-
: From: John Kelly [mailto:[EMAIL PROTECTED]
: Sent: Tuesday, October 21, 2003 3:45 PM
: To: [EMAIL PROTECTED]
: Cc: [EMAIL PROTECTED]
: Subject: Re: Need help constructing query ...
:
:
: - Original Message -
: From: Daniel Clark [EMAIL PROTECTED
Don
This is more help than I ever anticipated, and
I certainly thank you very much. Let me digest / re-program
this. If there's anything I can do you for, just let
me know.
Thanks lots!
Regards,
Kelly W. Black
Linux was very clearly the answer, but what was the question again
Just run mysql in it's own little jail
with --user=mysql # or some username you add to the tables...
Regards,
Kelly Black
-Original Message-
From: Dimitar Haralanov [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 4:18 PM
To: [EMAIL PROTECTED]
Subject: Re: granting
Richard Dice is a friend of mine, and has done a wonderful
tutorial on Choosing the right database system that I found
marvelous, at webmonkey:
http://hotwired.lycos.com/webmonkey/backend/databases/tutorials/tutorial1.ht
ml
Regards,
Kelly Black
Sprint PCS
Performance Engineering
Irvine, Ca
Usually there's a little more administrative work to limiting
usage...but it's up to you.
Regards,
~KB
-Original Message-
From: Jennifer Goodie [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 2:38 PM
To: Black, Kelly W [PCS]; 'Dimitar Haralanov'; [EMAIL PROTECTED]
Subject: RE
Also you can do
mysql -u userid -p -h hostname dbname /path/to/your/script.sql
Regards,
Kelly Black
Linux was very clearly the answer, but what was the question again?
-Original Message-
From: Anderson Pereira Ataides [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 27, 2003 5:37 AM
for your help.
Regards,
Kelly W. Black
Linux was very clearly the answer, but what was the question again?
-Original Message-
From: Don Read [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 25, 2003 8:30 PM
To: Black, Kelly W [PCS]
Cc: Mysql (E-mail)
Subject: RE: sum() using group
know about
the sum *before* the distinction...
Thanks guys, I will try these and see if I can fix it.
Regards,
Kelly Black
Linux was very clearly the answer, but what was the question again?
-Original Message-
From: Serge Paquin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26
I think this might do what you want, but then you will be required to log
in with the -p syntax...
GRANT SELECT on *.* TO yourlogin@'%' IDENTIFIED BY somepassword;
FLUSH PRIVILEGES;
mysql -u youruserid -p -h hostname dbasename
Regards,
Kelly Black
Linux was very clearly the answer, but what
AS SELECT DISTINCT * FROM pcf where release =
curdate()-1;
Query OK, 2438 rows affected (0.11 sec)
Records: 2438 Duplicates: 0 Warnings: 0
mysql
Any ideas on how I can get rid of the bug wars???
Regards,
Kelly Black
Linux was very clearly the answer, but what was the question again
Try using
GRANT ALL ON Security.* TO newbuddy@'%' INDENTIFIED BY 'password';
Regards,
Kelly Black
Linux was very clearly the answer, but what was the question again?
-Original Message-
From: Terrance Win [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 25, 2003 12:57 PM
To: [EMAIL
Try
/usr/local/mysql/bin/mysql -u userid -p -h hostname
password:
mysql
Regards,
Kelly Black
Linux was very clearly the answer, but what was the question again?
-Original Message-
From: Jennifer Goodie [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 25, 2003 3:16 PM
To: katherine
]
Sent: Tuesday, March 25, 2003 4:13 PM
To: Black, Kelly W [PCS]
Subject: Re: mysql install---help please
I typed in
/usr/local/mysql/bin/mysql -u userid -p -h localhost password:
prompted for password, gave only one I ever use
response was
ERROR 1045: Access denied for user: '[EMAIL PROTECTED
You guys probably need to start mysql with the --skip-grant option
and fix the allow tables...
See the mysql.com website or google.com for lost password mysql
-Original Message-
From: Chee-Wai Yeung [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 25, 2003 5:09 PM
To: [EMAIL PROTECTED];
a LOAD file to contain the load parameters and that the field
options are top to bottom for fields left to right.
**When I come to a field I want mysql to ignore do I just use this
parameter?
IGNORE
jim kelly
-
Before posting
Cute.
sql, query
~K Black
-Original Message-
From: [EMAIL PROTECTED] [mailto:mysql-help;lists.mysql.com]
Sent: Thursday, November 14, 2002 6:38 AM
To: Black, Kelly W [PCS]
Subject: confirm unsubscribe from [EMAIL PROTECTED]
Hi! This is the ezmlm program. I'm managing the
[EMAIL
Right.
My mistake.
I think you get the general idea.
~K Black
-Original Message-
From: Paul DuBois [mailto:paul;snake.net]
Sent: Tuesday, November 12, 2002 4:21 PM
To: Black, Kelly W [PCS]; 'Phil Iovino'; 'Scott Pippin'
Cc: [EMAIL PROTECTED]
Subject: RE: Installation Help
At 11:45
It doesn't appear this part is valid sql, query
DATA_DIRECTORY=/tmp;
~K Black
-Original Message-
From: Yuyi Guo [mailto:yuyi;fnal.gov]
Sent: Wednesday, November 13, 2002 9:21 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: create table w/ data/index directory
Hi,
I am using
localhost
~Kelly W. Black
-Original Message-
From: Phil Iovino [mailto:phil;nxtek.net]
Sent: Wednesday, November 13, 2002 10:36 AM
To: 'Paul DuBois'; Black, Kelly W [PCS]; 'Scott Pippin'
Cc: [EMAIL PROTECTED]
Subject: RE: Installation Help
I wasn't sure if I was supposed to use 'root
Did you remember to allow backwards compatibility in @INC
for perl 5.6.1?
~K Black
-Original Message-
From: Octavian Rasnita [mailto:orasnita;home.ro]
Sent: Wednesday, November 13, 2002 2:58 AM
To: MySQL List
Subject: Using MySQL with Perl 5.8?
Hi all,
I was able to install the
You might need to use rpm -e to uninstall previous version first.
Check the documentation.
~Kelly W. Black
-Original Message-
From: Rick Root [mailto:rroot;wakeinternet.com]
Sent: Wednesday, November 13, 2002 10:47 AM
To: mysql
Subject: Upgrading MySQL from 3.23.41 to 3.23.53a
I
If you ran into any problems it would probably
be RAM. RAM is cheap so if you have trouble...just
pop a couple of 512MB chips in it.
~KB
-Original Message-
From: Jeremy Zawodny [mailto:Jeremy;Zawodny.com]
Sent: Wednesday, November 13, 2002 11:12 AM
To: Devore, Jacob
Cc: '[EMAIL
I have been using the MySql 4.x MAX with absolutely
NO problems. It's being used on heavily operated servers,
and I upgraded to 4.x for it's incredible index speeds and
it's VERY reliable to me.
In fact, in our local benchmarks it's kicking the living crap out
of Oracle on sql, query. :)
~Kelly
Make sure some previous version of MySql isn't running.
I have seen this on systems which had the OS installed version
of MySql, and I had to issue
shell /sbin/service mysql stop
shell cd /usr/local/mysqlversion
shell ./bin/mysqld_safe -user=theuserid
Hope this helps...
~Kelly W. Black
You don't have a compiler installed? Hmmm. This seems tough to
believe.
Try issuing 'which cc'
~K Black
-Original Message-
From: leaddog1 [mailto:jsobeck;lead-dog.net]
Sent: Tuesday, November 12, 2002 6:44 AM
To: [EMAIL PROTECTED]
Subject: Solaris 2.6
Is there any version of MySQL
Make sure when you are creating the database that
U_Number | int(9) unsigned | | PRI | NULL
is
U_Number | numeric() | | PRI | NULL
-Original Message-
From: Petre Agenbag [mailto:internet;boesmanland.com]
Sent: Tuesday, November 12, 2002 4:27 AM
To:
Don't re-install.. Fix the problem
Try issuing
shellcd /usr/local/mysqlversion
shell./configure
~K Black
-Original Message-
From: mod_perl [mailto:shine_perl;spectrum.net.in]
Sent: Monday, November 11, 2002 10:23 PM
To: [EMAIL PROTECTED]
Subject: unable to start mysql
hi all,
when i
Make sure you issued the correct GRANT statements
at the sql, query.
mysqluse mysql;
Database Changed
mysql GRANT * ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY 'somepassword';
#note that will give FULL access...see the docs to restrict this.
mysql FLUSH PRIVILEGES;
0 Rows Affected.
~Kelly W
See the file INSTALL_BINARY
~KB
-Original Message-
From: Pierre [mailto:pierre;epinetworx.com]
Sent: Tuesday, November 12, 2002 1:45 AM
To: [EMAIL PROTECTED]
Subject: Problem compiling mysqlgui 1.7.5
Hi,
I try to compile mysqlgui-src-1.7.5 on my GNU/Linux system with gcc-3.2
but with
Check if mysqld or some other process uses all
available memory. If not you may have to use
'ulimit' to allow mysqld to use more memory
or you can add more swap space,
If it persists, use vmstat 1
~Kelly W Black
-Original Message-
From: Jeremy Zawodny [mailto:Jeremy;Zawodny.com]
Sent
Get on out there with your bad self Michael !!
:)
~KB
-Original Message-
From: Michael T. Babcock [mailto:mbabcock;fibrespeed.net]
Sent: Tuesday, November 12, 2002 3:23 PM
To: David Kramer
Cc: '[EMAIL PROTECTED]'
Subject: Re: Why does safe_mysqld runs as root?
David Kramer wrote:
By
You can do this in /etc/my.cnf
~K Black
-Original Message-
From: [EMAIL PROTECTED] [mailto:CZachary;wiley.com]
Sent: Monday, November 11, 2002 10:05 AM
To: [EMAIL PROTECTED]
Subject: /tmp/mysql.sock question (newbie)
Hello all, I would like to change where the /tmp/mysql.sock file
Can you post about 30 seconds worth of
the vmstat 1 command when the system
is busy?
Thanks
~Kelly W. Black
-Original Message-
From: [EMAIL PROTECTED] [mailto:kahnmatt;engin.umich.edu]
Sent: Monday, November 11, 2002 11:09 AM
To: [EMAIL PROTECTED]
Subject: Commands out of sync
Hi
/tmp/mysql.sock
and things seem to work fine.
~K Black
-Original Message-
From: Adolfo Bello [mailto:adolfobello;bisapi.com]
Sent: Monday, November 11, 2002 1:32 PM
To: Black, Kelly W [PCS]
Cc: Mysql Lists
Subject: RE: /tmp/mysql.sock question (newbie)
I am also a newbie so don't
XFS is X server Font Server, and is unrelated.
~Kelly W. Black
-Original Message-
From: David Kramer [mailto:DKramer;reflect.com]
Sent: Monday, November 11, 2002 1:51 PM
To: [EMAIL PROTECTED]
Subject: Mysql starts under XFS on boot up???
I noticed that Mysql starts up under XFS, Im
.
~Kelly W. Black
-Original Message-
From: [EMAIL PROTECTED] [mailto:CZachary;wiley.com]
Sent: Monday, November 11, 2002 1:48 PM
To: Adolfo Bello
Cc: Black, Kelly W [PCS]; Mysql Lists
Subject: RE: /tmp/mysql.sock question (newbie)
There is a cleanup script run via cron that removes files from
Michael I have a nice perl program I wrote that I use to dump
from MySql to a tab delimited ASCII file. I would
pass it along if you think it would help...
~Kelly W. Black
-Original Message-
From: Michael T. Babcock [mailto:mbabcock;fibrespeed.net]
Sent: Monday, November 11, 2002 2:38
, query
~Kelly W. Black
-Original Message-
From: Mertens Bram [mailto:bram-mertens;linux.be]
Sent: Friday, November 08, 2002 9:55 AM
To: mysql mailing list
Subject: Re: Error connecting to Mysql via Apache/PHP - Access Denied
(Newbie)
On Fri, 2002-11-08 at 16:51, [EMAIL PROTECTED] wrote:
I
Mysqladmin is seperate rpm
~K Black
-Original Message-
From: SpyProductions Support Team [mailto:support;spyproductions.com]
Sent: Friday, November 08, 2002 11:13 AM
To: [EMAIL PROTECTED]
Subject: MysQL Installation
I just installed the most recent version of MySQL with an RPM
Oh, okay. Sorry about that, the RedHat rpm's puts the admin binary in the
server package, but MySql.com has it in the client's:
$ rpm -qlp MySQL-client-3.23.53a-1.i386.rpm | grep admin
/usr/bin/mysqladmin
/usr/share/man/man1/mysqladmin.1.gz
sql, query
~Kelly W. Black
PS IN the future check out
' '--with-zlib' '--with-openssl=/usr/local/ssl'
'--with-png-dir=/usr/lib' '--enable-magic-quotes=yes'
'--enable-memory-limit' '--enable-trackvars=yes'
If this didn't confuse you let me know I will try to confuse you again.
~Kelly W. Black
sql, query
-Original Message-
From: SpyProductions Support
wanted to be within the bounds of 'good reading'.
Thanks!
Regards,
Kelly Black
Sprint PCS
18200 Von Karman
Irvine, Ca. 92612
949-623-5417
Linux was very clearly the answer, but what was the question again?
-
Before posting
Make sure /etc/hosts has this line
127.0.0.1 localhost
~Kelly W. Black
-Original Message-
From: Kevin Passey [mailto:kpassey;kdpsoftware.co.uk]
Sent: Thursday, November 07, 2002 4:38 AM
To: 'Timothy Venn'; Mysql (E-mail)
Subject: RE: Host not allowed to connect problem
Hello Tim
Try using dashes.
-mm-dd
-Original Message-
From: Andrew Sitnikov [mailto:sitnikov;infonet.ee]
Sent: Wednesday, November 06, 2002 9:39 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: DateTime comparation problems
Hello bugs,
SELECT ... FROM table o WHERE o.date =
I have seen this when Windows was involved.
Windows word and note pads have a different new
line character than Un*x type systems.
Perhaps that's what's foiling the sql query.
~K Black
-Original Message-
From: Gelu Gogancea [mailto:ggelu;arctic.ro]
Sent: Wednesday, November 06, 2002
This is incorrect.
!google new line character linux windows
-Original Message-
From: Gelu Gogancea [mailto:ggelu;arctic.ro]
Sent: Wednesday, November 06, 2002 11:33 AM
To: Black, Kelly W [PCS]; Schroeder, Bradley (Contractor);
[EMAIL PROTECTED]
Subject: Re: Problem importing data from
the Perl program.
Perform query.
sleep 10;
perform query.
sleep 10;
Hope this helps,
~Kelly W. Black
-Original Message-
From: heath boutwell [mailto:heathboutwell;yahoo.com]
Sent: Tuesday, November 05, 2002 7:19 AM
To: [EMAIL PROTECTED]
Subject: RE: Thread Thrashing and 3.23.53a
After
you can get some useful error output about the connect.
Not certain but at least I am trying to help :)
Oh and don't forget sql query! :)
~Kelly W. Black
-Original Message-
From: Steven Webb [mailto:scumola;yahoo.com]
Sent: Tuesday, November 05, 2002 11:20 AM
To: Mysql list
Subject: Re
I have had problems with this kind of statement:
date = DATE
Try
date = 'DATE'
or even
date =curdate();
Note you can subtract
date = curdate()-1;
I have encountered no problems with upper/lower case in Linux
and Mysql.
~Kelly W. Black
-Original Message-
From: John Ragan
So use the C syntx instead.
:)
-Original Message-
From: Steven Webb [mailto:scumola;yahoo.com]
Sent: Tuesday, November 05, 2002 12:21 PM
To: Black, Kelly W [PCS]; Mysql list
Subject: RE: using libmysqld - can't connect to remote DB as client.
Ok, but I'm writing this in C, not perl
-execute(@data);
}
$cursor-finish;
$dbh-disconnect();
The question marks are replaced by real data on the fly from STDIN.
Thanks to Richard Dice for this interesting wrinkle in my brain.
sql,query foo
~Kelly W. Black
-Original Message-
From: Daniel Kasak [mailto:dkasak;nusconsulting.com.au
Also see
http://hotwired.lycos.com/webmonkey/backend/databases/tutorials/tutorial1.ht
ml
It helped me a lot here...
sql query by the man
~Kelly W. Black
-Original Message-
From: Daniel Kasak [mailto:dkasak;nusconsulting.com.au]
Sent: Tuesday, November 05, 2002 2:49 PM
To: Alain
/to/mysql.sock /tmp/mysql.sock
~Kelly W. Black
-Original Message-
From: Paul DuBois [mailto:paul;snake.net]
Sent: Friday, November 01, 2002 6:26 PM
To: CM Miller; [EMAIL PROTECTED]
Subject: Re: Cannot Log into MySQL
At 16:27 -0800 11/1/02, CM Miller wrote:
Still workin' at it here.
Ok
Typically if your OS runs, the mysql will too.
You should only be worried with hardware
if you are running large database apps
on a slow system.
-Original Message-
From: Stephen Hitchner [mailto:steve;number41media.com]
Sent: Friday, November 01, 2002 9:40 PM
To: Mysql
Subject: mysql
Use the ROUND statement
ROUND(sum(CLICKS),sum(IMPS)/sum(CLICKS)*100.0,0),2);
-Original Message-
From: David Garamond [mailto:davegaramond;icqmail.com]
Sent: Sunday, November 03, 2002 2:31 AM
To: [EMAIL PROTECTED]
Subject: rounding behaviour
hi,
mysql select 1/29;
+--+
| 1/29 |
been struggling with this and could really use some help.
Thanks in advance for any ideas.
Regards,
Kelly Black
Linux was very clearly the answer, but what was the question again?
-
Before posting, please check:
http
You might also need to add hostname.
It depends on what GRANT sql statement was
used to add the user id.
Something like
mysql -u userid -p -h hostname dbasename
should work.
If not, check that mysqld is in fact running. You can
use
ps -aux | grep mysql
Regards,
~Kelly W. Black
More appropriately, use curdate()feature from within sql.
select * where date= curdate()-1;
for example
~Kelly W. Black
-Original Message-
From: Benjamin Pflugmann [mailto:benjamin-mysql;pflugmann.de]
Sent: Monday, November 04, 2002 1:06 PM
To: Jim Hogan
Cc: [EMAIL PROTECTED]
Subject
This simply returns me to the documentation.
Thanks
-Original Message-
From: James Northcott [mailto:jnorthcott;dpmg.com]
Sent: Monday, November 04, 2002 12:13 PM
To: Mysql (E-mail)
Subject: RE: Interesting Challenge
mysql SELECT cell, sector,
If you only want one row, then
Try using
mysqlshow variables;
Some variables can be exported to the sql server via the environment table.
For example:
shellulimit=2046
shellexport ulimit
shellmysqld restart
Hope this helps,
~Kelly W. Black
-Original Message-
From: Nissim Lugasy [mailto:lugasy;lerc.nasa.gov]
Sent
Thanks!!!
I appreciate all the help I can get.
I am trying to validate what appears to be a working query, and will
post back to the list as soon as I can confirm it works.
I think many others will benefit from my working this out..
Thanks again and all my best!
~Kelly W. Black
-Original
Try using
shellmysqladmin -u root -p -h hostname databasetobecreated
password:
~Kelly W. Black
-Original Message-
From: Admin-Stress [mailto:meerkapot;yahoo.com]
Sent: Monday, November 04, 2002 2:41 PM
To: [EMAIL PROTECTED]
Subject: newbie: creating database error
After playing around
Make sure you use the complete line of syntax
mysqladmin -u username -p -h hostname create databasename
password: (enter the password to that userid here)
Oh yeah sql query .
~Kelly W. Black
-Original Message-
From: john [mailto:john;cllug.org]
Sent: Monday, November 04, 2002 3:53
The government has a white paper on this.
Just !google benchmark MySQL
-Original Message-
From: Benji Spencer [mailto:ben.spencer;moody.edu]
Sent: Thursday, October 31, 2002 9:36 AM
To: Benjamin Pflugmann
Cc: [EMAIL PROTECTED]
Subject: Re: How much data can MySQL push out?
Sorry, I
Almost all modern unix type systems come with the powerd daemon.
-Original Message-
From: Jan Steinman [mailto:Jan;Bytesmiths.com]
Sent: Thursday, October 31, 2002 10:46 AM
To: [EMAIL PROTECTED]
Subject: UPS (Was: Mysql in Innodb)
From: gerald_clark [EMAIL PROTECTED]
A UPS is of
identifiers in
the select portion. If you try selecting colA, it will
throw an error because it has 3 colA available to
it.
Kelly
--- Veysel Harun Sahin [EMAIL PROTECTED] wrote:
Hello,
I have a problem with select statetement. I need to
query and select
records from multiple tables which have
Pushpinder,
Looks like a file permission problem. Which user do
you have that runs the MySQL daemon (server)? Does
this user have the ability to write to the directory
you've specified as the data directory for MySQL?
Kelly
--- Pushpinder Garcha [EMAIL PROTECTED]
wrote:
Hi
I have set up
Thanks for all the responses on how to import a dump file that will not
write over existing tables and not stop with an error on existing tables -
in other words just add missing tables. As Victoria pointed out, there is no
option in mysqldump to add the appropriate create table option [IF NOT
Best to check out InstallShield's product forums at
http://community.installshield.com. Their users and support staff troll it
and assist persons in need.
Kelly
SQL,MySQL
At 11:52 AM 10/2/2002 +0800, Alice Tan wrote:
Hi, i am doing a project and it is almost nearing release version.
i planned
Hi, I am trying to use mysqldump to dump the structure of a single database
and want the output to make create table commands that include the IF NOT
EXISTS switch so that when the file is imported into an existing database it
does not write over tables with the same name. Does anyone know if
)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Kelly Firkins
Database Developer
Siebel configuration and administration
prompt type:
php c:\path\to\the\test.php
This will invoke the PHP interpreter via command line
and you should see the results you'd expect. As for
the errors... I'm not particularly sharp
troubleshooting IIS.
Kelly
--- Noël [EMAIL PROTECTED] wrote:
Hi,
Finally, I installed mysql and php
Maybe you should be a poet, lol
- Original Message -
From: Jim Bailey [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 20, 2002 7:00 AM
Subject: Constraint Hell
sql, Query
Hark ye experts!
Here I stand an expert grunt.
Trying to understand,
The syntax of constraint.
1 - 100 of 132 matches
Mail list logo