I have written the following SQL request, but I get
an error, why ?
create table MovementOrder (
teamCode INT(4) NOT NULL,
quarter INT(4) NOT NULL,
position INT(4) NOT NULL,
priority INT(4) NOT NULL,
order VARCHAR(10),
parameter VARCHAR(5),
PRIMARY
I want to store different file formats in a database like images (*.jpg)
or audio files (*.mp3). Is it possible to do so in mysql?
-Nikhilesh
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
HI!
In response to several mail messages on mailing list that were
centered around some misbehaviour of SHOW DATABASES / TABLES, I have
tested thoroughly (with several --user=... options) 3.23.33 and found
out that it works perfectly.
Causes of misbehavious can be :
- errors in building
Hi all,
All of a sudden, some of my data (originating from a web form) is showing
content such as the following...
Sailing Windsurfing Instructor #8211; training
given-(Mediterranean Coast)This is a fantastic opportunity to work
for the UK#8217;s leading children#8217;s adventure
On Sat, 17 Feb 2001, Nikhilesh Haval wrote:
I want to store different file formats in a database like images (*.jpg)
or audio files (*.mp3). Is it possible to do so in mysql?
Yeah, that's what BLOB is for--but why would you want
to do that? Why not just store the path in the table,
and
Hi everybody,
I want to implement ordering something on a website without refreshing the
page. Lets say i have four columns in the html table - name,age,skill and
phone. All these are links - under these are the information, eg:
Name Age Skill Phone
Siim 23 php 051...
Tony 18 html 132...
Maybe Flash is an option?
-Original Message-
From: Peter Skipworth [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 17, 2001 9:29 AM
To: Siim Einfeldt aka Itpunk
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL
XML is all about data definition - not being able to dynamically
change the display of the data on a webpage. Browsers don't even
understand XML natively - you need to write it out as HTML before you can
display it in IE or Netscape.
P
On Sat, 17 Feb 2001, Siim Einfeldt aka Itpunk wrote:
Actually ... there are often some good reasons one might want to store
pictures in BLOBs.
For example, our integrated application gives the administrators at our
various customer sites the ability to associate a series of icons on a
toolbar with a wide range of programmable functions. In
Relax, XML has N.O.T.H.I.N.G. to do with what you want to do.
You want dynamically update (rebuild) HTML page, well,
the only way to do it currently in more or less compatible way
is to use javascript+DHTML. And the result will SUCK, i know,
i've done it. So, go the way the elders did. Refresh
On Fri, Feb 16, 2001 at 10:46:40AM -0800, Fox Mulder wrote:
--- Brian Reichert [EMAIL PROTECTED] wrote:
On Sat, Feb 17, 2001 at 03:23:49PM +0800, yindu wrote:
There are no DB defined space limits on MySQL Databases ?It's
dangerours .How to control
the database space on my database
Aha, java is even better :)
- Original Message -
From: "Brian V Bonini" [EMAIL PROTECTED]
To: "Peter Skipworth" [EMAIL PROTECTED]; "Siim Einfeldt aka
Itpunk" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL
does anybody know the QUERY to drop a column for MSSQL 6.5?
thanx regards wernher
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
can yopu link a database to flash?
van
-Original Message-
From: Siim Einfeldt aka Itpunk [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 17, 2001 4:07 PM
To: Brian V Bonini
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL
Am I the only one with problems with mod_auth_mysql?
When trying to install Apache 1.3.17 with mod_auth_mysql 2.20
the compilation of apache fails. This seems to be because
mod_auth_mysql wants to use alloc (from apache), but
its name has changed to ap_alloc.
I just changed alloc.h to
No, solve it in your own program.
- Original Message -
From: "Robert Heron" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, February 17, 2001 6:35 PM
Subject: special characters in MySQL query
I have written a program which reads data from WWW forms and passes
it to
MySQL
It is even possible to do just with JavaScript, by being creative. However,
refreshing the page seems the logical option. Is there any special reason
for not doing it? I am almost always in favor of keeping things on the
server side.
Jose Carlos
Relax, XML has N.O.T.H.I.N.G. to do with what you
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Hello folks,
This is probably some very stupid mistake, but I don't know what else to do.
I just installed the latest mysql source. Everything compiled nice and
without errors and installed correctly. My problem is, I can't connect to
the
yes you can. And its cool too :-)
On Sat, 17 Feb 2001, Wernher Korff wrote:
can yopu link a database to flash?
van
-Original Message-
From: Siim Einfeldt aka Itpunk [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 17, 2001 4:07 PM
To: Brian V Bonini
Cc: [EMAIL PROTECTED];
I said Java. Java i said. Java said I.
- Original Message -
From: "Wernher Korff" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, February 17, 2001 6:53 PM
Subject: RE: [PHP] Re: Creative solution with XML,PHP,MYSQL
can yopu link a database to flash?
van
-Original
try mod_auth_mda
or some generic auth module which allows authrization via
any script. However, i am happily using mod_auth_mysql
with 1.3.14, however i build from the port on mysql with
some magic envolved. However, i didn't try to build
it with 1.3.17
- Original Message -
From: "Erik
On Sat, 17 Feb 2001, Artem Koutchine wrote:
Aha, java is even better :)
Absolutely. I can't think of anything I'd rather do
than sit and wait for the browser to load the JVM.
--
/"\
\ /ASCII RIBBON CAMPAIGN
X AGAINST HTML EMAIL
/ \AND POSTINGS
You can use PHP with Flash and then use PHP to access MySQL.
BR,
Fábio Ottolini
- Original Message -
From: "Wernher Korff" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, February 17, 2001 12:53 PM
Subject: RE: [PHP] Re: Creative solution with XML,PHP,MYSQL
can yopu link a
just do it using grant statement so that you can connect from another host.
use grant to username@'%' instead of localhost
- Original Message -
From: "Emre Yildirim" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, February 18, 2001 12:40 AM
Subject: cannot connect to database
Hi All,
Below is the status that I got from my server's mysql server, can anyone
explain to me more on this?? and as u see here... currently mysql server
is running extremely slow:
mysqlshow variables;
++--+
| Variable_name
Some guys here lurk around only to get their problems solved and chuck off the
minute any kindred list memeber solves it . For them it just feels so smart thinking
that the list is the best place to get their work done without paying a dime .
So all u guys intending to only take and not
On Sun, Feb 18, 2001 at 01:18:04AM +0800, Teddy A Jasin wrote:
Hi All,
Below is the status that I got from my server's mysql server, can anyone
explain to me more on this?? and as u see here... currently mysql server
is running extremely slow:
Try posting a 'show processlist' so you can
Hello, I've been trying to make and ODBC connection with a remote database
and I can't. What should I do?
Something else, Can I have a connection between Visaul Basic and MySqlwith a
remote database?
Thank you.
-
Before
I'm having an ODBC call failed error when I open one of my customers
databases. I've tried re-linking it and still get the error. My other
Mysql databases are working. But we just upgraded from FreeBSD 2.2.8 to
FreeBSD 4.2 and we have had a few files come over with wrong
permissions. It's saying
On Fri, Feb 16, 2001 at 05:58:27PM +0300, Peter Zaitsev wrote:
Hello monty,
I'm trying to use merge table for logging - to have a possibility to
Rotate log files and to quickly delete old data - for this I'm goint
to setup a number of merge tables where each contains data for one
Actually, blobs are stored in files in data directory. You can store your
binary files in data directory, if you wish.
- Original Message -
From: Gerald R. Jensen [EMAIL PROTECTED]
To: clay bond [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, February 17, 2001
On Sat, 17 Feb 2001, Ingrid Kast Fuller wrote:
I'm having an ODBC call failed error when I open one of my customers
databases. I've tried re-linking it and still get the error. My other
Mysql databases are working. But we just upgraded from FreeBSD 2.2.8 to
FreeBSD 4.2 and we have had a few
Hello.
On Fri, Feb 16, 2001 at 03:58:20PM -0800, [EMAIL PROTECTED] wrote:
This is the latest approach we're using now. It turns out that the
query to get Total Plays for an Album per City can be taken out of
the City for loop done only once as a GROUP BY. The worst case
time for MySQL is
So I got MySQL installed on a build of MacOS X.
I futzed it up, I need to unistall it, and I thought I did, but it says that
MySQL is still running on an open port, and I can't allow the newer version
of MySQL I've installed to run. Any ideas? I can't kill the process, as it
appears to just be
Hi.
On Sun, Feb 18, 2001 at 01:18:04AM +0800, [EMAIL PROTECTED] wrote:
Hi All,
Below is the status that I got from my server's mysql server, can anyone
explain to me more on this?? and as u see here... currently mysql server
is running extremely slow:
mysqlshow variables;
At 16:25 17-02-2001 +0200, Siim Einfeldt aka Itpunk wrote:
Hi everybody,
I want to implement ordering something on a website without refreshing the
page.
That is generally done using JavaScript. But be advised that not everyone
has JavaScript turned on by default: I often have it turned off
If connect to mysql server using C API function and mysql server is under very
high load, client never timeout, it's just sit there waiting - how to stop
this?
I use the mysql_options() first to set timeout
const char *timeout = "1";
mysql_init(mysql);
mysql_options(mysql,
Here is the table:
+--+
| STOP_0FFS |
+--+
|FLIGHT_NO |CITY | SEQUENCE|
|127 |Chicago |1|
|127 |Boston |2|
|391 |Miami|1|
+--+
SELECT
On Fri, Feb 16, 2001 at 06:50:53PM -0600, Richard Reina wrote:
Here is the table:
+--+
| STOP_0FFS |
+--+
|FLIGHT_NO |CITY | SEQUENCE|
|127 |Chicago |1|
|127 |Boston |2|
|391
On Sun, Feb 18, 2001 at 02:19:17AM +0100, Fred van Engen wrote:
On Fri, Feb 16, 2001 at 06:50:53PM -0600, Richard Reina wrote:
Here is the table:
+--+
| STOP_0FFS |
+--+
|FLIGHT_NO |CITY | SEQUENCE|
|127
Dear all,
I have a field defined as float (16,0). When I insert 99 (10 9s) into the
table, it changed it's value to 100(1 and 10 0s). It also change some other
inserted values.
Does anybody have any idea what the reason causing it? And how can I fix that?
Thanks in
Hi,
The problem is when I execute show processlist; the mysql
replied syntax error. So i cant use the processlist.
here's wat the mysql respond:
SHOW PROCESSLIST;parse error near 'PROCESSLIST' at line 1
thanks
teddy- Original Message -
From: "Fred van Engen" [EMAIL PROTECTED]
To: [EMAIL
"G. Adam Stanislav" schrieb:
At 16:25 17-02-2001 +0200, Siim Einfeldt aka Itpunk wrote:
Hi everybody,
I want to implement ordering something on a website without refreshing the
page.
That is generally done using JavaScript. But be advised that not everyone
has JavaScript turned on by
Hello,
is there a browseable archive for this list?
I would as soon look it over, if it exists, before
posting what may be an FAQ.
TIA
Michael Fischer
--
[EMAIL PROTECTED]
-
Before posting, please check:
Dear Sir,
I have a Red-hat Linux6.2 . And i have installed MySql -3.23.32 server. It installed
successfully. now when go to install MySql-3.23.32.rpm it doesn`t install, same for
MySql-devel-2.32.32 it also doesn`t install.
And also tell em how to Uninstalled .rpm.
Pls reply me asap.
Ok, I looked through the archive, unsuccessfully.
Here's the "problem":
I rebuilt a machine running a MySQL db, and stupidly
only backed up the user-oriented databases, and not
the mysql administrative ones. Nonetheless, I went
back in and used the guiclient to do the appropriate
grants. After
46 matches
Mail list logo