LS.
This is the text i sent you, the text you have seen was a attachment
C:\mysql\binmysqld
Innobase: Assertion failure in thread 4294946135 in file M:
\mysql-3.23\innobase\
os\os0file.c line 187
Innobase: we intentionally generate a memory trap.
Innobase: Send a bug report to [EMAIL
hello
Please inform me how to load IMAGES INTO MYSQL TABLES.
thanks
Palaniappan
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Does anyone know how to pass a variable from a page embedded with a .swf (flash)
object to a .php file for processing, and pass back the results to the same page
containing the .swf file?
Thanx in advance!
yes.
get MySQL/PHP Database Applications. by J. Greenspan and Brad Burger.
enjoy.
p.s. your hotmail email addy doesn't work.
At 2:03 PM -0300 6/21/01, Laura Lía Marcello wrote:
I need to know if there is a way to create a searchable database that
returns results as a web page...
As you can
Please inform me how to load IMAGES INTO MYSQL TABLES.
You can do so with MySQL-Front - www.mysqlfront.de . Simply paste image from
clipboard into BLOB-Editor.
Greetings,
Ansgar
-
Before posting, please check:
Hi everybody,
On Windows mySQL database stores its record in 3 files
per tables (table.frm, table.MYD, table.MYI) in this
directory c:\mysql\data\database_name\
I use this file to make a backup.
I want to know if these files exist in mySQL on HPUX?
I hope someone can help me.
Thanks.
Please inform me how to load IMAGES INTO MYSQL TABLES.
Having created several similar applications in the past I would recommend
NOT storing these images IN the database; your filesystem makes for a nice
blob storage device. I would instead store pointers of some sort to the
files to
Yes.
Though having never installed mysql on HP-UX my presumption is that it
acts much like all other unices and stores them in a ./data directory.
For example, in the binary distribution this is typically usually in
something like /usr/local/mysql/data. (or, unpacked directory/data)
Take
Hi,
whats the difference between:
alter table tablename add index (name);
alter table tablename add index (age);
alter table tablename add index (birthdate);
alter table tablename add index (city);
compared to:
alter table tablename add index (name,age,birthdate,city);
What I want is
in this directory is the ./mustang-bin.index and also ./mysql/most.frm
however I am getting the error messages below when I try and start it. I
have never had this problem before. Does anyone have any ideas.
Your mysqld doesn't know where your files are (though, that was probably
obvious ;).
Does anyone know how to pass a variable from a page embedded with a =
.swf (flash) object to a .php file for processing, and pass back the =
results to the same page containing the .swf file?
Thanx in advance!
Perhaps not the most topical discussion for the mysql list, but, alas, I
would
whats the difference between:
alter table tablename add index (name);
alter table tablename add index (age);
alter table tablename add index (birthdate);
alter table tablename add index (city);
These are four INDIVIDUAL keys.. helpful if you want to search by name,
age, birthday, _OR_ city
how do i change a table's name without recreating it?
-
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
I have used MySQL for about 2 years nowand I love it.
My only problem is that I am in africa were power
fluctuations are rampant. I usally get table handelr
error 127 after every power outage. S'times simple
repair just doesn't work and the entire database must
be restore. It there a way around
hi,
I was running myisamchk and ismchk on my databases and I got the following
error:
warning: 1 clients is using or hasn't closed the table properly
what does this mean ?
how to prevent it ?
Who can help me out ?`
kind regards
Koen Gogne
[EMAIL PROTECTED]
how do i change a table's name without recreating it?
See:
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
ALTER TABLE tbl_name RENAME TO new_tbl_name
Take care,
seth
---
Seth Northrop
Manager of Information Technology
Reflectivity, Inc.
3910 Freedom Circle, Suite 103
Santa Clara, CA 95054
whats the difference between:
alter table tablename add index (name);
alter table tablename add index (age);
alter table tablename add index (birthdate);
alter table tablename add index (city);
These are four INDIVIDUAL keys.. helpful if you want to search by name,
age, birthday, _OR_ city
It there a way around this error occuring
after every outage?.
Eeek!
Are you running myisamchk -r? - obviously, there isn't really much of a
way to avoid having to repair tables after a hard OS crash. I would
highly recommend trying to get ahold of something like an APC battery
supply which
How can I query the database to know that a specific table exists in a
given database.
for example my database is MessageNotification and I want to know if
Message_data table exists in this database. I am using Mysql++ to query
the database.
Thanks in advanced
Tiwonge
Just make sure you have a key on any field you do a query on. Given that
there isn't a whole lot of correlation between your columns (logically
speaking.. ie, age doesn't really match up with city) I wouldn't worry
about compound keys.. they'll actually just slow you down since you need
to
hello all.
I install mysql 3.23.32 on red hat 6.0 .
I have a c program source as bellow:
//*
//insert_test.c
#include stdlib.h
#include stdio.h
#include mysql.h
int main(int argc, char *argv[]) {
MYSQL my_connection;
int res;
I was running myisamchk and ismchk on my databases and I got the
following error:
warning: 1 clients is using or hasn't closed the table properly
You aren't running (my)isamchk with mysqld running are you? If so, you
shouldn't be.. or at least running on tables that are being used/open and
We are planning to use RAID for backing-up MySQL-data.
Is it adviced that we put the OS on the RAID-array too, or just the data ?
Let's say your OS crashes (Linux...bad libraries for example, that are not resolvable,
for example :), then you'll have to format all your disks including your data
Keep in mind the version of innobase that I am using is compiled with a page
size of 64k.
I have a table of 10million rows (give or take, select count(*) from
tablename is slow for innobase tables so I dont do it often). Everyday I
need to run a query that selects rows that are marked for
Description:
While starting mysqld, mysqld stops with default values from
support-files/my-medium.cnf.
I'm not sure if it's really a bug or just inadequate buffer settings. Anyway, you
asked
in the $hostname.err to make a bug report. ;-) My compile time flags you have in my
previous
Description:
While starting mysqld, mysqld stops with default values from
support-files/my-medium.cnf.
I'm not sure if it's really a bug or just inadequate buffer settings. Anyway, you
asked
in the $hostname.err to make a bug report. ;-) My compile time flags you have in my
previous
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 22, 2001 10:00 AM
I´m trying to install:
perl -MCPAN -e'install DBD::mysql'
in RH 7.0 to conect to mysql with perl
it fail first time...
'BEGIN faild--compilation aborted at Makefile.PL line 5'
desc tablename does the trick from the console or via a query. Checking
for the datafiles is another way if you are local to the server; though,
that's not really a sane technique since you have to usually have the
permissions of the database to see the datafiles.. privs you probably
don't your
Hi,
some more notes:
when using strace to trace the startup, I see some strange errors:
read(198, test -z \$defaults\\n then\n..., 1024) = 1024
xstat(2, /usr/local/mysql/var/data/mysql, 0xe0a31d0) = -1 ENOENT (No such file or
directory)
xstat(2, ./share/mysql/english/errmsg.sys, 0xe0a31d0)
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
and how you fix it?
thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
1. mysql SHOW databases;
2. mysql USE MessageNotification;
3. mysql SHOW TABLES FROM MessageNotification;
hth
At 10:58 AM +0200 6/22/01, Tiwonge Nathan Kawonga wrote:
How can I query the database to know that a specific table exists in a
given database.
for example my database is
Has anyone successfully passed the get_lock()
and release_lock() commands to a MySQL
server using PHP? If so, how did you go about it?
PHP does not seem to implement these functions
despite the fact that they have been around since
sometime in March/April 1998.
/ Carsten
--
Natural selection
Is this what you are looking for?
RENAME TABLE tbl_name TO new_table_name[, tbl_name2 TO new_table_name2,...]
Just take a look at the manual!
Cheers, Nessi
At 09:22 22/06/01 , you wrote:
how do i change a table's name without recreating it?
Hi,
i'm standing before small problem. Which type of table i will use for
my application.
I will need row-locking and speed (maybe transaction)
What type of table do you prefer ? I prefer InnoDB
Michal Dvoracek [EMAIL PROTECTED]
Intekhab Choudhury writes:
Hi
I have installed/configured Oracle under HPUX, but
thinking of moving to mySQL. But finding that a
little difficult.
First of all, document talks about (including
throughout the Internet) a depot file (i.e.
mysql.full) to be run with swinstall
David Freeman writes:
I am having a problem with mysql. I am running a php web site that uses a (mysql
Ver 11.15 Disturb 3.23.39 for pc-linux-gnu (i686))database. Whenever i get a load of
about 100 simultaneous users, mysql begins to spawn D stat processes and the site
dies. Everything
Ricardo Striquer Soares writes:
does enyone knows a GUI to use with mysql wich is verry friendly one?
thanks advanced.
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
Hi!
Try our mysqlgui.
New
are you shore there is a rpm for DBI in RH 7.0 installation cdrom 1 2?
- Original Message -
From: Michael Ott [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, June 22, 2001 11:59 AM
Subject: Re: Fw:
hallo!
With reference to [EMAIL PROTECTED] on 22.06
Rich Duzenbury writes:
And of course, right after I clicked send, I remembered reading about the
mysql gui client. I installed a copy, and it works great. I only had to
tweak it (options dialog) to use the socket name (/tmp/mysql.sock), rather
than it trying to use the IP address.
Hello.
Have a look at the transaction safe table types (InnoDB, BDB, ...). I
did not try them myself, but from what I read on the list, there is a
good chance that they will return to a consistent state themselves.
Bye,
Philemon.
PS: Of course, the better solution would be a back-up
Hi,
I wonder to know if mysql follows any order in
retrieving the data from a table.i.e Is it based on
ascending row order or descending row order.
--Ravi
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or
Hello.
I am not using PHP, so take my comment with a grain of salt.
PHP doesn't need explicit support for GET_LOCK and RELEASE_LOCK as
they are both just simply SQL functions. So I am not sure what you
problem is, just execute the following query:
SELECT GET_LOCK('whatever')
from PHP the
Hi.
There may be some internal order, but according to the SQL
specification, you may not rely on it. The order of records of a query
without ORDER BY is undefined on purpose.
Bye,
Benjamin.
On Fri, Jun 22, 2001 at 01:43:33PM +0100, [EMAIL PROTECTED] wrote:
Hi,
I wonder to know if
Hi,
I accidentaly deleted the mysql.sock file, does anyone know how to
restore it? Thanks.
-Michael Kirschenbaum
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
mysql
hello all.
I install mysql 3.23.32 on red hat 6.0 .
I have a c program source as bellow:
//*
//insert_test.c
#include stdlib.h
#include stdio.h
#include mysql.h
int main(int argc, char *argv[]) {
MYSQL my_connection;
int
Hello.. Friends
I have just installed my OpenBSD 2.9 with mysql 3.23.37 and when i wanted to
startet i can do it first time, but if i have to restart the server. I
cannot start it again, why?
i come with this error.
w3# safe_mysqld
/usr/libexec/ld.so: my_print_defaults: libpthread.so.14.20: No
Can anybody help with the question about which one is the best to handle database
driven webpage, Since, we are running on ACCESS DB, and MS SQL for a long time, but,
We just have our new Lynex server it is running MySQL, my question is:
1) What's the different between MDB and MySQL. I mean
como faço p/ desligar o servidor mysql remotamente?
estou usando win98 e o Mysql esta em uma maquina NT
falow
valeu
Hello,
Suppose I want to update n rows (where n is a possibly large number)
using the mySQL C API. I can create n separate UPDATE
statements and send each of them to the server with mysql_[real_]query(),
but that doesn't seem particularly efficient to me. Is there a better
way to do it ? Can I
Can I show records from my SQL statement where records both have a match and
do NOT have a match. I'm having trouble with the syntax for no matching
records in a related table, my current SQL statment looks like this:
SELECT fid,Family_Last_Name,Phone FROM familytable,playertable WHERE
I got the message when I try to run mysqld.
mysqld: Can't change dir to '/usr/local/mysql/var/' (Errcode: 2)
010622 10:35:41 Aborting
010622 10:35:41 mysqld: Shutdown Complete
-Michael Kirschenbaum
Rolf Hopkins wrote:
You just crashed the mysql server. Just restart it.
- Original
Hello.. Friends
I have just installed my OpenBSD 2.9 with mysql 3.23.37 and when i wanted to
startet i can do it first time, but if i have to restart the server. I
cannot start it again, why?
i come with this error.
w3# safe_mysqld
/usr/libexec/ld.so: my_print_defaults: libpthread.so.14.20:
hallo yann!
are you shore there is a rpm for DBI in RH 7.0 installation cdrom 1 2?
yes, one is called perl-DBI and is at the powertools-cd and the other,
which you mean is at
ftp://ftp.redhat.com/pub/contrib/libc/i386/perl-DBD-msql-mysql...
but you must copy some files after installation
cp
Try also mysql_navigator (latest 1.2.3). You'll need qt 2.2.x (and a
little work with compillig :-).
Nice, simple, powerfull. I'm very happy with this GUI.
http://sql.kldp.org/mysql
Malmo
Malmo If I only got 20$
can´t find rpm DBI in RH 7.0 installation cdrom 1 2
help
- Original Message -
From: Michael Ott [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, June 22, 2001 4:06 PM
Subject: Re: Fw: Fw:
hallo yann!
are you shore there is a rpm for DBI in RH 7.0
Hello all,
apologies if this has been posted before but I can't find it in the FAQ, docs or
anywhere...
Subject says it all: before closing down for a backup or whatever, how do I find
out who is logged into the server (as opposed to just getting connections
information)?
Many thanks for
Hi
I was trying MySQL on a RedHat 7.0 for the first time using MySQLGUI. But
when I try to connect I get:
Can't connect to local MySQL server through socket '' (111)
Arnor Sigfusson
Arnor Sigfusson Tel:+354 5574488
FutureMedTecMobile: +354 8949960
Storhofda 17
MySQL has is used by alot of major players and there are pre made setup for building
database driven websites like PHP-Nuke.
Unsure on the strings
I use Win2K and Mysql PHP and PHP Nuke with Apache for my site and it's working great!
My Linux Server has the same and also does excellent.
Hello,
I think it might not be a right mailing list for this question, but I
don't know where else should I post it.
If I run Perl DBI's $dbh-connect() without $dbh-disconnect(), MySQL (or
is it the Perl DBI module) will run rollback() with an error message:
Issuing rollback() for database
Hi,
is better to create insert query for better performance this way:
INSERT INTO table VALUES(val1, val2, val3), (val4, val5, val6), (...);
or in this way:
for (i = 0; i 3000; i++) {
INSERT INTO table VALUES(val[i][1], val[i][2], val[i][2]);
}
Michal Dvoracek
Try something like
SELECT fid, Family_Last_Name, Phone, playertable.Family_ID
FROM familytable
LEFT OUTER JOIN playertable ON playertable.Family_ID = familytable.fid
AND playertable.SportRegistered = 'O'
GROUP BY fid
ORDER BY Family_Last_Name ASC;
The rows from
First off, I wouldn't really want to call Access a database, as its little
more than just a file with 1/2 of a program trying to access it. And second,
I would say that MS SQL is both over-priced, and way too bloated, buggy,
slow, etc, etc. (but then again, everyone has their own opinion on
Well, that all depends on what language your apps are written in. VB?
Delphi? C? PHP? Perl? and what database architecture are you using within
the language (ie, in VB are you using ADO, or ODBC, or DAO, etc)...
Also, for a good comparison of databases, look at this:
Arnor Sigfusson [EMAIL PROTECTED] writes:
Hi
I was trying MySQL on a RedHat 7.0 for the first time using
MySQLGUI. But when I try to connect I get:
Have you applied all updates, and can you connect through the mysql
CLI client?
--
Trond Eivind Glomsrød
Red Hat, Inc.
Hi all,
When I perform a delete command and then I insert a new row, this new
row is placed in the row just deleted. Is it possible to place newly
inserted rows always at the end of the table???
Martin
-
Before posting,
Batara Kesuma [EMAIL PROTECTED] writes:
Hello,
I think it might not be a right mailing list for this question, but I
don't know where else should I post it.
If I run Perl DBI's $dbh-connect() without $dbh-disconnect(), MySQL (or
is it the Perl DBI module) will run rollback() with an
On 22 Jun 2001 [EMAIL PROTECTED] wrote:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
database,sql,query,table
If you just reply to this message, and
Hi,
Is there a way to retrieve the field values in the
same order as during insertions based on something
like rowid or so??
Eg:
Insertion order into a table for a text field:
bbb
abaa
aa
Retrieval order:
I want to have the retrieval order also the same.The
output of the query on
KEY is used to build other indexes. It's not short for Primary Key. There
are PRIMARY KEY indexes, candidate key indexes (these COULD be a primary key
but for one reason or another , are not) and just regular indexes.
All tables should have a primary key. (I'm partial to adding an
It is my understanding that the first syntax is faster in mysql.
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
- Original Message -
From: Dvoøáèek Michal [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 22, 2001 11:48 AM
Subject: insert
Hi,
is
I think you must start the mySQL server to connect
- Original Message -
From: Trond Eivind Glomsrød [EMAIL PROTECTED]
To: Arnor Sigfusson [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, June 22, 2001 5:07 PM
Subject: Re: Problem starting mysqlGui
Arnor Sigfusson [EMAIL
On Friday 22 June 2001 09:22, [EMAIL PROTECTED] wrote:
MySQL has is used by alot of major players and there are pre made setup for
building database driven websites like PHP-Nuke. Unsure on the strings
I use Win2K and Mysql PHP and PHP Nuke with Apache for my site and it's
working great! My
It only corrupted your database twice?
On Friday 22 June 2001 09:50, Patrick Calkins wrote:
MySQL can handle infinately more concurent connections to it, and handle a
much bigger load than MDB can even dream of doing. A few years back I used
to write database apps in visual basic and MDB. It
Dear sir;
I have find a big error from MySQL. I have one fields like that;
co_na(Fields) = Johsua's Brother;
mybtd is the data name, co_na is the fields;
I cannot insert the data by using the php commands;
mysql_query(INSERT into mybtd(co_pe) values('Johsua's
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
and how you fix it?
It means you have no local socket for mysql to connect through. Meaning,
something/someone either deleted or mangled /tmp/mysql.sock or mysqld
isn't running to begin with.
Try to
Sorry for the delayed reply.. the list marked my reply as spam ! ;)
-- Forwarded message --
Date: Fri, 22 Jun 2001 02:48:14 -0700 (PDT)
From: Seth Northrop [EMAIL PROTECTED]
To: Wouter de Jong [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: RAID advice :
Let's say your
Auto_increment is one of the options
--Ravi
--- Martin Quevedo [EMAIL PROTECTED] wrote: Hi
all,
When I perform a delete command and then I insert a
new row, this new
row is placed in the row just deleted. Is it
possible to place newly
inserted rows always at the end of the table???
At 12:17 PM -0400 6/22/01, Trond Eivind Glomsrød wrote:
Batara Kesuma [EMAIL PROTECTED] writes:
Hello,
I think it might not be a right mailing list for this question, but I
don't know where else should I post it.
If I run Perl DBI's $dbh-connect() without $dbh-disconnect(), MySQL (or
On Fri, 22 Jun 2001 11:28:19 -0500, Cal Evans [EMAIL PROTECTED] wrote:
If your using Perl w/DBI, you may want to check out the use of place holders and
bind_columns. Create your create your insert statement outside the loop, then do
the execute() within the loop using placeholders or
On 22-Jun-01 Carsten H. Pedersen wrote:
Has anyone successfully passed the get_lock()
and release_lock() commands to a MySQL
server using PHP? If so, how did you go about it?
Yes;
mysql_query(SELECT GET_LOCK('signups',20));
fillsignups();
mailsignups();
mysql_query( SELECT
The manual also states that INDEX is a synonym for KEY, which means that
they have identical funcationality.
Daniel Åkerud
- Original Message -
From: Cal Evans [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; Marco Bleeker [EMAIL PROTECTED]
Sent: Friday, June 22, 2001 6:27 PM
Subject: Re: KEY
You need to escape your strings.
INSERT into mybtd(co_pe) values('Johsua\'s Brother'); cannot run...
[EMAIL PROTECTED] wrote:
Dear sir;
I have find a big error from MySQL. I have one fields like that;
co_na(Fields) = Johsua's Brother;
mybtd is the data name, co_na is
On 22-Jun-01 Jean-Philippe Cote wrote:
Hello,
Suppose I want to update n rows (where n is a possibly large number)
using the mySQL C API. I can create n separate UPDATE
statements and send each of them to the server with mysql_[real_]query(),
but that doesn't seem particularly
Try
mysql_query(INSERT into mybtd(co_pe) values('Johsua''s Brother'));
or
mysql_query(INSERT into mybtd(co_pe) values('Johsua\\'s Brother'));
Daniel Åkerud
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 22, 2001 7:15 PM
Subject: Error for the '
On 22-Jun-01 Colm McCartan wrote:
Hello all,
apologies if this has been posted before but I can't find it in the FAQ,
docs or
anywhere...
Subject says it all: before closing down for a backup or whatever, how do I
find
out who is logged into the server (as opposed to just getting
Sounds like you could be a reference site for Microsoft!! Only 2 corruptions
using Access multi-user. That's incredibly good. I've supported systems with
only 3 concurrent users who suffered corruption on a nearly daily basis.
- Original Message -
From: John Meyer [EMAIL PROTECTED]
To:
On 22-Jun-01 VVM Ravikumar Sarma Chengalvala wrote:
Hi,
Is there a way to retrieve the field values in the
same order as during insertions based on something
like rowid or so??
Eg:
Insertion order into a table for a text field:
bbb
abaa
aa
Retrieval order:
I want to
Hi all. I recently downloaded the source distribution of MySQL version 3.23.39
and am trying to compile it so that it installs it's files in the same manner
as the binary RPM version does. Does anyone have an idea what the prefix
directory and datadir directories are supposed to be set to? I'm
On 22-Jun-01 Martin Quevedo wrote:
Hi all,
When I perform a delete command and then I insert a new row, this new
row is placed in the row just deleted. Is it possible to place newly
inserted rows always at the end of the table???
There is no 'end' (or 'begin' for that matter) to a
How do you force mysql to use either TCP/IP Sockets or UNIX Sockets?
And how do you know which one it uses?
It is for a performance analysis.
Thanks!
Daniel Åkerud
Anyone has any experience with mySQL in combination with data replication? Are there
products available out there that allows this?
Thanks
Daniel Åkerud
Hi.
In a relational database you may _not_ rely on internal order. It is
completely up to the RDBMS how it handles insertions. The internal
order is undefined by definition according to the SQL standard.
Therefore you should have no interest at all on where insert go to.
Use SELECT ... ORDER BY
William Clifford [EMAIL PROTECTED] writes:
Hi all. I recently downloaded the source distribution of MySQL version 3.23.39
and am trying to compile it so that it installs it's files in the same manner
as the binary RPM version does.
Just download the lastest SRPM from rawhide, and rebuild it.
Hi.
On Fri, Jun 22, 2001 at 05:31:32PM +0100, [EMAIL PROTECTED] wrote:
Hi,
Is there a way to retrieve the field values in the
same order as during insertions based on something
like rowid or so??
No. Insertion order is not kept anywhere. Use an AUTO_INCREMENT column
to obtain an key to
At 9:04 PM +0200 6/22/01, Daniel Åkerud wrote:
How do you force mysql to use either TCP/IP Sockets or UNIX Sockets?
And how do you know which one it uses?
It is for a performance analysis.
Thanks!
Daniel Åkerud
If you connect to localhost, MySQL will use a UNIX socket if possible.
If you
I am using two versions of MySQL, on two different platforms, and having the
same problem on both. One very odd aspect of this problem is that it behaves
precisely the same way on both platforms, down to which records are garbled
onscreen and how they are garbled. Anyone with any ideas?
Hi.
On Fri, Jun 22, 2001 at 09:04:14PM +0200, [EMAIL PROTECTED] wrote:
How do you force mysql to use either TCP/IP Sockets or UNIX Sockets?
And how do you know which one it uses?
localhost uses UNIX sockets, hostname uses TCP/IP sockets.
You can indirectly determine what connection was used
Occasionally, MySQL seems to lock up on the Linux box and just sit there. It
did it today for three hours before we realized it. When this happens, the
only thing we know of to do is restart it, and this time it wouldn't shut
down so we had to reboot the Linux box. Does anyone have any idea what
What sort of support for transactions and table/record locking is there in MySQL right
now? I had heard that only table locking was supported, and limited support for
transactions.
Aaron
-
Before posting, please check:
At 1:39 PM -0800 6/22/01, Joshua J. Kugler wrote:
I have read the manual about GRANT/REVOKE syntax. I have set up several
queries that worked to grant privileges, but then I sent this query to the
MySQL server:
REVOKE ALL PRIVILEGES ON *.* FROM 'testuser'@'xxx.xxx.xxx.xxx'
testruser is a user
1 - 100 of 110 matches
Mail list logo
