to rename this page? Maybe to rem.php, or
something like this. It would be enough, if this would be a symlink on
the server to unsubscribe.php.
Thanks,
Alexander Skwar
- Forwarded message from p j j [EMAIL PROTECTED] -
From: p j j [EMAIL PROTECTED]
Date: 6 May 2002 06:09:01 -
Subject
and
still got a good copy of date around.
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.iso-top.de | Jabber: [EMAIL PROTECTED]
iso-top.de - Die günstige Art an Linux Distributionen zu kommen
!
BTW: You don't have to insert the user manually. If you try to GRANT
access to a non existing user, the user will be silently created.
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.iso-top.de | Jabber: [EMAIL
So sprach »Cafetechno« am 2001-12-26 um 10:34:59 +0700 :
If mysql will include the stored procedure feature, what kind of langguage
to be used for the stored procedure ?
If you use myperl, it will be perl.
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to
So sprach »Fredrick Bartlett« am 2001-12-26 um 07:30:44 -0800 :
Explain how to configure the handlers for myperl under the win32 platform...
I don't know.
filter: sql
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http
So sprach »Webmaster« am 2001-12-25 um 10:30:47 -0500 :
i meant 3.23.. just so you all know
Fine... And the problem is...?
Filter: sql
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.iso-top.de | Jabber
is, that comparisons with a BINARY VARCHAR
are case sensitive, whereas VARCHARs are case insensitive.
sql
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.iso-top.de | Jabber: [EMAIL PROTECTED]
iso-top.de - Die
So sprach »Keith C. Ivey« am 2001-11-28 um 16:27:46 -0500 :
Does that work for you? The MySQL button on the side links to a
Yep, it does. Mozilla 0.9.6, Opera 5.05tp1 and Konqueror 2.2.1 checked;
all on Linux.
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote
just fine.
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.digitalprojects.com | http://www.iso-top.de
iso-top.de - Die günstige Art an Linux Distributionen zu kommen
Uptime: 1 day 10 hours 17 minutes
the mysql process runs
under.
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.digitalprojects.com | http://www.iso-top.de
iso-top.de - Die günstige Art an Linux Distributionen zu kommen
Uptime: 2 hours
So sprach »Felipe Baytelman« am 2001-09-19 um 11:37:36 -0400 :
I'm getting
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
Does the file actually exist? I know that you deleted it, but
Alexander Skwar
--
How to quote: http://learn.to
So sprach »Kimman Lui« am 2001-09-03 um 16:26:33 +0800 :
How many types of triggers MySQL have? And what about stored procedures?
none and (close to) none.
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http
So sprach »s . keeling« am 2001-08-31 um 11:51:00 -0600 :
Is anyone else getting these goofy bounces from 123box.co.uk besides
me? Should I report them to Spamcop? :-)
i'm getting these as well.
database, sql, ...
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http
database,sql,query,table
So sprach =BBJaime Teng=AB am 2001-08-31 um 03:53:47 +0800 :
Is there a number sequence generator/function in
you can set the INT types to auto_increment, which will do just that
when you insert rows.
Alexander Skwar
--
How to quote: http://learn.to/quote (german
So sprach »James McLaughlin« am 2001-07-28 um 13:24:21 -0600 :
PHPmyAdmin is a great program to use for working with a mySQL DB.
http://www.phpwizard.net/projects/phpMyAdmin/
Or, for a more recent version of phpMyAdmin:
http://phpMyAdmin.sourceforge.net
PS: sql
Alexander Skwar
--
How
a telnet session.
PS: sql
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.digitalprojects.com | http://www.iso-top.de
iso-top.de - Die günstige Art an Linux Distributionen zu kommen
Uptime: 5 hours 8
? Honestly, I
really think this is a *BAD* advice...
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.digitalprojects.com | http://www.iso-top.de
iso-top.de - Die günstige Art an Linux Distributionen zu kommen
then. Which is fine in certain
use cases.
PS: filter sql
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.digitalprojects.com | http://www.iso-top.de
iso-top.de - Die günstige Art an Linux Distributionen zu kommen
database,sql,query,table
So sprach =BBPeter van Dijk=AB am 2001-07-25 um 23:59:48 +0200 :
That is only true for a parallel cipher. A non-parallel cipher (like
Yep, that's why I said symetrical encryption. Asymetrical enc.'s work
like you explained.
Alexander Skwar
--
How to quote: http
unhappy so he
may go.
PS: PLEASE *NO* FULLQUOTES! No topquotes either.
PPS: sql and such
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.digitalprojects.com | http://www.iso-top.de
iso-top.de - Die günstige Art
So sprach »Alexander 'Digital Projects' Skwar« am 2001-07-26 um 18:48:15 +0200 :
MySQL's builtin ENCRYPT() function is good enough. No need to worry
Uhm, is ENCRYPT decryptable?
Anyhow, I was rather thinking about ENCODE()/DECODE().
PS: filter sql
Alexander Skwar
--
How to quote: http
]
List-Unsubscribe: mailto:[EMAIL PROTECTED]
List-Post: mailto:[EMAIL PROTECTED]
List-Subscribe: mailto:[EMAIL PROTECTED]
Delivered-To: mailing list [EMAIL PROTECTED]
Received: (qmail 21241 invoked from network); 26 Jul 2001 16:48:40 -
Date: Thu, 26 Jul 2001 18:51:30 +0200
From: Alexander Skwar
So sprach »Christian Grimm« am 2001-07-25 um 22:16:04 +0200 :
sa must be a 2-char long Salt-String...
Which is completely optional :)
sql,database,filter
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http
to decrypt the cc# which is
not stored on the same computer as the MySQL database. But then you
need to worry about how to securly transfer the data from the MySQL
database to the computer running the decryption program.
So, overall, I'd say: Don't hassle with encryption: It's not worth it.
Alexander
be true, if you disregard the fact that you cannot store 8 MB
in a TEXT field.
benefit of TINYTEXT over a VARCHAR field?
This, I always wondered myself...
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.digitalprojects.com
value i set. So, if I'd replay the dump, the
first time I insert a row it would get 1 for the auto_increment, and not
4711.
How to circumvent this?
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.digitalprojects.com
:
SELECT * FROM this_table ORDER BY name, time GROUP BY CONCAT(field1,
field2);
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.digitalprojects.com | http://www.iso-top.de
iso-top.de - Die günstige Art an Linux
it itself.
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.digitalprojects.com | http://www.iso-top.de
iso-top.de - Die günstige Art an Linux Distributionen zu kommen
Uptime: 14 hours 30 minutes
So sprach »Sinisa Milivojevic« am 2001-07-16 um 14:20:07 +0300 :
MySQL 4.0 will be this autumn.
Very fine! Thanks a lot!
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.digitalprojects.com | http://www.iso-top.de
.
Would this work?
SELECT Cities.Name FROM Profiles,
IF(Profiles.CityID 7, Cities1, Cities2) AS Cities
WHERE Profiles.ID = Cities.ID
AND Profiles.ID = 4711;
Thanks,
Alexander Skwar
filter: sql
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage
So sprach »Prabu Subroto« am 2001-07-15 um 01:00:17 -0700 :
Dear my beloved e-pals,
Hello beloved Prabu! :)
engine...? Under which directory is my database
On RedHat/Mandrake it's in /var/lib/mysql.
But actually you might not need it. Have a look at mysqldump.
Alexander Skwar
--
How
o sprach Sinisa Milivojevic am 2001-07-14 um 15:24:32 +0300:
Unions will soon come in 4.0.
Yes, I know, bad question, but anyhow: How soon is 4.0 going to come?
Tomorrow :), end of the month, end of the year?
PS: database,sql,query,table
Alexander Skwar
--
How to quote: http://learn.to
Hello
When I store some data in a table of type Heap, this data will be lost
when the server is shutdown (and later restarted), won't it?
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.digitalprojects.com | http
So sprach »Fournier Jocelyn [Presence-PC]« am 2001-07-15 um 23:37:57 +0200 :
Hi,
Definitely yes :)
But the table structure won't be lost.
Thanks to all who replied!
filter: sql
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage
So sprach --==[bMan]==-- am Sat, Jun 09, 2001 at 06:35:31PM -0400:
Where can I get MySQL authentication module for Apache?
try google.com - the first hit for the exact quesion you asked will tell you
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english
So sprach Jeffrey L. Fitzgerald am Wed, Jun 06, 2001 at 12:08:18AM -0400:
Currently the text coming back from the database is all runs together in
the web browser...
Try nl2br - php.net/nl2br
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english
also say that RedHat is somewhat nice. I'd take Mandrake,
though.
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.digitalprojects.com | http://www.iso-top.de
iso-top.de - Die günstige Art an Linux Distributionen zu
and ', so it's still a good idea to htmlentites' it if it's only
going to be printed afterwards.
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.digitalprojects.com | http://www.iso-top.de
iso-top.de - Die günstige Art
the \\ in my ALTER TABLE statement survived.
This is very strange/I don't understand it all
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.digitalprojects.com | http://www.iso-top.de
iso-top.de - Die günstige Art
a DATETIME or TIMESTAMP column.
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.digitalprojects.com | http://www.iso-top.de
iso-top.de - Die günstige Art an Linux Distributionen zu kommen
Uptime: 0 hours
So sprach Dave Carter am Fri, May 25, 2001 at 06:21:08PM -0400:
Is there a way inside of mysql to force the case of data being inserted into
the database???
- http://www.mysql.com/doc/S/t/String_functions.html
LOWER() / LCASE() and UPPER() / UCASE()
Alexander Skwar
--
How to quote: http
at http://mysql.com/doc
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.digitalprojects.com | http://www.iso-top.de
iso-top.de - Die günstige Art an Linux Distributionen zu kommen
Uptime: 6 days 10 hours 27
will automatically update everytime you
update/insert a row, or use a DATETIME column which you'll have to set to
the date you want, eg. with 'INSERT INTO Tbl SET DatetimeColumn = NOW();'
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage
+0300:
SELECT DISTINCT MYID from Table;
How can I get the results ordered by time ?
SELECT DISTINCT MYID from Table order by time;
Alexander Skwar
--=20
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.digitalprojects.com | http
was?
You can't. last_insert_id() will tell you the last_insert_id from the
current session/connection.
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.digitalprojects.com | http://www.iso-top.de
iso-top.de - Die
old value. Not doing this will set it to the
then current time.
Or add a datetime column and set it to the current time when INSERT'ing with
"INSERT INTO TBL SET DatetimeCol = NOW()"
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
On 11.04.2001 10:41:05 Jamaludin Azilawati-F1159Z wrote:
.doc and .bmp files can be stored but when retrieved , files get corrupted .
Any idea how I can solve this?
Uhm, did you escape embedded NULLs in the file? Did you byte compare the files
you've stored and retrieved to see if they
On 06.04.2001 11:46:53 vblkuer wrote:
Rckmeldung bitte an
[EMAIL PROTECTED]
Nein, hier gefragt - hier die Antwort!! Zumal so eine Antwort bestimmt auch
andere interessiert - mich zum Beispiel!
-
Before posting, please
On 04.04.2001 16:42:28 ?iso-8859-1?Q?Ren=E9_Tegel?= wrote:
not for speed, but i defitively prefer your second query. Reason for this is
simple: you name the field you want to insert.
Yes, you are right. But I prefer a third way altogether:
INSERT INTO Tbl SET Field=42;
The reason for
On 05.04.2001 04:23:55 Taing Nguon wrote:
I am not sure what you explained. You mean that place PATH/filename.jpg to
picture field. isn't it? If yes, it is just a text. How can we explore that
picture thru web browser such as IE or Netscape? Thanks for the answer
Well, he said that he has
On 04.04.2001 08:55:04 Nicolas Villatte wrote:
is it possible? If yes, how ?
Could someone *PLEASE* add this to the FAQ?
There are two answers you'll get:
a) Don't store the binary data in the database. Instead store nothing but the
metadata.
b) Also store the binary data in the database.
On 04.04.2001 11:21:46 Peter Skipworth wrote:
Ouch! I don't know if many people would recommend this method - that's a
fair bit of unnecesary overhead to place ony our server...depending, of
course, on how often these images are created/modified/read.
Do you mean the base64 part, or what?
On 04.04.2001 08:49:07 Nanjunda BM Prasad wrote:
i have set the system format of date as DD/MM/. Is there any
additional things to do ? pls. send me the solution.
use date_format to return the date in any format you want.
On 21.03.2001 10:14:34 Don Read wrote:
So I looked in the manual and found that:
"mysql_query() cannot be used for queries that contain binary data; you
should use mysql_real_query() instead. "
What manual? MySQL manual? If so, disregard that information - it's incorrect
as
On 21.03.2001 12:33:35 Sinisa Milivojevic wrote:
Unfortunately, that is not true !!
PHP has yet to fix that. That is not a serious error, though, just a
small waste of OS resources.
Oh, so you're saying that PHP is buggy wrt this?
Thanks for the information!
On 20.03.2001 14:48:58 Sinisa Milivojevic wrote:
Also, do you have clients that do not call mysql_close at the end ,
like PHP programs ?
Huh? According to the PHP manual, I always thought that it is unnecessary to
explicitly call mysql_close() in PHP. In the PHP manual it says, that the
So sprach Kelly Alexander Zia am Sat, Mar 17, 2001 at 11:08:04AM -0700:
Warning: Supplied argument is not a valid MySQL result resource in
c:\phpweb/searchresults1.php on line 462
The database connection is somehow broken.
Alexander Skwar
--
How to quote: http://learn.to/quote (german
On 14.03.2001 22:33:13 Charles L Hagen wrote:
Has anyone found a GUI for MySQL on a Linux box? I found Webmin, but it
seems limited.
Is there an HTML GUI for MySQL?
phpMyAdmin - see freshmeat
-
Before posting, please
On 15.03.2001 10:23:19 Sunrise wrote:
Hi, alexander.skwar,
Mysql has the type as the MSSQL BIT???
Pardon me? What do you mean?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
On 15.03.2001 11:10:24 Eric Holmbom wrote:
Thu, 15 Mar 2001 11:09:14 +0100 SQL SQLDriverConnect
Thu, 15 Mar 2001 11:09:14 +0100 ERR [TCX][MyODBC]Access denied
for
user: 'root@ipaddress' (Using password: YES)
Wrong password, I'd say.
On 13.03.2001 23:37:20 Kevin Price-Ward wrote:
You can NOT use gcc-2.96.
Why not? Compiling works fine, without a problem - anything else that I'm
missing?
-
Before posting, please check:
On 09.03.2001 10:29:28 Christian Hammers wrote:
Is this a bug or is the decimal type just evil or how should *I* behave
when having such a table?
If I'm not mistaken, then decimal is handled internally like a float. And as
such, problems like yours are really expected, because there simply
On 08.03.2001 13:39:34 James Makunike wrote:
Where do I get the php libraries as one file?
What do you mean?
http://www.php.net has the sources and binaries
-
Before posting, please check:
On 06.03.2001 19:05:34 iso-8859-1 wrote:
Is this expected behavior? Or is this an actual bug?
I suppose this may be expected behavior, as FullText now is a reserved word in
MySQL
-
Before posting, please check:
choice.
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.digitalprojects.com | http://www.iso-top.de
iso-top.de - Die guenstige Art an Linux Distributionen zu kommen
Uptime: 15 hours 18 minutes
tion still is. Why are auto_increment columns are not supported
True.
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.digitalprojects.com | http://www.iso-top.de
iso-top.de - Die guenstige Art an Linux Distributionen
On 28.02.2001 05:58:33 ?US-ASCII?Q?Fabio_Ottolini?= wrote:
mysqldump "spits" not only table structures but data also. When you use
mysql to import data it will first attempt to create the table and then load
its values. If your table's got AUTO_INCREMENT set it will work fine after
On 28.02.2001 19:51:13 Gerald L. Clark wrote:
In the dump, the autoincrement columns will have their actual values,
not 0.
Yes, correct - and if the actual value is 0, it will contain just this. And
inserting a row with the col set to 0, will change the column value.
TRY IT!
On 28.02.2001 22:51:12 Jason Landry wrote:
Well, except that the value of an auto-increment field CAN be set to a
specific value (perhaps negative) an INSERT or UPDATE statement.
As long as the value is != 0 for INSERT statements.
On 01.03.2001 02:37:17 Rolf Hopkins wrote:
Or use the no dependency flag or upgrade.
That's as good as suggesting to not use rpm at all. The dependencies are in
there with a reason, you know.
Never upgrade/install with --force/--nodeps.
On 01.03.2001 01:54:14 John Nielsen wrote:
Hey everyone,
This may have already come up a couple of times in the mailling list, but I
I was wondering with mysql-3.22.32 if you can have two auto_increment's
in one table, e.g.:
What would this be good for? Yes, I've seen that one of your
On 01.03.2001 10:46:33 M. A. Ould-Beddi wrote:
I know that in Oracle it is possible to select a number
from DUAL and put it in a variable. Is it possible
??? What's DUAL?
-
Before posting, please check:
On 01.03.2001 09:50:36 Blaz Grapar wrote:
Is there a boolean field type (Yes/No; True/False, 1/0) in MySQL or what is
closest to the boolean type
ShortInt: 0 == FALSE, 0 == TRUE
That's how I do it anyway.
Or maybe combine multiple bool fields to one and use binary logic.
On 01.03.2001 11:55:40 Ben Kennish wrote:
"Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (111) in
/var/www/html/index.php on line 5"
Are you sure that your MySQL installation creates the socket right there? If
I'm not
On 01.03.2001 12:35:55 Gorjan Todorovski wrote:
So does mySQL support transactions or not? There are transaction safe tables
but they are not actually implemented?
They are implemented, if you chose the right table type.
On 01.03.2001 13:16:47 soon chee keong wrote:
Table_A: ID APPL
B BI
A BII
* *
* *
C BII
* *
D BI
Table_B: Cnty ID
USC
or " and what not all else. This will become a
hassle which I avoid by base64 encoding the data.
I also have to store the image type (PNG, JPEG, GIF...), so that it is
completely clear what kind of image I'm storing. I don't know if the
browser would display
On 28.02.2001 05:17:09 Rolf Hopkins wrote:
But the way you are doing it now is perfectly ok. You may even find it a
Not always! There are setups where it is better to store the image in the
database instead of on the filesystem.
On 28.02.2001 21:26:17 ?iso-8859-1?Q?F=E1bio_Ottolini?= wrote:
Try using mysqldump.
This won't work always! For instance, I have a table that has a auto_increment
INT column in it. Storing a row with this column set to 0 (zero), will add this
row just fine. But now the row will not have
On 28.04.2003 10:55:50 Keneth wrote:
"When I try to dump sql database it gives me some errors 1.Error 1045
mysqldump --opt database backup-accp.sql mysqldump: Got error: 1045:
Access denied for user: 'accp@localhost' (Using pass word: NO) "
You did not specify the username and password on
On 28.02.2001 13:13:05 Bob Hall wrote:
Og nu da jeg s nrmere p din email adresse, er du selvflgelig velkommen
til at sprge p dansk... ;-)
Det er alltid hyggelig se p andre sprg p internettet, men hvis
du skriver p dansk, s skal de aller fleste taper sjansen lre om
ADO og MySQL.
Bitte
On 28.02.2001 14:28:14 Tobias Wolff wrote:
The binary may have a different name. If there is only a /usr/bin/perl you
may have to create and symbolic link.
Which won't work, because RPM doesn't care at all about what the filesystem
really looks like. All it cares about is what it THINKS
On 27.02.2001 09:51:02 Toth Dalibor wrote:
What is wrong here??!!
Missing a , at the line above
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
On 27.02.2001 12:00:38 wrote:
then i try the following and i get the error message.
WHAT error message?
load data local inifile "c:\text.txt" into table dbname.tblname fields
terminated by ',' ;
Hmm, as you don't tell us the error message that you're getting, it's hard to
help you.
I
On 27.02.2001 14:11:51 Toth Dalibor wrote:
I managed to make, a match throughout multiple fields but single table:
SELECT rid,nazivRecepta,MATCH nazivRecepta,uvod,nacinPripreme AGAINST
('vegetine') as relevance FROM recepti order by relevance desc
I also need to include nazivSastojka field
On 26.02.2001 12:54:02 MANGERA, Faizal wrote:
Hi everyone,
Is there a front-end available for Mysql. I am currently using Mascon as an
administrative front-end, which is very good. However I need a front-end
with less administrative features, something where-by users can
On 26.02.2001 14:19:40 TisSoft s.c. wrote:
PRIMARY KEY (SYMBOL),
UNIQUE SYMBOL (SYMBOL)
What's the sense of this? PRIMARY is already UNIQUE, so you don't need to
UNIQUE symbol again.
-
Before posting, please check:
On 26.02.2001 14:45:50 Dart wrote:
Dear all,
Sorry to ask question again, or maybe i am just a beginner.
I wanna ask:
If there are 2 records
Name Income Out
Data1 1000 700
Data2970500
If i want to have the output:
Name
On 22.02.2001 16:22:13 Simon Windsor wrote:
Has anyone user MySql on a ReisserFS file system ?
HERE!
No problems whatsoever - why should there be problems anyway?
-
Before posting, please check:
On 22.02.2001 17:55:36 Jon Haworth wrote:
Well, you could filter anything sent or cc'ed to [EMAIL PROTECTED] into
a separate folder
But only, if your client allows that - and changing is not always an option!
-
Before
On 23.02.2001 10:29:21 ?iso-8859-1?Q?T=F5nu?= Samuel wrote:
Only problem we know is that in our tests on ReiserFS is MySQL was 30%
faster on writes :/
Hmm, so, I understand you right: You're saying that it's not a good idea to use
MySQL on ReiserFS, as you may get a speed rush? *G*
On 23.02.2001 13:01:44 Danie Weideman wrote:
What field type must be defined for pictures.
MEDIUMTEXT for the data
VARCHAR/ENUM/INTEGER/whatever for the image type
How to load and retreive pictures from a database using PHP
The same you do with "normal" data. Ie.:
Store:INSERT INTO
On 23.02.2001 13:35:33 ?iso-8859-1?Q?Daniel_Als=E9n?= wrote:
tried changing the type to TEXT and 2000 as fieldlength. But i only get a
syntax error.
What did you type and what was the error? Maybe the VARCHAR field was indexed
without bounds? That's not possible for BLOB types; you have to
On 20.02.2001 10:08:18 ited wrote:
why do [would] you want to *admin* MySQL over the web (say, with phpMyAdmin)?
Because especially phpMyAdmin allows me to nicely see what's in the database and
administer it?
Hmm, I know, questions should not be answered by questions, but why would you
On 16.02.2001 10:05:54 I.SivaramaKrishnan wrote:
Hi all,
Basically I have a requirement where I have to store xml files in the
database.
The table that I visualised for the purpose will contain two columns, one
being
the key (varchar) and the other for the xml file. What data type should
On 16.02.2001 10:08:26 I.SivaramaKrishnan wrote:
NOTE: Since iam not a member of this group, please reply by cc`ing to my mail
id.
That's a behavior I never quite understood - you come to list seeking for
advice. Fine. Next you say that you do not care at all about the list. Geez,
if you
On 16.02.2001 13:27:58 Vyacheslav Chukin wrote:
Please, tell me,
how could I determine,
which one of two datetime values is greater?
Date1 Date2
In other words,
how could I determine,
is stored on db datetime value in future or past?
Past:
DbDateTime NOW()
Present:
DbDateTime =
On 09.02.2001 12:01:01 Kissandrakis S. George wrote:
I have 6500 tables under one database there is no problem
Pardon me, but how do you keep track of that many tables? I mean, I've a hard
time with 10 or 20 tables - but 6500???
On 08.02.2001 15:09:47 Christian Ribeaud wrote:
would like that the table put automatically the today's date for every INPUT
as
default value. What is wrong?
Uhm, why don't you use a timestamp column type then? Okay, it will also save
the time, but it's easy to extract only the date, if
On 06.02.2001 18:09:36 russ wrote:
Im new to the list, apologies if this has been asked before.
Im developing a backend for a personal site (www.russd.com) using mySQL.
The site is hosted on NT4 and has myODBC installed, I have some database
access
working, but I'm looking for a way to
1 - 100 of 106 matches
Mail list logo