sword yyy.
> mysql> grant all privileges on xxx.* to xxx;
Here you insert another user but don't set a password!
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
--
can display the "nicely" formated date in DATE_DSP 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 PROTECT
it be possible 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" <
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
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
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 |
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 (
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
than 7.
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 (engl
auto_increment 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
e ORDER BY name, time;
Untested:
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
l would not have done 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
version of the same field. And what is the
This may 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) ht
bly do.
The last also applies, if you use a program 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:
ethods.
It's rather security-through-obscurity 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
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
l he's already 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üns
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
--
ilto:[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: h
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
-
sitive
data from 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
U
ing is fine, but Unstable? 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 Distribu
not GPL. So,
you can buy your way out of the GPL wrt. MySQL.
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 Distrib
So sprach »Jay Fesco« am 2001-08-30 um 12:01:09 -0400 :
> X-message-flag: Mailbox corrupt. Please upgrade your mail software.
It's a "feature" of Outlook, which will interpret this header line and
display the note which is in it.
> database,sql,query,table
Alexander S
> 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:
On 14.02.2001 17:08:15 Lad.Gaal wrote:
> and mysql seems to be working fine. However, I could not find phpMyAdmin. So
how
So, download it, follow the instructions, and you're done! And if you don't
know where it is - search! Hint: It's google.com's top hit.
---
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 sh
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 yo
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:
DbDateT
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
*NOT
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:
http://www.mysql.com/ma
On 22.02.2001 12:08:06 Jeff Gannaway wrote:
> I've only been on the list for a day and a half. However I'm a memeber of
> 3 high-volume lists and I can tell that adopting this technique would make
> my life easier, and presumably other list memebers too. It definitely
> makes it easier to sort
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!
-
Befor
On 22.02.2001 18:06:12 Quickling wrote:
> Hey -
>
> >Since a lot messages have undescriptive subjects ("Help", "Check This",
> >"What's This?", etc...) I think it would be a good idea to set up the
> >majordomo to add a tag to each subject line like the PHP list does.
>
>
> "[MYSQL] Help" is har
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 11:44:55 mvandaele wrote:
> I tried a lot of statements similar to this one from visual basic on an access
> database:
> "select * from Times where" & strField & " between '" & CDate(FilterA) & "'
and
> '" & CDate(FilterB) & "'"
>
> =select * from Times where StartTime between '20
On 23.02.2001 11:52:27 Software by ScuoLavoro wrote:
> Warning: MySQL Connection Failed: Can't connect to MySQL server on 'localhost'
> (10061) in lib.inc.php3 on line 255
> Erreur
> coul someone help me?
With such a "descriptive" error message?
Please also post the line 255 to the list.
But
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 T
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 t
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
> create/edi
On 26.02.2001 13:36:20 Christian Hammers wrote:
> Hello
>
> Since a few weeks tablename completition using tab is not working any longer.
Are you sure that the table information is actually read at start of mysql? Do
a 'rehash' and see if it works then.
-
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:
>
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 lis
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 f
Further, if true binary data would be stored
in the table, you'd have to escape some "characters" in the binary stream,
like \0 (null character) ' or " and what not all else. This will become a
hassle which I avoid by base64 encoding the dat
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 th
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 28.02.2001 13:13:05 Bob Hall wrote:
> >Og nu da jeg så nærmere på din email adresse, er du selvfølgelig velkommen
> >til at spørge på dansk... ;-)
>
> Det er alltid hyggelig å se på andre språg på internettet, men hvis
> du skriver på dansk, så skal de aller fleste taper sjansen å lære om
> A
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 sh
On 28.02.2001 16:03:57 Gerald L. Clark wrote:
> But the dump who't have it set to zero, so it will reload with its
> proper value.
No, in the dump the column will be set to zero, but since "INSERT INTO Tbl
(AutoCol) VALUES (0)" means that AutoCol should be set to the next available
value (if Au
On 28.02.2001 15:33:27 John Dean wrote:
> Hi
> Since the language of business here at MySQL is English it would be nice if
> all messages to the list are written in English. This way you would have more
> chance of receiving reply
Yeah, that's just what I was saying :]
--
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
> recre
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 yo
On 01.03.2001 09:59:58 Patrik Nylund wrote:
> Hi everybody, I qould like to this query:
select userid,count(userid) as cnt from points where acq=6 AND cnt > 1 group by
userid limit 100
-
Before posting, please check:
htt
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:
http://www.mys
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 28.02.2001 22:40:39 UzeV wrote:
> Hi,
>
> The webhosting company where I host my my site had upgraded their mysql to
> 3.23.32
> and now my program has an error, saying :
>
> Supplied argument is not a valid MySQL result resource in
>
> the error is in the line containing :
> while (
On 01.03.2001 11:56:59 Richard Ellerbrock wrote:
> Why not use a timestamp column to guarentee the order in which rows get
> inserted into the table? You can then order on the timestamp column.
Hmm, timestamp, ie. seconds as finest resolution, might be to broad depending on
the hits his site wi
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 mis
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
>
>
is also not a good 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: 1
ex.
> The question 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 L
So sprach Robert Vetter am Thu, Mar 01, 2001 at 04:55:34PM +0100:
> 1 or 2 bytes, depending on the number of enumeration values (65535
> values maximum). I've read this in the _MANUAL_ !
Heh, okay, thanks *G*
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://
On 06.03.2001 18:43:32 Nguyen, David M wrote:
> I try to create a new table and setup a datatype for comment column that has
> about 7000 characters long. How do I define it in Oracle?
That's the MySQL mailing list, you know No idea how to do stuff in Oracle.
>
> **Here's my SQL and the
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:
http
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:
http://www.mysql.com/manual.p
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 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:
http://www.mysql.com/manual.
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, pleas
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)
http:
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.
---
at question of sunrise - could you be so kind
and explain what he asked?
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
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 (
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
c
On 21.03.2001 00:01:16 Mike Baerwolf wrote:
> Hello,
>
> Still trying to get jpegs into my database. I have a blob column setup, How
do
> I get the jpeg into the blob column?
Read the file into a variable and insert it. Make sure to either escape NULLs
or to make the data "safe" in other ways
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 incorrec
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 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 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 fo
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 ha
On 06.04.2001 11:46:53 vblkuer wrote:
> Rückmeldung bitte an
> [EMAIL PROTECTED]
Nein, hier gefragt - hier die Antwort!! Zumal so eine Antwort bestimmt auch
andere interessiert - mich zum Beispiel!
-
Before posting, please
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
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: h
ess 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 53 minu
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
Alexande
:
>
>mksock /var/lib/mysql/mysql.sock
>chmod 777 /var/lib/mysql/mysql.sock
>chown . /var/lib/mysql/mysql.sock
>
>replace and by the user/group the mysql process runs
>under.
>
>Alexander Skwar
>--
>How to quote: http://learn.to/quote (germ
tar.gz
which also uncompresses 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:
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
So sprach »Lars G 'LG' Örne« am 2001-12-07 um 13:19:00 +0100 :
> MySQL, float fields: Can I change from "." to ","?
Nope, they are always stored with . in the DB. However, when SELECTing,
you can easily convert using MySQLs replace() function.
Alexander Skwa
RY VARCHAR and a VARCHAR 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]
1 - 100 of 132 matches
Mail list logo
