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
IMPORTANT INFORMATION!
This is an automated message.
The message you sent (attached below) requires confirmation
before it can be delivered. To confirm that you sent the
message below, just hit the Reply button and send this
message back (you don't need to edit anything). Once this is
done,
Did you install from the SuSE CD? If so then you have to tell YaST to start
MySQL. You can start it from /etc/rc.d/mysql. If you want to use PHP you
will need to tell YaST to install PHP for apache as well. SuSE has made
running MySQL and PHP so easy by using YaST. Also run YaST to update PHP
Ok, Let's try this again, for some reason this didn't post from early today.
I have db that has two tables that I am needing to post the same information
into both tables, I can't use ID. So I am want to see if there is a sql
statement that will let me or how I can do with a php page.
I am
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
Hi,
I would like to know if there is a way that I can pass on an information
from a pull down menu into a sql query. Right now I have to right a PHP page
for each piece I am wanting to pass on. Example I have a movie database and
now if I want to see what is in my Anime Category that starts with
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
Ok,
I guess I have to re-state what I needing help with. I have a database with
three date fields. If I do a date_format for all three fields I get error.
Example
SELECT DATE_FORMAT(DATE1, '%M %D, %Y) as DATE1, DATE_FORMAT(DATE2, '%M %D,
%Y) as DATE2, DATE_FORMAT(DATE3, '%M %D, %Y) as DATE3,
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:
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
A friend of my who is a programmer helped me only after I gave up on the
mailing answering me. So it is fix now. I had to the following...
// This is the actor query
$sql = SELECT concat_ws(\ \, fname, lname)as actor FROM actormovie WHERE
title = '$title';
$result = mysql_query($sql);
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
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/
Hi,
I have a design question for mysql database that I am wanting to create a
my movies collection. I was going to do as one-to-one database, but I see
now that I need to do as a one-to-many. I have never done a one-to-many but
I see that is the way to go.
I guess then is can someone show me
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
Hi again...
When I felt proud because last week I had asked about how to use NOW(), and
get answer that got me working, but now I have a strange problem. It listing
dates, but it not listing like it should, when the web page is create it
going 9, 8, 5, 10 on the dates. Here is the SQL statement
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
-
From: Chuck PUP Payne [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 10:49 AM
To: MySQL Mailing List (E-mail)
Subject: no subject
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
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
Hello again,
I am trying to set up a SQL statement using NOW(), what I am wanting to do
is to use NOW() then do a search on any date less than 7 days. Before I get
several e-mails asking why. I am trying to a news base database for the
company intranet and I am wanting to only show newsitems
Hi,
I have set up a user call FooBar and I have set up the host that FooBar can
access from %, but everytime I go to a different machine I get an error that
FooBar can't access mysql from that machine IP address. Why isn't the
wildcard (%) working?
I am using 3.23.44 with mysql-max. Any clues
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
If you are using KDE, there a great gui mysql program called kmysqladmin,
that you can download and install and have running within second, it comes
all versions of Sues and a great guy to work with. I know that on the
website there is a tar ball and a Red Hat version.
Use google.com to find it.
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
Ok, if never run it then you have to start once, if I remember right undex
Red Hat, you have to go to /etc/rc.d/init.d and do this...
./mysql start that will start it
Then you will need to set it up so it will start later. SuSE you have to
start it once
You will then need to set a password
for beginner? man
DBD::mysql is difficult to understand. Thanks again for the info.
From: Chuck \PUP\ Payne [EMAIL PROTECTED]
To: Doug Thompson [EMAIL PROTECTED], Andy Cheng
[EMAIL PROTECTED], Intrex [EMAIL PROTECTED],
[EMAIL PROTECTED] [EMAIL PROTECTED]
Subject: Re: Mysql
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 and
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
Hi,
I a seting up a php page that will let me delete a record from my mysql
database, but I want it be able to match to fields before it will let a user
delete that record. I know the basic sql command is
DELETE FROM $table WHERE field 1 = $value
But I don't know how to write the state for
To: Chuck PUP Payne; [EMAIL PROTECTED]
Cc: PHP General
Subject: Re: Deleting a Record
At 7:46 -0500 3/6/02, Chuck \PUP\ Payne wrote:
Hi,
I a seting up a php page that will let me delete a record from my mysql
database, but I want it be able to match to fields before it will let a
user
delete
47 matches
Mail list logo