I have a question regarding tracking multiple referral
levels in a database. The number of referral levels
tracked needs to be at least 4, but should be able to
be expanded later (without modifying the database).
The first design I considered was:
table:
id int(8) unsigned not null
Try to modify the autoexec.bat if you are using Win9x or the Path User env
in Winnt. Another choice in some systems is to modify DOSTART.bat or
something like that in \windows.
A way to keep the previous setting of the PATH env is to issue a stat like
SET PATH=%PATH%;c:\mysql; ...
I hope this
Hi Jeremy,
Same problem for me, I submitted a bug report with a repeatable testcase
yesterday to the bugs list.
Reading the source code and changeset 1.1287, it appears this part of the
source code should be desactivated ?
(ChangeSet
1.1287 02/09/15 02:23:53 [EMAIL PROTECTED] +2 -0
Jeremy, Jocelyn,
can you try the following this patch?
The flag which bans MySQL using a descending cursor to calculate
column LIKE 'jhghj%' ORDER BY column DESC
queries was apparently put to the wrong place in ha_innodb.h. The assertion
I had added to 4.0.4 revealed this hidden bug.
The
I use MySQL as a desktop db. It is alot faster than access, and much more
efficient. A great front end I use is phpMyAdmin.
www.phpMyAdmin.org
-Steve.
-Original Message-
From: Insanely Great [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 25, 2002 1:58 AM
To: MySQL List
Subject:
In the last episode (Sep 25), David Bordas said:
I've just a little question for the end. I planned to have around 10K
tables under a DB and this number surelly grow up to 20K. I know that
a database is a directory and a table is 3 files. I just want to know
is mysql have a limit in the
On Wed, Sep 25, 2002 at 08:09:08PM +0300, Heikki Tuuri wrote:
Jeremy, Jocelyn,
can you try the following this patch?
I'm building a new binary row.
The flag which bans MySQL using a descending cursor to calculate
column LIKE 'jhghj%' ORDER BY column DESC
queries was apparently put to
Hi All,
I've built a survey application in MySQL that allows people to enter
free-form comments. In processing the input, if the comments string is less
than 256 characters long, I save it to a varchar column; if longer, I use a
mediumtext.
This works fine, but I'm wondering if I'm getting any
Hello,
If the number of files is your concern, have you considered using InnoDB? It
spans tables across any number of data files you want. The performance is
great, too.
Best regards,
Iikka
On Wed, 25 Sep 2002, David Bordas wrote:
Hi list,
I've just a little question for the end.
I
Maybe someone else can come up with an answer for me on this question. I am
getting the following error when I try to run my index.php file. I think I
have configured it correctly, but obviously I haven't. And my host basically
told to go shove it.
Welcome to phpMyAdmin 2.3.1-rc1
Error
MySQL
Hi Heikki,
The query doesn't crash anymore, but the ORDER BY doesn't work at all (I
tested it on a table with data).
How-to-repeat :
INSERT INTO threadhardwarefr13 (pseudo,date,numreponse) VALUES
('kytine','2002-09-18 20:37:31','1360'),('joce','2002-09-18
Help!
The following works are required so that this mail goes through
sql query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
I load a table whit the query:
LOAD DATA INFILE 'a.txt' INTO TABLE table FIELDS TERMINATED BY '\t'
LINES
TERMINATED BY '\n';
the file:
211ppp222
222ooo333uuuo
and more
the problem is, the last field in the table is '|' , 'uuuo|'
Under NT and XP you set the environment variables by clicking on the My
Computer icon and selecting Properties, then clicking the Environment
variables on the Advanced tab. Make sure you set the PATH under the
System Variables instead of User Variables if you want MySQL to be
available to
At 15:08 25/9/2002 +0300, Iikka Meriläinen wrote:
Hi,
Only for to clarify: There is a rename table bug for some NT family
(Win2k I tested) when is used at the command rename tables names with
uppercase and the default lower_case_tables_names =1. This is already
fixed in the next releases.
On
Help!
The following works are required so that this mail goes through
sql query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
This email leads to a question I have about SQL. I have been accustomed to
Mysql with all of its nifty little extensions - like describe. Now I have a
project with MSSQL (not because I wanted it - politics). Does any one now
how to describe a table structure with standard SQL. Even more
Hi,
Use the following:
SELECT * FROM sysobjects WHERE type='U'
This will show you all of the user tables
And then
select * from syscolumns where ID = (select ID from sysobjects where
name = 'your_tablename' and type = 'U'
This should get you started!
HTH
Ian.
-Original Message-
Ian's help worked great. I have one question. How do I specify the DB?
I mean in the query analyzer I can select a db from the pulldown box - is
there a way to specify the db in the statements below?
Thanks.
-Original Message-
From: Ian Robertson [mailto:[EMAIL PROTECTED]]
Sent:
Figured it out. just use the use name_of_db and you can switch to another
DB.
thanks.
-Original Message-
From: Norris, Joseph
Sent: Wednesday, September 25, 2002 9:02 AM
To: 'Ian Robertson'; Norris, Joseph; 'Peter van der Goes'; 'Thomas R
Wyant_III'; [EMAIL PROTECTED]; 'Mysql_List
Help!
sql query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
Jocelyn,
below the latest patch which puts the code as it was in 4.0.3. Some LIKE
'abc%' ... DESC queries may return wrong results, but this is the best we
can get to 4.0.4.
I have to ask Monty about the use of HA_READ_PREFIX_LAST. Other bugs may be
lurking in the use/non-use of that search
- Original Message -
From: Daren Cotter [EMAIL PROTECTED]
To: MySQL Mailing List [EMAIL PROTECTED]
Sent: Wednesday, September 25, 2002 7:34 PM
Subject: Multiple Referral Levels
I have a question regarding tracking multiple referral
levels in a database. The number of referral levels
Hi,
Just to clarify a bit, the file in \windows is called winstart.bat, but it
seems to be discontinued in Windows XP (may not be available in W2K either).
In Windows NT it works, though.
In NT/W2K/XP the most efficient way to modify these variables _and_ persist
them is through My
Some people have had problems with the binary of 3.23.5x. We had that
problem, and when we went back to a self-compiled 3.23.46 things
worked normally again.
The bad behavior looked like normal operation for anywhere from two
hours to five days, followed by a CPU meltdown with loads over 200,
On Tue, 2002-09-24 at 23:05, Ken Menzel wrote:
Hi Everyone,
I don't know if it makes a difference to anyone, but mysql client
libraries are no longer LGPL. see
http://www.mysql.com/doc/en/Copyright.html. (original licenses can be
found in old source tar files documentation). I think this
If not, i know that ext3 can have ten of thousands files in a directory.
But commande like 'ls' will become slower and slower ...
Is this also slowing mysql ?
I believe it would have to. There is a patch somewhere (I don't know
if it's maintained) for adding indexed directories to ext2/ext3
Hello all, I am brand new to MySql and I wanted to know if you could
recommend any books that are a good start on learning the mechanics of
MySql. Thanks!
-
Before posting, please check:
http://www.mysql.com/manual.php (the
also:
-
mysqlstudio - http://www.mysqlstudio.com
mascon - http://www.scibit.com
-j
-Original Message-
From: Steve Bradwell [mailto:[EMAIL PROTECTED]]
Sent: September 25, 2002 1:09 PM
To: Insanely Great; MySQL List
Subject: RE: MySQL as a desktop DB
I use MySQL as a desktop db.
Lindberg,
Wednesday, September 25, 2002, 5:17:53 PM, you wrote:
LP I use mysql 3.23.4 max on linux and it have worked just fine.
LP Now I want to use Transactions so I thougt that I should use the my.cnf to
configure for that.
If you want to use transaction, you should use InnoDB or BDB
At 20:25 -0500 9/23/02, Paul DuBois wrote:
At 16:43 -0700 9/23/02, Jan Steinman wrote:
From: Moestl, Wolfgang [EMAIL PROTECTED]
Is there a defined behaviour for handling the case-sensitivety for
user- and hostnames?
According to the specification for the Domain Name System (DNS),
Internet
You are on the right track that you don't want to modify the database
just to add a level. You also want to have your levels in one
column/field so that you can use an index to search it quickly and
easily.
You didn't mention whether someone can be referred on multiple levels,
this will
Hello All,
Can someone tell me if I can load only one column of data from a tab
delimited text file into MySQL 4.0? If so, then can I assume that I can
load data from multiple data stores, picking columns as I need to.
Thank you for your assistance.
William
Then, go here: http://lists.mysql.com/php/unsubscribe.php
Or, try using a real MUA.
Regards,
Van
--
=
Linux rocks!!! http://www.dedserius.com/
=
David Busby
It's probably faster to retrieve from a varchar field than a mediumtext
field, but any benefit is completely erased by the need to perform an
OR query to search in both fields.
Your biggest speed benefit can actually be attained by avoiding varchar
and text fields altogether, use char(). This
I believe you need to change the socket to the location in your /etc/my.cnf
file.
I usually add both sections in it just to kep things straight.
[client]
socket=path-for-socket-file
[mysqld]
socket=path-for-socket-file
I used /ldata/mysql/tmp/mysql.sock
my.cnf isn't automatically there so you
hi all
i've mysql 2.32.52 installed, and there is a table with nearly 2.000.000
records in it (4 field/record). i have 256megs of RAM, and the linux
version is RedHat 7.3. i do a simple delete, like:
delete from foo_db where foo10; (this is around 15.000 record)
and after 30 minutes, still
Yes, please, someone please tell how that mysql.sock file is working. I get
the same general thing as well when I try to connect using just mysqladmin.
Don B.
-Original Message-
From: Easton, William [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 25, 2002 10:55 AM
To: ''
Subject:
Not really a MySQL question, but...
The way you have it now definitely won't work. Your select statement for
getting the number of referrals for level one will always return a count of
one -- because id is the primary key of your table. One way to do this,
without listing all the referrals in a
On 25 Sep 2002, at 16:28, Brent Baisley wrote:
Your biggest speed benefit can actually be attained by avoiding varchar
and text fields altogether, use char(). This will cause each record to
be exactly the same length, which will allow MySQL to jump to spot in
the file quicker. It's less
Any reason you can't upgrade to a newer version?
mysql,query
DSL
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
The change is made to avoid lots of discussions about when the GPL
is effective. Basically we follow the same rules as we always have
about when we want people to pay us for a commercial license but
now we have a better legal ground to base it
On Wed, Sep 25, 2002 at 08:26:25AM -0600, Scott Pippin wrote:
We are moving a databse over from Oracle to MySQL 4.0.3 and I was
wondering if I should use MyISAM or InnoDb. The databse currently has
800-900 updates and inserts done to it in a day along with about 1000
selects. Would I run in
On Wed, Sep 25, 2002 at 08:42:05AM -0300, Dyego Souza do Carmo wrote:
The variables record_buffer,join_buffer and sort_buffer are alocated
every user connect ?
No, their are allocated on an as-needed basis for each thread. If a
thread doesn't need to join anything, there will be no join
I am new to InnoDb and was wondering what steps I would have to do to
restore a table. Lets assume I am backing up the data by backing up the
tablespaces.
Thanks in advance
(MySQL, query)
-
Before posting, please check:
On Wed, Sep 25, 2002 at 11:33:37PM +0300, Gergely Imre wrote:
hi all
i've mysql 2.32.52 installed, and there is a table with nearly 2.000.000
records in it (4 field/record). i have 256megs of RAM, and the linux
version is RedHat 7.3. i do a simple delete, like:
delete from foo_db
Does this also apply to non-open-source but free applications? For
example, we give away Escapade for free - always have, always will,
at least for the minimal version of the product. If we develop a
non-free version of Escapade that uses mysqlclient, what happens
then? We also
Query: can you guys please trim up your quotes a little?
--
: Jan Steinman -- nature photography: http://www.Bytesmiths.com
: Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services
: Join the forums at http://www.Bytesmiths.com/wiki
whew, I found it. I looked at my installed rpm's ('rpm -q php')
found the install php 4.1.2-7.3.4. Tried to remove ('php -e php*.rpm')
got multiple dependent errors. That when I noticed I had about 6 rpm's
had installed 6 different flavors of php. I uninstalled all and reinstalled
just
On Wed, 2002-09-25 at 10:10, Keith C. Ivey wrote:
On 25 Sep 2002, at 0:57, John Coder wrote:
So it's probably the fact that I didn't make the connection persistent
that screwed me up sometimes I feel so stupid.
I don't think that will help. Read Paul's message again. Even if
you
I think MySQL will be more faster in Desktop environment and if you are
adverse to using the text based interface to MySQL then you can try out
some
GUI avaiable in the market. The best I know are MySQL-Front and SQLyog but
since MySQL-Front has been discontinued you can try SQLyog at
i've installed ver 3.23.47 sa win2k pero di ko sya
mstart as service..
if i type this==mysqladmin create database01
ERROR==mysqladmin: connect to server at 'localhost'
failed
error: 'Can't connect to MYSQL server on 'localhost'
10061'
Check that mysqld is running on localhost and that the
port
Why not you set the path in your environment variables and restart the
computer
Are you using win98 or NT?
- Original Message -
From: William Martell [EMAIL PROTECTED]
To: MySQL Main List [EMAIL PROTECTED]
Sent: Wednesday, September 25, 2002 11:33 AM
Subject: Set Path Environment
CREATE TABLE temponly(name VARCHAR(50) NOT NULL PRIMARY KEY, pic BLOB)TYPE =
INNODB ;
INSERT INTO temponly(name , pic) values( 'velan',
load_file('e:/mysql/images/Click.gif')) ;
Hope this helps.
- Original Message -
From: Chris [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday,
Hi - I'm a mysql newbie. As I've yet to discover a method of batching mysql
commands I prefer to input lengthy instructions (such as large file
structures) in stages, so input errors can be dealt with more easily. For
example, I first define table structures and then indexes.
This led me to
At 11:55 -0700 9/23/02, johnbarri wrote:
Hi - I'm a mysql newbie. As I've yet to discover a method of batching mysql
commands I prefer to input lengthy instructions (such as large file
structures) in stages, so input errors can be dealt with more easily. For
example, I first define table
I create a table with a VarChar field set to not null. When I do an
insert into this table with no value for this field it goes through
without a problem. I realize MySQL inserts a empty string into the
field. But what a want is an error when this happens. Is there any
way to force this?
I have installed the php-mysql package and can now connect to the database.
There is however another error which i do not undertand.
Warning: No MySQL-Link resource supplied in
/usr/local/www/vantweststamps/databaselogin.php on line 15
Connected successfully
These pages all work without error
sorry i missed the update statement
UPDATE temponly SET pic = load_file('e:/mysql/images/mod_jk.jpeg') where
name = 'velan' ;
regards
- Original Message -
From: kayamboo [EMAIL PROTECTED]
To: Chris [EMAIL PROTECTED]
Cc: list mysql [EMAIL PROTECTED]
Sent: Thursday, September 26, 2002
Description:
selecting distinct when executing a left join causes mysql to die
How-To-Repeat:
CREATE TABLE test1 (
i1 int(10) unsigned NOT NULL default 0,
s1 varchar(30),
PRIMARY KEY (i1)
);
CREATE TABLE test2 (
i1 int(10) unsigned NOT NULL default 0,
s1 varchar(30),
PRIMARY KEY (i1)
);
Hi,
can anyone tell me how can i set the default datetime as current datetime in
the mysql. so that every time i insert a record in the table current
datetime automaticall inserted.
Thanks in advance.
Regards
Daya Krishan Dubey
Core Solucomm Ltd
423 B, Hamilton court
DLF phase IV
Gurgaon, India
Dear all
i had two tables, tableA Table B.
I want to create a permanent table call Table C which the first two field
will be equal to Table A's first 2 field and last field will be equal to
Table B's first field.
can anyone pls tell me what query should i use?
it will be nice if you can
From: Dana Diederich [EMAIL PROTECTED]
Date: Mon, 23 Sep 2002 09:40:45 -0500
Perhaps the InnoDB/MyISAM gurus can comment on this. I want to switch from
MyISAM to Innodb, because we have database tables that have many updates,
inserts, deletes and selects going on at the same
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
(http://www.ezmlm.org)
From: [EMAIL PROTECTED]
Date: Mon, 23 Sep 2002 11:57:19 -0800 (AKDT)
News-Group: list.mysql
Reply-To: [EMAIL PROTECTED]
Description:
While trying to run this query:
SELECT users_1.* FROM users
Hi there,
Anyone have experience (good or bad) running recent 3.23.49-or-higher MySQL
releases on Red Hat Advanced Server? I'm thinking of test driving it and
was wondering if anyone has seen noticeable performance improvements over
7.3 or any gotcha's to watch out for.
Oddly enough, I'm sort
Apologies,
I thought I had done a decent search to see if anyone else had reported
it, but apparently my search skills are lacking, I see that it was fixed
in 4.0.4.
On Wed, Sep 25, 2002 at 11:34:07PM -0500, Shane Allen wrote:
Description:
selecting distinct when executing a left join
hope that i don't muddy the waters here, but there's
a solution for all of your data sources that doesn't
require knowledge of any commands.
the corereader app loads and displays the
information that you want when you connect to a data
source, in this case to a database.
it's free as a
Description:
Compile MySql with BDB installed as a system package with no build
directory. MySql configure and compile insist on building the included
BDB which is not wanted as the system BDB package contains a more
recent version of Berkeley DB. Adding BDB include and library
Dear support
I am trying to write data in the database in ISO-8859-7 character set.
My Questions are:
1) How do I configure MySQL to support this character set?
2) I am using PHP to get these infornation from the database. Do I have to
do something in my code to read teh data?
Thenks a lot
Dear George,
I use to have problems with Greek Chars and after hundreds of hours of
testing i can assure you that the only solution is to compile Mysql using
as default char-set the Greek char-set.
Thus if your are using mysql for Linux you have to add to the .configure
parameters the
DB I found my problem and why Mysql lock my table for a select. In
DB fact, mysql sometimes don't use the right index and so does a 'Table
DB sort' that lock my table. I modify the query to add USE INDEX
DB clause and now, all seems to work well ... I just need to test
DB during several days
Dear Nikos
I run the below --defult-character-set=ISO-8859-7 and when I insert into the
database like
insert into test values('ÄÕÏ');
when I select:
mysql select * from test
- ;
+--+
| data |
Hello
I want to distribute my java database application
together with mysql, and I want to make it as easy as
possible.
Right now a new user has to:
- download and install mysql
- run the mysql server with mysqld --standalone or a
similar command
- download my program and run it.
To make this
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
| I currently use MS Access as a single-user desktop database. The
database is
| getting quite large. The largest table has 300,000 rows.
Definately a case when an upgrade would help, but maybe it's not
essential. We used to use a system here that
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
OT
Filter: query , sql
Hi Brian,
| I'm running apache-1.3.23-14 on a redhat 7.3 system.
| I have installed the php-rpm and the php_mysql.rpm from Redhat.
| installed php-4.1.2-7.3.4 and php-mysql-4.1.2-7.3.4.
|
| Cannot connect to my
Check out this article in MSDN:
http://msdn.microsoft.com/library/default.asp?url=/workshop/author/dhtml
/reference/charsets/charset4.asp
It describes how to set the character set for Internet Explorer. I'm
not sure of an equivalent for Netscape, but I assume there is one...
Dean Harding.
What you mean by explorer pages? Browser?
If so you have to set the correct character set at the beginning of each
place, whether asp, jsp, php or html.
regards
- Original Message -
From: [EMAIL PROTECTED]
To: Nikolaos Georgiafentis [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent:
No
In the explorere I can see Greek when I do the same with asp and access db.
George Nikoloudis
INTRACOM S.A.
Telecom Business Support Systems
19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58
GR 19002 Athens Fax: +30 10 667 97 97
Greece
Fear George,
try putting 'META HTTP-EQUIV=Content-Type
CONTENT=text/html;charset=iso-8859-7' in the header section of your
page. Keep me informed
At 10:54 AM 9/25/2002 +0300, you wrote:
Dear Nikos
I run the below --defult-character-set=ISO-8859-7 and when I insert into the
database like
It is obvious, even in windows you have to set the configuration files
atleast.
It is the privilege of the user to install the stuff anywhere in his
computer and so he has to change the .inf or .cnf accordingly
Why not you try onething called the embedded mysql.
If you just want to go with your
Dear Nikos
I did that I nothing.
I am sending you also the php script I run:
meta http-equiv=Content-Type content=text/html; charset=greek8
?php
/* Connecting, selecting database */
$link = mysql_connect(localhost, test, )
or die(Could not connect);
print Connected successfully;
I have installed MySQL 3.23.47 in a Windows 98 machine and created a a table count.
I have installed Apache Server on 98 machine and try to execute the following PHP
script to insert the data. I was not able to post the data and got an error
Method Not Allowed
The requested method POST is
Hello ,
i have version 3.23.52
Why
CREATE TABLE user4(
id INTEGER ,
passwort VARCHAR(10)
) DATA directory=/usr/local/mysql/data/test;
doesent works (Syntax Error : because of DATA ..)
-
Before posting, please check:
Hello William,
Tuesday, September 24, 2002, 9:56:49 AM, you wrote:
William, don't send me your questions in private mail. We provide support in
public list. For commercial support, go to https://order.mysql.com/.
WM Thank you for your responses. How do I delete a table if I do not need to
WM
Dear Gorge,
the page you have sent me is included in an other page?
If is not then try to put also all the required html tags (i.e
HEAD,BODY etc.)
If it is then try to put the correct page encoding in the main page that
includes the page you have sent me.
At 11:48 AM 9/25/2002 +0300, you wrote:
Dear Nikos
The charset is ISO_8859-7 not greek8
In you system the greeks work fine?
George Nikoloudis
INTRACOM S.A.
Telecom Business Support Systems
19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58
GR 19002 Athens Fax: +30 10 667 97 97
Greece
Hussein,
Wednesday, September 25, 2002, 11:42:00 AM, you wrote:
HM i have version 3.23.52
HM Why
HM CREATE TABLE user4(
HM id INTEGER ,
HM passwort VARCHAR(10)
HM ) DATA directory=/usr/local/mysql/data/test;
HM doesent works (Syntax Error : because of DATA ..)
It works only in 4.0 branch
Sorry the correct charset is ISO_8859-7.
Is the problem resolved?
At 12:45 PM 9/25/2002 +0300, you wrote:
Dear Nikos
The charset is ISO_8859-7 not greek8
In you system the greeks work fine?
George Nikoloudis
INTRACOM S.A.
Telecom Business Support Systems
19.5 km, Markopoulou Ave.
VINOD wrote:
I have installed MySQL 3.23.47 in a Windows 98 machine and created a a table
count. I have installed Apache Server on 98 machine and try to execute the
following PHP script to insert the data. I was not able to post the data and got an
error
Method Not Allowed
The
antispam,
Tuesday, September 24, 2002, 8:30:35 PM, you wrote:
aafdn I dont know what exactly happened but suddenly one tables just went back 10
days.. it only has 10 days back information.. please help me.. what happened with
mysql ?? how can i retrieve those
aafdn information...
I also
Steven,
Tuesday, September 24, 2002, 7:03:15 PM, you wrote:
SK I am currently working on a table that has a column called state and a
SK column called stateid. All 42,000 records in this table have a 2 Letter
SK abbreviation for that state (NY, CA, NV, etc) however. To eliminate
SK
Nothing I did it.
I will try to install againthe PHP.
I will come back.
Thanks a lot
George Nikoloudis
INTRACOM S.A.
Telecom Business Support Systems
19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58
GR 19002 Athens Fax: +30 10 667 97 97
Greece
Please help me alter table:
___
| |
CREATE TABLE `f_ivairus_bodies` (
`id` int(11) NOT NULL default '0',
`body` text NOT NULL,
`thread` int(11) NOT NULL default '0',
PRIMARY
Please help me alter table:
___
| |
CREATE TABLE `f_ivairus_bodies` (
`id` int(11) NOT NULL default '0',
`body` text NOT NULL,
`thread` int(11) NOT NULL default '0',
PRIMARY
I'm having problems with php scripts that use 'LOAD DATA LOCAL INFILE'. Each time I
run a script, I get an error in the server log
saying MySQL query failed: LOAD DATA LOCAL INFILE : The used command is not
allowed with this MySQL version.
We're using php version 4.1.2 and MySQL 3.23.49,
Please help me alter table:
___
| |
CREATE TABLE `f_ivairus_bodies` (
`id` int(11) NOT NULL default '0',
`body` text NOT NULL,
`thread` int(11) NOT NULL default '0',
PRIMARY
Hi mysql people,
I am trying to install mysql on SuSE-8 from source. everything goes fine
untill make install.
It then exists with the following errors:
make[2]: *** [install-benchSCRIPTS] Error 1
make[2]: Leaving directory `/usr/local/mysql-3.23.52/sql-bench'
make[1]: *** [install-am] Error 2
Hi,
Have you tried just putting greek characters directly in the page? That way you can
at least find out if the browser is at fault. Then try something like:
?= some greek characters ?
to rule out whether it's PHP. It's probably not MySQL if you can see them when just
using the
thnx guyz
i ve win2k pro, apache 1.3.24 n php 4.2.2
i dont know how you managed to configure your system on the root only since
i need multiple users each with its own set of database and tables ..
heres a piece from my config.inc file .
$i++;
$cfgServers[$i]['host'] =
thnx iikkaa
im bsorry ... i ve win2k pro, apache 1.3.24 n php 4.2.2
all workin fine .
my mysql4.0.1 alfa is givin me these night-mares
cud this be the problem 4.0.1 ALFA ? it was a win zip file i guess
not the source but a binary .
plz do lemme know what can i do
1 - 100 of 148 matches
Mail list logo
