Guys,
I have been fighting with mysql trying to get it to only show every after
the last dot(.) on a ip. for example
instead geting 10.0.0.0 only get 10.0.0
But what every I try doesn't work. Can someone pls point to a web page
where I can learn how to do it, of explain it here.
Thanks.
Payne
Yes, sorry. I have a database that records ip of attacks on a customer
server, what I like to do get a count so that I can see what subnet is
doing the major of the attacks.
select ip from ipslimit 10;
+-+---+
| ip | count(ip) |
+-+---+
Thanks Glyn,
What you have given me works. I have taken it so now I get anything
greater that one
select substring_index(ip,'.',3), count(*) from ips group by 1 having
count(*) 1 order by 2 desc limit 10;
+---+--+
| substring_index(ip,'.',3)
Hi,
I am currently using SuSE and like to be able use myisamcheck when start
up mysql. Is there a command that I can added to my init.d script that
would do that.
Thanks,
Payne
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
the desc with out the boxes.
Can someone help me? I need the box because I am going to cut these
tables out so I can map out the relatation to them.
Thanks,
Payne
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
hi, I got a table where the myi isn't able to re be read. I tried to run
myisam but it give an error about the index.
Do I need to drop the table? Can it be repaired?
Payne
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
Hey,
been trying to output a select statment to a file, all the books I have
only show how to input from a file, what is the correct way
I thought I could do select * from my_toy `/tmp/my_toys`
But I get an error.
Payne
--
MySQL General Mailing List
For list archives: http
Hey,
I got a box that is dying, it is currently running MySQL-Max, I want to
move the DB from it to a box that is running just plain jane MySQL, what
will happen and will it work.
I know, strange but I am not sure what the Max does.
Payne
--
MySQL General Mailing List
For list archives
statement I am doing now.
select count(*), date from my_db group by date;
Thanks, for any help you can give me.
Payne
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks, this and the from ISC Edwin Cruz helped, it what I was wanting.
Payne
Sameer wrote:
Payne wrote:
Hi,
I having a problem doing a simple count with the way date is format
2005-12-11 21:49:36, what I am wanting to do is a simple count where
it only returns just the date. What do i
, at 3:24 AM, Boysenberry Payne wrote:
I tried using
`mysqldump $log -v -Q -c --set-charset --default-character-set=utf8
--add-drop-table --add-locks --create-options --disable-keys
--extended-insert --lock-tables --quick $db_name -r $bk_file 21`
and I still get
-- MySQL dump 10.9
--
-- Host
, 2005, at 4:57 PM, Boysenberry Payne wrote:
Is this the wrong list to ask this on?
If so can someone suggest a better list?
Am I missing something in my analysis of my problem?
Did I not include enough info?
Could it be a problem with perl scripts?
Thanks,
Boysenberry
boysenberrys.com
I'm having difficulty getting certain special characters to stay the
same when I export databases.
Here are some of the examples:
View of data from phpMyAdmin:
Habitat is a “what you see is what you get� or “WYSIWYG�
View from table dump via phpMyAdmin export:
Habitat is a “what
I think the problem is mysqldump uses this:
DEFAULT CHARSET=latin1
with --set-charset
How can I get it to use utf8?
Thanks,
Boysenberry
boysenberrys.com | habitatlife.com | selfgnosis.com
On Nov 7, 2005, at 8:46 PM, Boysenberry Payne wrote:
I'm having difficulty getting certain special
for any help you can give.
Payne
?
$db = mysql_connect(127.0.0.0,fred,mrbill);
mysql_select_db(links,$db);
$result = mysql_query(SELECT url FROM sponsors order by
rand() LIMIT 1, $db);
if ($myrow = mysql_fetch_array($result
Has 4.0 Been offical release, I thought it was still in Beta?
-Original Message-
From: Josh Wilson [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 22, 2002 10:32 AM
To: [EMAIL PROTECTED]
Subject: Re: MySql 5.0
When can we expect a release of 5.0 with stored procedure
functionality in
Hi,
I have database that has grown in size, I want to see what ID files have
been deleted. Is there a way or do I have to print out the list and find
them myself?
Is there a sql or query statement that will let me find them.
Chuck Payne
Hi,
I wanting to know what the sql statement is that will let me get the total
of database. The feild is amount. I have tried a couple of sql statement and
have even looked at mysql 6.3.3.1 Arithmetic Operations. But I am lost.
Chuck Payne
Magi Design
PROTECTED]
To: Chuck Payne [EMAIL PROTECTED]
Subject: Re: How many days out...
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query
If you just reply
Hi,
I am having problems get how many days out an invoice is from mysql. I have
try this.
SELECT NOW()-summitted_date FROM table;
But it not working as usually. So please guys a little help.
So If an invoice was summitted on 9-26-02 then I should be able to see that
5 days.
Chuck Payne
Magi
Hi,
I am having problems get how many days out an invoice is. I have try this
sql statement.
SELECT NOW()-submmitted_date FROM table;
But it not working as usually. So please guys a little help.
So If an invoice was submmitted on 9-26-02 then I should be able to see that
5 days.
Chuck Payne
think a
round $500.
But hey that my 2 Cents.
Chuck Payne
Magi
-Original Message-
From: William R. Mussatto [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 12:29 PM
To: Insanely Great
Cc: Ibrahim Al-Tawil; [EMAIL PROTECTED]
Subject: Re: Urgent!!
On Sun, 29 Sep 2002, Insanely
: [EMAIL PROTECTED]
To: Chuck Payne [EMAIL PROTECTED]
Subject: Re: RE: Urgent!!
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query
If you just reply
you are doing. I might be able to help a little.
Chuck Payne
Magi Design and Support
Account Protect by ASK!
-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 2:52 PM
To: Jan Steinman
Cc: [EMAIL PROTECTED]
Subject: Re: FileMaker Pro Schema
there been an update on 7.3.
If you need any more help. Let me know I have used SuSE since 5.3 and I am
currently on 8.0.
Chuck Payne
On 9/27/02 7:27 PM, DeNewbie [EMAIL PROTECTED] wrote:
I am new to this newsgroup and I am a SUSE Linux 7.3 user. I want to learn how
to use PHP and MySQL and I
Hi,
I have a question. I have two tables that I want to post data too. Is there
a way to do a sql statement that lets me post data two tables at the same
time?
Thanks,
Chuck Payne
-
Before posting, please check:
http
sorry to ask, I have looked around to see if there any on the net or in
my mysql and php books but this seems like a weird task.
Chuck Payne
Magi Design and Support
-
Before posting, please check:
http://www.mysql.com/manual.php
'mysql' there need to be a better filter. Yes, We get this letter 20 times a
weeks. I will forward this on to the FBI to add to their list.
-Original Message-
From: Clive Smart [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 9:55 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL
Hi again,
I need to change cross 600 records that have 'Null' in the field and I need
to change it a value. What is the sql statement that will let me change that
field.
Chuck Payne
Magi Design and Support
-
Before posting
Well I am glad for the help :). I am get an old table clean up but need to
re-index my table. I think there is on small problem. It's is ISAM table and
not myISAM.
Chuck Payne
Magi Design and Support
Mysql and sql
-
Before
Hi,
I got a small problem I can't seem to do a sql statement that will pick on
the first letter of word in a feild. I have over 700 record in a database,
but I like to be able only to see those that let say start with D. How can
I do a statement that will let me do that.
Chuck Payne
Magi Design
is where I am lost.
Chuck Payne
Magi Design and Support
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL
Hi,
This might be a strange question, but can you do date_format when you do a
myrow? Or does date_format as always have to be done in a sql statement?
Does anyone have an easy of doing dates?
Chuck Payne
Magi Design and Support
, Groom, Bride FROM
DB1;
Now I am using this sql statement in a PHP page. I want to see if you can do
sql statement in $myrow, but don't think you can. So I want to know if there
is an easy way to do dates.
Thanks if you can help or will answer.
Chuck Payne
Magi Design
I would buy a book called PHP Essentials. www.thickbook.com
I used it to learn how to write an html/php interface to my databases and i
use it all the time now. It takes a bit of work to get the interfaces built
but the book is really easy to follow and understand.
seth
-Original
You can go this link and get MySQL in package form it works great...
http://www.entropy.ch/software/MacOSx/mysql
Hope this helps.
Chuck Payne
Magi Design and Support
http://www.magidesign.com
-
Before posting, please check
In SuSE you should be able to start the MySQL server by:
rcmysql start
or
rcmysql restart
rcmysql is a symlink to the /etc/init.d directory
-Original Message-
From: John Macloy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 2:26 AM
To: [EMAIL PROTECTED]
Subject: AW: AW:
Have you went into YaST and turn it on? I won't run until you do so. You
can start it yourself as well;
/etc/rc.d/mysql start
Chuck Payne
On Monday, July 1, 2002, at 09:47 AM, Cal Evans wrote:
What's your log file say?
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http
done
By going into YaST2/YaST and telling it to start mysql it will start it
from boot up. For more help with SuSE and start up daemons feel free to
write me ok. This isn't really mysql fault, it the way SuSE control
things.
Chuck Payne
Magi Design and Support
Is the mysql mail list down?
sql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To
Use Limit is one way
On 6/25/02 12:19 PM, Mark S Lowe [EMAIL PROTECTED] wrote:
Is there a nifty way to select just that last 100 records with MySQL? In
Oracle I use Maxrows and date to accomplish this. Can¹t seem to figure this
out with MySQL.
Please advise! Thank you!
Mark
no was going to help me, since no answer after a
day.
Chuck
On 6/15/02 10:42 PM, Zak Greant [EMAIL PROTECTED] wrote:
On Sat, 2002-06-15 at 05:31, Chuck Payne wrote:
...
// Some where here it's not working.
$sql = SELECT concat_ws(' ', fname, lname)as actor FROM actormovie WHERE
title = '$title
If you aren't good with sql commands you could try one of the many gui
interfaces that are out that, I use phpMysqlAdmin and Kmysqladmin (KDE) they
work really great at alter tables.
Chuck Payne
On 6/14/02 6:51 PM, Peak Digital Productions [EMAIL PROTECTED]
wrote:
Thank you - I'd already
actormovie WHERE
title = '$title' ORDER by lname;
$result = mysql_query($sql);
print $sql;
$actor = ;
while ($myrow = mysql_fetch_array($result)) {
$actor = $myrow[actor];
$actor .= A HREF='' . $actor . /ABR\n;
}
What am I doing working.
Chuck Payne
If you have mutli-date fields, can you set one date format in mysql sql
statement for all fields? I have 9 date fields, that like to have the same
format. Also I don't want it to work fields that have -00-, can I
tell not to show those?
Hi,
This may be a stupid question how do you create a database with join tables
in mysql?
Chuck Payne
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
head is spinning with trying to
understand on one-to-many works.
Chuck Payne
Magi Design and Support
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
I am just checking to see if the mysql server is down I haven't gotten any
e-mails today?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Yes have to turn it off in my.conf
-Original Message-
From: Scott Olson [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 12, 2002 12:47 PM
To: [EMAIL PROTECTED]
Subject: Turning off innodb
Is it possible to turn off Innodb in MySQL 4.0 via
the my.cnf file? Or command line params or
Hi,
I got a small problem I like to be able to read a DATE but I don't want to
read the Year. I only want to read the month and the date. For example, I
like to read the a Birthday Field to see who Bithday is today. Also like to
be later be able to read that same field but this time the year so
',
'%H %k %I %r %T %S %w');
- '22 22 10 10:23:00 PM 22:23:00 00 6'
mysql select DATE_FORMAT('1999-01-01', '%X %V');
- '1998 52'
Mike
- Original Message -
From: Chuck PUP Payne [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 11, 2002 7:42 AM
Subject: Another
on 4/11/02 8:02 AM, Mike at [EMAIL PROTECTED] wrote:
Sorry, Do you mean to use the date in a WHERE clause? I've use php's date
function to supply a date for a WHERE clause in a sql statement.
Mike
- Original Message -
From: Chuck PUP Payne [EMAIL PROTECTED]
To: Mike [EMAIL
Sorry that second 2002 should be year. I don't want to change year to get it
to work.
Chuck
on 4/11/02 8:10 AM, Chuck PUP Payne at [EMAIL PROTECTED] wrote:
Mike and the mysql list,
This is the SQL statement I am using now;
SELECT DATE_FORMAT(DOB, '%M %D, %Y') as DOB, Fname, Lname, Email
Payne
Magi Design and Support
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED
Ok, I know I am going to get yell about this but how can I do an SQL and
only show to fields from a table. For example I only like to see the names
and birthday? Or will as so all fields for a given table.
Chuck Payne
-
Before
Thanks, I got it :) I am using phpMySQL and command line and I couldn't see
anything because it was showing everything but now I am cool. Again everyone
thanks.
Chuck Payne
On 4/8/02 12:03 PM, Rick Emery [EMAIL PROTECTED] wrote:
SELECT name,birthday FROM mytable
-Original Message
Thanks, My book that I have been studying from, only show commands and no
examples. MySQL web had want I wanted at the very top.
I have finish my page now.
Chuck
on 4/6/02 11:46 PM, Georg Richter at [EMAIL PROTECTED] wrote:
On Sunday, 7. April 2002 05:56, Chuck \PUP\ Payne wrote:
Hi,
I
that are 7 days or
less. And I want NOW() to set today date and then go back as far as seven
days. But I am not sure now to use less than in my statement with NOW(),
or if it will work.
| Chuck Payne |
| Magi Design and Support |
| www.magidesign.com
would be great. Thanks.
| Chuck Payne |
| Magi Design and Support |
| www.magidesign.com |
| [EMAIL PROTECTED] |
BeOS, Macintosh 68K, Classic, and OS X, Linux Support.
Web Design you can afford.
Never be bullied
Hi,
I am wondering is there a way to set up user that can log in from anyplace?
I know I need to set this user up with the %(I hope this is the wildcard
for) mysql.
Thanks,
Chuck Payne
-
Before posting, please check
You don't need samba you can do it from a command line...
...mysql -u user -h hostname or ip -p
Sorry for the ... Thast is not part of the command just outexpress like to
make things captial where they shouldn't be.
Chuck
on 3/23/02 10:02 AM, Paul Gilbert at [EMAIL PROTECTED] wrote:
Hi Egor
it.
Chuck Payne
Magi Design and Support
On 3/21/02 10:44 AM, Victoria Reznichenko
[EMAIL PROTECTED] wrote:
Nguyen,
Thursday, March 21, 2002, 5:53:08 AM, you wrote:
NHN I am using Linux Red Hat 7.2 and I want to execute
NHN mysqlgui. After I start this program, have a error is:
NHN Can't
I need to do a search where I am looking at the table that has dates and I
need to look only things that are 30 days or younger.
Can so one show me a some SQL statements where you use , ? And the key
for equal to or less?
Chuck Payne
Magi Design
Ok, strange question. I have delete some records and I have notice that ID's
are no longer in order when I do a SQL statement. Why is that? What can I do
put the records back into order?
| Chuck Payne |
| Magi Design and Support
of your query..
Is this what you were asking? If not , can you give more insights of what
the query was returning before the deletion, and what it is returning now
and what you'd like it to return?
Thanks,
Gurhan
-Original Message-
From: Chuck PUP Payne [mailto:[EMAIL PROTECTED
it to return?
Thanks,
Gurhan
-Original Message-
From: Chuck PUP Payne [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 12:23 AM
To: mysql lists.mysql.com
Subject: ID order...
Ok, strange question. I have delete some records and I have notice that ID's
are no longer
?
Chuck
on 3/19/02 1:20 AM, Gurhan Ozen at [EMAIL PROTECTED] wrote:
Hi,
Just add order by ID in your query it will give you the results in the way
you'd like...
Gurhan
-Original Message-
From: Chuck PUP Payne [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 1:17 AM
for mysql.
I hope that helps.
| Chuck Payne |
| Magi Design and Support |
| www.magidesign.com |
| [EMAIL PROTECTED] |
BeOS, Macintosh 68K, Classic, and OS X, Linux Support.
Web Design you can afford
Sorry I don't know perl. I am PHP man. And I am stll trying to learng mysql
so that I can get it working to the way I want.
Chuck Payne
Magi Design and Support
on 3/10/02 7:30 PM, Andy Cheng at [EMAIL PROTECTED] wrote:
Thanks for the help. I got it working. I could connect to mysql from
Hi,
I not a newie but I am not a pro at mysql either. I want to do a query by
letter(a, b, c..ect.). Is there a simple way to do it. I am writing in PHP.
So can someone please so me the how.
| Chuck Payne |
| Magi Design and Support
like the example
above.
Chuck Payne
Magi Design and Support
on 3/10/02 9:42 PM, Cary at [EMAIL PROTECTED] wrote:
At 08:24 PM 3/10/02, Chuck \PUP\ Payne wrote:
Hi,
I not a newie but I am not a pro at mysql either. I want to do a query by
letter(a, b, c..ect.). Is there a simple way to do
so a sort like the example
above.
Chuck Payne
Magi Design and Support
on 3/10/02 9:42 PM, Cary at [EMAIL PROTECTED] wrote:
At 08:24 PM 3/10/02, Chuck \PUP\ Payne wrote:
Hi,
I not a newie but I am not a pro at mysql either. I want to do a query by
letter(a, b, c..ect.). Is there a simple
You can't log as root because a password has been set. You need to log like
this
root@yourbox# mysql -u root -p
It will then ask you for a password
If you ever have to log onto another box use a -h hostname.
| Chuck Payne |
| Magi Design
Paper e-mail.
Chuck PUP Payne
Sr. System Administrator
GDI Engineering, Inc.
2075-E West Park Place Blvd.
Stone Mountain, GA 30087
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
for a second field. Can some one
tell, but one field seem to give too much choose and would make it to easy
to delete the wrong record.
| Chuck Payne |
| Magi Design and Support |
| [EMAIL PROTECTED] |
BeOS, Macintosh 68K
Thanks I have now five ways to try.
| Chuck Payne |
| Magi Design and Support |
| [EMAIL PROTECTED] |
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 06, 2002 10:43 AM
I had the same problem too. If you go to CPAN and then go to DBD::Mysql,
click on the ftp site to
Jochen Wiedmann's directory and scroll past the one that says DBD-Mysql-yada
to the one that says Msql-Mysql-modules-1.2216.tar.gz and install that one
instead, it should work. Worked like a charm
Signing the applet will allow the applet to make the connection. The user
of the applet will have to accept and install the certificate use to sign
the applet.
- Original Message -
From: "Carfield Yim" [EMAIL PROTECTED]
To: "Paulo Mora de Freitas" [EMAIL PROTECTED]
Cc: [EMAIL
78 matches
Mail list logo