suggestions or ideas I would appreciate it as I am plumb out of them! :)
TIA
--
Cheers
Mike Morton
*
* Tel: 905-465-1263
* Email: [EMAIL PROTECTED]
*
Indeed, it would not be an exaggeration
be skipped...
My $0.02...
Dan Greene
-Original Message-
From: Mike Morton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 06, 2004 2:15 PM
To: [EMAIL PROTECTED]
Subject: Sleeping Processes
I have a mysql database that is running in conjunction with a
PHP website
not necesscarily see a performance
boost by using stored procedures for everything, in fact a MySQL server handling a lot
of stored procedures could very well show poorer performance than a proper n-tier
application.
Regards,
Mike Hillyer
www.vbmysql.com
--
MySQL General Mailing List
For list
not sure of any standards for nested functions and control structures such as
that. Anyone have any input on that?
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
of my query that are dynamic. So if I have the user enter a name to search
for I would do:
$query = SELECT * FROM mytable WHERE username = ' .
mysql_real_escape_string($userdata) . ';
You should escape anything you do not trust.
Regards,
Mike Hillyer
www.vbmysql.com
--
MySQL General Mailing
I have table with 7 fields. First field is id (auto increment). As I
understand the value should start from 0 and next value will auto
increment.
And I shouldn't add insert the value. So the insert
statemens below gives me an error. ERROR 1136:Column count doesn't match
value count at row 1
PROTECTED]
Subject: Re: insert: auto increment field
Date: Sun, 04 Jan 2004 08:44:56 -0700
On Sun, 2004-01-04 at 08:09, Mike Mapsnac wrote:
I have table with 7 fields. First field is id (auto increment). As I
understand the value should start from 0 and next value will auto
increment.
And I shouldn't
I delete all records from the table and cannot insert second element to the
table. Auto increment starts with higher number ..
ERROR 1062: Duplicate entry '2147483647' for key 1
From: Larry Brown [EMAIL PROTECTED]
To: Mike Mapsnac [EMAIL PROTECTED],MySQL List
[EMAIL PROTECTED]
Subject: RE
It solved the problem. But what truncate does? Just deletes the rows?
From: Daniel Kasak [EMAIL PROTECTED]
To: Larry Brown [EMAIL PROTECTED],Mike Mapsnac
[EMAIL PROTECTED], MySQL List [EMAIL PROTECTED]
Subject: Re: insert: auto increment field
Date: Mon, 05 Jan 2004 11:18:08 +1100
Thanks.
Just for curiosity. Why truncate was necessary in my case? I just create a
table and try to insert some values.
From: Daniel Kasak [EMAIL PROTECTED]
To: Mike Mapsnac [EMAIL PROTECTED], [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject: Re: insert: auto increment field
Date: Mon, 05
I create two tables. And when I do
desc table_name;
NULL value can be 'Yes' or 'No'. What the difference when NULL value is
'Yes' or 'No
Thanks
_
Worried about inbox overload? Get MSN Extra Storage now!
values: Yes, No,
and NULL.
NULL simply means no value. Sometimes it is appropriate, sometimes it is not. In the
case of a Yes/No ENUM column I would say that in most cases the column should be set
NOT NULL.
Regards,
Mike Hillyer
www.vbmysql.com
--
MySQL General Mailing List
For list archives
I don't have enough space on /var/lib/mysql partition. What logs can be
deleted from the partition?
Is it possible don't delete last logs?
Thanks
_
Worried about inbox overload? Get MSN Extra Storage now!
I use MYSQL 4. I can modify or alter a column with no problems. But how I
can alter table and setup Default value. The column below has default value
NULL, but I want to setup default value used. How that's can be done?
type | enum('new',used') | YES | | NULL||
I'm trying to open mysql.sock file as a ROOT and receive the error message
permission denied.
Why mysql.sock has such permission?
_
Tired of slow downloads? Compare online deals from your local high-speed
providers now.
The replication between two servers works. But I tried to disable
replication on one table. According to the MYSQL Documentation. I did the
following:
#1 stop Slave
#2 Modified my.cnf on slave
[mysqld]
server-id=3
master-host=192.168.1.129
master-user=aert12
master-password=password
I made a mistake of not giving a name to an index.
alter table sometable add index ( field1, field2 )
I would like to remove this index but I can't figure it out.
If you perform SHOW INDEX FROM tablename; what do you get as the key_name? Try
dropping it based on what you see.
--
MySQL
I run update on the database which by my mistake updated all rows. Is it
possible somehow go back to previous state before the update?
_
Have fun customizing MSN Messenger learn how here!
Hi,
can the auto_increment value be reset back to '1' withou recreate the entire
table again ?? The table would be emptied first, but we would like to reset the
auto_increment value back to '1' without having to drop and recreate the table,
if possible.
MySQL version 4.0.15 Linux
TIA
--
By mistake I deleted all users in MYSQL. So, how can I login to the mysql?
Is it possible to add a user to my.cnf file?
Thanks
_
Grab our best dial-up Internet access offer: 6 months @$9.95/month.
Carlonie,
Use the UPDATE. I assume you mean by database here you mean the database table
named members... if so, try the following query.
UPDATE members SET user_name = 'john_doe' WHERE user_name = 'John Doe';
--
MikemickaloBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet
This is what we did.
root [~] #rpm -qa | grep MySQL
MySQL-client-4.0.15-0
MySQL-embedded-4.0.15-0
MySQL-devel-4.0.15-0
MySQL-shared-compat-4.0.15-0
MySQL-shared-4.0.15-0
MySQL-server-4.0.15-0
# Now remove the RPM's
rpm -e --nodeps MySQL-server-4.0.15-0
rpm -e --nodeps MySQL-embedded-4.0.15-0
rpm
I want to stop replication for one table in the database. According to the
mysql documentation: I need to add the parameter
(replicate-wild-ignore-table ) to the my.cnf file. I have some question.
#1 In what database I should made the change to my.cnf? Slave or Master?
#2 Than I should restart
I had an account mike to mysql. But somehow I change the password. So now
I have just one access to the system as root.
Trying to login to mysql as root with password and without password no
success. Root password is: 123456.
What I'm doing wrong? I cannot connect to MYSQL as root.
[EMAIL
structure.
On the plus side, if you add a column to the db, all you need to do is add a field of
the same name to the HTML form.
In a nutshell, while it's useful to do things like abstract the construction of the
query, it's often not worth the trouble.
--
Mike Johnson
Web Developer/Systems Asst
Hello,
Was wondering if any one on the list has or is using PremiumSoft Navicat's MySQL
Administration Tool for windows, and if so, any thoughts on it... good,
excellent, poor...etc.
Appreciate the feedback ;)
TIA
--
MikemickaloBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain
, but it might be worth a shot.
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
; either side of [EMAIL PROTECTED] are
two separate args to be stored in two separate columns.
This should work...
GRANT ALL ON *.* TO 'me'@'mysite-dev.foo.com' IDENTIFIED BY 'foo';
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing
From: Paul DuBois [mailto:[EMAIL PROTECTED]
At 13:29 -0500 12/16/03, Mike Johnson wrote:
From: Ari Davidow [mailto:[EMAIL PROTECTED]
I seem to have run into a problem with a host name that
incorporates a hyphen:
mysql GRANT ALL ON *.* TO [EMAIL PROTECTED]
IDENTIFIED BY foo
If an INT has a fixed range, then what is the point of giving it scale? As
in, int(12).
In Oracle, a NUMBER(12) indicates how many digits you could have (in this
case, 999 would be the max value).
Would an int(2) allow -99 to 99, or -2147483648 to 2147483647?
That's because in
No setup file is included in the ZIP mysql-4.1.1-alpha-win.zip
Do you know why ??
It is alpha software, expect an installer with the final version. In the meantime just
extract the zip file into a directory and it should run.
--
MySQL General Mailing List
For list archives:
Is anyone aware of international standards for field lengths for commonly
used database fields?
I.e
Firstname
Lastname
Address
City
State
Etc
The basic contact information for a user...?
If anyone knows of a standard, please email me a link or reference to it.
Thanks :)
--
Cheers
Mike
], not just the last one.
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
parser from thinking that the opening for Password is a close of the string? I
use single quotes in that kind of situation, FWIW.
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
off would result in the actual join query returning
nothing.
Let me know how those turn out...
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
...
LOAD DATA LOCAL INFILE '/path/to/file'
INTO TABLE tablename
FIELDS TERMINATED BY ','
OPTONALLY ENCLOSED BY '';
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
. In that case you'd be right
back at the drawing board. If you build it that flexible from day one, though, he can
change his mind to his heart's content.
Anyway, good luck!
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list
Hello,
been trying to figure out the correct SQL query to get
percentage from a table that list a Min, and Max., price
range and the percentage associated to the range.
Here is the current data in the table:
1 0.00 4999.00 13.0
2 5000.00 .00 12.5
3 1.00 14999.00 12.0
4 15000.00
Sorry..
The query should be:
select percentage from table_name where
min = 500.00 and 500.00 = max;
database.
Original Message
Subject: Query Range
Date: Mon, 08 Dec 2003 11:23:28 -0600
From: Mike Blezien [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Organization: Thunder Rain
properties.area, images.image_filename FROM properties,
images WHERE properties.reference_number=images.reference_number AND
properties.area='$id';
HTH!
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list archives: http
Hopefully someone can help me out with this -
I have two tables in mySQL: comments and diary
I want to populate a new field in comments with the current values of diary
- but only if they meet certain criteria.
Now, the problem is this - my webserver is using an older version of mySQL
that
Hello,
what is the best way to convert a TIMESTAMP value to a value
similar to a DATETIME value ??
thx's
--
MikemickaloBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Quality Web Hosting
, actually. The middle two? Or should it pick one?
Good luck either way.
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hi all,
Can someone show me how to lock a record in mySQL?
As far as my understanding goes, only innoDB tables support record locking
level. I am currently using mySQL version 3.23 and my tables are in myISAM.
Thanks in advance for any assistance.
Mike
since). The status for the process usually says
'killed' if that helps.
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
/INSERT_SELECT.html
JOIN syntax
http://www.mysql.com/doc/en/JOIN.html
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ron Albright [mailto:[EMAIL PROTECTED] wrote:
This is somewhat ambiguous. From the statements below it would appear to me
that you can ship MySQL with an application as long as the your application
does not directly link to the MySQL libraries as would be the case if
embedded. But mere
We just downloaded MySQL Front the other day... and it's one
of the best that I have seen in awhile :)
just my $0.02
--
MikemickaloBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Quality Web
One of the first things that I did at my former job was to turn off all
external-facing network adapters to our DB machines. If you're fortunate
enough that your DB resides on it's own box and not the webserver itself,
then there's really no reason that you *need* to have it externally facing.
and also covers opening and closing SSH tunnels from within Visual
Basic.
In any case, I hope you find these of use!
Regards,
Mike Hillyer
www.vbmysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi All;
I inherited an old Access database at work which was not at all normalized. I then
managed to normalize the schema, but I am running into problems. First let me show you
the two tables I need to query:
--
# Host: 10.1.1.14
!
Mike
On 11/26/03 2:22 PM, Jeremy Zawodny [EMAIL PROTECTED] wrote:
If so, could you ping me off-list? I'd just like to ask a few quick
questions.
Thanks,
Jeremy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
I couldn't ask for more :)
Mike
On 11/26/03 3:40 PM, Jeremy Zawodny [EMAIL PROTECTED] wrote:
On Wed, Nov 26, 2003 at 02:30:42PM -0500, Mike Minard wrote:
I would rather see these questions and answers in the list if you don't
mind. We are setting-up a MySQL cluster right now with active
. (The services control panel will report a startup
failure, and after that dialog, the mysql server will no longer answer
requests.
Fix:
Submitter-Id:submitter ID
Originator:Mike Peck
Organization:
Allnight Computing
MySQL support: none
Synopsis:Service dies as non LocalSystem user
As for a book, I recommend the one on PHP and mySQL web development by Luke
Willing and Laura Thompson.
Good luck!
Richard
I would second that reccomendation. Luke Welling and Laura Thompson have a really good
book. ISBN 067232525X.
--
MySQL General Mailing List
For list archives:
wanted to know if one can write a Function or a procedure in a mysql 4.0.12..???
This is not going to be supported until MySQL 5.
Also about this data dump, i went to C:\ and typed mysqldump test. .. this thing ran
for quite some time but where was the dump finally could figure that out ..
You are correct. I interpreted Function or a procedure to be the
questioner referring to stored procedures with two seperate terms.
Mike Hillyer
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 25, 2003 8:06 PM
To: mike
Cc: [EMAIL PROTECTED
I always gone with ENUMs b/c TINYINT(1) still allows you to insert a '2'
into the field and the last idiot at my current job actually used '0'
for 'true' in a some fields in some tables.
I believe both would use 1 byte.
Mike
Paul Fine wrote:
Normally for a column with 2 possible values, I
Hello,
I need the ability to round off dollar amounts to the
nearest 100th of a dollar amount, IE $14.9564 to $14.96 or
$132.1123 to $113.11
can this be accomplished with MySQL SQL function ??
TIA
--
MikemickaloBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
DuBois wrote:
At 16:34 -0600 11/22/03, Mike Blezien wrote:
Hello,
I need the ability to round off dollar amounts to the nearest 100th of
a dollar amount, IE $14.9564 to $14.96 or $132.1123 to $113.11
can this be accomplished with MySQL SQL function ??
Sounds like a job for TRUNCATE().
http
Thanks Peter.
I strongly suspect that I'm getting deadlocks where it's simply a lock contention.
Grrr.
I chose BDB because my client has it available on his installation. I'll configure
InnoDB support
if necessary. It looks like a LOT less headache.
Thanks.
- Mike
the transaction ?
3. If the transaction has been rolled back, what is a reasonable number of times to
re-start the
transaction ?
- Mike.
__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
--
MySQL General Mailing List
For list archives: http
.
Mike Boone
(reply to the list or contact me directly at:
http://boonedocks.net/mailmike.php3)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello Santino,
I tried to formulate my query as you suggested. According to EXPLAIN, MySQL
seems to process it the same way as my first query, working first on table C
and using where, temporary, and filesort.
Thanks,
Mike.
-Original Message-
From: Santino [mailto:[EMAIL PROTECTED]
Sent
.
Mike.
-Original Message-
From: Matt W [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 19, 2003 9:25 PM
To: Mike Boone; [EMAIL PROTECTED]
Subject: Re: Optimizing Custom Full Text Index
Hi Mike,
Those tables aren't that big for what you're doing (which is about how
I'd do it if I
Mike Morton
*
* Tel: 905-465-1263
* Email: [EMAIL PROTECTED]
*
Indeed, it would not be an exaggeration to describe the history of the
computer industry for the past decade as a massive effort
much precision since
you only wanted the date, not the time.
http://www.mysql.com/doc/en/DATETIME.html
Mike
On Thursday 13 November 2003 16.15, Mike Morton wrote:
I am trying to change a column specification, a date column, so that the
default value is the current date. Is this possible
select a timestamp as...
SELECT DATE_FORMAT(column, '%Y-%m-%d') AS date
...and get a date just fine.
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
or check
out:
http://www.mysql.com/doc/en/GRANT.html
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
a reasonable
transaction retry
policy ?
I'd like ALL the transactions to complete successfully, but I don't want to have to
retry a
transaction, say, 100 times.
Thanks.
- Mike.
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http
Linux 9 running MySQL 4.0.15-standard-log, and the slaves are
Redhat Linux 7.1 running MySQL 4.0.15-standard-log as well.
Has anyone run into this before?
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list archives
'
AND AcctStopTime
= '2003-11-11 15:30:00')
His WHERE clause is on two different fields (AcctStartTime and AcctStopTime). I don't
think a BETWEEN clause is what's needed...
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
--
MySQL General Mailing List
For list
key or not has a unique address. Is there
such a thing in MySQL? ROWIDs are extremely useful for guaranteeing that you
are manipulating the exact row that you think you are.
Mike
--
Michael Brando
Senior Manager of Engineering
I knew I'd sound like an idiot.BUT...
The imported text consists of a 'customer' generated message with large arraysand
since I haven't figured out how to generate arrays in mySQL4.0 each array entry is a
record. Since I'm trying to BULK LOAD the message (with as little intervention as
else knows anything about that specifically.
Thanks for the help!
:)
-Mike
Could you include the error you receive?
You can check the current value of your max_allowed_packet using the
following command,
mysql show variables like 'max_allowed_packet';
max_allowed_packet determines
What is the relationship between column name length, Number of columns and max
columns?
Upon creation of a table with +1700 columns (with approximately 25...30 characters per
name) I get the Too many columns ERROR.
If column names are limited to 2 characters the ERROR goes away.
The table was
) I can change it in and restart the server?
Thanks For Any Help,
-Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
. Im fairly new to Linux by the way, if you have not
already guessed.
Any help would be greatly appreciated.
Thank You,
Mike.
**
This email and any files transmitted with it are confidential and
intended solely for the use
libmysqlclient.so.10 is needed by MySQL-python-0.9.0-2
libmysqlclient.so.10 is needed by perl-DBD-MySQL-1.2216-4
libmysqlclient.so.10 is needed by php-mysql-4.1.2-2.1.6
Thanks,
Mike
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
I'm not familiar with that function in MS SQL, and you're a bit unclear, but
it looks like you might be able to use temporary
tables.
Looks like he's asking if MySQL supports namespaces. Is there anyway to
simulate
from table temp1 a, temp2 b
where a.endtime=b.endtime
and a.unique_id=b.unique_id;
If there are duplicates I suspect you'd get away with distinct?
Of course I'm sure there's a smarter way!
Rgds
Mike (--traitorous Oracle Ingres DBA)
-Original Message-
From: Larry Brown [mailto
Begging to differ, no vendor that I'm aware of claims to be compliant with a
paper or textbook. They tend to comply with an adopted standard such as:
ANSI/ISO/IEC 9075-1(through 5):1999
ISO/IEC 9075-1(through 5):1999
Collectively known as SQL:1999. While I'd offer that MySQL *is* a relational
Hi,
Can somebody tell me if there is a way to accomplish this update without
locking both tables.
UPDATE t1, t2 SET t2.a = t1.a WHERE t2.id = t1.id
t1 is not being updated yet it becomes locked and does not allow any
read queries until it is done.
Can somebody help?
Thanks,
Mike
Traditionally, I'd take the following approach
1) Update - assume it's there
2) If update fails (0 rows) do an insert
Thats assuming that the update case is more prevalent. If the row is
unlikely to be there - insert and do the update if you get a duplicate key.
Rgds
Mike
-Original
in this.
Sincerely,
Mike Tiny Bailey
Author of
What Have We Done? The Dragon Chronicles
, and if results come
back, have the data updated, and if not have it inserted.
I know how to do this in PHP with $query_total_rows. Is there some way in
SQL to do this, or do I need to figure out a way to do it in the shell
script?
Thanks,
Mike
--
MySQL General Mailing List
For list archives: http
, if
there is no match, then the data is inserted into a new row.
Mike
From: Brent Baisley [EMAIL PROTECTED]
Date: Thu, 16 Oct 2003 14:29:21 -0400
To: Mike Tuller [EMAIL PROTECTED]
Cc: MySql List [EMAIL PROTECTED]
Subject: Re: Check for data before inserting
It sound like you want to use REPLACE
How could I write a statement that uses something like 'OR' as a case. Like
this:
SELECT * FROM list WHERE name = '$this1' OR name = '$this2' OR name =
'$that1'
?
Thanks for any help,
-Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
I know this is a little off-topic, but I have been approached to do some
consulting to move an ISAM based app to MySQL. The potential customer is
asking an hourly rate but as I have not done MySQL work as a consultant I am
not sure what to charge.
Any Ideas?
Thanks,
Mike Hillyer
www.vbmysql.com
Dear All,
Hi!
Installed RH8 included it mysql (RPM-version) with
it, looks like it didnt install in the /usr/local/
directory.
I'd love to uninstall it however, everything I do an
rpm -e mysql it gives this:
error: Failed dependencies:
libmysqlclient.so.10 is needed by (installed)
.
Mike Griffin
From: dan orlic To: Subject: mysql statement autogenerator... Date: Tue,
14 Oct 2003 14:01:52 -0500
Is anyone aware of an open source project that provides a graphical
representation of tables that can then generate a database schema in sql
statements. Something like Posiedon auto
check the data, and nothing was entered. When I
run each statement on it's own (not from a script file, but in the shell)
Everything seems to work. It just doesn't work when you try to run it from a
script.
Any ideas?
Mike Tuller
--
MySQL General Mailing List
For list archives: http
Paul
How about
select FIRST_NAME, count(*)
from a table
group by FIRSTNAME
having count(FIRST_NAME) 1
Mike
--
Live Life in Broadband
www.telewest.co.uk
The information transmitted is intended only for the person
My code is shown below, I can select * from employees but I cannot get
any data back from SHOW FIELDS, I do not receive an error, in fact,
something is returned but I'm not sure what. I can execute the
command:
SHOW FIELDS FROM test.employees
in the Control Center just fine, even
try adding a '\' before the comma like a \n in c++
-Original Message-
From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 25, 2003 10:41 AM
To: Roger Davis; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Ideas on creating connections
Thank you for
what your configuration is.
mike
-Original Message-
From: John Cole [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 10:44 AM
To: [EMAIL PROTECTED]
Subject: MySQL connection with PHP
hello,
i am learning PHP and MySQL recently, i use PHP to
connect to MySQL server,
however
I would like to cron my backups...
I currently have the following items on my list: mysql, ldap, various
files/directories, kerberos, etc.
I'm needing the following questions answered:
1. How to 'cleanly'/securely propagate mysql backup user credentials to
mysqldump. This will be a user with
to create a script owned
by user that passes user password thru to mysql...but this smells hacky (not
in good sense).
mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Question: how is this done?
I am getting tired of entering my existing unix login information (same
login/pwd) every time I want to login to mysql.
I would like to propagate my existing unix credentials (/etc/pwd) or
possibly use pam/sasl/etc.
Note...of course this isn't the same as mysql/pam
Question: how is this done?
I am getting tired of entering my existing unix login information (same
login/pwd) every time I want to login to mysql.
I would like to propagate my existing unix credentials (/etc/pwd) or
possibly use pam/sasl/etc.
Note...of course this isn't the same as mysql/pam
501 - 600 of 1406 matches
Mail list logo