hello everybody,
i m using redhat linux 7.2 with mysql 3.23.49a-max-log with
Apache 1.3.24 .
i have encounter following error for load data local infile when i
tried to use an example on mysql site's documentation file :
mysql use test;
Database changed
mysql show tables;
++
|
mysql load data infile pet.txt into table pet;
ERROR 1105: File './test/pet.txt' not found (Errcode: 2)
mysql load data infile pet.txt into table pet;
Query OK, 8 rows affected (0.00 sec)
Records: 8 Deleted: 0 Skipped: 0 Warnings: 4
mysql select * from pet;
mysql load data infile pet.txt into table pet;
ERROR 1105: File './test/pet.txt' not found (Errcode: 2)
mysql load data infile pet.txt into table pet;
Query OK, 8 rows affected (0.00 sec)
Records: 8 Deleted: 0 Skipped: 0 Warnings: 4
mysql select * from pet;
Description:
mySQL package from SGI freeware will not install on irix 6.2. It fails at the
mysql_install_db script. The version i'm trying to install is 3.22.21
How-To-Repeat:
just run the mysql_install_db script
Fix:
Submitter-Id: Peter
Originator:System
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 19 November 2002 23:34, Steven Roussey wrote:
OK, it seems to be working. The load is not spiraling out of control. :)
Thanks! This is very reassuring. I will start building 4.0.5a Linux binaries
right away.
Bye,
LenZ
- --
For
Hi all.
I've downloaded mysql-max-3.23.53a-pc-linux-gnu-i686.tar from www.mysql.com
and tried to install it on a linux box.
I followed the steps provided at
http://www.mysql.com/doc/en/Installing_binary.html
shell groupadd mysql (Not really, I have a mysql group)
shell useradd
* yan zhang
My MySQL LEFT JOIN Syntax as following is wrong? I
cannot get the right result.
What result do you get?
SELECT name, email form T1 LEFT JOIN T2 ON
T1.Snum=T2.Bnum
Except from the typo form - FROM, this looks like a valid statement. Do you
get an error?
Frank,
if the tables are InnoDB type, then the following patch might fix the
problem. The patch will be in 3.23.54, which, I guess, will be released
around December 5th, 2002.
MySQL/InnoDB-4.0.5, November 18, 2002
...
Fixed a bug: if a SELECT was done with a unique key from a primary index,
and
Frank,
if the tables are InnoDB type, then the following patch might fix the
problem. The patch will be in 3.23.54, which, I guess, will be released
around December 5th, 2002.
MySQL/InnoDB-4.0.5, November 18, 2002
...
Fixed a bug: if a SELECT was done with a unique key from a primary index,
and
Dobrý den,
terça-feira, 19 de novembro de 2002, 23:10:11, napsal jste:
PB Hi,
PB I like to know if you can help me. I installed mysql-3.23.53-win.zip
PB which should have the Innodb feature as part of MySQL. However, I am
PB unable to create an Innodb database. The problem may be that one of
On Tue, 19 Nov 2002, Bill Easton wrote:
I'd be happy to write up a short example for inclusion in the MySQL manual,
if there were some indication from MySQL, AB, that it would be included.
I guess they will; after all it would fit perfectly into the tutorial and
would be most welcome to all
I've problems sincronizing a Slave DB with a Master.
I've a db created with name foo-db from phpmyadmin but the mysql shell doesn't accept
create database foo-db;
Do you know something about this??
Thanks, Massimo.
-
Before
Rafal,
the table cache size limit parameter in my.cnf affects also InnoDB. MySQL is
not aware that InnoDB does not open any files when InnoDB creates a handle
to a new table.
Hmm... I doubt that opening tables really takes much time. You can try
empirically if the table cache size has any
Hi all.
I resolved the problem of starting mysql server changing permissions of /tmp
directory to permit user mysql write /tmp/mysql.sock.
But when I start mysql server with /etc/init.d/mysql server start I get
error @HOSTNAME@.
prototipo mysql # /etc/init.d/mysql.server start
Hi
I have been asked to support/bug-fix a Windows based web site using MySQL.
I have used MySQL on Linux/FreeBSD for 3/4 years, but never on Windows.
How does MySQL compare on Linux and Windows for stability and performance ?
Simon
--
Simon Windsor
mail: [EMAIL PROTECTED]
* Massimo Bandinelli
I've problems sincronizing a Slave DB with a Master.
I've a db created with name foo-db from phpmyadmin but the
mysql shell doesn't accept
create database foo-db;
Do you know something about this??
The '-' character makes this name difficult for the mysql parser to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 20 November 2002 11:41, Iago Sineiro wrote:
I resolved the problem of starting mysql server changing permissions of
/tmp directory to permit user mysql write /tmp/mysql.sock.
But when I start mysql server with /etc/init.d/mysql
Hi Support Team,
I'm quite a novice in installing Mysql. I needed to do this because of a task i had to
accomplish by installing webtts for which mysql was a pre-requisite.
during the installation process of webtts, i had the following errors
install_driver(mysql) failed: Can't load
Oh, yes, I know this option.
The problem is quiet different, because if I create a db using php with mysql_create
function, I can use the name with minus foo-db.
Analizing the binary log I see the command
create database foo-db;
and when the slave process the query, it returns an error.
Dear Readers,
I have a little mySQL problem here.
Maybe it's a bug, maybe I'm just too stupid to read the documentation
correctly, who knows... I'm sorry if I bother anyone with my stupidity.
I run a simpy query like:
SELECT INTERVAL((UNIX_TIMESTAMP(ReceivedDateTime) -
Thanks Lenz. Now, after modifying the init script, I don't get the advise.
Iago Sineiro.
-Mensaje original-
De: Lenz Grimmer [mailto:[EMAIL PROTECTED]]
Enviado el: miércoles, 20 de noviembre de 2002 12:27
Para: Iago Sineiro
CC: MySql Mail List
Asunto: Re: Problems installing
[EMAIL PROTECTED] wrote:
Description:
After installation and setting basic authentication data I tried to
connect to MySQL from other machine with the mysql client.
I could not connect, I just got an error message
ERROR 2013: Lost connection to MySQL server during query
It does not
Simon,
I have been asked to support/bug-fix a Windows based web site using MySQL.
I have used MySQL on Linux/FreeBSD for 3/4 years, but never on Windows.
How does MySQL compare on Linux and Windows for stability and performance ?
=congratulations. Your relief appears in the phrase, MySQL is
Hello Pallavi,
i m using redhat linux 7.2 with mysql 3.23.49a-max-log with
Apache 1.3.24 .
i have encounter following error for load data local infile when i
tried to use an example on mysql site's documentation file :
mysql use test;
Database changed
mysql show tables;
Pallavi,
mysql load data infile pet.txt into table pet;
ERROR 1105: File './test/pet.txt' not found (Errcode: 2)
mysql load data infile pet.txt into table pet;
Query OK, 8 rows affected (0.00 sec)
Records: 8 Deleted: 0 Skipped: 0 Warnings: 4
mysql select * from pet;
David,
- Original Message -
From: David Mechner [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, November 20, 2002 1:59 PM
Subject: Re[2]: delete where column = null
Ok, so it seems to be a bug. What's the procedure for reporting it (or
do the developers read this
Hello,
I downloded MySQL-Version 3.23 for Windows XP from MySQL-webpage. If I try
to load a Database from a textfile I got message Error 1148 The error used
Command is not allowed with this MySQL-Version.
I used following Command: LOAD DATA LOCAL INFILE verlagdaten.txt INTO
TABLE verlag;
Any
Pallavi,
Wednesday, November 20, 2002, 11:01:51 AM, you wrote:
PAP i m using redhat linux 7.2 with mysql 3.23.49a-max-log with
PAP Apache 1.3.24 .
PAP i have encounter following error for load data local infile when i
PAP tried to use an example on mysql site's documentation file :
[skip]
p_action969,
Wednesday, November 20, 2002, 11:11:03 AM, you wrote:
paydc mySQL package from SGI freeware will not install on
paydc irix 6.2. It fails at the mysql_install_db script. The version i'm trying to
install is 3.22.21
paydc How-To-Repeat:
paydc just run the
Stephen,
Wednesday, November 20, 2002, 5:48:35 AM, you wrote:
SA I've managed to build my first web database using MySQL and accessing
SA it with Python CGI scripts. I only have two tables going, and not
SA many columns per table, but I'm suspecting that there will be many
SA calls to INSERT,
John,
Wednesday, November 20, 2002, 8:32:35 AM, you wrote:
JC After I dump the database what is the command to import it into another
JC computer?
mysql -hhost_name -uuser_name -puser_password [database_name]
dump_file.sql
JC Do I have to create a new database and then import all tables
JC
MySQL is good on the Win32 platform ... slower than on Linux / Unix / BSD
etc., but nonetheless it is a good performer.
We have several of our Win32 clients who have switched to Linux servers or
have augmented their Win32 servers with Linux servers to specifically handle
database duties... the
* Massimo Bandinelli
* Roger Baklund
* Massimo Bandinelli
mysql shell doesn't accept
create database foo-db;
Do you know something about this??
The '-' character makes this name difficult for the mysql parser to
understand, it could be interpreted as foo minus db (even though
Thanks a lot.
-Messaggio originale-
Da: Roger Baklund [mailto:[EMAIL PROTECTED]]
Inviato: mercoledì 20 novembre 2002 13.59
A: [EMAIL PROTECTED]
Cc: Massimo Bandinelli
Oggetto: backticks replication (was: Re: Slave sincronize)
* Massimo Bandinelli
* Roger Baklund
* Massimo Bandinelli
Greetings
I think the path for the file is not correct. Try giving the complete path
with (\) in the directory name changed to (/). Also specify the escaping
characters properly.
For more information you can check out the MySQL docs on LOAD LOCAL INFILE.
Rgds
Insane
SQLyog - The Definitive
Bingo! Thanks Dan
Missing were:
ftp://mysql.nixc.net/pub/mysql/Downloads/MySQL-4.0/mysql-4.0.5-beta.ta
r.gz
ftp://mirror.sit.wisc.edu/mirrors/mysql/Downloads/MySQL-4.0/mysql-4.0.
5-beta.tar.gz
http://mysql.mirrors.netnumina.com/Downloads/MySQL-4.0/mysql-4.0.5-bet
a.tar.gz
I only tried 3
David,
Tuesday, November 19, 2002, 5:20:23 PM, you wrote:
DN (sorry if this is a duplicate -- I don't think the original made it)
DN Running mysql 3.23.53-max binary on a RedHat 7.2 based server. Replication
DN is working fine, but I'm running into errors with the replicate-rewrite-db
DN
kwagner,
Wednesday, November 20, 2002, 2:27:45 PM, you wrote:
kapdd I downloded MySQL-Version 3.23 for Windows XP from MySQL-webpage. If I try
kapdd to load a Database from a textfile I got message Error 1148 The error used
kapdd Command is not allowed with this MySQL-Version.
kapdd I used
Yes, you are correct and it can be worse because you have not
considered that there are some descriptors required by other processes
running. I suggest you increase your file limit to at least 2048.
Good luck
Ken
- Original Message -
From: Lance Lovette [EMAIL PROTECTED]
To: MySQL
and how on-the-fly?
Thomas
On Wed, 20 Nov 2002 09:18:15 -0500 Ken Menzel [EMAIL PROTECTED] wrote:
Yes, you are correct and it can be worse because you have not
considered that there are some descriptors required by other processes
running. I suggest you increase your file limit to at
MySQL Gurus:
I am working on a process to import data from a VMS database (SJ2) to
MySQL.
The table that I am importing has 10378507 (over 10 million) records in
it. I have the records
exported to a comma-delimited text file, as the fields within the
database do not
contain any commas at all.
If you with Linux, you can use the 'sysctl' programm.
sysctl -h gives you the parameters (i.e -u is for the maximum
number of processes created by a user). I use the sysctl command
in the safe_mysqld script to increase this number. if you want to
set a parameter systemwide you may also use
To optimize speed I would like to use a HANDLER sql query to get data
from my database.
HANDLER questions OPEN;
HANDLER questions READ FIRST WHERE qid = 1 LIMIT 1;
[Php code collects data]
HANDLER questions CLOSE;
Is that the best way to use HANDLER?
Can I make it even faster?
If any of you
Can somebody suggest some good English magazines on MySQL ?
Rgds
Insane
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
Hi Thomas,
This would be a question for your OS support list, however an
example from FreeBSD:
bash-2.04$ sysctl -a | grep files
kern.maxfiles: 2
kern.maxfilesperproc: 19000
kern.openfiles: 1569
bash-2.04$ su
tuvok# sysctl kern.maxfiles=20001
kern.maxfiles: 2 - 20001
tuvok#
Hope
Well, I've done imports of about 50.000-100.000 posts from other databases.
I've gone another way then, and through perl/vi generated a file of
mysql commands
that I've then run. Maybe is a bit slower, but you get a complete log in
case some things dont
work out when you have logging turned on.
I would like to export the full contents of one particular table in a
database to a csv file once every day. I will then email this file I am
running MySQL 3.21 on a RedHat 7.2 server. Is there an automated way of
doing this?
This e-mail is
A question:
I've a Mysql System with a Master and two slave.
Can I configure my master to automatically forward the select queries to =
the slaves?
Massimo Bandinelli
System Administrator
-
Register.it S.p.A. - Gruppo DADA
tel +39 199 REGIST (+39
thanks a lot for both replies.
I just asked as this question was brought up with the post before mine.
I will ask further off-list :-).
Thomas
On Wed, 20 Nov 2002 15:25:32 +0100 Thomas Seifert [EMAIL PROTECTED] wrote:
and how on-the-fly?
Thomas
On Wed, 20 Nov 2002 09:18:15 -0500
Hello,
I have several mysql 3.23 daemons running in a Windows
XP Professional computer. To achieve this, I have run
the following commands:
mysqld-opt --basedir=C:\mysql
--datadir=C:\mydb\data1
--port=3020
--standalone
--default-table-type=MyISAM
--tmpdir=C:\mydb\temp1
mysqld-opt
Hi,
Currently, my program creates a new MYSQL object each time a connection
is needed to save or load information from my MySQL database.
Sometimes, this connection is created 10,000 or more times during one
use of the program. I'm wondering if I reuse the connection (have a
static MYSQL
Hi,
I'd like to obtain the number of hours and minutes between two fields
datetime and I'm trying to proceed just like the documentation says.
SELECT ..., B.dthr_occurrence as open,
DATE_SUB(C.dthr_occurrence, INTERVAL B.dthr_occurrence
HOUR_MINUTE) AS during,
Hello,
I tried to execute the following query:
SELECT studenti.*
FROM studenti,valutazioni LEFT JOIN valutazioni ON studenti.sid=valutazioni.sid
WHERE valutazioni.sid IS NULL;
and give me the following error message:
ERROR 1066: Not unique table/alias: 'valutazioni'
I have the Mysql 4.0.1 alpha
On Wed, 20 Nov 2002, Francesco wrote:
Hello,
I tried to execute the following query:
SELECT studenti.*
FROM studenti,valutazioni LEFT JOIN valutazioni ON studenti.sid=valutazioni.sid
WHERE valutazioni.sid IS NULL;
Hi!
I think you don't have to specify valutazioni in the FROM subclause (is
Syntax errors. Try:
SELECT studenti.*
FROM studenti LEFT JOIN valutazioni ON studenti.sid=valutazioni.sid
WHERE ISNULL( valutazioni.sid )
Ignatius
- Original Message -
From: Francesco [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
On 20 Nov 2002, at 14:40, Felipe D. Ramalho wrote:
SELECT ..., B.dthr_occurrence as open,
DATE_SUB(C.dthr_occurrence, INTERVAL B.dthr_occurrence
HOUR_MINUTE) AS during,
DATE_SUB(D.dthr_occurrence, INTERVAL B.dthr_occurrence
HOUR_MINUTE) AS late
FROM CALL A,
Hi,
I tried taking out the new MYSQL, and my application dumps -- it doesn't
look like mysql_init is actually allocating memory for the MYSQL object
because then mysql_real_connect is called with a NULL pointer.
Is that supposed to happen?
--Anna
Ben Goodwin wrote:
Hi!
mysql_init will
Hi!
On Nov 18, Kevin Lewandowski wrote:
I'm using mysql fulltext indexes and want them to see words of 2 or
more characters, and no stopwords. I've edited the appropriate files
(ftdefs.h, ft_static.c), then recompile, install, restart mysql,
rebuild indexes, and there is no change. It
Sorry, but I've omitted part of the where clause to make the message shorter
and now I see that it was important. Here goes the select again:
SELECT A.cod_call, A.cod_link, A.nr_call , A.status,
B.dthr_occurrence as open,
DATE_SUB(C.dthr_occurence, INTERVAL B.dthr_occurrence
Hi, Sergei.
In myisam/ftdefs.h I changed:
#define MIN_WORK_LEN 4
to:
#define MIN_WORD_LEN 2
and I commented out the line:
#define COMPILE_STOPWORDS_IN
(this should leave out stopwords right?)
There were no changes to ftstatic.c
recompile, reinstall, restart mysql.
To test I dropped and
On 20 Nov 2002, at 15:30, Felipe D. Ramalho wrote:
Sorry, but I've omitted part of the where clause to make the message shorter
and now I see that it was important. Here goes the select again:
SELECT A.cod_call, A.cod_link, A.nr_call , A.status,
B.dthr_occurrence as open,
Hello, it may be a simple question, but I can't get to it:
Why this simple query does not use the PRIMARY key (which is oai_ui)?
mysql explain select * from idb_metadata where oai_ui like 'doi:10.1088/0%';
+--+--+---+--+-+--+++
|
Hi,
From the manual (http://www.mysql.com/doc/en/MySQL_indexes.html):
Fabrizio Nesti wrote:
Hello, it may be a simple question, but I can't get to it:
Why this simple query does not use the PRIMARY key (which is oai_ui)?
mysql explain select * from idb_metadata where oai_ui like
Well, This is my first attempt at moving from Oracle to MySQL on such a
large scale and so far it isn't going well at all. We are running oracle
7.3.4.0.1 and MySQL 4.0.4-0 standard. We are moving 101 tables with a total
of 45 millon records over. I have tried several diffrent methods including
On Wed, 20 Nov 2002, Joseph Bueno wrote:
Fabrizio Nesti wrote:
Why this simple query does not use the PRIMARY key (which is oai_ui)?
mysql explain select * from idb_metadata where oai_ui like 'doi:10.1088/0%';
While this is correctly using it
mysql explain select oai_ui from
Sorry, but I've omitted part of the where clause to make the message shorter
and now I see that it was important. Here goes the select again:
SELECT A.cod_call, A.cod_link, A.nr_call , A.status,
B.dthr_occurrence as open,
DATE_SUB(C.dthr_occurence, INTERVAL B.dthr_occurrence
Scott Pippin
[EMAIL PROTECTED]
Wesley Brown [EMAIL PROTECTED] 11/20/02 11:24AM
Well, This is my first attempt at moving from Oracle to MySQL on such
a
large scale and so far it isn't going well at all. We are running
oracle
7.3.4.0.1 and MySQL 4.0.4-0 standard. We are moving 101 tables with a
Hi
I have moved huge amounts of data around in the past, from Oracle to Oracle,
and Oracle to MySQL.
The problems to consider are
- export speed
- load speed
It can take hours to download a large database, nevermind re-loading it into
another database. It is usually best to export the data
On 20 Nov 2002, at 12:54, Steve Buehler wrote:
What I am trying to do is to copy a mysql table to a new
table name in a PHP script.
Use the query SHOW CREATE TABLE $from_table to get the SQL
statement for creating the table, then do
$create_table_sql = preg_replace(
Hello All,
I have done quite a bit of searching but have not been able to find any
MySQL 3.23.x Binary packages for AIX 4.2.1 (RS6000) any help in locating one
would be very much appreciated.
Thank you,
Christophe Banal
-
Dear Egor,
thanks for your great advice, finally pointing out the reason for the
problem.
SH mysql ALTER TABLE auftrag CHANGE Nummer Nummer INT UNSIGNED NOT NULL
SH PRIMARY KEY;
SH ERROR 7: Error on rename of '.\trainee\auftrag.MYI' to
SH '.\trainee\#sql2-648-2.MYI' (Errcode: 13)
This
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 20 November 2002 20:32, [EMAIL PROTECTED] wrote:
I have done quite a bit of searching but have not been able to find any
MySQL 3.23.x Binary packages for AIX 4.2.1 (RS6000) any help in locating
one would be very much appreciated.
Well, it looks like Simon has the best possible answer so far. I did a test
dump into a delimited file from Oracle and imported that using the LOAD
command in mysql and sustaned about 11,000 inserts a second. This is with no
indexes on the mysql tables at all. I have also tried using the dbtools
Can you explain this procedure to me a little better or point me to
something I can read? I still have to convince the person who manages the
Oracle box to open up an NFS share.
The point of using NFS to transfer the files from the oracle box to the
mysql box is to avoid copying the data
Hi
I am a beginner in using mysql on Windows platform, and I have a question regarding
the use of SELECT * from TABLE_NAME statement within the mysql prompt.
I have a table of consisting of three columns POSTCODE, SUBURB, STATE where
the primary key is a composite of all three fields.
When I
You should write:
SELECT postcode FROM TABLE_NAME;
This will display the postcode from your table?
Jfernand
** sql **
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: November 20, 2002 16:12
To: [EMAIL PROTECTED]
Subject: SELECT Statement Question
Hi
I am
Thank You. I am not sure which one is faster because I don't have any HUGE
tables to test it on, but someone from the PHP mailing list gave me the
following that works like a charm.
create table table2 select * from table1
Thanks
Steve
At 02:09 PM 11/20/2002 -0500, you wrote:
On 20 Nov 2002,
TERRIBLE!
at least with ver mysql-3.23.53 on Win98. It crashes my machine
after a while and when I close it, it sends the hadr drive into an
infinite loop doing who knows what.
On 20 Nov 2002, at 11:02, Simon Windsor wrote:
Hi
I have been asked to support/bug-fix a Windows based web
When I run SELECT * FROM POSTCODE; in mysql prompt I get garbled display of
data and some of my data is not shown.
the garbled display is probably due to the results being wider then the
screen/terminal, and since the mysql client doesn't implement a horizontal
scrollbar like a gui/web mysql
Wesley,
Forgive me because I'm not overly familiar with Oracle, and this is an
unproven idea
If you can run the oracle export function from unix shell, you could do
something like the following
-- Install the mysql client on the oracle db server (will be quick and won't
need any
Hi all,
I have the following query i'm running through a PHP script:
SELECT DISTINCT board_threads.*
FROM board_threads
LEFT JOIN board_replies
ON board_threads.id = board_replies.threadid
WHERE (board_threads.stamp '{$startDate}' OR board_replies.stamp
'{$startDate}')
ORDER BY
I had a free mysql database and admined with phpmyadmin. well i got a back
up from called backup.sql
in side the file it looks like this
# Table structure for table `phpbb_auth_access`
#
CREATE TABLE phpbb_auth_access (
group_id mediumint(8) NOT NULL default '0',
forum_id smallint(5)
On 20 Nov 2002, at 16:01, Steve Buehler wrote:
Thank You. I am not sure which one is faster because I don't have any HUGE
tables to test it on, but someone from the PHP mailing list gave me the
following that works like a charm.
create table table2 select * from table1
The problem with
When you specify a limit clause, do you start at 0 or at 1?
The reason why I ask is that, on one query, it seems to be picking up the
second record first when I use 1 e.g LIMIT 1, 10.
-
Before posting, please check:
Stick Dragon wrote:
I had a free mysql database and admined with phpmyadmin. well i got a
back up from called backup.sql
in side the file it looks like this
# Table structure for table `phpbb_auth_access`
#
CREATE TABLE phpbb_auth_access (
group_id mediumint(8) NOT NULL default '0',
In my situation I used Delphi 6 and MySQL as a client/server application. I
tried DBX before but it gives me more headache, more on connection
issue...so I decided to switch to WinZeos project as a component in
Delphi...for now I use the component as my basic connector to my server. I
also heard
Use the mysqlc.exe client instead of mysql.exe
-- Geoff Morris
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 20, 2002 7:28 AM
To: [EMAIL PROTECTED]
Subject: Error 1148 The error used Command is not allowed with this
MySQL -Version
On Thursday 21 November 2002 00:31, JohnMeyer wrote:
When you specify a limit clause, do you start at 0 or at 1?
The reason why I ask is that, on one query, it seems to be picking up the
second record first when I use 1 e.g LIMIT 1, 10.
Hi, this is my first dabble of using MySQL and am having trouble setting a
password.
I have installed MySQL on Windows XP. I've gone through the manual, but I
can't really find how to do it. If you could post me the coomand line I need
to enter, it would be great. Thanks.
Trystan Hughes
since you're comfortable with rolling your own
tools, here are some observations about the ado
approach, and which could be applied to odbc as
well.
i'm running an oracle enterprise server in a test
environment for corereader, and i've noticed
that, although oracle sometimes takes a while
thanks for the chuckle. we've all been beginners
and i still do dumb things with sql.
download corereader from http://corereader.com
it will let you click on the database objects to
build your queries. when you click on your table
name and your field name, it will return the data
to you
my experience is rather limited since i use linux
only as a file server. after installations of
mysql on win2k and nt4.0 sp6, i can say that it
came up without incident, and has been running
for months in the corereader test environment.
it was far far easier to install than oracle, and
I have recently installed msql v 3.21 on my UNIX server (SCO Openserver
Enterprise). Can someone steer me to where I might find a UNIX character
based front end (NOT GUI) so that I might be able to interactively add,
edit, delete, and browse the records of my database.
Thanks,
--Ray [EMAIL
Query:
SELECT Count(id) AS Taken FROM ClassGuests WHERE id=5
Returns 1 record, value 0
Query:
SELECT Sum(nGuests) AS Taken FROM ClassGuests WHERE id=5
Returns 1 record, value '' (nothing)
And
Query:
SELECT Count(id)+Sum(nGuests) AS Taken FROM ClassGuests WHERE id=5
Returns 1 record, value ''
I've been running MySQL on Windows 2000 and Windows XP as local services
on my DESKTOP, (I know, I know) without any problems. In fact, I hardly
even know that the services are running except when I process a large
chunk of data...
Dan Cumpian
-Original Message-
From: John Ragan
At 21:38 -0500 11/20/02, Daniel Chicayban wrote:
Query:
SELECT Count(id) AS Taken FROM ClassGuests WHERE id=5
Returns 1 record, value 0
Query:
SELECT Sum(nGuests) AS Taken FROM ClassGuests WHERE id=5
Returns 1 record, value '' (nothing)
And
Query:
SELECT Count(id)+Sum(nGuests) AS Taken FROM
In the last episode (Nov 21), ck nuke said:
I have a problem about : mysql query
I need help for this.
Sever: mysql Version: 4.0.4-bata
SELECT p.pid, p.dateline, t.tid, t.replies FROM cdb_threads t,
cdb_posts p WHERE p.tid=t.tid AND t.fid='24' ORDER BY p.dateline DESC LIMIT
0,1
When
Greets:
I just have a quick question. I've been setting up a
website using a MySQL database loaded with a large
number of articles but I'm having a problem.
Some of the articles did not load correctly into the
database. Is there a method of loading a text (well,
in this case a *.html file)
On Wed, 2002-11-20 at 18:19, Stick Dragon wrote:
I had a free mysql database and admined with phpmyadmin. well i got a back
up from called backup.sql
in side the file it looks like this
# Table structure for table `phpbb_auth_access`
#
CREATE TABLE phpbb_auth_access (
group_id
Hi,
I would like to know how to store an image as a BLOB in MySQL. (from
Delphi).
Sincerely,
Adrian Tarniceru
---
Xnet scaneaza automat toate mesajele impotriva virusilor folosind RAV AntiVirus.
Xnet automatically scans all
1 - 100 of 106 matches
Mail list logo