When I try to do anything with MySQL, I always see
"Ignoring query to other database" on my screen. When I type "status", the
computer prints:
"All updates ignored to this database".
after "Current user".
Could anybody help me ? Does anybody know how can I unblock MySQL ?
robertix
Hello,
I have a compiling problem. I have the following system conditions:
solaris 2.7
gcc 3.0.1
mysql 3.23.46
gnu ld
The compiling process aborted after this step
gcc -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions
-fno-rtti -DHAVE_CURSES_H -I/opt/mysql-3.23.46/include
-DHAVE_RWLOCK_T
Hi!
I do not understand how replacing just the executable mysqld can make your
'mysql start' (or is it 'mysql.server start'?) script or safe_mysqld script
to search the executable from a different directory than it did before. Are
you sure you did not change anything else in the system?
Anyway,
Sure, open up a new MySQL session, and use "SHOW PROCESSLIST;" to monitor
the query status. It should report what it's doing and how long the
process has been running.
Chris Schreiber
-Original Message-
From: Karl Stubsjoen [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 10, 2001 8:38
Still need help with this one
Anyone, anyone?
-Original Message-
From: Gill, Vern [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 08, 2001 6:32 PM
To: '[EMAIL PROTECTED]'
Subject: RE: compile errors
Still not compiling. New issue now...
# rpm -q gcc
gcc-3.1-0.10
./configure -
I've had the same experience myself. I had a client running a large MySQL
database with 500+ concurrent users on a Sun E420R quad processor machine
with 2GB RAM and mirrored SCSI drives. Performance was acceptable, but
there
were some performance problems during peak usage times, that shouldn't
Hello All,
I am running a mysql DB that is a little under 8Gb in size. I have this
same DB running in two separate environments (1 a FreeBSD environment
running on a single Pentium III 900 Mhz CPU w/128 Mb of RAM, and the 2nd one
on a Sun (sparc) solaris 8 ultra enterprise 420R with 4 Gb of RAM
> > >
> > > > On Dec 10, Al Caponi wrote:
> > > > >
> > > > > But I keep getting the following error when I try to delete
> > some row:
> > > > >
> > > > > java.sql.SQLException: General error: Incorrect key file
> for table:
> > > > > 'mytable'. Try to repair it
> > > > >
> > > > > So far, I've f
On Mon, Dec 10, 2001 at 06:36:16PM -0700, Sasha Pachev wrote:
> On Monday 10 December 2001 05:45 pm, you wrote:
> > root@dbacp01d-red:/usr/local/mysql/bin# ./resolve_stack_dump -s /tmp/a
> > -n /tmp/b
> > 0x807b75f handle_segfault__Fi + 383
> > 0x812bcaa pthread_sighandler + 154
> > 0x815059c chun
>Description:
Mysql crashed on this machine, stack trace already submitted via email.
Please see previous email for details.
>How-To-Repeat:
If I knew how to repeat it, I'd make sure that didn't happen. :>
>Fix:
>Submitter-Id: [EMAIL PROTECTED]
>Originator: [EMAIL PRO
Hello,
We're needing to use MySQL-Max because we need the functionality provided by InnoDB.
According to InnoDB's web site, all I have to do is download the tarball and replace
the /usr/sbin/mysqld with the mysqld in the tarball.
I tried that on SuSE and I had to install a few other things and
Hello,
How can I tell if a process is "hanging"? I am performing a large (fairly)
insert from one table to another (insert into... select from) I have been
looking at a non-MySQL prompt for 20 minutes or more (non, meaning: after
you execute a command you are between prompts for awhile u
On Monday 10 December 2001 05:45 pm, you wrote:
> root@dbacp01d-red:/usr/local/mysql/bin# ./resolve_stack_dump -s /tmp/a
> -n /tmp/b
> 0x807b75f handle_segfault__Fi + 383
> 0x812bcaa pthread_sighandler + 154
> 0x815059c chunk_free + 596
> 0x8152573 free + 155
> 0x811579c my_no_flags_free + 16
> 0x
Hi,
> > >
> > > Hi!
> > >
> > > On Dec 10, Al Caponi wrote:
> > > >
> > > > But I keep getting the following error when I try to delete
> some row:
> > > >
> > > > java.sql.SQLException: General error: Incorrect key file for table:
> > > > 'mytable'. Try to repair it
> > > >
> > > > So far, I've
We've just migrated this app from solaris to linux. for several days,
this machine was a tracking slave to this application. last night we
actually switched to make this machine the master for the application.
this was the master and had a connected slave at the time of failure.
the machines ar
Hi,
I have a little problem, and hope that someone can help me with it.
I am trying to copy MySQL data files for a certain database from one Linux
box to the other. Copying works just fine, but then some of the tables
become unusable. Any suggestions?
mike
---
How about filtering on List-ID: mysql.mysql.com
That will work. And keeps the subjects from getting any longer than usual.
j- k-
On Monday 10 December 2001 07:30, Gordan Bobic wrote:
> On Monday 10 Dec 2001 14:08, Etienne Marcotte wrote:
> > PLEASE
> >
> > can everybody use a descripti
Is the date really stored as an integer? You say so, but then you're
trying a wildcard (i.e. char) search. If so, try this (pretending
date_int is your date stored as an integer column in the table
large_table):
Hi!
Table handler error 100 used to mean a deadlock or a lock wait timeout
in InnoDB. Starting from version 3.23.44 these have been replaced by native
MySQL error codes 1213 and 1205.
Regards,
Heikki
http://www.innodb.com
--
Order commercial MySQL/InnoDB support at https://order.mysql.com/
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id: imamferianto
>Originator:root
>Organization: unsoed
>MySQL support: none
>Synopsis: cannot start mysqld
>Severity: critical
>Priority: high
>Category: mysql
>Class: sw-bug
>Release:
I've seen a lot of posts recently of large tables that wrap all over the e-mail,
followed by
apologies for how hard it is to read... the mysql CLI has an option that will display
things
vertically instead of horizontal: end your query with \G instead of a semicolon.
It's a LOT easier to read!
From: MYSQL <[EMAIL PROTECTED]>
> I need to run a querry to return the following: date, email, client from
> table2 where the email address in table2 isn't already in table1.
Try this:
SELECT *
FROM table2
LEFT JOIN table1 ON table1.email = table2.email
WHERE table1.email
Raymond Norton wrote:
> error: failed dependencies:
>
> MySQL conflicts with mysql-3.23.36-1
>
> MySQL-server conflicts with mysql-server-3.23.36-1
Yeah, the MySQL rpms are incompatible with the mysql rpms (which are done
by RedHat). Apparently the two camps each think the other's file sys
I have 2 tables in my mysql database.
table1 is a master list with just one field -- email.
table2 is smaller, and contains three fields -- date, email, client
I need to run a querry to return the following: date, email, client from
table2 where the email address in table2 isn't already in tab
On Mon, Dec 10, 2001 at 03:49:34PM -0600, Dave Burgess wrote:
: You wouldn't happen to be crossing an architecture boundary, would you?
:
: Say from a Macintosh client to a PC server, or a PC client to a Sun Server?
:
: 16777216 Decimal = 100 Hex which would make perfect sense if there was a
At 19:10 10/12/2001 +0100, MOWE (Michael Owens) wrote:
Hi!
>Quick question for someone if they can pass along a little knowledge from
>their experiences:
>
>I am dabbling in MySQL and Apache on a Win2K box and most of it seems to
>work fine. The one thing I can't figure out is that when WinMySQLA
I don't have a Linux box around, so I'll have to check the specific order
you can do it... in the meantime, have you tried
rpm -ivh *.rpm
from that directory?
Kelly
--
Kelly Firkins
[EMAIL PROTECTED]
>This is what I get
>rpm -ivh 3.23.46-1.i386.rpm
>
>error: failed dependencies
This is what I get
rpm -ivh 3.23.46-1.i386.rpm
error: failed dependencies:
MySQL conflicts with mysql-3.23.36-1
MySQL-server conflicts with mysql-server-3.23.36-1
- Original Message -
From: "Kelly Firkins" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 10, 2001 4
From: jeff <[EMAIL PROTECTED]>
> I need to be able to search by partial dates.
> What is the best way to search?
You ~could~ do something harsh like:
SELECT *, substring(myDate, 1, 2) as month
FROM myFunnyTable
WHERE month = '06'
But unless you are only going to need this data
Hello everyone,
I'm getting error 100 from table handler. This is generated by the MySQL ODBC.
Does anyone know what this can be caused by? I'm doing an Update, when it results in
this error. But not every time, it happens randomly.
Regards,
Oganes Demirchyan
Oganes Demirchyan
Motoro
On Sun, 9 Dec 2001 19:32:48 -0800
Hai Nguyen <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am a newbie at this. I am running mysql 3.23.41 on my RedHat 7.2
> linux box. I installed it using rpm.
>
> I can start mysql but everytime I try to create a database, I keep
> getting this error:
>
> mysql
try just upgrading the RPMs using rpm -ivh
--
Kelly Firkins
[EMAIL PROTECTED]
>I need to remove a previous version of mysql and install the newest. When
>trying to remove the previous version it complains about dependencies . I
>don't know what to do about it, so I end up with a
I inherited a large table (50 million records) with the date stored as an
integer in the format (mmddyyy). The dates go back to the 1800's and in the
1990's so the year is either 8xx or 9xx.
I need to be able to search by partial dates. For example, some searches
need to pull every record for the
From: Dan <[EMAIL PROTECTED]>
> I can connect... on the same computer
> ...different machine it won't work.
I suspect that you need to add an entry at the MySQL host for the machine that you are
connecting from. This can be done with a GRANT statement:
- Format:
grant all privileges on
>I need to suuply an exact number of bytes in a database dump. When using VARCHAR(21)
>and only using 18 characters, how do you fill in the rest with forced spaces?
Take a look at the LPAD() and RPAD() functions.
HTH
/Rob
~
Robert Alexander, Alpha Geek
I can connect to mysql with Perl when I have the perl script on the same
computer, but as soon as I move the perl script to a different machine it
won't work. I replaced localhost with the IP address of the machine on which
mysql is on, but that didn't work either.
Does anyone have an example
What permissions do you need to have to issue a show slave status
command?
Thanks,
database,sql,query,table
--
Michael Eklund
System Administrator
Netmechanic, Inc.
[EMAIL PROTECTED]
http://www.netmechanic.com
---
You wouldn't happen to be crossing an architecture boundary, would you?
Say from a Macintosh client to a PC server, or a PC client to a Sun Server?
16777216 Decimal = 100 Hex which would make perfect sense if there was an
'endism' problem.
Philip Molter wrote:
> I have a 3.23.45 database r
I need to remove a previous version of mysql and install the newest. When
trying to remove the previous version it complains about dependencies . I
don't know what to do about it, so I end up with a successful install of the
new version. Any help would be appreciated
rpm -e mysql-3.23.36-1
error:
I have a 3.23.45 database running with InnoDB tables. When I do this:
create table test_default ( testint int not null default 1 );
desc test_default;
I get:
+-+-+--+-+--+---+
| Field | Type| Null | Key | Default | Extra |
+-+---
I'd pipe the process list contents to a file, then look at the file via a
text editor
eg.
\T c:\processes.txt
show processlist;
\t
Kelly
>try using mysqladmin with a grep command, or redirect it's output to a
>file. something like this should do it.
>
>mysqladmin -u user -p processlist | grep
From: Jeff Small (NWCC) <[EMAIL PROTECTED]>
> ...how do you fill in the rest with forced spaces?
char pads, but you may not want to alter your database. Why do you ~have~ to have 21
bytes? Can the device you're pulling this data into be modified to handle things more
intelegently? Another opt
try using mysqladmin with a grep command, or redirect it's output to a
file. something like this should do it.
mysqladmin -u user -p processlist | grep delete > deleteprocess.out
then less the file and you will be able to scroll thru the output.
hope this helps..
--shak
Karl J. Stubsjoen wr
Hello,
I need to kill a thread. I've issued a command which has locked a table
(delete from table where id <= 9) was the command and it is taking a
very very long time.
Now I'd like to kill that thread. However, I can't read the the thread ID
because the ID scrolls out of view in my little
I need to suuply an exact number of bytes in a database dump. When using
VARCHAR(21) and only using 18 characters, how do you fill in the rest
with forced spaces?
-
Before posting, please check:
http://www.mysql.com/manual.
Welcome to the Club!
Connecting to a mySQL database would be the same way in VB6 as MS SQL or
Access, via ODBC. You should download myODBC from mysql.com.
On Microsoft Oses it is easier to develop apps via ODBC because its like
saving you 5-10 lines of code to write. If it's a web applicatio
>I am new to dababases in general and have a few questions. I have been
>building a database in mysql using sql commands in msdos but would like
>to use Visual Basic from here on out to edit the database. After
>completion of the database I need to use it for a program that will also
>be editing t
Dr. Randy Frid writes:
> I recently wrote in that I've tried everything in the book to connect to
> MySQL but I'm still getting the infamous "socket (111) error. I've had a
> few good suggestions and I think we are almost there.
>
> Here's where I am.
>
> With MySQLGUI trying to connect, I chan
From: <[EMAIL PROTECTED]>
> I am new to dababases in general...
Learn SQL (which it sounds like you've done). It's almost always going to be the
standard tool between various database vendors and APIs.
> ...would like to use Visual Basic ...to edit the database.
I won't make any MickySoft vs
Unless I'm off my rocker, the WinMySQLAdmin program is a windows executable
and has nothing to do with Apache. When you're in it, click on the "My.ini
Setup" tab and enter the necessary username/password required to connect to
your MySQL installation and save that configuration. Then WinMySQLAd
Etienne Marcotte wrote:
>
> maybe you can add a small value to be sure it rounds up.
>
> select round(9.065+.001,2);
The rounding in 1 on odd and 0 on even is dealing only 5, to make the
round more accurate or even, as you mentioned. 6-9 always round in 1
while 1-4 always round in 0.
select ro
[EMAIL PROTECTED] wrote:
>
[blabla because there is no sql in my text]
>
> You have written the following:
>
> Good point
>
> well then the best is two smaller than the highest "resolution" you
> have.
>
> if all your data has 4 digits after the . you'll be ok with a epsilon 2
> digits smal
I am new to dababases in general and have a few questions. I have been
building a database in mysql using sql commands in msdos but would like
to use Visual Basic from here on out to edit the database. After
completion of the database I need to use it for a program that will also
be editing the da
maybe you can add a small value to be sure it rounds up.
select round(9.065+.001,2);
Always add 1 at the digit after the one you want to keep:)
so 9.065 can also be a variable...
Etienne
Shankar Unni wrote:
>
> Attila Soki wrote:
>
> > select round(9.065,2)
> > ++
> > | roun
Attila Soki wrote:
> select round(9.065,2)
> ++
> | round(9.065,2) |
> ++
> | 9,06 |
> ++
>
> why not 9,07 ??
Most C compilers today defer things like round() to the floating-point unit
on the CPU. Most CPUs these days implement IEEE75
Quick question for someone if they can pass along a little knowledge from
their experiences:
I am dabbling in MySQL and Apache on a Win2K box and most of it seems to
work fine. The one thing I can't figure out is that when WinMySQLAdmin
launches at startup, I am not able to use the functions of
Had a question on Whether or not MySQL Editor supports Db2 Version 5.0.
Kumud Advani
Sears Canada Inc
Architect Council - Corporate Data WareHouse
Tel : (416) 510 - 6217
-
Before posting, please check:
http://www.mys
The replication server functions perfectly, but the slaves are not updating.
A. Clausen [EMAIL PROTECTED]
- Original Message -
From: "Miguel Angel Solórzano" <[EMAIL PROTECTED]>
To: "A. Clausen" <[EMAIL PROTECTED]>; "MySQL Mailing List"
<[EMAIL PROTECTED]>
Sent: Friday,
My problem was the next:
I'm using Poolman to create a conecction pool in Tomcat 4 to access a
MySql database, the driver that I'm using is org.gjt.mm.mysql.Driver,
JDBC throws this exception:
java.sql.SQLException: Transaction Isolation Levels are not supported.
params: org.gjt.mm.mysql.Driver
I would love to give proper credit to the individual who created this, but
alas, I cannot remember where I stumbled upon it.
When I needed to do some cleaning, I did \T from the mysql app to write to a
file... then ran the script
SELECT CONCAT('DELETE FROM post WHERE threadid = ',
post.t
That "rule" is usually to try and get at the end the most accurate
value, if your numbers are evenly distributed your final value will be
closer to the "good one". So if your values will never have the rounding
digit odd so you'll always be discarting half the smallest digit.. at
the end of multip
Is this MySQL mailing list available via a news group?
Won
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mai
The rounding rule I learnt many years ago said, rounding in 1 if
previous digit is odd but discarding it if even.
so 9.065 -> 9.06, 9.055 -> 9,06, ...
Attila Soki wrote:
>
> hi,
>
> is this bug already in buglist, maybe in newer verisons of mysql is already
> corrected?
> if yes then please le
>From :
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Fun
ctions
ROUND(X)
Returns the argument X, rounded to the nearest integer:
mysql> select ROUND(-1.23);
-> -1
mysql> select ROUND(-1.58);
-> -2
mysql> select ROUND(1.58);
-> 2
Note that the b
hi,
is this bug already in buglist, maybe in newer verisons of mysql is already
corrected?
if yes then please let me know please from what version.
the probmlem:
select round(9.065,2)
++
| round(9.065,2) |
++
| 9,06 |
++
why not 9,07 ?
I recently wrote in that I've tried everything in the book to connect to
MySQL but I'm still getting the infamous "socket (111) error. I've had a
few good suggestions and I think we are almost there.
Here's where I am.
With MySQLGUI trying to connect, I changed the host from "localhost" to
127.
read http://www.mysql.com/doc/S/E/SET.html for the set, how it works
internally...
humm.. is that what you want? :
mysql> CREATE TABLE test(
-> id INT UNSIGNED AUTO_INCREMENT,
-> place SET("Whales","North","South");
-> PRIMARY KEY (id));
Query OK, 0 rows affected (0.00 sec)
[insert
Hey list,
thanks to all those who gave me useful information regarding my
problem with mySQL.
I intend to upgrade my kernel from 2.4.4 to 2.4.12, and then see if
there is any change.
If not then I'll try changing mySQL for the binary version from
the site. I plan to install to /usr/local/mysq
If you are a beginner and are using red hat why don't use the mysql rpms.
It does everything for you.
When you compile php, be sure you have the right path for mysql
(I think that is your error in this case).
Finally, be sure you entered the user right for the connection, with the host
specifi
Hi
Thanks for your reply.
I've got the field "res_places_sl". It's a SET field that consists of the
following options:
'Wales','North','South'
I was using FIND_IN_SET('Wales',res_places_sl); to access all records that
were categorised under 'Wales' which worked great.
Now, I want to be able
I think you are missing something.
>From the Manual:
FIND_IN_SET(str,strlist)
Returns a value 1 to N if the string str is in the list strlist
consisting of N substrings. A string list is a string composed of
substrings separated by `,'
characters. If the first argument is a constant s
I suggest installing FoxServ, which installs a combination of Apache, PHP,
and MySQL. Does it without a hitch. Great for development systems.
- Jonathan
-Original Message-
From: Dan Wolfe [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 07, 2001 6:24 PM
To: [EMAIL PROTECTED]
Subject: MY
Hi
How can I create an index of a SET field so that a FIND_IN_SET can search
for a column number rather than name?
Is this even possible in MySQL? It might seem like a bug?
Thanks.
Wiliam Stephens
Web Developer
http://www.fbagroup.co.uk
-
Gordan Bobic wrote
>I've got an additional idea - how about configuring the mailing list
remailer
>to put something like [MySQL-General] or [MySQL-Internals] in the subject
>line? For some of us who are on multiple lists, it gets really hard to
work
>out what is what without reading the whole l
If you use PHP, you can use my utility dbUtils at
http://php.sitecreative.com - it has functions for synchronizing databases.
- Jonathan
-Original Message-
From: Ananth Rajaraman [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 10, 2001 2:17 AM
To: [EMAIL PROTECTED]
Subject: Database Sy
On Monday 10 Dec 2001 14:08, Etienne Marcotte wrote:
> PLEASE
>
> can everybody use a descriptive subject?
I've got an additional idea - how about configuring the mailing list remailer
to put something like [MySQL-General] or [MySQL-Internals] in the subject
line? For some of us who are on mult
Thanks, I will definitively look for that
But the blocking should be done by the mailing list, making a reply like
the one for omitting mysql or database in the message.
the message could just ask to put a more descriptive subject.
because if every user filters out topics, then the person seeki
Hi!
On Dec 10, Al Caponi wrote:
> Hi Sergei!
> Thanks for the reply! That was fast :)
>
> > -Original Message-
> > From: Sergei Golubchik [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, December 10, 2001 10:48 PM
> > To: Al Caponi
> > Cc: MySQL Mailing List
> > Subject: Re: Limitation of Fu
Hi,
I recently installed 3.23.46 Binary for HP-UX
replacing my 3.xx.42 (basically, replaced the symbolic
link /usr/local/mysql to look at the 3.23.46 untar
directory.
-- Here's a an output:
$/usr/local/mysql#su# bin/mysqladmin -u root -p
version
Enter password:
Server version 3.
> "Arjen" == Arjen G Lentz <[EMAIL PROTECTED]> writes:
Arjen> Hi,
Arjen> - Original Message -
Arjen> From: "AJ" <[EMAIL PROTECTED]>
>> > > Ver 11.15 Distrib 3.23.46, for pc-linux-gnu (i686)
>> > > The problem that has cropped up I have is that in all GROUP BY column
>> > > DESC
>>
Hi
I've got the following SQL statement for a MySQL database:
SELECT * FROM gd_records WHERE FIND_IN_SET('$value',$field)
What I want to know is how do I replace $value with a number of the
position of the SET field? Ugh, I'll try and explain this more clearly.
I've got the following
Hello mysql,
Running Linux 2.4.x SMP/innodb.
This query works OK.
mysql> explain SELECT cp.counter_id, tg.tbl, cs.host
-> FROM counter.table_groups AS tg, counter.counterproperty AS cp, counter.servers
AS cs
-> WHERE tg.tblid=cp.tblid AND tg.server=1 AND cs.SERVER_ID=tg.server lim
On Saturday, December 8, 2001, at 12:53 PM, Arjen G. Lentz wrote:
>
>>> Re-order the list of tables in the FROM, and put the
>>> "subprojectweb.subproject_name = 'shoeshine.com' " bit first
>>> after the WHERE, that will also make it clearer for you to read.
>
>> Is this just for my own persona
What version of MySQL?? - older versions ( I think around version 3.2.22 and
earlier ) you could not
run on the same system as MySQL was running and use the TCP socket (3306) -
your programs had to
use the socket file. For some API packages interfacing to MySQL - they used
the TCP socket and woul
At 8:19 AM -0700 12/10/01, Chris Bolt wrote:
> > Our brand new, fresh install of 3.23.46 won't let us set the
>> password for the root user because one seems to already be set.
>> Even after wiping the ...mysql/data/mysql directory clean and
>> rerunning mysql_install_db, we still get an "Enter pa
Hi Sergei!
Thanks for the reply! That was fast :)
> -Original Message-
> From: Sergei Golubchik [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 10, 2001 10:48 PM
> To: Al Caponi
> Cc: MySQL Mailing List
> Subject: Re: Limitation of Full-Text indexing in MyISAM table?
>
>
> Hi!
>
> On
> Our brand new, fresh install of 3.23.46 won't let us set the
> password for the root user because one seems to already be set.
> Even after wiping the ...mysql/data/mysql directory clean and
> rerunning mysql_install_db, we still get an "Enter password:"
> prompt when attempting to set the root
Our brand new, fresh install of 3.23.46 won't let us set the password for the root
user because one seems to already be set. Even after wiping the ...mysql/data/mysql
directory clean and rerunning mysql_install_db, we still get an "Enter password:"
prompt when attempting to set the root user p
I knew that would get your attention. But it may become reality because I
don't seem to have the skill to solve this problem as I'm a Linux novice and
my Win2K install works perfect. It would be a shame to give up on Linux in
favor of Microsoft but it works on Microsoft.
I have run out of ideas
Hi!
On Dec 10, Al Caponi wrote:
> Hi all,
> Is there any limitation in creating full-text indexes on MyISAM tables?
> Currently, I have a table like this:
> CREATE TABLE IF NOT EXISTS mytable (
> UId BIGINT(20) NOT NULL AUTO_INCREMENT,
> Title VARCHAR(255) NOT NULL,
> Field1 TEX
Hi all,
Is there any limitation in creating full-text indexes on MyISAM tables?
Currently, I have a table like this:
CREATE TABLE IF NOT EXISTS mytable (
UId BIGINT(20) NOT NULL AUTO_INCREMENT,
Title VARCHAR(255) NOT NULL,
Field1 TEXT,
Field2 TEXT,
Field3 VA
Hi,
Bennett Haselton wrote:
--snip
>
> select * from user left join MYTEMP on user.ID = MYTEMP.userid where
> MYTEMP.userid IS NULL;
I bet that this approach will fail because you want the join to show you
records that aren't there. But it will show you something, and it will
show you more if y
PLEASE
can everybody use a descriptive subject?
Especially on a monday morning, I have over 250 messages, I really
appreciate to read and learn from other's problems, but when it talks
about solaris install I can't care less, I do filter subjects, but too
often they are totally unhelpful.
Is th
Please use a more descriptive subject...
I don't use Solaris and therefore cannot help you at all with your
problem.
Plus a lot of users filter out subjects "problem" "newbie" "question"
since they are usually a lost of time to read and often not related to
one of their "strong" subject.
Etienn
Please use a more descriptive subject,
you have better chances to have replies (a lot filter out subjects
having only "question" "newbie", etc
Etienne
Angel Gabriel wrote:
>
> Thanks for reading this. I'm new to the whole world of linux, and MySql, but
> I decided to get my hands dirty, and le
http://www.phpbuilder.com/columns/tim2705.php3
especially:
http://www.phpbuilder.com/columns/tim2705-res.php3
those aren't from the latest releases of both DB, but gives a good idea.
Someone in replies said that the mysql that dies is not normal and some
config was probably not done ri
mySQL can't do subselects afaik
Etienne
Harlan Feinstein wrote:
>
> Rory> I want to write an efficient query that will delete all records
> Rory> from one table when they show up in another table (pending
> Rory> shipments --> shipped shipments). I can't do it with this:
>
> mysql> DE
I use the -lmysqlclient command line argument to gcc
under Linux. It compiles fine and everything works
great.
However, if I move the compiled binary to another
system, which doesn't have the mysql client libs
installed, when I try to start the program, I get:
error while loading shared librar
So far as I know, yes. You need to set up two different connection strings,
though, and reference those in the different queries.
Kevin
On Friday 07 December 2001 08:14, Ares Liu wrote:
> Can I implement parallel queries to mySQL by using sevial query sentences
> in a single PHP file? Who kn
http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
says that for some sub-queries you can create temporary tables, but I
couldn't find any examples in the tutorial that show the use of a temporary
table. Are there any?
Or, if you're feeling generous, could you just tell me how to do this
1 - 100 of 137 matches
Mail list logo
