MySQL Version: 3.23.49
OS: Win 98
Query 1: select length ('abc') returns
You have an error in your SQL syntax near '('abc')' at
line 1
Query2: select length('abc') returns 3: OK
Note the space between the 'h' and '(' in Query 1. The
parser does not like this space...
The same problem occurs
Hi all,
It's my first posting here so sorry if this is a silly newbie question for
the MySQL forum. I'd
like to change a string that looks like 04/03/2002 to 2002-04-03. The
initial column is, of course VARCHAR and I'd like it to be DATE. I've tried
CHANGE and MODIFY, it changes only some of the
Duh! EXTRACT()
Sorry!
-Original Message-
From: Crook, Richard W [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 6:04 PM
To: '[EMAIL PROTECTED]'
Subject: string date thing
Hi all,
It's my first posting here so sorry if this is a silly newbie question for
the MySQL forum.
Hi,
hopefully I have reached the right list..
I have recently updgraded to version 3.23.49 and have found that when doing
the following query:
select now()
I get a universal time returned to me. I have this version installed on
linux 7.2 and I require a time in australian eastern standard
Is it possible to access a sql statement to mysql database through
Internet explorer ? such as :
http://www.abc.com?select * from test
Thanks.
--
Best regards,
Ridwan
Goldbase Technology
http://www.pembukuan.com
G'day All
kimtest,Kim,,,this is kim¹s test stories¹ to see how we c¹n
accommodate single quotes¹ There are a ³couple² of ³double² quotes here
to. And ³here are some single¹ quotes that¹re enclosed in
doubles²,2002-4-4,,
I seem to have found the problem to my own question and it didn't
Trying to send this again... SPAM filter messing with me...
this is a query about what hardware might make for a really good sql server
There :-p
Hello,
I need some advise.
We are about to purchase a huge system for use as a DB/web application server (mostly
DB).
I'd like to point out that
No,
MySQL is not a web server.
Rw wrote:
Is it possible to access a sql statement to mysql database through
Internet explorer ? such as :
http://www.abc.com?select * from test
Thanks.
--
Best regards,
Ridwan
Goldbase Technology
http://www.pembukuan.com
I'm having a problem with trying to come up with a work around for this
common(?) problem. I'mnew to using MySQL but have gotten a handle on it pretty easily.
My
problem is that I'm using itto develop a simple message board and of course message
boards have a lot
of text in them.
My problem is
Here's one for you all...
I know it's not necessarily MySQL-exclusive, but I think it's relevant
enough.
Anyway, suppose you want to create a table to hold somewhat-regular events.
The events could be weekly, every two weeks, monthly, etc. In some cases, it
could even be the 5th Friday of the
From: Colin Faber [EMAIL PROTECTED]
Rw wrote:
Is it possible to access a sql statement to mysql database through
Internet explorer ? such as :
No,
MySQL is not a web server.
Well, it's not an entirely invalid question...
One example that comes to mind is accessing ftp://, gopher://,
I agree but this one one of those things which _SHOULD_ have been
researched.
denonymous wrote:
From: Colin Faber [EMAIL PROTECTED]
Rw wrote:
Is it possible to access a sql statement to mysql database through
Internet explorer ? such as :
No,
MySQL is not a web server.
Is there a command I can give in the mysql client to find the number of
rows in a table or, better still, the number of rows in all the tables in
a database?
Andy
-
Before posting, please check:
From: andy thomas [EMAIL PROTECTED]
Is there a command I can give in the mysql client to find the number of
rows in a table or, better still, the number of rows in all the tables in
a database?
To return the # of rows in a table:
SELECT COUNT(*) FROM table_name;
Not sure about all rows
Try:
?
mysql_connect(localhost, user, password);
$query = SHOW TABLES;;
$result = mysql_db_query(databasename, $query);
$i = 0;
while ($row = mysql_fetch_array($result))
{
$tableNames[$i] = $row[0];
$i++;
}
for ($i = 0; $i = count($tableNames); $i++)
{
$query = SELECT
-Original Message-
From: Doug Bishop [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 10:13 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Table statistics
Try:
?
mysql_connect(localhost, user, password);
...
Might be helpful to the original poster to
Hi,
I have MySQL 3.23 installed in Windows 2000 Server 4
days ago. It runs as a service of the server. It was
working fine.
But now it stops abrubtly. When I run the PhpMyAdmin
from the browser it says the following :
--
Error
MySQL said:
Go Back
--
It does not say anything
On Thursday, 4. April 2002 20:16, Rw wrote:
http://www.abc.com?select * from test
Thanks.
MySQL is not a web server. But you can use a scripting language like PHP or
Perl in combination with a web server and MySQL to do this.
Regards
Georg
Hi Everybody,
I am having an existing Applicaion with MySQL server running on Linux with
Tomcat 3.2.1 and JSP in English language. Now I have a requirement of
migrating the application into the Japanese Language.
Could any one tell me what all the changes I have to do inorder to migrate
my
On Thursday, 4. April 2002 08:12, Doug Bishop wrote:
?
mysql_connect(localhost, user, password);
$query = SHOW TABLES;;
$result = mysql_db_query(databasename, $query);
$i = 0;
while ($row = mysql_fetch_array($result))
{
$tableNames[$i] = $row[0];
$i++;
}
for ($i = 0; $i =
Hi,
I'm having a problem when using Load Data where the single and double quotes
in the text file are getting nuked. It appears that the escape character is
not being respected but I'm not sure why. It is also knocking out
characters near the quotes.
Your single and double quotes come out
I have got a backup script that locks the MySQL tables then use cp(unix) to
copy the tables.
It then tar, then zips them up.
So my queston is what is the minimum privileges that this MySQL back user
needs just to lock tables?
Thanks
Simon Green
--
Live
101 - 122 of 122 matches
Mail list logo