Grass Cake wrote:
I'm still unsure about foreign keys..even after reading the doc file and
Paul Dubois 3rd edition
My doubt is...how much constraint is applied.( probably a bad
explanation)
If i have a table 'Customers' with the primary key being 'CustID'
Then i have a table 'LastVisit' wi
chylli wrote:
I run following command :
use db1;
insert into db2.c select a.a, a.b, a,c, b.d, b,e ... from a left join b on
(a.id=b.id);
Do you have an index on a.id and b.id ?
size of table a and table b is:
[EMAIL PROTECTED] ls -l ../db1/a.*
-rw-rw 1 mysql mysql 9230 May 10 15:41
Dyego Souza Dantas Leal wrote:
I have a Dell P2800 SERVER WITH:
Red Hat AS 4 ( 64 bit machine)
6 GB of RAM
Dual Xeon DUALCORE 2.8Ghz with 2MB of L2 Cache
I will use MySQl 5.0 and InnoDB, exits a config to use all power of this
server ? the developer guys can send-me a config ?
There is a
Annam Srinivas wrote:
Hi,
Problem is like this. There is table with 'table_name-1' where, when I
am executing the query like ' select * from table_name-1;' it is showing
only 432 records but acctually there are 539 records in the table. when I
select individual records from the table it is sh
leo huang wrote:
hi, Chris
Thank you for your advice!
I know that Innodb use the logfiles circularly. Can Innodb re-use the
deleted rows' disk space in tablespace?
I'm sure it will, what makes you think it won't?
You might need an 'optimize table' or something to s
ou using phpMyAdmin? I was told by a coworker that phpMyAdmin adds those
limits in. Wondering if taking the LIMIT out might do it. Also, are the
tables really named table1 and table2 (Yah, I know.. but I have to make
sure :( )?
--
Chris White
PHP Programmer/DBoy
Interfuel
--
MySQL Gener
On Wednesday 26 July 2006 11:00 am, Peter Lauri wrote:
> The query in full was exactly as you wrote it (but without the typo) :)
Alright, yes, what is your version of MySQL? I'm in the 5.0.22 series here
and that works just fine.
--
Chris White
PHP Programmer/DBackItUp
Interfuel
-
LIMIT 0, 100' at line 1
What's the full query look like right now (btw, there was a typo earlier, that
should have been table1 and not table 1 :/)?
--
Chris White
PHP Programmer/DBarkTree
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
FROM table 1
WHERE id NOT IN
(SELECT id FROM table2);
--
Chris White
PHP Programmer/DBacardi
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Prem wrote:
Hi All,
Could you please explain why some one needs multiple sql daemons and how to
control the number of dameons.
It forks so it can handle multiple queries at the same time. The main
process (mysqld_safe) handles starting up the other processes and
various other things (I assu
ame, n.question_id, n2.answer from blah n, blah n2
where n.name=n2.name and n.answer=n2.answer;
+---+-++
| name | question_id | answer |
+---+-++
| chris | 1 | yes|
| chris | 2 | no |
+---+-++
2 r
Ratheesh K J wrote:
I would like to know whether a SELECT query would block an Update on the
same table. The table is of InnoDB type.
Since InnoDB tables apply row level locks should the Update queries be
blocked until the select query completes?
I experienced such a scenario wherein an update
leo huang wrote:
hi, Dilipkumar
Thank you very much!
I think I know the fact: The Innodb can't reuse the deleted rows' disk
space. And a solution is: dump the data; shutdown mysql; delete the
files; restart mysql; import the data.
InnoDB does re-use the space inside the database, it's the log
saccion SET cantidad = 0 WHERE cantidad IS NULL;
--
Chris White
PHP Programmer/DBamBam
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
riations myself hoping it
would. You know, I'd almost LIKE someone to go "No you're wrong, you just
need to do this..." ;)
--
Chris White
PHP Programmer/DBlast
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
your client is inserting that < in there, that may be what's causing
your problem (not to mention it's <...)
> printf("%s\n",row[i] != NULL ? row[i] : "NULL");
> }
> }
--
Chris White
PHP Programmer/DBanned!
Interfuel
--
MySQL General Mailing List
For
f things worked before,
check if any updates to glibc were done. Otherwise I'd just google around a
bit for AIX+mmap64 and see what comes up.
--
Chris White
PHP Programmer/DBit
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I think we probably say either, equally. Sorry - I
don't buy that. :-)
Myself: I've never let local standards stand in the way of my
using international ones.
Excellent.
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
To see tomorrow's PC, look at today&
amp. It should be easy enough to test if you have a large set of
data where an update would take a long time. I'm pretty sure it will do
what you need though and set them all the same.
--
Chris W
KE5GIX
Gift Giving Made Easy
Get the gifts you want &
give the gifts they want
One stop wi
to sort on it and do
other calculations. Over here in Europe we at least use dd/mm/
(increasing unit size order), which is the next most logical, but to
start with the middle-sized unit, put the smallest unit in the middle
and end with the largest is just... weird!
--
Cheers... Chris
Highwa
tion to the file, then grab that
and use it to open the file and get the contents, using that for whatever
purpose you may have.
--
Chris White
PHP Programmer/DBlarg
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
dd comments. You'd have 2 choices:
1) Shove all the comments in one column (get ready for a HUGE table)
2) Create a separate image row for each comment (lots of duplicate data, bad!)
> KEY (img_id);
Not needed, you already declared it a key above (PRIMARY KEY)
> Thanks for any help.
>
s use the ever efficient test database to
test things first:
mysql -u [user] -h [host] -p test < fixme.sql
> Thanks for your help.
> Dominik
--
Chris White
PHP Programmer/DBlankRounds
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Robinson, Eric wrote:
Our MySQL-based medical application has been running fine for 3 years.
Last week, mysqld-nt started jumping up to 100% CPU and staying there
until someone restarts the service. mysqlcheck found no errors in the
database. I dumped it to disk and read it back in to create a fr
On Wednesday 19 July 2006 01:07 pm, Jesse wrote:
> `ID` int(10) unsigned NOT NULL auto_increment,
> `CTID` int(11) NOT NULL,
the storage types aren't the same. change CTID to INT(10) UNSIGNED NOT NULL
and it should work.
--
Chris White
PHP Programmer/DBank
Interfuel
--
My
y this is happening, and how to fix it?
>
> Thanks,
> Jesse
--
Chris White
PHP Programmer/DBlankSlate
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Kaushal Shriyan wrote:
Hi ALL
Can we have incremental backup of MySQL Database and if its there How
do we do it
Reposting your question again won't change the responses you have
received (it'll actually annoy people more than anything else).
--
MySQL General Mailing List
For list archives:
pradhuman jhala wrote:
I use MySQL version 4.1.18 with redhat-linux-gnu
(i686). I have created a InnoDB database consisting of
210 GB ibdata files. I used InnoDB to allocate more
memory and speed up the load. I want use it for
read-only purpose and it works fine with one MySQL
server instance.
I
David Felio wrote:
Is it possible to have general query type logging on just a specific
database or table? I don't want all queries to all databases, I just
need a log of accesses to a specific table. I figure I can use stored
procedures or a separate mysql instance as a workaround if I need to
s ahead of time
for any ideas.
mysql 5.0.22-standard
--
Chris White
PHP Programmer/DBouncingAtTheClub
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
or #60718 Can't open and lock privilege tables: Table 'mysql.host'
> doesn't exist
Did you install the initial database as stated in:
http://dev.mysql.com/doc/refman/5.0/en/unix-post-installation.html
? (yes it's unix, but the installation process for the initia
nd put this in your MySQL connect script after connecting to the db:
mysql_query ("set names 'utf8'");
or, better:
if (!mysql_query ("set names 'utf8'")) {
// handle the error
}
I hope that helps!
--
Cheers... Chris
Highway 57 Web Development -- http:/
going to
have a chat with my boss...
You could, it seems to me, get round all this by doing everything,
from soup to nuts, in utf-8. Is there a reason why it can't all be in
utf-8?
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
...but discriminating against Wi
Fauzan Azhary wrote:
Hi All,
I've tried to upgrade mysql from MySQL 4.1.12 to MySQL 5.0.22.
Before upgrading, I have like below :
# rpm -qa | grep mysql
mysql-4.1.12-3.RHEL4.1
mysql-server-4.1.12-3.RHEL4.1
mysqlclient10-3.23.58-4.RHEL4.1
mysql-devel-4.1.12-3.RHEL4.1
And after upgrading, I have
Dan Trainor wrote:
Kaushal Shriyan wrote:
Hi ALL
I would like to know following 2 things.
1) if i would like to take mysql incremental backup weekly
cp /var/lib/mysql/ /backup/mysqlbak/
how can i do it by above command as i would like to run cron weekly
for take mysql backup.
i would like t
Obed Soto Déctor wrote:
Hi, i'm sorry for my english, i'm from México and i'm gonna do my best,
i've made a store procedure but i have some problems becouse when a
make a simple operation with double datas the result is not what i
wait.
We can't tell much without seeing at least the stored pro
Kay C. Tien wrote:
At 05:37 PM 7/17/2006 Monday, Chris wrote:
Kay C. Tien wrote:
Hi All,
The simple script I'm testing works on a Linux server. I got tired
of having to upload and test them, so I decided to install MySQL on
my computer, which is running Win XP.
MySQL works fine on it&
[EMAIL PROTECTED] wrote:
I'm using MySQL 3.23.36 on RH 7.1. I've created a table photos (in
database album) with the following colums:
ID NUM AUTO_INCREMENT PRIMARY KEY
IMAGE MEDIUMBLOB
I'm running mysql from the command line:
mysql -u root
'root' has all privileges.
The file I'm trying to lo
L P wrote:
Folks,
say I have a need to add multiple rows at the same time.
for instance, say I'm collecting customer information and I want to add 3
addresses and 3 phone numbers at the same time for a customer.
The above is quite straightforward to accomplish when there is only one set
of data
thomas Armstrong wrote:
I created this very-simple '/etc/my.conf':
[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/var
socket=/tmp/mysql.sock
---
But it doesn't still work.
'/usr/local/mysql/var' hosts the data, but within 'mysql'
subdirectory, there are
only two fil
Xueron Nee wrote:
Hi all,
There is a table contains about 60,000 rows. where select from this
table with 'order by xxx' statement, it is tooo slow. but if i do it
without 'order by xxx', it works fine.
Is there any tips and suggestion for me? Thanks!
Add an index to the 'xxx' column?
That
Kay C. Tien wrote:
Hi All,
The simple script I'm testing works on a Linux server. I got tired of
having to upload and test them, so I decided to install MySQL on my
computer, which is running Win XP.
MySQL works fine on it's own, I've set the the database and etc., but
nothing happened whe
Ritesh Shetty wrote:
Hello,
My mysql server sometime just slows responding to database queriesIt
is as slow as less than 1 per sec.
But it speeds up by itself after some time , I have noticed that when it
speeds up there are lot more MYsql thread than just one thread when it
is slow.
So
Chris W wrote:
It may not be odd to many but I can't seem to think of how to do this
I have 2 queries below that give me exactly what I want each to do but
now I want to combing them is such a way that in the second query I
have one additional column that gives me a 1 on a row wher
|
SELECT `PID` FROM serviceplanfeaturelink WHERE `SID` = '$SID'
SELECT `PID`, `psoc`, `pName` FROM product WHERE pTypeID IN
($_FEATURES_TYPE_IDS)
Just in case your aren't familiar with PHP the $SID is just a php variable.
Any suggestions
--
Chris W
KE5GIX
Gift Giving Ma
d of obvious and a lot tidier than doing "datefield >=
'2006-03-01' and datefield <= '2006-03-31'", but are there pitfalls I
should know about?
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
Is there something that sticks out that
makes
sunny Tuesday
and want to try something new out.
Fat32/NTFS
Well, this is kind of a quick answer. Most will straightup go "NTFS" nowdays
(iirc because of speed and security labels, but I haven't dealt with windows
filesystems in awhile).
--
Chris White
PHP Programme
er as if the main one goes
down, I've got a real physically separated backup to work with. In the end
that's what matters.
--
Chris White
PHP Programmer/DBloomingOnions
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ere doing a
substantial amount of logging, or db dumping to disk. Then yes, you'd want a
nice fast disk at that point.
--
Chris White
PHP Programmer/DBlowMeAway
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
better.
--
Chris W
KE5GIX
Gift Giving Made Easy
Get the gifts you want &
give the gifts they want
One stop wish list for any gift,
from anywhere, for any occasion!
http://thewishzone.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
gt; I am more than willing to be called Wrong, slapped, and cast from a
> bridge.
Be careful on that, databases do more work in memory than anything else. That
said, I'd be more worried about your memory capacity. Now, if you rely
mainly on swap(virtual) memory, then you might worry m
while ($result = @mysql_fetch_array($query)) {
?>
Coo - something I actually know!
What column type is round? I bet it's a varchar or some other
non-numeric type. If I'm right, it's sorting lexically, so 1 comes
before 11, comes before 2, etc.
Change it to a some flavour of int and it
Addison, Mark wrote:
From: Chris W Sent: 07 July 2006 09:23
It's late and I just gave up reading the manual. Can someone please
tell me the easiest way to do a query that will return all
rows with a
time stamp that is X number of seconds older than the current time?
Something
)
Yes I know that is just 3 days but other times I will want to find
records that are a few hours old so I like using the formula.
--
Chris W
KE5GIX
Gift Giving Made Easy
Get the gifts you want &
give the gifts they want
One stop wish list for any gift,
from anywhere, for any occ
Neil Tompkins wrote:
I've the following SQL statement which I created in MS Access. My table
layout is the same in mySQL but it says I have an error and the query
doesn't run
SELECT AccommodationOverview.Title,
AccommodationOverview.AccommodationOverviewID,
AccommodationOverview.Accommodati
Always CC the list. You will get better / faster responses.
CREATE USER user [IDENTIFIED BY [PASSWORD] 'password']
thats is the syntax it tells me to use so i typed
CREATE USER dimitri [IDENTIFIED BY [PASSWORD] '**'];
were the starts are my password, i hav tried fiddling with the syntax
but
kalin mintchev wrote:
hi all...
i found this on the mysql dev manual site:
"MySQL 4 and later string comparisons, including DISTINCT, aren't case
sensitive unless the field is declared as BINARY or you use BINARY in your
comparison."
so here i tried it but no good. any ideas?! the field is not
z247 wrote:
Is this the only option? I get Access denied.
CREATE TRIGGER ins_sum BEFORE INSERT ON account
FOR EACH
ROW SET @sum = @sum + NEW.amount;
MySQL said: Documentation
#1227 - Access denied; you need the SUPER privilege for this operation
Read the error message.
You don't have "super"
Dimitri Mallis wrote:
hi list
firstly am in the right place to ask this sort of question
i installed mysql 5.0 from the repos on ubuntu dapper drake
i could only go in to mysql when i was root, & then i guess i am
suposed to add users there.
You've got things confused.
'mysql' the service,
Dominik Klein wrote:
Hi everyone
I'm wondering about the "--single-transaction" option on mysqldump.
Documentation says
---
This option issues a BEGIN SQL statement before dumping data from the
server. ...
---
So does this include the entire dump in one transaction? Or is it one
transaction
Nestor wrote:
People,
I have the following table:
DROP TABLE IF EXISTS bid;
CREATE TABLE bid (
bid_id int(11) NOT NULL auto_increment,
bid_proj_name varchar(100) NOT NULL default '',
bid_prop_name varchar(100) NOT NULL default '',
bid_amount varchar(20) NULL default '',
bid_sub_name varchar
CES user_status ( id );
--
Chris White
PHP Programmer/DBoo
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ULL, and you'd have to verify that the columns were not
NOT NULL, but the application logic should remain the same with regards to
that.
--
Chris White
PHP Programmer
Interfuel
805.642.2200 x110
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
r "Postgres MySQL comparison" or something of the like.
--
Chris White
PHP Programmer/DBlameSomeoneElse
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
or different
instances of the same picid. Like I said - it wasn't an ideal setup
in the first place, but anyway it seems to be solved now. See my post
earlier today.
Thanks for the interest though.
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
Everything Is Mor
SELECT is not cut has it is in the INSERT ?
SELECT probably doesn't care about the display width with regards to WHERE
clauses, it just wants to see if the field matches and be done with it. The
real answer to your issue would be to increase the display width, possibly
through ALTER TA
.
Thanks, Tanner!
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
When you've seen one shopping centre, you've seen a mall.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re you, I wouldn't start from
here," but it's what I'm stuck with.
And - not wishing to push my luck, /but/ - if there's a nifty MySQL
5-type answer I'd be interested in that too.
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
The l
the
> dates in this scenario.
That's why ORDER BY id DESC is used, it basically flips your table reverse, so
that last inserted (in essence the highest ID) is first, all the way down to
the first inserted (the lowest ID). Then LIMIT 50 will give you 50 from
highest id to lowest ID, or the
On Tuesday 27 June 2006 01:52 pm, Jesse wrote:
> @cInvNo
replace all instances of this with just cInvNo. cInvNo is already declared as
an OUT variable, and @cInvNo will be set to that value when you run:
CALL sp_GetNextInv(-1,@cInvNo);
--
Chris White
PHP Programmer/DBBD
Interfuel
--
My
UPS system
to keep your things running until the generators kick in, or you pay more
than that for data loss.
--
Chris White
PHP Programmer/DBrain Freeze
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
;message", but you're gonna get rather tacky output.
> I'm using MySQL 5.
>
> Thanks,
> Jesse
--
Chris White
PHP Programmer/DBad Boy
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql/bin/mysqld -uroot -S/var/lib/mysql/mysql.sock
> But when I call mysql_pconnect("localhost","root","") in my web page, the
> server return me an error, saying "Can't connect to
> socket:/var/lib/mysql/mysql.sock(13)". How can I do?
&g
> sport_name text not null,
Woh there! TEXT is probably overkill, I'd recommend VARCHAR for that (120 or
so, 255 if you're feeling lucky). As far as the sport_name, you could store
it as lowercase, and use the ucwords (http://www.php.net/ucwords) function in
PHP to make it upperca
allocated MYSQL_BIND in bind[0]. Take that line out
and things should work.
--
Chris White
PHP Programmer / DBlair Witch Project
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-server Build the embedded server (libmysqld). <-- I'm
assuming this is what you want
> --
> TIA,
>
> Asif
--
Chris White
PHP Programmer/DB Jaguar
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 15:47 +0200 23/6/06, Jørn Dahl-Stamnes wrote:
Yes, I forgot to say that I was using PHP...
Oh, I think the clue was in the subject line. :-)
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
Revolution: an abrupt change in the form of misgovernment.
-- Ambrose
ng to look out for.
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
Some speakers electrify their listeners, others only gas them.
-- Sydney Smith
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ply a dollar
amount to another number. Has anyone else seen this problem?
What does a show create table give for the price column? I bet it is
varchar. The only way to make it work then would be to trim off the
dollar sign and cast it to a float or double.
--
Chris W
KE5GIX
Gift Giving Made
t because of certain glibc functions:
> ../mysys/libmysys.a(mf_pack.o)(.text+0x4ef): In function `unpack_dirname':
> : warning: Using 'getpwnam' in statically linked applications requires
>
> at runtime the shared libraries from the glibc version used for linking
--
Chr
On Monday 19 June 2006 04:08 pm, Logan, David (SST - Adelaide) wrote:
> Hi Chris,
>
> I've noticed that a Ctrl-C will also leave the query running (5.0.22 -
> Linux) and I've had to use the kill from mysqladmin or mysql client to
> get rid of it.
Huh, that's o
m the command line and have it really
> stop that query?
> --
> -
> Scott HanedaTel: 415.898.2602
> <http://www.newgeo.com> Novato, CA U.S.A.
--
Chris White
PHP Pro
port can only be used by one server
--
Chris White
PHP Programmer/Dances With DB's
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
u want in there. So I could
say:
From: mysql@lists.mysql.com
Through some magic mojo and "become" the MySQL mailing list. So in
conclusion, don't take what you see worth a grain of salt when it comes to
who things are from in the email world.
--
Chris White
PHP Programme
es (I /think/
that's what they are) appearing as grey bullets where you expect
normal spaces.
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
Empty warhead found in White House
-- Sign carried on New York peace rally, April 2003
--
MySQL General Mailing List
For list a
do they need to be in
a single row? There MIGHT be a way to do it with stored procedures, I'm just
not sure how..
> Thanks.
>
> Albert Padley
--
Chris White
PHP Programmer/DB Fighter
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
u might want to just
check the MySQL manual entry on fulltext searches for more information (and
user comments):
http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html
--
Chris White
PHP Programmer/DB Fawn
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
m
> Madison, Wisconsin, USA
> MySQL AB, www.mysql.com
--
Chris White
PHP Programmer/DB Unofficial
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
first
line after the BEGIN clause. Anything else I'm missing?
--
Chris White
PHP Programmer/DB Knight
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
lse I might have missed. I know there's:
"Beginning MySQL Database Design and Optimization:
From Novice to Professional (Apress, 2004)"
And it does say it covers MySQL5, I'm just not sure to what extent.
--
Chris White
PHP Programmer/DB Virus
Interfuel
--
MySQL General Maili
On Friday 09 June 2006 11:27 am, Samuel C Flores wrote:
> Um, did anyone actually answer Jesse's question?
Um, did you read the all the threads? If you'll notice the first message by
Jimmy Guerrero pretty much answers it, all he did was quote the MySQL site.
--
Chris White
P
s what clubs/bats/spoons are for
> I personally will avoid these situations.
I don't, I like to live on the edge
--
Chris White
PHP Programmer/DB Fly
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
on the command line, you may as well call
it a rock ;).
> Thanks,
> Jesse
--
Chris White
PHP Programmer/DB Howler Monkey
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
next time. Although I'm not
sure why this question isn't in the FAQ as often as it is posted here.
--
Chris W
KE5GIX
Gift Giving Made Easy
Get the gifts you want &
give the gifts they want
One stop wish list for any gift,
from anywhere, for any occasion!
http://thewishzon
velopment platform no-one's
accessing it if I'm not. I ran myisamchk on some tables before I saw
your message - with the server running - and I've just run it again
after stopping the server, and got identical results.
You must be logged in as root or mysql.
sudo does the trick. :-
e answer, but having done all
that I find there's no change.
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
Among the things money can't buy is what it used to.
-- Max Kauffmann
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 7:38 -0500 8/6/06, Jimmy Guerrero wrote:
"The official way to pronounce "MySQL" is "My Ess Que Ell" (not "my
sequel"), but we don't mind if you pronounce it as "my sequel" or in some
other localized way."
Miss Quill?
--
Cheers... Chr
.
Wow! I was right. I'm learning... :-)
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
If at first you don't succeed, try, try again.
Then quit. No use being a damn fool about it.
-- W.C. Fields
--
MySQL General Mailing List
For list archives: http://lists
op of my head, maybe you
need to specify the type even if it's unchanged (I assume all you
want to do is rename the column?). So supposing director_id was a
SMALLINT(3) UNSIGNED, try:
ALTER TABLE actors CHANGE director_id actor_id SMALLINT(3) UNSIGNED;
Any good?
--
Cheers... Chris
Highway
Hi all,
I'm currently looking for a tool that will take XML and produce a database
from it. Not really looking for anything in particular at this point, just
sort of scoping around. Anyone know of such a tool?
--
Chris White
PHP Programmer/DB Sloth
Interfuel
--
MySQL General Mailing
501 - 600 of 2108 matches
Mail list logo