Hi,
> Ok so this really doesnt have anything to do with MySQL but I
> thought this
> might be a good placeto ask.
Why?
As you say, it's not in any way related to MySQL.
> reload the page and postthe message again! doh!
> Anyways, has anyone come up against a similar problem and found a
> way a
> 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
Gaah..
> Hi,
>
> > I use PHP (cgi) with IIS and phpMyAdmin. The
> > problem with the head
> "The specified CGI application misbehaved by not
> returning a complete set of HTTP headers. The headers
> it did return are:"
Looks like you're running phpMyAdmin on a machine with Windows and PHP
in CGI-mode?
I don't recall if it's PHP in CGI-mode on Windows that in general
doesn't work with
> I assume that the mysql daemon is looking for one of those
> owned by mysql.
>
> The server will start if I send the --skip-grant-tables option
>
> Who wants to run a database with no grant tables
Find out where your databases are located.
Think /var/db/mysql is the default.
Go there an
> I assume that the mysql daemon is looking for one of those
> owned by mysql.
>
> The server will start if I send the --skip-grant-tables option
>
> Who wants to run a database with no grant tables
Find out where your databases are located.
Think /var/db/mysql is the default.
Go there an
Hi Greg,
> SELECT f.language as From, t.language as To
> FROM language f, language t, language_pairs lp
> WHERE f.id = lp.from
> AND t.id = lp.to;
I really need to get some sleep I think.
So simple, and yet my buggy mind didn't come up with that solution.
Thanks,
//andreas
(sql, query - just
Hi,
I have two tables:
languages:
id tinyint(3) unsigned not null,
language varchar(30) not null
language_pairs:
from tinyint(3) unsigned not null,
to tinyint(3) unsigned not null
language_pairs.from and language_pairs.to are linked with languages.id
Hi,
> Anyone know if its possible to have mysql databases under
> $HOME for users.
> I am running RH7.2 and have virtualhosts under apache 1.3.22
> so i am hoping
> i can put databases under each user account in order to
> control (quota's)
> etc.
You can put them under each users homedir and
> But if I change the output format with: DATE_FORMAT(data,'%d-%m-%Y'),
> the order by clause attempt to order the new format
> incorrectly, because
> I've an output like this: 12-2-2002, 12-3-2002, 12-4-2002,
> and 13-2-2002!!!
I normally do this:
SELECT DATE_FORMAT(datefield,'%d-%m-%Y') as d
> mysql_select_db("$DBName");
> mysql_query("SELECT Date,BuyerID,OrderNumber FROM Buyers")
>
> How do I assign the variable to both of those lines that make
> up the DB
> call???
Unless you're planning to use several databases, you only have to use
mysql_select_db($DBName); once, normally where
> > It means something is out of date...looks like you need an update of
> > something...
>
> This is the line 7 that it is talking about How do I know
> what is out of
> date and how to fix it? Are there any utilities out there for updating
> scripts or do I need to manually go into each .p
Hi,
> Warning: mysql is deprecated; use mysql_select_db() and mysql_query()
> instead in (rootPath here)\cart\admin\addcategoryresponse.php
> on line 7
[snip]
> What does depricated mean? I have searched the manual and the
> resources
> online but cannot find anything about it. Does it mean t
> tar -xvfz mysql-3.23.32.tar.gz
> tar: Cannot open z: No such file or directory
> tar: Error is not recoverable: exiting now
> Any Help? Should there be a z: directory? And where?
Try:
tar zxvf mysql-3.23.32.tar.gz
z = gzipped
x = eXtract
v = verbose
f = file
You had a 'z'
Hi there,
I'm having som difficulties trying to figure out MySQL's unique indexes
and primary keys.
Case:
mysql> create table flaf (lala varchar(20) not null, unique(lala));
Query OK, 0 rows affected (0.00 sec)
mysql> insert into flaf VALUES ('hest');
Query OK, 1 row affected (0.00 sec)
my
14 matches
Mail list logo