Caroline Jen wrote:
Hi, I tried to create a table. This table has
seventeen fields. My create table syntax gets too
long and I was only able to specify 5 fields at the
mysql prompt in the DOS window (DOS does not accept a
command beyond certain length). How do I put the rest
12 fields in the ta
I am having trouble revoking the rights of the anonymous user or setting
a password for that user. Can some one help. I can just do an update
or delete but I want to do it with revoke and set password.
Chris W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To un
Hi, I tried to create a table. This table has
seventeen fields. My create table syntax gets too
long and I was only able to specify 5 fields at the
mysql prompt in the DOS window (DOS does not accept a
command beyond certain length). How do I put the rest
12 fields in the table I just created?
To view your greeting, choose from the options below.
Click on the following link:
http://www.pickup.aol.egreetings.com/view.pd?i=6375961&m=5319&rr=y&source=aole999
OR
Copy and paste the above link into your web browser's "address" window.
Thank you for using AOL E-Cards!
--
MySQL General Mai
I am storing data from an html form and there could be any character in
there, including a % and an _. I'm using mysql_real_escape_string in
php to escape special characters, but it says it doesn't escape the %
and _. I was also reading something about escaping the -- . If I want
all of thes
Rocar Peças wrote:
Dear Friends,
I´m programming in C, Linux envirnment.
The SELECT´s results are being brought to the client by using mysql_store_result. And the result sets are being released by mysql_free_result.
The problem is: as mysql_free_result is called, the system memory is NOT actual
Sorry about this,
> The only way to search for kk-4835 is to do the
> search
> in Boolean mode and put things in quotes ->
> "kk-4835"
> So your query would look like this:
>
> > SELECT * FROM ms_items
> > where MATCH (it_mnfgID, it_title, it_descrip)
> > AGAINST ('"kk-4835"' IN BOOLEAN MODE )
P
Hello,
Fulltext section of mysql manual: "MySQL uses a very
simple parser to split text into words. A "word" is
any sequence of characters consisting of letters,
digits, " ' ", and " _ ". Any "word" that is present
in the stopword list or is just too short is ignored."
Thus a hyphen would be vi
on 01/31/2004 11:57 AM, Kenneth Letendre at [EMAIL PROTECTED]
wrote:
> Hello,
>
> I'm trying to get the difference (in days) between dates stored in two
> date fields.
> My query:
>
> SELECT id,(firstdate- postdate) AS diff FROM calendar
>
> This works fine if the two dates are in the same m
Have you tried to execute this statement manually thru their PHPAdmin?
Have you checked the case of your SQL?
I recently migrated a bunch of PHP/MySQL code from a Linux to Windows
then back to Linux and some of my SQL did not work because the case of
the table names had been converted to part upp
Kenneth,
try
SELECT id, DATEDIFF(firstdate, postdate) AS diff FROM
calendar
RTFM!
hope that helps, dan
-Original Message-
From: Kenneth Letendre
[mailto:[EMAIL PROTECTED]
Sent: Saturday, January 31, 2004 1:51 PM
To: [EMAIL PROTECTED]
Subject: Subtracting date fields
Hello,
I'm tr
Hello,
I'm trying to get the difference (in days) between dates stored in two
date fields.
My query:
SELECT id,(firstdate- postdate) AS diff FROM calendar
This works fine if the two dates are in the same month, but not
otherwise. MySQL appears to be treating the two dates as base-10 int
Hello,
I'm trying to get the difference (in days) between dates stored in two
date fields.
My query:
SELECT id,(firstdate- postdate) AS diff FROM calendar
This works fine if the two dates are in the same month, but not
otherwise. MySQL appears to be treating the two dates as base-10 int
Hi everyone,
If, using MySQL, I have to select 'playerID' from soccer.players based on
lname='smith', fname='john', and dob='1988-12-02' and THEN update
soccer.teams 'coachID' equal to the result of the select statement, can I do
it all in one query? Or must I let my PHP script run a select, retu
I have spent all day working on a PHP/MySQL system offline using MySQL
version 4.0.15-nt. One particular SQL statement that works perfectly
wouldn't work when I uploaded it to my web site. It seems that my ISP
is using version 3.23.56, and I have written a SQL statement that will
only work on 4.04
In the last episode (Dec 31), michael elston said:
> I am having some trouble with fulltext search when searching a Table
> for parts numbers which contain HYPHENS ( - ) and i am 90% sure that is
> where the problem is.
>
> My query is:
> SELECT * FROM ms_items
> where MATCH (it_mnfgID, it_title
Dear Friends,
I´m programming in C, Linux envirnment.
The SELECT´s results are being brought to the client by using mysql_store_result. And
the result sets are being released by mysql_free_result.
The problem is: as mysql_free_result is called, the system memory is NOT actually
released.
For
I've distilled the problem I'm having with DELETE/INSERT to an even
simpler test case.
Here's the SQL - it can be used with any database, not just the special
"expdb" I created. I run this script followed by running "mysqlcheck
expdb".
#
USE expdb;
DROP
I am having some trouble with fulltext search when searching a Table
for parts numbers which contain HYPHENS ( - ) and i am 90% sure that is
where the problem is.
My query is:
SELECT * FROM ms_items
where MATCH (it_mnfgID, it_title, it_descrip) AGAINST ('*kk-4835*' IN
BOOLEAN MODE )
What i wan
Dennis Strickland wrote:
> Just started using MYSQL. And in doing some reading about MYSQL I
> read that MYSQL does not support nested Selects.Is this true?
Current documentation reveals nested selects aka subqueries aka derived
tables aka anonimous views are available as of version 4.1, first alp
* Dennis Strickland
> Just started using MYSQL. And in doing some reading about MYSQL I read
> that MYSQL does not support nested Selects.Is this true?
Depends on your definition...
The most used version (3.23) does not support nested selects.
The current version (4.0) does not support nested
>If you run the app again, does it give errors on the same record again?
>If you move the record in question up or down in the sequence of
>inserts, does it still give errors on that record?
Don't know about the commit. I have set autocommit to 250 but that is
connection by connection and I'm usi
TriKster Abacus wrote:
>
> I am trying to get some kind of friggin Quake 3 stat generator to work
> on my Quake 3 servers that I have running.
> Currently I am running a program called Q3Log, which is java based, but
> it seems to have stopped working for some reason. (no log to show
> errors). An
[snip]
Just started using MYSQL. And in doing some reading about MYSQL I read
that MYSQL does not support nested Selects.Is this true?
[/snip]
You mean SUB selects? See
http://www.mysql.com/doc/en/Subqueries.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
Hello,
I have made a website using jboss, Hibernate, mysql 4.0.16 and
mysql-connector-java-3.0.9.
In development this is installed on Windows2000 and everything works fine, also
when the user inputs characters like é, à, è,
In production this is installed on Linux (RedHat 8). There
Just started using MYSQL. And in doing some reading about MYSQL I read
that MYSQL does not support nested Selects.Is this true?
Just to wish you a prosperous new Year.
My wishes go to the special guys of the MySQL and related software development team[s].
May the coming year bring you happiness and more innovative and productive ideas.
May your families be the happiest on this earth!
May this year protect you against homo
You can afterwards the installation specify the path to the data in the "my.cnf"
config file.
Marc.
-Message d'origine-
De : Kirti S. Bajwa [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 31 décembre 2003 01:08
À : [EMAIL PROTECTED]
Objet : MySQL on RAID server
Hello List:
Here comes
BTW the error also indicates your client is trying to connect to the
localhost i.e. the same machine you are connecting from. Try using the IP
address of the server instead of the servername. This should also be a
string (eg. "123.123.123.123").
You most likely have a parameter/data type problem.
Arun,
Please reply to the list so all may help/benefit from your question.
The mysql server program/daemon must be running on the server prior to any
client access.
If you are able to access the mysql server from any client than the server
is running.
For example if your linux server's resolvabl
Hi Caroline,
> Hi, I have several simple questions regarding creating
> tables in the MySQL.
>
> 1. For a variable of Java primitive int type, I should
> use INT or INTEGER? Do I have to specify the length of
> the field?
> CREATE TABLE message_thread( thread_id INT or INTEGER
> NOT NULL AUTO_INC
the problem is that, if it happens again, I get a file of 900 MB, which
gets kinda big ... In order to rectify the situation after that, I'll
need to dump all innodb tables, drop them and reinsert them. This would
takes hours, and in the meantime the application running on top of it
would be do
32 matches
Mail list logo
