I think u just have to create exactly the same table in another database,
and then copy
the .frm file to the one where you lost the original one.
CB
-Original Message-
From: Jonathan Stockley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 26, 2002 00:20
To: [EMAIL PROTECTED]
Subject:
Hi,
I'm sort of glad we're not the only one having this problem.
Yesterday we had kind of the same error message on an Solaris 8 machine with
512Mb of ram.
Our buffer_pool_size was set to 250Mb, because the other 250Mb is used by
the orion-web-server.
Today I will perform crash-tests on another
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `' and `').
SEND-PR:
From: root
To: [EMAIL PROTECTED]
Subject: [compiler error]
Description:
make all-recursive
make[1]: Entering
hi guyz
i have downloaded phpmyadmin
i have configured it by the book
but i dont know how to use it for mysql database
:$
will someone pleez tell me how to
thnx a million
toby .
_
MSN Photos is the easiest way to
Hi!
Michael == Michael Jessop [EMAIL PROTECTED] writes:
Michael _mysql_exceptions.OperationalError: (1114, The table '#sql700_2_0' is full)
Michael ...I reinstalled MySQL with the Innodb backend, and configured it (per the
nice example at mysql.org) to fit on my 10GB disk with 128 mb ram, I
hello sir,
I am Rajesh.
I am an administrator in DeUS
Infotech.Hyderabad,India.
I had installed mysql on windows and connected with
the database with Jrun for JSP pages.
I am getting the error and some times the data
accesiible.I am using the mmmysql.jar file for
connecting the mysql with
Hi
If you open the directory where it is installed with a web browser what
happens?
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
Hiho hiho!
Which joins could that be? I think most if not all subqueries should be
replacable with joins.
Greetings
Ralf
Arul wrote:
Hi All
I am currently porting our application from Oracle to MySQL.
We have some subqueries in oracle which cannot be ported into MySQL.We even
tried some
Agreed Ralf...
Not all SubQueries can be replaced by Joins..
Thats why we have planned for Temp Tables..
Any ideas on it..
- Original Message -
From: Ralf Narozny [EMAIL PROTECTED]
To: Arul [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED]
Sent: Wednesday, June 26, 2002
Hiho hiho!
How about:
CREATE TABLE tmp_whatever SELECT list FROM table1...
INSER INTO tmp_whatever SELECT list FROM table2...
?
Greetings
Ralf
P.S.: A bit dirty for someone who got used to Oracle ;-)
Arul wrote:
Hi
Can i use Unions in MySQL.
If not could anyone comeout with some
SELECT
U.UserID
FROM
Transaction_Data T, Rfq_Data R ,Company C
WHERE
T.TransactionID = R.TransactionID AND
(R.Industryid=1 or R.IndustryID IN (SELECT IndustryID FROM
Company_Industries CI WHERE CI.CompanyID = C.CompanyID))
This is to Pass the Mail Server : sql,query
U did not clarify that either u r accessing MYSQl through java beans or u
have specified the driver in that JRun itself..U require to start mysql as
service on ur machine for that u need to click winmysqladmin.exe at
mysql\bin dir .. hope it should work..
D K Dubey
-Original Message-
Hi
Paul - Thanks for your suggestion.
Unfortunately the general query log indicates that there is
no hint of any external interference and it still rotates
every few seconds ... there are constant accesses to the DB,
and the bin-log is rotated mid-connection by a querying client.
I have an
I run a MySQL/PHP-based website. In an attempt to make some search
functionality, I search a few specific tables that I find relevant and look
in certain fields when performing a search. A query will generally look
something like this:
SELECT * FROM Books WHERE LongName LIKE '%$kw%' OR ShortName
At 11:55 AM 6/25/2002 -0400, Andy Dustman wrote:
From a usability perspective, since other databases don't seem to be so
picky about this sort of thing, InnoDB ought to (IMHO):
a) Act on REFERENCES clauses (i.e. column type REFERENCES ref-table)
instead of ignoring them.
b) Auto-create
Hi!
I want to store my mysqldatabase encrypted on disk, it contains sensitive
data. Is there anybody out there doing this already? Or do I have to rewrite
the myisam routines? Or is there another way?
Regards, Tobbe
--
`Given enough eyeballs, all bugs are shallow.'
69D6 E76A FC83 E9CA 0747
I've just downloaded a version of dbf2mysql that supports fields of type
MEMO.
I was wondering if anyone knew how to use this as the readme doesn't tell
you?
Thanks,
Neil
-
Before posting, please check:
Hi,
Could any of you help me in getting a Performance Comparison document for
MySQL on different architectures (Intel linux or S390 linux).
Regards,
prabha
-
Before posting, please check:
http://www.mysql.com/manual.php
Hi All,
I am new to MySQL, can any body tell me how to write store procedures
in MySQL.
and How to run the same in command line. This will help me very much.
Thanks in Advance.
Pradeepp
-
Before posting, please check:
Dear listmembers,
I have two tables
candidate_index
candidate_skill
candidate_index hold information about the candidate like id
(autoincrement), firstName, lastName
and emailAddress.
candidate_skill has three columns
- id (autoincrement)
- candidateID
- skill
client_index has a fulltext
I am new to MySQL, can any body tell me how to write store procedures in
MySQL.
MySQL doesn't support stored procedures yet.
and How to run the same in command line. This will help me very much.
But you can create text fle with SQL commands and then run it from command
line:
mysql -h host
Hi!
You can try FULLTEXT search, implemented in MySQL,
or consider installing specialized Web search engine.
Eivind A. Sivertsen wrote:
I run a MySQL/PHP-based website. In an attempt to make some search
functionality, I search a few specific tables that I find relevant and look
in
Hello,
I am trying to set up a MyODBC connection from my MAC OS9. I
have a filemaker database on the MAC OS 9 machine that I would
like to connect to a MySQL database on my host server. There are
MyODBC drivers published for MAC OS X on the MyODBC downloads
page, but they don't seem to work on
There are no sprocs in MySQL at this time.
There are plans for such, but it will be at least a 4.x (post 4.0) release.
There are some 3rd party things out there to allow you to run inline Perl
and stuff like that, but they are true add ons and are not an exact match to
a stored procedure
Ah, that makes sense. So it potentially could be the simple matter of
telling the compiler that the type is unsigned.
--shak
Chuck Simmons wrote:
Bert --
Your problem is not the same as Shakeel's. For you, the database is
saying that it couldn't allocate memory. For Shakeel, it is
[please honor my mail-followup-to header]
At a certain time, now past, Dana Diederich spake thusly:
Out of curiosity, why would you recommend not putting images into a DB?
I've had a lot of success doing that sort of thing.
Cheers.
-Dana
I never said it wouldn't work, but you need to
I am trying to do move a (hard to maintain) spreadsheet task
over to the Mysql database so I can more easily add to the
data and harvest result information.
I am using Mysql 3.23.49
The following table parts have been created and will be
referenced below:
CREATE TABLE TestSuite (
TSid
Hi!
It turned out that the bug indeed was connected with a 32-bit signed integer
wrap-over if the buffer pool on a 32-bit computer is bigger than 2 GB.
The following patch may fix the problem, but better test first if there are
also other similar wrap-overs which I did not notice.
Best
Hi,
for viewing long tables.
in my sql query when i say SELECT * FROM abc
i miss the upper entries of the table as they scroll down.
is there something by which i can view a table page by page(as | more in
unix)
thanx
anil
-
For anyone else having this problem building the MyODBC MySQL driver, I
ended up commenting out all of the ctl3d calls in setup.c (and replacing
SetWindowLong(hdlg, DWL_MSGRESULT,Ctl3dDlgFramePaint(hdlg, wMsg, wParam,
lParam)); with SetWindowLong(hdlg, DWL_MSGRESULT,lParam);) The driver
now
Does anyone else feel that lack of support for subqueries is the number 1
deficiency in MySQL? I'm not sure why support for subqueries is being
deferred for so long. Certainly, uncorrelated subqueries are almost trivial
to implement and the truth is that correlated subqueries aren't really all
Not directly, MySql does not support sub selects yet.
HTH
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
Hi all!
I am using MySQL (version 3.23.51-max-log). I have a problem with locking.
Let's assume that we have 2 connections (Conn1 and Conn2) and table test:
CREATE TABLE `test` (
`id` int(3) NOT NULL auto_increment,
`name` char(10)
Mysql does not currently support stored procedures. Check the website for
the features that will be added to the 4.x seriese.
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Pradeep.C.Pangi [mailto:[EMAIL PROTECTED]]
Sent:
Hi,
I have installed MySQL 4.0 on Linux box using RPM. Everything is working fine, but the
database directory is set to
/var/lib/mysql. So everytime I create a database it is getting created on
/var/lib/mysql. What I would like to have is to create database under
/var/lib/mysql/data_dir,
Hi!
I'm not sure whether I understood what exactly you mean.
To exclude a row from the result, one should usually
use conditions in WHERE clause. Probably you missed
something in WHERE?
Martin Adler wrote:
Hi,
is it possible to force mysql in a SELECT clause depend on a
condition to
Is there any way in SQL (and especially MySQL) that I can determine
the count of rows that would be returned by a SELECT with a GROUP BY
and a HAVING, without retrieving the rows?
For example, I want the number of orders whose total value is greater
that 1. The orders would be SELECTed like
Hi,
I wonder which is the best filesystem to use with MySQL (to increase
performances). And which mounting option should be used ?
According to the documentation, the best system is SuSE Linux 7.1, 2.4
kernel, and ReiserFS. I currently use ReiserFs with noatime option. But it
seems (according
I've got the following 2 tables:
create table cinema_order (
id int not null primary key auto_increment,
revision_number int not null default 1,
active_revision int not null default 1
);
create table cinema_order_revision (
id int not null primary key auto_increment,
cinema_order_id int not null
Is the mysql mail list down?
sql
-
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
Hi,
the sql process(on doing ps) shows the following process:
/usr/local/bin/safe_mysqld --user=mysql
when i kill this process and try to restart it with command:
safe_mysqld --user=mysql
it says a mysql process already exists.
can anyone tell me how to restart mysql daemon.
thanx
anil
MySQL is barely an SQL database - it doesn't support much basic SQL 89
functionality. Can any one throw some light on why professional SQL
database developers want to use it for anything but simple file
management? AND It is written in C as well so why do Java developers
use it?
Regards,
Dave
Hi all.
I execute the next query in Delphi 5.0 against MySQL and Delphi understand
that the column of the query is of type ftFloat
when it should be ftInteger (The field cantidad in the database is int).
SELECT SUM(cantidad) AS Ventas
FROM LALBARANCL
WHERE fecha = 2002-05-01
AND fecha
Hi.
First, I removed the CC to the java list, because this problem is not
java-related in any way.
Second, I suggest you do some reading in the manual, the questions you
asked recently are mostly answered there.
On Wed 2002-06-26 at 15:03:19 +0530, [EMAIL PROTECTED] wrote:
SELECT
U.UserID
What us U.UserID? You don't have table U in the table list.
Arul wrote:
SELECT
U.UserID
FROM
Transaction_Data T, Rfq_Data R ,Company C
WHERE
T.TransactionID = R.TransactionID AND
(R.Industryid=1 or R.IndustryID IN (SELECT IndustryID FROM
Company_Industries CI WHERE CI.CompanyID =
Err well, the problem is mine since I'm new to SQL.
I have an mysql server running and have a data source that contains text
posts. I'd like to setup a script that will search for string1 and replace
it with string2.
There may be text before or after this statement that must remain
Hello.
On Wed 2002-06-26 at 16:47:05 +0530, [EMAIL PROTECTED] wrote:
Hi All,
I am new to MySQL, can any body tell me how to write store procedures
in MySQL.
and How to run the same in command line. This will help me very much.
More of help would be a look in the manual, which would
Pierre,
Tuesday, June 25, 2002, 3:54:28 PM, you wrote:
PB how to remove a foreign key constraint without recreating the innodb table ?
No, it's not possible ...
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net
There are no stored procedures in mySQL
Andrei Cojocaru
[EMAIL PROTECTED]
- Original Message -
From: Pradeep.C.Pangi [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 26, 2002 05:17
Subject: Regarding Store Procedures
Hi All,
I am new to MySQL, can any body tell
I hope someone can tell me a bit more
on how to integrate a MYSQL server with a windows network.
I have a web server that is running IIS5.
The internet user account is IUSR_Machinename.
I do not want to run the database on the web server.
When I tried this with Access it did not work because
When trying to use the /auto feature of the Windows MyODBC driver setup
program, it wants to use read a odbcinst.ini file. Anyone have any info
on the format of this file and what should be in it? Many thanks in
advance...
-- Rick
MySQL spam killer strikes again.. (not)
Hi!
There is a workaround for it using ENCODE and DECODE functions.
Insert data in this style:
INSERT INTO t VALUES (field) ENCODE('string','password');
Retrive it using decode():
SELECT decode (field,'password') FROM t;
Perhaps this helps.
Tobias Bengtsson wrote:
Hi!
I want to
mysql pager more
See: http://www.mysql.com/doc/m/y/mysql.html
Gurhan
- Original Message -
From: Anil Garg [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 26, 2002 4:15 PM
Subject: long table scroll down
Hi,
for viewing long tables.
in my sql query when i say SELECT *
At 16:15 -0400 6/26/02, Anil Garg wrote:
Hi,
for viewing long tables.
in my sql query when i say SELECT * FROM abc
i miss the upper entries of the table as they scroll down.
is there something by which i can view a table page by page(as | more in
unix)
thanx
anil
Yes, if you *are* using Unix.
I execute the next query in Delphi 5.0 against MySQL and Delphi understand
that the column of the query is of type ftFloat
when it should be ftInteger (The field cantidad in the database is int).
SELECT SUM(cantidad) AS Ventas
FROM LALBARANCL
WHERE fecha = 2002-05-01
AND fecha
Shon,
Tuesday, June 25, 2002, 8:54:39 PM, you wrote:
SS i have an application that will allow me to rotate mysql table using
SS date variable substition. in other words
SS table=tblname.%m%d%Y
SS if i am using a remote system to host the application, what
SS permissions to i need to give the
Aqeel,
Tuesday, June 25, 2002, 5:12:45 PM, you wrote:
AA I have installed mysql 3.23.25 on solaris 7. It was
AA installed in /usr/local/mysql. When I run the
AA safe_mysqld scritp, the mysql daemon starts withouut
AA any error and the ps command shows that mysql is
AA running. However from
It's hard to give a common suggestion which
is suitable for all cases. We need to know
the exact queries being executed.
Arul wrote:
Agreed Ralf...
Not all SubQueries can be replaced by Joins..
Thats why we have planned for Temp Tables..
Any ideas on it..
- Original Message -
I've been a loyal MySQL fan for a few years now, and use it extensively
in web site development. But I've run into a problem now (MyODBC
3.51.03) that is making me reconsider my choice.
Most of my database access is local using JDBC, but I have some
critical Windows software that relies on
How are people representing subsecond date/time values with MySQL?
In Sybase, the datetime data type supports subsecond values with a
resolution of 1/300th of a second (go figure). PostgreSQL does microseconds
with its time (4 bytes) and timestamp (8 bytes) data types.
More generally, JDBC
Search for 'my.cnf' on mysql.com
This is the config file that you can use to set the data dr
You may need to create it if it doesn't already exist.
HTH
Peter
---
Excellence in internet and open source software
RedHat 7.1
MySQL Version 3.23.42
Couple of questions about MySQL and the open_files stat as reported by
mysqladmin extended-status.
I've changed my configuration (both MySQL and Linux) to increase the max
number of open files -- I don't have a problem here. But, I do see that the
open_files
Bert --
Your problem is not the same as Shakeel's. For you, the database is
saying that it couldn't allocate memory. For Shakeel, it is saying that
an assert failed. At about line 213, there is a right shift (X Y)
that is occuring. The behavior of a right shift is different depending
on
ericloe,
Tuesday, June 25, 2002, 12:17:03 PM, you wrote:
e I'm new in MySQL.anyone out there can help please?
e I'm actually experimenting with the mysqlimport utility to import data from
e a text file.however i'm always getting this error upon the command
LTrain1007,
Wednesday, June 26, 2002, 1:51:17 AM, you wrote:
L I downloaded this version, and unzipped it using winrar. I have all the
L files in a directory but i dont know how to use or install mysql? any help?
Have you downloaded binary or source distribution?
If you downloaded binary
Marcel,
Wednesday, June 26, 2002, 12:57:27 AM, you wrote:
M ./bin/safe_mysqld --user=mysql --port=7000
M im want to start mysql in the 7000 por and imm using the command abobe put
M it still on port 3306.
M Whats Wrong ? I can put port parameter in My.cnf ?
Check your my.cnf file is there
Hi
When I run my MySQL question I get what I think is a cartesian product?
SELECT table1,Username
FROM table1, table2
WHERE table1.Username != table2.Username;
If I just run'=' then no problem but it seems to what to match every thing
with every thing
and so I run out of memory.
Is
I recently installed MySQL on a computer running Windows 2000 and
have been working through the tutorial session in the manual. All
went well until I created the second (event) table. While I believe
that all the data in the table is correct, any query which returns
the remark column results in
Shon Stephens wrote:
i have an application that will allow me to rotate mysql table using
date variable substition. in other words
table=tblname.%m%d%Y
if i am using a remote system to host the application, what
Host doesn't matter. localhost and remote hosts are processed
in the same
Hi,
i found a solution by myself
i think it's very complex but may help others
for finding solutions
Thats the query:
SELECT entries.id, entries.head, entries.date, entries.author
FROM entries
LEFT JOIN category ON entries.cat_no REGEXP
CONCAT(\\.,category.id,(\\.|$))
LEFT JOIN entgroup ON
MySQL doesn't support stored procedures. They are on
TODO and should appear in MySQL-5.0.
Pradeep.C.Pangi wrote:
Hi All,
I am new to MySQL, can any body tell me how to write store procedures
in MySQL.
and How to run the same in command line. This will help me very much.
--
For
At 11:43 +0200 6/26/02, Gary Colman wrote:
Hi
Paul - Thanks for your suggestion.
Unfortunately the general query log indicates that there is
no hint of any external interference and it still rotates
You may not see an explict FLUSH LOGS query. Do you seen any
lines that say Refresh after a
[snip]
I am new to MySQL, can any body tell me how to write store procedures
in MySQL. and How to run the same in command line. This will help me very
much.
[/snip]
http://www.mysql.com/doc/T/O/TODO_sometime.html
MySQL does not currently support stored procedures
Jay
sql, mysql, query
Hi
When I run my MySQL question I get what I think is a cartesian product?
SELECT table1,Username
FROM table1, table2
WHERE table1.Username != table2.Username;
If I just run'=' then no problem but it seems to what to match every thing
with every thing
and so I run out of memory.
Is there a way
mysql is running on an i386 box with Red Hat Linux 7.0
this works:
mysql -u root -p
--it askes for the root password, and lets me into the mysql monitor. I can
create databases and tables, life seems good.
than I try something like:
Grant all on *.* to user identified by 'password';
where
At 03:03 PM 6/26/02 +0530, Arul wrote:
SELECT
U.UserID
FROM
Transaction_Data T, Rfq_Data R ,Company C
WHERE
T.TransactionID = R.TransactionID AND
(R.Industryid=1 or R.IndustryID IN (SELECT IndustryID FROM
Company_Industries CI WHERE CI.CompanyID = C.CompanyID))
You ran this query through
Hi!
I have an table called 'list' where I store all items for the pulldown
menues on my site.
Table list has three columns
- id (int autoincrement)
- pulldown_name (tinytext - name of pulldown)
- item (tinytext - the item for the pulldown menu)
A table called client_index stor all the info
You are correct. It was a typo on my part. I forgot to copy the AND in
the AND event.event_id = score.event_id; The problem is the same and I
still receive an empty set message. You are also correct that there are
events with the date of 1999-09-23. TIA for any assistance.
D. H. Craig, CSM
What URL did you try?
Takacs Istvan wrote:
Hi
I'd like to download
mysql-3.23.51-sun-solaris2.8-sparc.tar.gz
from mysql.com, but the server doesn't allow me
to get the file.
What's wrong with it?
Thanks in advance!
Regards;
Istvan
Hi,
I've just got this error on my server.
According to the manual, I can read :
If you get Commands out of sync; you can't run this command now in your
client code, you are calling client functions in the wrong order!
This can happen, for example, if you are using mysql_use_result() and try
U can use the latest version of WinZeos 5.0.3
Hope it helps
R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No.(Office) (088) 858-1028
(Home) (088) 858-8889
Mobile No. (63) (919-3085267)
-Original Message-
From: Iago Sineiro [SMTP:[EMAIL
In a nutshell, this can be rewritten as a join - no sub-select needed, so no
problem (this is true of the vast majority - albeit not all - sub-selects).
Because the U table is missing (indeed, it looks like a lot of your join
informaiton is missing too), there's no way for me to give you an
At 20:22 +0200 6/26/02, Iago Sineiro wrote:
Hi all.
I execute the next query in Delphi 5.0 against MySQL and Delphi understand
that the column of the query is of type ftFloat
when it should be ftInteger (The field cantidad in the database is int).
SELECT SUM(cantidad) AS Ventas
FROM LALBARANCL
At 7:16 -0700 6/26/02, Dave Morse wrote:
MySQL is barely an SQL database - it doesn't support much basic SQL 89
functionality. Can any one throw some light on why professional SQL
database developers want to use it for anything but simple file
management? AND It is written in C as well so why do
I'm trying to retrieve a particular field using C API. When I use this
select statement from the mysql client it retrievs the correct result:
mysqlSELECT ap_senders FROM mailtable WHERE pw_name='regis' and
pw_domain='mbpost.com';
But...
In the C function listed below:
#include stdio.h
At 05:40 AM 6/26/2002, you wrote:
Hi!
I want to store my mysqldatabase encrypted on disk, it contains sensitive
data. Is there anybody out there doing this already? Or do I have to rewrite
the myisam routines? Or is there another way?
Regards, Tobbe
-
Tobbe,
MySQL 4.02 has
At 05:00 AM 6/26/2002, you wrote:
I run a MySQL/PHP-based website. In an attempt to make some search
functionality, I search a few specific tables that I find relevant and look
in certain fields when performing a search. A query will generally look
something like this:
SELECT * FROM Books WHERE
Shakeel,
this may be something with 32-bit unsigned integer / signed integer
arithmetic. I assume mysqld runs in the 32-bit mode?
Are you able to compile mysqld yourself? You could add the following to line
214 of mysql/innobase/include/buf0buf.ic
...
if (block buf_pool-blocks) {
Hi
Any idea when MySQL 4.0 stable release will be made..
As of now only Alpha is released..
Also any sites which run on 4.0 Alpha
Regards,
-Arul
To pass the List : sql , query
-
Before posting, please check:
create temporary table tmp
SELECT IndustryID FROM
Company_Industries CI WHERE CI.CompanyID = C.CompanyID;
SELECT
U.UserID
FROM
Transaction_Data T, Rfq_Data R ,Company C
WHERE
T.TransactionID = R.TransactionID AND
(R.Industryid=1 or R.IndustryID=tmp.IndustryID)
Cheers
Rich
Arul
Hi
I've tried to compile the latest mysql source on
our Solaris 8 SPARC server and gcc 2.95.3,
but make hangs up with these errors;
-I/usr/share/src/mysql-3.23.51/include -DHAVE_RWLOCK_T -c sql_lex.cc
sql_lex.cc: In function `void lex_init()':
sql_lex.cc:85: `symbols' undeclared (first use this
I got problem on my machine running with mysql 3.23.51, some field use
varchar
(40) if query from this field mysql got hanging
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd-query at 0x82c3318 = SELECT * FROM `COURSE` ORDER BY
`SUBJNAME`
Hello All,
I have mysql 3.23.41 running on a Dell Poweredge 2550 on standard install of
Red Hat 7.2 (2.4.9-21smp). This version of mysql came with Red Hat. It's been
running my website very smoothly for the last few months, and averages 130
queries per second.
Mysql has crashed twice in
Everyone,
Is it possible to use LOAD data infile syntax in MySQL ver 3.23.51 win98
version?
R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No.(Office) (088) 858-1028
(Home) (088) 858-8889
Mobile No. (63) (919-3085267)
If you execute UPDATE LOW PRIORITY table_name .. does mySQL automatically
return or does it wait for the update to execute? (that is, is it async or
sync)?
Andrei Cojocaru
[EMAIL PROTECTED]
-
Before posting, please check:
Are u doing a user@hostname or user@%? The hostname part is needed, % means
from anywhere. A better way to write this to prevent any errors is enclosing
user host in single quotes as such: 'user'@'host'.
Regards,
Bhavin.
- Original Message -
From: Michael Knauf/Niles [EMAIL PROTECTED]
I'm trying to figure out how to setup my first mySQL DB... I hope this
isn't too OT for this list.
The DB will serve several purposes, which I think will each go into a
different table w/in one DB.
Here's what I want to be able to accomplish:
pull up a listing of:
1) names and email addresses
At 1:44 +0200 6/27/02, Jocelyn Fournier wrote:
Hi,
I've just got this error on my server.
According to the manual, I can read :
If you get Commands out of sync; you can't run this command now in your
client code, you are calling client functions in the wrong order!
This can happen, for
At 10:42 -0500 6/26/02, rm wrote:
I'm trying to retrieve a particular field using C API. When I use this
select statement from the mysql client it retrievs the correct result:
mysqlSELECT ap_senders FROM mailtable WHERE pw_name='regis' and
pw_domain='mbpost.com';
But...
In the C function
Hi All
Sorry Guys...I just cut a small part of a bi Query where i had problems
but i didnt see the User Table missing in the From List :((
Thanx for your Help..
-Arul
- Original Message -
From: Rob Vieira [EMAIL PROTECTED]
To: 'Benjamin Pflugmann' [EMAIL PROTECTED]; Arul
[EMAIL
1 - 100 of 105 matches
Mail list logo