 | | | MySQL General | | Erich Beyrent wrote
> Hi all
>
> I need some advice as to how to manage a user login system using PHP and
> MySQL. Currently I have the following table
>
> +-------------+Did you use a MySQL binary or one that you compiled? What version of 4.0
did you test against?
> > > > > > > > > > > > > > > > > > Original Message < < < < < < < < < < < < < < < < < <
On 3/4/04 7 43 02 AM <dave@(protected) > wro
There 's a whole list of all the functions at http //www.php.net
Curtis
On Thu 4 Mar 2004 James Marcinek wrote
> Rhino
>
> I know this is an off topic however I see that you have DB2Mark Riehl <mark.riehl@(protected) > wrote
> All - Running MySQL 4.0.17 under Red Hat 9 using MyISAM tables.
>
> I 'm trying to add the auto_increment attribute to column in a table thHello list I am trying to find a way to retrive the time a certain select statement took for debug purposes. If I execute a select statement in the mysql console I get the time that select statement Currently everything you listed can be done via queries to the server. Take
a look at the MySQL manual for all the queries and their requisite responses.
And I 'm quite sure what you want to do haswould you mind being morew specific?
On Wed 2004-03-03 at 23 20 Elly Wisata wrote
> Hi *
>
> How to query records that most of the fields are the same value? Izit
> possible?
>
> ThanksHi
I am using MySQL 4.0.18 with InnoDB and I would to have some suggestions
about how can I backup the data. I read in this list that some people are
using mysqldump others are using some too----- Original Message -----
From "Sasha Pachev " <sasha@(protected) >
To "Daniel R. Anderson " <dan@(protected) >
Cc <mysql@(protected) >
Sent Thursday March 04 2004 7 22 AM
Subject RCliff
please run
CHECK TABLE ...
on your table and look if mysqld prints anything to the .err log. Send the
WHOLE .err log to me.
What is your operating system version?
> > amount of Defryn Guy wrote
> Hi there
>
>
> I would like to know some professional opinions on the following
>
> -Are there any drawbacks on installing Mysql on a windows server? Would it be possib
--
MySQL General Mailing List
For list archives http //lists.mysql.com/mysql
To unsubscribe http //lists.mysql.com/mysql?unsub mysql@(protected)Scott Haneda <lists@(protected) > wrote
> Here is what I am doing now...
>
> SELECT id first_name last_name password FROM account WHERE password
> ENCODE( "1234 " 'foobar ') ORDER BY last_name "Lorderon " <ighen@(protected) > wrote
> Since I don 't use MySQL 4.1 is this query OK?
>
> SELECT SQL_CALC_FOUND_ROWS * FROM
> ((SELECT * FROM t1 WHERE id >100 GROUP BY country)
> Try something like this
SELECT ID Name Country
FROM peoplelist
GROUP BY Country
HAVING count(Country) >10
That might work. Also you can have subselects in 4.0.
At 22 04 -0700 3/3/04 Sasha Pachev wrote
>Joshua J. Kugler wrote
> >In the manual that came with MySQL 4.0.17 (at least in the Mandrake
> >packages of such) it says I can use %f to get the microsHi
Does any one help me in formating the output result in PHP with mysql?
The code is here.
<form action "hostrep.php " method "get " >
</form >
<?
$username "root "
$password " "
$database "dataI am trying to create a temporary table through code in my DB. I can do
it when I use MySQL Control Center or something like that but when I
try to do it through my VB program it doesn 't work.
Que es la version de MySQL. De la computadora?
> > > > > > > > > > > > > > > > > > Original Message < < < < < < < < < < < < < < < < < <
On 3/3/04 12 42 25 PM Miguel Angel Solorzano <miguel@(protected) > wrote
regarding Re Fw iSubj
--
MySQL General Mailing List
For list archives http //lists.mysql.com/mysql
To unsubscribe http //lists.mysql.com/mysql?unsub mysql@(protected)
Kieran Kelleher wrote
> Here is the user host and password fields from one of my MySQL servers
> named TestServer
>
> mysql > select user host password from user
> +------------+-------Mark
http //www.innodb.com/manual.php#advanced.slave describes how to set up a
new slave from a hot backup of a master.
If you take a hot backup of a slave and want to use it to set up a new
do you mean inserting the whole .zip file in a table?
if the above is right short answer is YES
On Wed 2004-03-03 at 13 32 Manda Sairam wrote
> I would like to import zip file into mysqlThat 's not the way of removing the service! Change it to the older file.
Then run
"nameofold-mysql.exe --remove "
To reinstall the service
"nameofthenew-mysql.exe --install "
On Wed 2Bernd Jagla wrote
> Hi everyone
>
> I have XML data with a corresponding DTD and I want create the necessary tables and load the data.
> Does anyone has experience with this?
> Are there any Manda Sairam <mandasairam@(protected) > wrote
>
> Hello Sir
> I have a file with the name doc.db.001 It is a binary file and it is a mysql file.I tried opening the file using load data file commanAll
I recently discovered the Show Processlist statement which is great. My
question is this...
One the process completes it falls off this list. Is there another
command that will show me This error usually occurs for one of two reasons
1. There is already a /tmp/mysql.sock. You 've ruled this out.
2. The user mysqld runs as typically mysql does not have permission to
write hi
i have some mysql tables in my mysql database . Table name is ServiceStatus and It is included with "status " field .
In the status field it is maintainig "up " "down " status.
SO i want Hi list
I 'm trying to optimise a SELECT ... LIMIT query perhaps i miss something
important and so i 'm asking your help )
I 'm using MySQL 4.0.15 under Linux.
Here 's a test query
mysql > |
|
|
