Re: [PHP] Little help please

> I'm looking for a webbased interface that will allow me to managae mysql > databases. However, phpmyadmin has been ruled out due to the fact it > requires the username and password to be stored in the config file No it doesn't. > and that it doesn't have any security to protect the average joe

Re: Query execution times in general query log?

> I have a need to find out how long each of the queries executed > against a mysql server are taking. Why can't there just be a function that returns this? I mean, it's already printed to the screen when you're running from the command line. Hopefully I've missed something and it's already there,

Re: phpMyadmin

Are you also going to install MySQL on the laptop? PHPMyAdmin runs over the web, so you just need to be able to pull up the PHPMyAdmin website on the laptop in order to use it. There shouldn't be any installation required. If you want to use a GUI to connect to the remote MySQL server, then use My

Re: Random 32bit number for columns?

> I am trying to find a means to create a column that self-populates with > unique random 32bit integers in MySQL. > > Do I need to do this in code, or is there a column spec/extra that I can > use to populate a column with random numbers on an insert? Ideally, the > database itself would manage th

Re: getting NULL in auto_increment column

> Can you update an auto_increment with NULL in MySQL? Obviously if you > try and put a NULL in directly it will increment to the next integer. > Is there some way to actually get a NULL in there instead of the > integer? No that's why you declare it NOT NULL when you create it. ---John Holm

Re: decimal type

> I'm creating a table where one column will be prices. How is this type > supposed to work? I tried it, loaded the data, and it cuts it off at the > decimal when I run a query. How can I get this to store correctly? Use a column type such as DECIMAL. http://www.mysql.com/doc/en/Column_types.html

Re: Checkpoint FW1 logs into mysql

> I'm trying to work out how to import Checkpoint FW1 firewall logs into > mysql. > > Each line of the logs consists of 27 space deliminated fields. > Of the 27 fields, I want to ignore about 11 of these fields when I do > the LOAD command on the log file. > > I've already figured out I want to use

Re: what is the best way to check if primary key exists?

> I need to insert recond to mysql use servlets, > > insert into mytable values('key', 'f1'); > > i need to chech if key is already in mytable. > > what is a good efficient way to do that? Insert the value and see if a "DUPLICATE KEY" error is returned. Act accordingly. ---John Holmes... --

Re: How to grab the latest record in one query?

- Original Message - From: "Chris Czeyka" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 20, 2003 10:02 AM Subject: How to grab the latest record in one query? [snip] > Either I'm stupid or it's impossible. Let's see which case is true. :) I'm sure it's neither. :)

Re: With or Without PHP

> Is there an equivalent lsit as this that also deals with PHP. > > A PHP and MySQL list I am sure MySQL is used in conjunction with other languages > but I am only interested in developing PHP and MySQL solutions, unless someone > convinces me otherwise. > > Also think you for whom ever it was tha

Re: Web interface

> I started using MySQL about two months ago (and I already love it!) and I'm new to this list... > > I would like to know if there's some web interface for MySQL management that has been released as open source. Preferably this should be in ASP 3.0 or ASP .NET languages, but I'll appreciate to kno

Re: SELECT 'ä'='\\' gives 1

> why does Mysql consider an 'ä' as equal to '\' ??? > The query > SELECT 'ä' = '\\'; > gives 1 as result! I get zero on 3.23.52-max-nt mysql> select 'ä' = '\\'; ++ | 'ä' = '\\' | ++ | 0 | ++ 1 row in set (0.00 sec) ---John Holmes... ---

Re: [PHP] MySQL 4.0 + PHP 4

> Anyone out there have anything to share as to using PHP4+MySQL4. I've been > hearing good things on the MySQL list about v4.0 and I'm thinking of > upgrading, since I run a rather small server. There's really no change from the PHP side. PHP just sends the data and receives something back The on

Re: [PHP] PHP + MySQL, how to get total rows matched when using LIMIT 0, 10?

> I'm trying to get the total matched rows when I'm using "LIMIT 0, 10", > but I only get the number 10, when the total should be around 100. So, > can I get total matched rows without doing a separate query using > count()? > > Here is an example of my current query: > > $result = mysql_query("SEL

Re: [PHP-DB] how can I do?

> I am trying to find the records whose create dates (field name > =create_date) are between the ones I want .For example , I want to seee the > records between $start_date and $end_date ..So I tried the code > below..But it looks not that right to me?... > > select * from bug where ..