Steve,
Steve Davies sagte:
Sinisa Milivojevic wrote:
On Mon, 08 Sep 2003 19:57:25 +0100
Steve Davies [EMAIL PROTECTED] wrote:
Hi All
I'm currently trying to learn C so that I can recode some php/mysql apps
I've got but I've run into probs right at the start.
I'm trying to compile the
Hi;
Can anyone tell me whether there is a version of mysql that will run on a
handheld PDA, and if so what are the hardware/software specifications?
Fraser
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have this query which looks something like,
(
SELECT count(*) AS tCount, amount, block
FROM table_a
GROUP BY amount, block
)
UNION
(
SELECT count(*) AS tCount, amount, block
FROM table_b
GROUP BY amount, block
)
ORDER BY amount;
tCountamountblock
3400A--
Maria,
Maria Garcia Suarez sagte:
Hi there!
I'm currently developing a web where we let users
create their own forums. All the messages (wherever
they are posted) are stored in the same mysql table.
When users read a certain message I would like to
display the previous and next message in
Daevid Vincent [EMAIL PROTECTED] wrote:
Thanks Victoria for the pointer. I should have looked there first. Duh!
Now for the help... I tried:
ALTER TABLE rep_table ADD FOREIGN KEY (`rep_company_code`) REFERENCES
`company_table` (`company_code`) ON UPDATE CASCADE;
But get ERROR 1216:
I'm rather new to OS X after not using a Mac since grade school. I have a bit of UNIX
experience so its not too complicated but having never administered to either I've
been
having some difficulty setting mySQL up after the auto-install. I'm interning for a
company and the computer I'm using
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 10 Sep 2003, Jason Frisvold wrote:
Aha... I think I figured it out...
I have the MySQL-4.0.15-0.src.rpm in the same directory... I'll bet
that an rpm -Fvh automatically installs the source.. The source is
owned by mysqldev, isn't
Sebastian Haag wrote:
Steve,
Steve Davies sagte:
Sinisa Milivojevic wrote:
On Mon, 08 Sep 2003 19:57:25 +0100
Steve Davies [EMAIL PROTECTED] wrote:
Hi All
I'm currently trying to learn C so that I can recode some php/mysql apps
I've got but I've run into probs right at the
I'm rather new to OS X after not using a Mac since grade school. I have a bit of UNIX
experience so its not too complicated but having never administered to either I've
been
having some difficulty setting mySQL up after the auto-install. I'm interning for a
company and the computer I'm
Hello!
My Mysql version is 3.23.56.
I want to use specific index, but when I use use
index EXPLAIN gives me that key not used. And when
I'don use use index mysql uses other index.
Where I test this in 4.0.14 with force index it works
and the query time is 4x faster with index I choose,
then the
Hello!
My Mysql version is 3.23.56.
I want to use specific index, but when I use use
index EXPLAIN gives me that key not used. And when
I'don use use index mysql uses other index.
Where I test this in 4.0.14 with force index it works
and the query time is 4x faster with index I choose,
then the
Hello!
My Mysql version is 3.23.56.
I want to use specific index, but when I use use
index EXPLAIN gives me that key not used. And when
I'don use use index mysql uses other index.
Where I test this in 4.0.14 with force index it works
and the query time is 4x faster with index I choose,
then the
I need help understanding how Mysql processes the simbol (ampersand) in
full text search; I've a text field in a table with this data:
kw
kwz
kwzw
att
Of course I've instructed mysql to index words of 2 chars or greater; here's
my findings:
- MATCH (mycolumn) AGAINST ( 'kw' IN BOOLEAN MODE )
Dear all,
what is the meaning of
Can't open file: 'products_description.MYI'. (errno: 145)
in mysql?
Regards,
_DT
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi!
On Sep 11, Andrea Gangini wrote:
I need help understanding how Mysql processes the simbol (ampersand) in
full text search; I've a text field in a table with this data:
kw
kwz
kwzw
att
Of course I've instructed mysql to index words of 2 chars or greater; here's
my findings:
-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Thu, 11 Sep 2003, Andy Callan wrote:
I can log in as 'root' if need be. After the install I
get errors like:
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through
Deependra b. Tandukar [EMAIL PROTECTED] wrote:
what is the meaning of
Can't open file: 'products_description.MYI'. (errno: 145)
in mysql?
$ perror 145
Error code 145: Unknown error 145
145 = Table was marked as crashed and should be repaired
You should repair table with REPAIR TABLE
Deependra b. Tandukar wrote:
Dear all,
what is the meaning of
Can't open file: 'products_description.MYI'. (errno: 145)
in mysql?
Regards,
_DT
$ perror 145
145 = Table was marked as crashed and should be repaired
Hope this helps
--
Joseph Bueno
--
MySQL General Mailing List
For list
Hi There,
errno 145 means:
'Table was marked as crashed and should be repaired'
You can Type on the commandline (dosbox, bash, etc-): perror ErrorNumber
to get information about errors.
prosit
Klaus
P.S.:REPAIR TABLE (manual chapter 4.4.5) might help.
--
MySQL General Mailing
Hi,
I've found the phrase in MySQL documentation
http://www.mysql.com/doc/en/Temporary_table_problems.html
You can't use temporary tables more than once in the same query. For
example, the following doesn't work.
mysql SELECT * FROM temporary_table, temporary_table AS t2;
Does it mean that I
Are there packages for java to include a standalone mysql database? Or are there plans
for such?
Luc
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I couldn't find an appropriate mailing list for compiling MySQL, so I
thought I'd try here.
anyone successfully compile MySQL 4 on RedHat 9? I keep getting errors on
libmysql.c during the make step. Google doesn't reveal a whole lot about
compiling MySQL on RedHat which leaves me to believe
Are BLOB column types the only columns that will let you write a NULL
(Hexidecimal 0) and still write beyond that?
CHAR, CHAR BINARY, VARCHAR, and VARCHAR BINARY all seem to truncate the
string and stop at the first null even if I escape the string being
updated.
I don't want to use a BLOB
http://www.mysql.com/doc/en/Adding_users.html
First, use the mysql program to connect to the server as the MySQL root
user:
shell mysql --user=root mysql
Then you can add new users by issuing GRANT statements:
mysql GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED]
- IDENTIFIED BY
On 11 Sep 2003 at 11:04, Andrew Kuebler wrote:
Are BLOB column types the only columns that will let you write a NULL
(Hexidecimal 0) and still write beyond that? CHAR, CHAR BINARY,
VARCHAR, and VARCHAR BINARY all seem to truncate the string and stop
at the first null even if I escape the
Dear Miguel:
Firstly I found the path for mysqld, in my system (Linux RH7.3), it is in
/usr/libexec/
Then I write this command:
/usr/libexec/mysqld --log=/var/mysqldquery.log -u root
however the system give me this message:
bash: mysqld: command not found
I don`t understand what is happen.
Dear Mohamed:
I tried with your suggestion but when I like to see the /var/
mysql_query.log file my system says that this file doesn`t exist.
What can I do?
Thank you,
Edwin Limachi N.
DATACOM - Instalaciones La Paz
Tel.: 591-2-212-3978
Cel.: 591-715-29967
Fax.: 591-2-212-3975
Mohamed
Dear Friends,
After days of struggling with the 2013 error which no one seems to know how
to fix. I decided to install a 3.xx version of mysql, and then a new 4.0.15
version as well from binary this time. (even tried the RPM and src versions)
Installation is easy
Mysql Server is up
I then try
I've looked and looked but really can't find an answer to this question.
In my my.cnf file, these are some of the things that are specified in
[mysqld]:
set-variable = key_buffer=256M
set-variable = table_cache=64
set-variable = sort_buffer=512K
set-variable = max_connections=1000
set-variable =
bad happened, human or machine wise.. :)
and then when you have this running, you probably should run the mysqldump
program from the command line, and use the
mysqldump --opt --flush-logs --all-databases 20030911.mysqldump.sql
and that should give you a good backup from right now
Nicola Hartland wrote:
I am not sure this is the right place for this question but I am trying to find a personal server that I can install on my PC, I run XP that I can have to test the web pages. Does anyone have any suggestions and how to configure them.
thanks in advance
Nicci
Hi, I´m trying to join two tables with the follow statement
SELECT t1.name,t2.name FROM table1 t1,table2 t2 WHERE
t1.namet2.name.
I supose the expected result must be the non-matching rows of both
tables, but it´s not what I get. ¿What it´s wrong with that query?. I
hope do you understand my
At 9:29 AM -0700 9/11/03, Mark Kaufer wrote:
I've looked and looked but really can't find an answer to this question.
In my my.cnf file, these are some of the things that are specified in
[mysqld]:
set-variable = key_buffer=256M
set-variable = table_cache=64
set-variable = sort_buffer=512K
On Thu, Sep 11, 2003 at 09:29:27AM -0700, Mark Kaufer wrote:
I've looked and looked but really can't find an answer to this question.
In my my.cnf file, these are some of the things that are specified in
[mysqld]:
set-variable = key_buffer=256M
set-variable = table_cache=64
set-variable =
Abs wrote:
hi
i know this has been discussed before, storing bools
in the right column type. in the case of enum as:
enum(N,Y) or n,y, etc. it might be easy to
read when u're looking at the database table itself,
but if u had to communicate this properly to other
programmers designing a front-end,
I then try to connect to the server from a remote location and get
ERROR 1130: Host 'xxx.yyy.zzz' is not t allowed to connect to
this MySQL server
which is normal since i did not create a user yet
I do this:
GRANT ALL PRIVILEGES ON *.* TO stew@'%' IDENTIFIED BY '123' WITH
GRANT OPTION;
On Thu, Sep 11, 2003 at 12:06:23PM -0500, Paul DuBois wrote:
Linux reports the threads of a process as processes. You really only
have one process, with 31 threads. (Probably because a bunch of clients
have connected.) So your resources are shared among the threads of
the server process.
At 10:17 AM -0700 9/11/03, Jeremy Zawodny wrote:
On Thu, Sep 11, 2003 at 12:06:23PM -0500, Paul DuBois wrote:
Linux reports the threads of a process as processes. You really only
have one process, with 31 threads. (Probably because a bunch of clients
have connected.) So your resources are
xander xxx wrote:
Hi, I´m trying to join two tables with the follow statement
SELECT t1.name,t2.name FROM table1 t1,table2 t2 WHERE
t1.namet2.name.
I supose the expected result must be the non-matching rows of both
tables, but it´s not what I get. ¿What it´s wrong with that query?. I
hope do
I have two tables which are exactly the same but have different set of data on them. I
wrote a query and used EXPLAIN to see how it would run on each table.
It turn out that the same query will use index on one table but not the other. So I
delete all data on the bad table (the one that won't
I really appreciate your help with this.
Hmmm... So, while SET FOREIGN_KEY_CHECKS allowed me to ALTER the table, now
I can't UPDATE the company that has a rep with the same company_code
because:
Error :: 1217 :: Cannot delete a parent row: a foreign key constraint fails
UPDATE company_table SET
I don't think so. Based on what I've read, MySQL always assumes and
equal distribution of data for an index. Based on this assumption it
may determine that it's just not worth it to use the index, like if
your search will return most of the records. You should periodically
optimize your
By the way, Jeremy's original answer was more correct than mine, because
he noted where I did not that the sort buffer is a per-client resource
and is allocated once for each client -- or at least for each client that
issues queries requiringn sorting, such as those with ORDER BY clauses.
Thanks for your answer, this is what I ended up putting in my
/etc/hosts.allow file, just to remove any doubt
ALL : ALL : allow
auth : ALL : allow
mysqld: ALL : allow
At 10:17 AM 9/11/2003 -0700, Jennifer Goodie wrote:
Assuming mysql server is running on a unix box, does the connecting client
I try to compile MySQL/InnoDB 4.1.1 ( loaded from BK )
My Configure Line is:
export CFLAGS=-O6 -mpentiumpro
export CXX=gcc
export CXXFLAGS=-O6 -mpentiumpro -felide-constructors -fno-exceptions -fno-rtti
./configure --with-innodb --without-isam --without-docs --without-bench
ok...
I think this'll work...
select unique t1.*
from table1 as t1
left outer join table2 as t2 on t2.name = t1.name
where t2.name is null
-Original Message-
From: xander xxx [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 11, 2003 2:56 AM
To: Dan Greene
Subject: Re: RE:
Dear Listmembers,
I have two tables, one is an updated version of the other. How can I find
only the new items on the newer table?
Table newtest
mom flowers
dad tools
dave video
matt magazine
Table newtest2
mom flowers
dad tools
dave video
matt magazine
gram book
erin flower
Query:
SELECT
Hi,
I'm trying to do a simple UNION in MySQL (4.0.11a on Linux). I am trying the
following ...
If I do
SELECT THIS.PRODUCT_ID,net.ajsoft.WebShop.Inventory.Product AS
JPOXMETADATA,THIS.ID FROM PRODUCT THIS LEFT OUTER JOIN BOOK SUBCLASS0 ON
THIS.PRODUCT_ID = SUBCLASS0.BOOK_ID WHERE
I have a bit of an issue with mysqldumps and inserting it back into
mysql.
Granted, I have 1 table that has over 1Million entries, but generating
these tables takes about 3 hours with a java app.
But when I do a mysql -u root -p the mysql dump.dmp it is taking
about 28 hours to complete the
I think you are right. I try adding and deleting data one by one and found no
particular data that will always turn off index in all circumstances. myisamchk
--analyze doesn't help.
Is there a way to force using index? I don't think optimizer is smart enough. My table
has more than 30,000
Daevid,
there is really one update you need to do first: upgrade to MySQL-4.0.14.
http://www.innodb.com/ibman.html#InnoDB_foreign_keys
Starting from version 3.23.50, you can also associate the ON DELETE CASCADE
or ON DELETE SET NULL clause with the foreign key constraint. Corresponding
ON
Never mind. New MySQL has force index option.
Thanks for your help Brent.
Anan T.
-Original Message-
From: Tongprasith, Anan
Sent: Thursday, September 11, 2003 3:32 PM
To: Brent Baisley
Cc: [EMAIL PROTECTED]
Subject: RE: Query optimizer decision to use index depends on data?
I think
On 11 Sep 2003 at 15:31, Tongprasith, Anan wrote:
I think you are right. I try adding and deleting data one by one and
found no particular data that will always turn off index in all
circumstances. myisamchk --analyze doesn't help. Is there a way to
force using index?
Yes, 'USE INDEX
Mikhail Entaltsev [EMAIL PROTECTED] wrote:
Hi,
I've found the phrase in MySQL documentation
http://www.mysql.com/doc/en/Temporary_table_problems.html
You can't use temporary tables more than once in the same query. For
example, the following doesn't work.
mysql SELECT * FROM
Dear Kelley:
We tryed with your suggestion, thank you very much. We can see the
mysqlupdate and 20030911.mysqldump files. However when we connect an do
some queries to our Mysql server, we can not see anything, the columns
Time, Id Command and Argument are in blank.
Is there something
Hi again,
Does any of you have an idea on this? I get the same error in 4.0.15. I
could find that the problematic code was in mysql-test/mysql-test-run.sh:
sleep_until_file_created $MASTER_MYPID $wait_for_master
wait_for_master=$SLEEP_TIME_FOR_SECOND_MASTER
MASTER_RUNNING=1
I guess I could
Hi Dan,
- Original Message -
From: dan orlic [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, September 11, 2003 2:30 PM
Subject: mysql dump speed
I have a bit of an issue with mysqldumps and inserting it back into
mysql.
Granted, I have 1 table that has over 1Million
Have tried using the --opt parameter on mysqldump? This is supposed
optimize the dump speed and create a file optimized for reloading. I
haven't played with this option, so I don't know what kind of
difference it makes.
On Thursday, September 11, 2003, at 03:30 PM, dan orlic wrote:
I have a
From what I understand about InnoDB, you want to make that InnoDB buffer
pool as big as 60-80% of your allowable RAM. If you use only InnoDB,
then the other settings won't help you to give much ram. If you use no
InnoDB, then don't bother giving InnoDB buffer pool any real ram.
If it works
Use the --opt option when performing the dump. It can make a tremendous
difference.
-JF
-Original Message-
From: dan orlic [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 11, 2003 12:31 PM
To: [EMAIL PROTECTED]
Subject: mysql dump speed
I have a bit of an issue with
our current situation is a mysqld crash, it hits an assertion
in my_seek.c.
Assertion failed: pos != (~(my_off_t) 0), file
c:\build\build\mysql-4.0.14\mysys\my_seek.c, line 31
This is with a myisam table containing variable length text fields.
I'm not expecting any solution from this list,
On Thu, Sep 11, 2003 at 11:30:20AM -0700, Mark Kaufer wrote:
By the way, Jeremy's original answer was more correct than mine, because
he noted where I did not that the sort buffer is a per-client resource
and is allocated once for each client -- or at least for each client that
issues
always just worked like a charm
for me.
Kelley
[EMAIL PROTECTED] wrote:
Dear Kelley:
We tryed with your suggestion, thank you very much. We can see the
mysqlupdate and 20030911.mysqldump files. However when we connect an
do some queries to our Mysql server, we can not see anything
On Thu, Sep 11, 2003 at 02:30:59PM +1000, Daniel Rossi wrote:
when is it a good time to do the set auto commit=0 , while doing the
update or insert query or sometime before that in the application ?
Whenever you need explicit transactions.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux
On Thu, Sep 11, 2003 at 04:10:21PM -0400, Pierre-Luc Soucy wrote:
Hi again,
Does any of you have an idea on this? I get the same error in 4.0.15. I
could find that the problematic code was in mysql-test/mysql-test-run.sh:
sleep_until_file_created $MASTER_MYPID $wait_for_master
Ok, here's another question. Given effective external locking by the OS, could
MyISAM tables achieve this? If so, do you know any operating systems that would
have reliable external locking?
Mike
Quoting Jeremy Zawodny [EMAIL PROTECTED]:
On Wed, Sep 10, 2003 at 06:00:55PM -0600, Mike Hillyer
On Thu, Sep 11, 2003 at 10:08:18AM -0400, Luc Foisy wrote:
Are there packages for java to include a standalone mysql database?
No.
Or are there plans for such?
Last time I saw Mark discuss it, no. There was significant overhead
in coming up with a Java-to-embeeded-MySQL bridge. Check the
I noticed this deadlock in show innodb status on a mysql 4.0.14 box
today. Both transactions seem to be trying to execute the a query on
the same record, which I don't think should cause a deadlock. What am I
missing?
030911 10:12:45
*** (1) TRANSACTION:
TRANSACTION 0 153127600, ACTIVE 53 sec,
I'd like to be able to look at show innodb status, notice that a query
is waiting on a lock to be released, and then determine which tx is
holding that lock.
I know you can use the innodb_lock_monitor table, but this would make
things a lot faster especially when there are a lot of active
On Thu, Sep 11, 2003 at 03:41:21PM -0700, [EMAIL PROTECTED] wrote:
Ok, here's another question. Given effective external locking by the OS, could
MyISAM tables achieve this?
Yes.
If so, do you know any operating systems that would have reliable
external locking?
I'm not sure what the
Hi Sergei!
Thanks for your reply and taking time to read and consider my
suggestions. :-) I didn't reply sooner because I was deciding what to
say in this message. ;-)
I joined the list specifically for posting these suggestions, and, with
your reply, I wanted to say that it's great to have
On Thu, Sep 11, 2003 at 10:22:13AM -0400, Peter Koutsoulias wrote:
I couldn't find an appropriate mailing list for compiling MySQL, so I
thought I'd try here.
anyone successfully compile MySQL 4 on RedHat 9? I keep getting errors on
libmysql.c during the make step. Google doesn't reveal a
On Thu, Aug 28, 2003 at 04:20:50PM -0400, Nick Gaugler wrote:
Ken,
Thanks for the response. I really wish MySQL AB would compile FreeBSD
binaries with LinuxThreads. It's really a pain when you find a bug, the
first thing they ask is have you compiled this yourself when in this
case you
Joe,
what does SHOW CREATE TABLE give as the table definition?
What do
EXPLAIN SELECT ... where user_id = 190864 and is_deleted = 0;
and
EXPLAIN SELECT ... where user_id = 190864;
say? If user_id is not the full primary key, then an index scan will happen
and deadlocks of the type below are
I have a fresh install of mysql 4.0.11 on a linux box. When I try to
open mysql as a [EMAIL PROTECTED], I get the following error:
mysql -u [EMAIL PROTECTED] -p db_name
Enter password:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]@localhost' (Using
password: YES)
However
user_id is the primary key..
relevant parts of show create table:
| plx_user |CREATE TABLE `plx_user` (
`user_id` int(11) NOT NULL auto_increment,
`is_deleted` int(11) NOT NULL default '0',
`edit_counter` int(11) NOT NULL default '0',
`sendlist_edit_counter` int(11) NOT NULL default '0',
i'm about to do this tonight as i'm setting up a desktop system to do my
local development on, all i can say is redhat and gnome is slow as hell !,
i only have 160 meg ram on the machine and after loading a few apps it only
has 4 meg ram left ! plus the apt package manager for redhat is slow as
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jeremy Zawodny wrote:
On Thu, Sep 11, 2003 at 10:08:18AM -0400, Luc Foisy wrote:
Are there packages for java to include a standalone mysql database?
No.
Or are there plans for such?
Last time I saw Mark discuss it, no. There was
Joe,
I think I see why this can happen. Even though the search condition is
unique, the search may end up on the B-tree leaf node which immediately
precedes the right node. That is why Transaction 1 is waiting for a lock on
a 'supremum' record. It is the supremum of the previous leaf.
Hmm... I
At this point it is pure academic curiousity. I am putting together a cheap
cluster to play with shared drive failover, and thought I would see what
happens when I point two MySQL machines at the same drive while I'm at it.
Mike
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL
Heikki, I took your advice and installed the RPM updates to no avail:
[root]# rpm -qa | grep mysql -i
MySQL-server-4.0.15-0
mod_auth_mysql-1.11-1
MySQL-devel-4.0.15-0
MySQL-shared-4.0.15-0
php-mysql-4.1.2-7.2.6
MySQL-client-4.0.15-0
MySQL-shared-compat-4.0.15-0
And it seems to be running...
On Thu, Sep 11, 2003 at 04:27:10PM -0400, Brent Baisley wrote:
Have tried using the --opt parameter on mysqldump? This is supposed
optimize the dump speed and create a file optimized for reloading. I
haven't played with this option, so I don't know what kind of
difference it makes.
It
At 10:22 AM -0400 9/11/03, Peter Koutsoulias wrote:
I couldn't find an appropriate mailing list for compiling MySQL, so I
thought I'd try here.
anyone successfully compile MySQL 4 on RedHat 9? I keep getting errors on
libmysql.c during the make step. Google doesn't reveal a whole lot about
Good news for OS X users. CocoaMySQL has just been updated and it now
supports CSV imports among other improvements. It's freeware too.
http://www.MacUpdate.com/info.php/id/10573
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
is there such a gui tool for linux ? i like sqlyog alot so anything similar
would be excellent.
Good news for OS X users. CocoaMySQL has just been updated and it now
supports CSV imports among other improvements. It's freeware too.
http://www.MacUpdate.com/info.php/id/10573
--
MySQL
OK, here are the last few lines from make. I configured using the
following:
./configure --prefix=/usr/local/mysql --with-mysqld-user=mysql
errors:
libmysql.c: In function `mysql_real_connect':
libmysql.c:1790: warning: passing arg 5 of `gethostbyname_r' from
incompatible pointer type
OK, here are the last few lines from make. I configured using the
following:
./configure --prefix=/usr/local/mysql --with-mysqld-user=mysql
errors:
libmysql.c: In function `mysql_real_connect':
libmysql.c:1790: warning: passing arg 5 of `gethostbyname_r' from
incompatible pointer type
hi i was wondering if there is a way to check for a table type ?
ie i have an authentication class, in some situations it uses innodb and sometimes its
myisam and currently its not autocomitting
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
hi there i keep getting an error on a table
Lock wait timeout exceeded; Try restarting transaction
i intitally had made the update query but it wasnt committed, as it was using a myisam
query function i have gone back to it with and innodb query function which starts a
transaction , i have
SQL guru's,
I could use some help writing a bit of SQL.
There's 3 tables:
orderable_parts
partID varchar,
topCatID int, # top level category ID
...
part_attributes
partID varchar,
attName varchar,
attValue varchar,
...
topcatattributevalues
tcavID int,
topCatID int,
attName varchar,
attValue
hi there, i am trying to use transactions on some innodb tables although a few things
i am experiencing, on one query the value appears, i refresh the page and the value
dissapears again, i am using persistant connections in php, the value is actually
there in the console, what could be the
I have Mac OS X 10.2.6 with December 2002 Dev Tools and the Dec 2002 gcc
updater, which means I'm using gcc 3.3. Following the directions in
INSTALL-SOURCE, I ran configure with:
CC=gcc \
CFLAGS=-O3 -fno-omit-frame-pointer \
CXX=gcc \
CXXFLAGS=-O3 -fno-omit-frame-pointer -felide-constructors
92 matches
Mail list logo