I no longer have the original post in my inbox, I had a problem with
fetchmail which downloaded all the messages a couple hundred times, so i
did a mass delete.
All you should have to do is wrap the statement in () like:
UPDATE SET field=(field+1) WHERE
This will work fine from PHP using s
Hi,
I have to insert data to table which has many fields (252 fields). This
table was successful update by the LOAD DATA infile. But when I generate
SQL statement with from VB, SQL statment length got more than 1000 byte. I
was try many time to re-check SQL syntax but I still can not i
rcastro,
Wednesday, February 27, 2002, 12:28:01 AM, you wrote:
r> Hi!
r> My name is Ricardo Castro and i'm writing for Ensenada, Mexico. My problem
r> installing MySQL is next:
r> I've unzipped MySQL (mysql-max-3.23.49-pc-linux-gnu-i686.tar.gz)in /usr/local/;
r> i've follow all the steps
Floyd,
Wednesday, February 27, 2002, 2:31:56 AM, you wrote:
FB> Hi.. Can anyone tell me some good places to look for sample snips,
FB> tutorials or other assistance specifically for making PHP and mySQL
FB> cooperate. Running mysql queries using php syntax. Mysql talks about
FB> mysql queries,
Hello,
is possible to change encoding (character set) while conecting to
mysql from php ?? (In postgre is SET client_encoding = 'latin2').
Thank you.
Lampa aka Michal
-
Before posting, please check:
http://www.mysql.com/ma
I've been having this problem as well, which results from mySQL not allowing
you to select and insert from the same table at the same time. This
restriction makes some sense even in your case- mySQL wants to insert each
row as it finds it in the select, but then that might change what results
the
Problem:
1. in a phone book, a single field may contain several words, e.g.
District 52 Police Station.
2. The query for this record may contain some or all of these words, but not
necessarily in that order, e.g. Police district 52.
3. Searching for all of the query words can be done in many way
On Wednesday 27 February 2002 07:47 am, Jeff Kilbride wrote:
> -
> I'm going to be implementing a keyword search pretty soon myself, so I'd
> like to see you solve this. :)
Me too! :-)
> What about doing some sort of prefix indexing, instead of indexing the
> e
Hi Tyler,
Apologies for the absence/delay. Pleased to hear that the problem is solved.
It does raise the question though - if it failed in PHP (etc) how did you manage to
get it to work in
MySQL-client?
If an UPDATE flat refuses to go (which didn't seem to be the case here), then the
first 'ch
Hi Floyd,
> Hi.. Can anyone tell me some good places to look for sample snips,
> tutorials or other assistance specifically for making PHP and mySQL
> cooperate. Running mysql queries using php syntax. Mysql talks about
> mysql queries, etc. and php talks about php functions, etc. but I'm
> fi
Stewart,
> All you should have to do is wrap the statement in () like:
> UPDATE SET field=(field+1) WHERE
I had a look in the manual (http://www.mysql.com/doc/U/P/UPDATE.html).
Where did you find the requirement for parentheses?
Do you have live code where UPDATE works with parentheses, but
You have written the following:
I understand the principles but WHEN should they be used or considered ??
Any help appreciated
tia
John
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (t
>Description:
There are a few errors in characters sorting order
in sql/share/charsets/cp1257.conf file.
Characters 0xE0 0x5A 0x7A 0xDE 0xFE are treated equaly.
But accoding Lithuanian standart LST 1285:1993 (if you interested :)
character 0xE0 should be between 0x61 (a) and 0x62 (b),
Has anyone tried to use the Mysql++ api with visual C++.net?
Thanks,
Josh
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archiv
Hi Rob,
You're right for my problem. I'll hope this solution to be fixed
in MySQL someday. thanks anyway.
Sommai
At 10:28 27/2/2002 +, Rob wrote:
>I've been having this problem as well, which results from mySQL not allowing
>you to select and insert from the same table at the same
Michal,
Wednesday, February 27, 2002, 11:41:14 AM, you wrote:
MD> Hello,
MD> is possible to change encoding (character set) while conecting to
MD> mysql from php ?? (In postgre is SET client_encoding = 'latin2').
Character set is set when mysqld is started. If you want to use
different characte
Joey,
Wednesday, February 27, 2002, 3:26:26 AM, you wrote:
JF> Dear all,
JF> How to make MySQL with Chinese Big5 support? Thanks.
You should set big5 character set, look at:
http://www.mysql.com/doc/C/h/Character_sets.html
--
For technical support contracts, goto https://order.mysql.
Davis, Charles M writes:
> Hello,
>
> I downloaded the beta version of MySQLGUI and was unable to perform any
> table creation. Is this feature currently not supported?
>
> Thanks,
> Charles
>
> Charles Davis
> Member Engineering Staff, Data Analysis Systems
> Lockheed Martin - Naval Electronic
Joshua Angolano writes:
> Has anyone tried to use Mysql++ with Microsoft Visual C++ .NET?
> Better yet, has anyone had any luck and how?
> Thanks for your help,
> Josh
No, but it could be tried out ..
If you have that VC++ version, you can try it.
--
Regards,
__ ___ ___ _
Craig,
[BTW there is a set of PHP lists, including PHP-DB - mentioned because 'purists'
sometimes object to 'PHP
questions'!?]
> >>The following lists 12 items from a fruits table.
> >>
> >>$results = mysql_query("SELECT ID, date, appleprice, orangeprice, pearprice
> >>FROM fruits");
> >>while (
hello edna and brian,
your life savers! thank you for getting back to me.
i've done the chown and chmod which went well! then i typed:
mysql_install_db
this then said 'installing all prepared tables' and a message saying:
/usr/sbin/mysqld: Shutdown Complete
after that the default kind of we
Hi rob,
I have another question but still in this solution. How did you
delete data which different in 2 table?
Sommai
At 10:28 27/2/2002 +, Rob wrote:
>I've been having this problem as well, which results from mySQL not allowing
>you to select and insert from the same table at th
John,
> You have written the following:
>
> I understand the principles but WHEN should they be used or considered ??
>
> Any help appreciated
Something of an assumption here that we're all able to recollect an earlier post? Hope
I'm on the right
wavelength.
I use temporary tables to get over
I have tried to use the Mysql++ api with visual C++ .net. It would not
even compile the library.
Has anyone had any luck with this?? Maybe there is some setting that I
missed?? Are there any plans to update Mysql++ to work with visual
C++.net??
Thanks,
Josh
---
* Doug Thompson
> Roger:
> I found using variables to work as expected with 3.23.43 and Win98.
>
> I was unable to duplicate your changing outputs.
I was using a 3.23.30-gamma win2k.
> mysql> select @a:=digits,number,round(number,@a) from testme;
> ++--+--+
>
[EMAIL PROTECTED] writes:
> >Description:
> There are a few errors in characters sorting order
> in sql/share/charsets/cp1257.conf file.
>
> Characters 0xE0 0x5A 0x7A 0xDE 0xFE are treated equaly.
> But accoding Lithuanian standart LST 1285:1993 (if you interested :)
> character 0xE0 s
Joshua Angolano writes:
> Has anyone tried to use the Mysql++ api with visual C++.net?
>Thanks,
> Josh
>
As far as I know, no.
But it is worth a try if you have VC++.net.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL
Joshua Angolano writes:
> I have tried to use the Mysql++ api with visual C++ .net. It would not
> even compile the library.
> Has anyone had any luck with this?? Maybe there is some setting that I
> missed?? Are there any plans to update Mysql++ to work with visual
> C++.net??
> Thanks,
>
Hi, I have a table like this
Key Field-1
A string1
A string2
A string3
B string1
B string 2
I want to create a query to get the following result (only one line by key
field):
A - string1,string2,string3
B - string1,string2
I try to u
This is probably an easy one for someone...
Is here an easy way NOT to have a mysqldump data file that includes /N when the column
is a NULL ?
Ideally what I'm looking for is a mysqldump option that doesn't put a /N in the data
file for al the NULL VALUES.
Scripting a global cut or strip out o
Paul,
Wednesday, February 27, 2002, 4:47:46 AM, you wrote:
PW> Hi,
PW> I wish to alphabetically sort data retrieved from MySQL using JSP for
PW> web a page. The data will be stored in Japanese. I understand there are
PW> multiple alphabets/dialects in Japanese with a large number of character
Hi. I am running MySQL 3.22.30, and am having trouble repairing a corrupted
table with isamchk. Everything that I've tried either doesn't work, or wipes
out all the data. Here's what I've tried so far:
***
isamchk -d guestbook
ISAM file: guestbook
Data records: 79764 Deleted bl
Description:
When using mysqlhotcopy for database backups, it fails to backup a Database or Table
with a minus ("-") or blanks in its name,
for example when using "mydb.user-table", "mydb.user table", "my db.usertable" or
"my-db.usertable" and says "You have an error in your SQL Syntax"
How-To
Is it possible to install just the mysql client software for NT? The only
client distributions I can find include the mysql server as well.
Carl McNamee
Systems Administrator
Billing Concepts
(210) 949-7282
-
Before posting, p
Sorry for the length of this message, but, I don´t understand what it means,
and why it says my address will be removed from the list without
explanation.
thanx
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 27, 2002 12:58 AM
Subject: ezm
Hi Javier,
> Hi, I have a table like this
>
>Key Field-1
>A string1
>A string2
>A string3
>B string1
>B string 2
>
> I want to create a query to get the following result (only one line by key
> field):
>
>A - string1,string2,string3
Sommai,
Wednesday, February 27, 2002, 11:29:30 AM, you wrote:
SF> Hi,
SF> I have to insert data to table which has many fields (252 fields). This
SF> table was successful update by the LOAD DATA infile. But when I generate
SF> SQL statement with from VB, SQL statment length got more tha
Oladejo,
Wednesday, February 27, 2002, 3:04:05 AM, you wrote:
Oeoen> Hi All,
Oeoen> I am trying to compile php with mysql and apache into it, however during the
Oeoen> ./configure, I keep getting "Invalid Apache directory - unable to find
Oeoen> httpd.h under /usr/include/apache", even though tha
On 27 Feb 2002, at 8:18, Baines, Dominic wrote:
> If you immediately use the dump, this is fine if it is to be used
> with MySQL but if you want to port it to another RDBMS the /N for
> a NULL causes some 'issues'.
If you don't care about the difference between NULL and the empty
string or 0, w
Please be careful of reading only half of the story, unfortunately the
article in question only talks about
> -Original Message-
> From: Tyler Longren [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 26, 2002 3:25 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: NuSphere
I asked this question as well some time back and got the standard answer
'READ THE MANUAL'. However, I still never found the answer to my question,
so when I get closer to deployment, I am going to experiment. I am
thinking that only MyODBC installation is required on the client and
possibly
All of a sudden Apache and MySQL are not running correctly under Windows 98.
It appears that somehow localhost was changed from 127.0.0.1 to something else.
Could the fact that I NOW have a 24/7cable connection to the Net cause the
problem?
Thanks!
Anthony Rodriguez
([EMAIL PROTECTED])
-
David,
I am seeing the exact same thing on some Solaris boxen. My database
sees a couple of updates every minute or two; and show slave status on
the slave always appears to lag behind the master. The data in my
tables lag as well as I've done some rudimentary checksumming and have
found dif
hi
i downloaded mysql rpms from mysql.com
& tried to install them on linux.
when i use the command rpm -i mysqlpackname in shell
it says
error:can't get exclusive lock on /var/lib/rpm/packages
error:can't open packages database in /var/lib/rpm
what shall i do.
later i managed to install it using
There is a huge difference between a NULL and NOT NULL and an empty string
and it would be handled in the table definition statements of the 'new' RDBMS
usually with a default column setting.
However, in this case the MySQL columns values are NULL the problem
(if it is one) is that /N does not
It can be done but it involves quite a few statements
and the use of temporary variables and a temporary table.
assuming that your table is defined as follows
CREATE TABLE `tble` (
`keyf` char(1) default NULL,
`Field1` char(8) default NULL
)
do this:
set @k='';
set @field='';
create temp
Hi,
Localhost is always associated to at least 127.0.0.1 IP, however you can add
as many IP adresses as you want to your machine by using TCP/IP properties
window in your control panel.
As long as you add IP adresses (reference them in tcp/ip layer) your apache
will handle the HTTP request.
It w
On Wed, 27 Feb 2002 13:53:15 +0100, Roger Baklund wrote:
>* Doug Thompson
>> I found using variables to work as expected with 3.23.43 and Win98.
>>
>> I was unable to duplicate your changing outputs.
>
>I was using a 3.23.30-gamma win2k.
>
>> mysql> select @a:=digits,number,round(number,@a) fro
On 27 Feb 2002, at 10:31, Baines, Dominic wrote:
> However, in this case the MySQL columns values are NULL the problem
> (if it is one) is that /N does not mean NULL in other RDBMS and you have
> to craft a method of converting or parsing the data either at load or
> pre-load to another format
Anthony,
Wednesday, February 27, 2002, 4:58:09 PM, you wrote:
AR> All of a sudden Apache and MySQL are not running correctly under Windows 98.
AR> It appears that somehow localhost was changed from 127.0.0.1 to something else.
No, localhost is 127.0.0.1
What type of error did you recieve?
AR> T
Carl,
Wednesday, February 27, 2002, 4:16:51 PM, you wrote:
CM> Is it possible to install just the mysql client software for NT? The only
CM> client distributions I can find include the mysql server as well.
Take a look at MySQLGUI and MyCC. You can find them at:
http://www.mysql.com/downlo
Hi,
I've noticed this problem, even if I don't know if it's really a mysql problem:
if I store a date in standard format, in a date field, all kinds of
ordering are OK.
But if I change the output format with: DATE_FORMAT(data,'%d-%m-%Y'),
the order by clause attempt to order the new format incorr
Hi,
I am using MySQL 3.22.32 and are trying to accomplish the following (without
going into too much detail, this is an example of the exact situation)...
1) I have two tables:
a) User table containing: UserID, FullName
b) Project table containing: ProjectID, ProjectManagerID and ProjectOwner
Dear all.
Has anyone practice in www-mysql package ?
I've installed apache, www-mysql. And so ? What next.
Marek Wysmulek.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mys
i am trying to write a program in perl and am getting a mysql error from my
module. here is the error:
DBI::db=HASH(0x294738)->disconnect invalidates 1 active statement handle
(either destroy statement handles or call finish on them before
disconnecting) at ./pop.pl line 124, line 2."
i think a
> But if I change the output format with: DATE_FORMAT(data,'%d-%m-%Y'),
> the order by clause attempt to order the new format
> incorrectly, because
> I've an output like this: 12-2-2002, 12-3-2002, 12-4-2002,
> and 13-2-2002!!!
I normally do this:
SELECT DATE_FORMAT(datefield,'%d-%m-%Y') as d
Wakan <[EMAIL PROTECTED]> wrote:
> But if I change the output format with: DATE_FORMAT(data,'%d-%m-%Y'),
> the order by clause attempt to order the new format incorrectly, because
> I've an output like this: 12-2-2002, 12-3-2002, 12-4-2002, and 13-2-2002!!!
> What can you say about this?
Can you
I have a MySQL InnoDB table for recording checking account transactions and
it currently has a foreign key on the routing number referencing a local
copy of the fed ach routing number database. It works a little too well, in
that a routing number may be good today, but not tomorrow. I would lik
>Description:
When using groups in 3.23.49, client dumps core.
This bug sounds to be new (it does not appear in 3.23.41)
>How-To-Repeat:
Just compile a little C client (you can also dump cores with DBI perl
module) :
% cat bug.c
#include
#include
int main(void) {
MYSQL mysql;
mysql_init
Try moving your $dbh->disconnect call after it prints out the fetchrow_array()
my ($t_user,$t_password,$t_prefs) = $sql_check->fetchrow_array();
if($debug_state) {
print "S: $t_user,$t_password,$t_prefs\n";
}
$dbh->disconnect();
If your using an older version of DBI, like 1.13 or
You need to tell the handler you are finished with your statement, this will
free resources, etc..
http://www.savebaseball.com/mysql/DBD_3.21.X.php3#finish
$sql_check->finish;
my $sql_check = $dbh->prepare("select user,password,prefs from users
where username='$LNAME'");
# I do
Hi,
Wakan wrote :
>
> Hi,
> I've noticed this problem, even if I don't know if it's really a mysql problem:
> if I store a date in standard format, in a date field, all kinds of
> ordering are OK.
> But if I change the output format with: DATE_FORMAT(data,'%d-%m-%Y'),
> the order by clause attem
On Wed, 27 Feb 2002 10:40:21 -0600, "nickg" <[EMAIL PROTECTED]> wrote:
>>
>>You need to tell the handler you are finished with your statement, this will
>>free resources, etc..
>>
>>http://www.savebaseball.com/mysql/DBD_3.21.X.php3#finish
>>
>>
>>$sql_check->finish;
EXTREMELY out-dated!
MySQL
Please be careful of reading only half of the story, unfortunately
the article in question only talks about half of the issues. See
http://www.nusphere.com/releases/index.htm for more information and related
documents.
Britt...
> > -Original Message-
> > From: Tyler Longren [mailto:[EMA
i am using the older v1.19 DBI. i looked at that line and it should not
cause a problem. the values are stored, even after the handle is destroyed
or the connection closed. the error is complaining that i should destroy
statement handles or call finish. thanks for the respones.
- Original Mes
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi:
Using MySQL version 3.23.39-Max, SuSE 7.2
I have two tables, cbtran with 46564 rows and cbma with 4184 rows.
Both tables are indexed.
The following query:
select tr.*,ma.nombre from cbtran as tr, cbma as ma where
tr.empresa='1' and tr.mes='1
Hi Ash,
> I am using MySQL 3.22.32 and are trying to accomplish the following (without
> going into too much detail, this is an example of the exact situation)...
>
> 1) I have two tables:
>
> a) User table containing: UserID, FullName
> b) Project table containing: ProjectID, ProjectManagerID
"nagendra prasad" <[EMAIL PROTECTED]> writes:
> hi
> i downloaded mysql rpms from mysql.com
> & tried to install them on linux.
> when i use the command rpm -i mysqlpackname in shell
> it says
>
> error:can't get exclusive lock on /var/lib/rpm/packages
> error:can't open packages database in /v
Hi Alfredo,
What an amazing piece of code!
The join statement is a computation on both sides, so therefore no index is of
material use.
Consequently a table scan would be required.
Have you tried EXPLAIN?
Regards,
=dn
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hi:
>
> Using MySQL
Hi Edward,
[I've put this back on the list - others will be able to share their wisdom/you might
not have to wait so long
for me to get around to a reply!]
My first thought is that you have a neat system of encoding the link data being stored
in MySQL.
I assume this is preceded by some sort of
Hi,
> -Original Message-
> From: Scalper [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 27, 2002 6:53 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Client installation by itself?
>
>
> I asked this question as well some time back and got the standard answer
> 'READ THE MANUAL'.
Hi,
I'm using MySQL for the first time and have been trying to solve this basic
SQL problem for 2 days... I have tried everything from using JOINs to local variables,
searching in www.mysql.com and Paul DuBois MySQL book (Great book!), but failed to do
this in a single SQL query has I
can MySQL run as cluster under the platform of IBM AS/400 also??
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread,
Hi,
Thanks for the reply.
An example of the record output I was after is...
ProjectIDProjectOwnerProjectManager
A12345 Bob Smith John Smith
from tables:
User -
UserIdFullName
1Bob Smith
2John Smith
Project -
ProjectIdProjectOw
Alfredo Cole <[EMAIL PROTECTED]> wrote:
> select tr.*,ma.nombre from cbtran as tr, cbma as ma where
> tr.empresa='1' and tr.mes='1' and tr.anio='2002' and
>
>concat(ma.empresa,ma.clase,ma.tipo,ma.mayor,ma.grupo,ma.costo,ma.cuenta,ma.subcuenta)=concat(tr.empresa,tr.cuenta)
>
> order by tr.anio
Hi there ,
I read your thread discussion Jan and it is certainly very interesting to
me.
There are though a couple of areas where I would (oh shit you wrote this
email in 1999, I hope you are still there anyway ..) be rather skeptical,
and these are:
Facts:
- An average DW will contain an a
Hi Miguel,
As far as I know (I'm no expert), this can't be done in a single MySQL
query. The following link shows how you can do it using a temporary table:
http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#exam
ple-Maximum-column-group-row
Alternatively, if you are using
You want the row with the max Version? How about
SELECT Number, Version, Description
FROM versions
ORDER BY Version DESC
LIMIT 1;
Michael
On Wed, 27 Feb 2002, Miguel Alves (SEP) wrote:
> Hi,
>
> I'm using MySQL for the first time and have been trying to solve
> this basic SQ
sql,query
Good Day,
I have a varchar field which contains alphanumeric data.
I want to be able to order this field by only the
numeric values in the field.
help!!
Rick
-
Before posting, please check:
http://www.mysql.co
It would appear that the apparent lagging/slave processes not working
(yet telling me they are up) was due to having two slaves set to the
same server-id. I will know as more time passes.
On Wed, Feb 27, 2002 at 09:27:04AM -0600, Michael Douglass said:
>
> David,
>
> I am seeing the exact s
InnoDB doesn't support the CASCADE functionality of foreign keys, so it's
possible deleting the key from the parent table won't have any effect on
existing transactions in the child. It may only prevent new records from
being inserted with that key -- which is essentially what you want. Most DBs
t
select * from table
where
strcol REGEXP "^[[:digit:]]+$"
order by strcol
Regards
Dan
> -Original Message-
> From: Prospect'In [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 28 February 2002 11:31 a.m.
> To: [EMAIL PROTECTED]
> Subject: Order by on Alphnumeric
>
>
> sql,query
>
When I try to delete a row from the parent table and the key is in use in
the child table, I get:
ERROR 1217: Cannot delete a parent row: a foreign key constraint fails
So it doesn't cascade and delete rows in the child table (assuming I am
interpreting "cascade on delete" correctly), but it d
Hi All,
I want to make my publicDB available for anonymous access from everywhere
and spend hours and hours reading the manuals and FAQ's and searching the
web, but can't make it work.
After deleting all entries in mysql.user apart from root@localhost:
grant select on publicDB.* to johan; works
Thanx Vic,
Are you saying I have to recompile apache as well before reconfiguring PHP.
Thanx
Toks
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 27, 2002 9:54 AM
Subject: php - apache compilation
> Oladejo,
> W
Hi,
I think that one of the admins on my MySQL 3.23.38 server somehow
removed mysql.host when he was cleaning out old databases, I get the
error:
020227 15:21:46 mysqld started
020227 15:21:46 /usr/local/libexec/mysqld: Table 'mysql.host' doesn't
exist
020227 15:21:46 mysqld ended
If I re-run
Jonathan,
the bug is probably the SHOW CREATE TABLE bug which was fixed in 3.23.48.
Please upgrade to 3.23.49a.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the online manual and latest news on InnoDB
Hi!
>From http://www.innodb.com/ibman.html :
"
Note that InnoDB does not create directories: you have to create them
yourself. Use the Unix or MS-DOS mkdir command to create the data and log
group home directories. Check also that the MySQL server has the rights to
create files in the directorie
>From the PHP home page:
PHP Security Update
[27-Feb-2002] Due to a security issue found in all versions of PHP
(including 3.x and
4.x), a new version of PHP has been released. Details about the security
issue are
available at http://security.e-matters.de/advisories/012002.html.
All users of PHP
* Doug Thompson
> On Wed, 27 Feb 2002 13:53:15 +0100, Roger Baklund wrote:
>
> >* Doug Thompson
>
> >> I found using variables to work as expected with 3.23.43 and
> >> Win98.
> >>
> >> I was unable to duplicate your changing outputs.
> >
> >I was using a 3.23.30-gamma win2k.
> >
> >> mysql> selec
Error
SQL-query:
CREATE TABLE quotes (
id int(9) NOT NULL auto_increment,
author varchar(255),
content text,
PRIMARY KEY (id),
UNIQUE KEY id (id),
FULLTEXT KEY author (author,content)
) TYPE=
Arrrggghhh!
This is definitely a problem!
Can't access table White in mysql 4.0.1: table is "read-only".
why? because it's corrupt!
Try to fix: takes a long time (about an hour) and seems to work.
But it's still corrupt and read-only:
[root@db1 elenco4_fb02]# myisamchk White;
Checking MyI
Hi,
On Thu, 2002-02-28 at 04:43, Oscar Colino wrote:
> I read your thread discussion Jan and it is certainly very interesting to
> me.
> There are though a couple of areas where I would (oh shit you wrote this
> email in 1999, I hope you are still there anyway ..) be rather skeptical,
> and th
Does MySQL 4.01 support Views? And if so, how?
Stephen Cox
Web Development, Webmaster
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (
Hi,
I downloaded the tarball for the latest RH binaries of Mysql 3.23.49a. I
"installed" it according to the INSTALL-BINARY file included with the
package. When I tried to run mysql according to the same file it crashed
giving no explanation. I have tried the suggestions listed on the websit
At 16:31 -0500 2/27/02, Stephen Cox wrote:
>Does MySQL 4.01 support Views? And if so, how?
Ask the person who told you that it does to substantiate the assertion.
>
>Stephen Cox
>Web Development, Webmaster
>[EMAIL PROTECTED]
-
On Wednesday 27 February 2002 04:59 pm, Paul DuBois wrote:
> At 16:31 -0500 2/27/02, Stephen Cox wrote:
> >Does MySQL 4.01 support Views? And if so, how?
>
> Ask the person who told you that it does to substantiate the assertion.
>
> >Stephen Cox
> >Web Development, Webmaster
> >[EMAIL PROTECTED]
>Description:
LOAD DATA LOCAL INFILE ...
leads to 'The used command is not allowed with this MySQL version'
This happens regardless of whether I have a
local-infile= 1
in my /etc/my.cnf. In neither case does the local-infile variable show
up with SHOW VARIABLES.
>How-To-Repeat:
>Fix:
>
At 17:09 -0500 2/27/02, Anthony W. Marino wrote:
>On Wednesday 27 February 2002 04:59 pm, Paul DuBois wrote:
> > >Does MySQL 4.01 support Views? And if so, how?
>>
> > Ask the person who told you that it does to substantiate the assertion.
>>
>
>Can't you just say NO or just don't respond?
Sure
On Wednesday 27 February 2002 05:16 pm, you wrote:
> At 17:09 -0500 2/27/02, Anthony W. Marino wrote:
> >On Wednesday 27 February 2002 04:59 pm, Paul DuBois wrote:
> > > >Does MySQL 4.01 support Views? And if so, how?
> > >
> > > Ask the person who told you that it does to substantiate the
> >
1 - 100 of 125 matches
Mail list logo
