Carlos Soria wrote:
Hello,
I am working with MySQL 5.0.24 on Mandriva-Linux 2007. I can't compile
book
example test1_libmysqld due to an incompatibility
gcc -g -W -Wall -I/usr/include/mysql -D_THREAD_SAFE -D_REENTRANT -static
test1_libmysqld.c -L/usr/lib/mysql -lmysqld -lz -lm -lcrypt
Jonathan Mangin wrote:
File downloads are enabled in IE but refuse to work.
Does anyone know where I can FTP the latest version
of mod_auth_mysql
While this particular apache module does deal with mysql, the question
you are asking is more oriented to the module working with apache than
Marten Lehmann wrote:
How can I check which tables are using innodb with sql? How can walk through
the tables with show databases and show tables. Thanks.
This somewhat depends on how the tables were declared. If you used
ENGINE=InnoDb; in the CREATE TABLE sequence, you'd be able to loop
Sven Fuchs wrote:
These characters are stored/retrieved correctly. But they are wrongly
regarded the same character by statements like SELECT * FROM tablename
WHERE fieldname LIKE '[greek small eta]'
The database's character-set is set to UTF-8 Unicode (utf8) and the
table's and varchar
Jim C. wrote:
CREATE TABLE credits (
person integer NOT NULL default '0',
chanid int NOT NULL default '0',
starttime timestamp NOT NULL default '1970-01-01 00:00:00+00',
role VARCHAR NOT NULL,
CONSTRAINT role_check CHECK role IN
Jim C. wrote:
OK, I've another question. This one is about the INSERT command.
When I uncomment some of these statements I get an error in regards to a
comma. What I'm afraid of is that perhaps there is a compatibility
issue such that an INSERT command on Postgres can't take as many records
as
Michael Fischer wrote:
Having a very bad time with the subject sorts of queries.
Here is a simple reproduction of the problem for me.
Perhaps I'm blind/stupid while looking at the docs,
or there's a bug...
mysql version 5.0.24-standard
simple schema:
mysql desc people;
Konstantin Saveljev wrote:
Hi,
i have a system that has media files == users can be fans of media ( so
media becomes their favorite ).
the table itself:
CREATE TABLE media_fans(
id int(11) unsigned not null auto_increment,
user_id int(11) unsigned not null,
media_id int(11) unsigned not
idea as any to use the table.
Another thing to consider is:
--
Chris White
PHP Programmer
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Another thing to consider is:
heh, silly mail client :). Another thing to consider is this:
http://dev.mysql.com/doc/falcon/en/index.html
Though it's Not recommended for production use, I've heard people still use
it in production environments.
--
Chris White
PHP Programmer
Interfuel
,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Just to toss something else in here. A lot of times you have a server
that you can connect to by ssh, but because of firewalls, can't access
mysql through. If you can, however, connect to the database through
ssh, you can do port forwarding. In *nix systems it should be something
like
Michaël de Groot wrote:
Hi guys,
I have a question about index usage in MySQL.
I have a query:
MYSQL: ([EMAIL PROTECTED]) [webstats] EXPLAIN SELECT sum(users) as
totaal_uniek,
page_id FROM webstats.stats_hour where page_id LIKE 'vipPage_%' and site =
'spelpuntVip' and date
[EMAIL PROTECTED] wrote:
FROM .$tn., bill_info as b
LEFT JOIN shipp_info as sh ON (b.bill_id=sh.bill_id
That would be the usage of multiple from's combined with a left join.
Unfortunately with mysql 5 you can't do this. You're going to have to
do bill_info as a left/right/inner join
If I fire a lot of querries, I get an error mysql server has gone
away/lost
connection with the server .
I've seen this error for the second reason you've mentioned, wrong
queries. You'll need to show us the query so we can see any possible
issues.
--
MySQL General Mailing List
For list
Haig Dedeyan (Home) wrote:
Hi everyone,
I'm a dbase rookie and I've ran into a small problem.
I created a basic faq table and all is fine regarding displaying
searching the Q A's on a web page.
Up until now, I;ve entered all Q A's from phpMyAdmin.
I'm trying to create an admin page to
Is it possible in mysql to create a date field that stores year and month
only (-MM) without having to zero out the day or use varchar type fields
Best here is to just use a DATE field, then use DATE_FORMAT when you
want to pull up the customized date. It will get stored as a timestamp
Scott Yamahata wrote:
Newbie question here. Using Mac OSX Server 10.4.4. Do most MySQL
tasks in terminal window.
Recently purchased software that tells me to go to Control Panel
(which I don't think I have--though I have MySQL tools) and load their
file onto the MySQL database.
Generally
bruce wrote:
hi...
i'm trying to determine if it's safe, or if there are pitfalls to running
simultaneous copies of mysql on a given server. assume that the instances
are completely separate, dirs/ports/etc...
The one reason why is because of the network load and the memory usage.
MySQL
I did a DB conversion before that with ALTER DATABASE db_name
CHARACTER SET utf8
That worked wonderfully, except not as expected. ;-)
It basically converted only the database itself. so I had to do a
separate ALTER TABLE ... for each table.
The database encoding more establishes the default
Richard Reina wrote:
I am trying to update from one table to another but I get a syntax error when I
try:
UPDATE from maindb.orders o, altdb.orders ao SET o.price=ao.price WHERE o.ID=a.ID;
First off, it'd be best if possible (I know some cases prevent it) to
upgrade your server. The
Reading the noted previous thread, I was curious as to updating multiple
tables. I read the MySQL docs, which mentions that you can do it:
Multiple-table syntax:
UPDATE [LOW_PRIORITY] [IGNORE] /|table_references|/
SET /|col_name1|/=/|expr1|/ [, /|col_name2|/=/|expr2|/ ...]
[WHERE
zv Green wrote:
Hello all,
What I want to do is select all the records from the table but where
there
are duplicate entries (based on say, the surname and postcode fields)
pick a random record and then ignore the rest.
If you want to pick a random record, you can do ORDER BY RANDOM LIMIT 1
Anders Lundgren wrote:
One potential solution might be to use an extra column that tracks
month_number, and populate it with a trigger on insert or update.
Index that field and then use it in your WHERE clause. One
possibility anyway.
Resulting question, what if I have three colums
I'll bite..
Sorry for this silly question but I've been always had trouble
pronouncing MyISAM and InnoDB.
How do you pronunce them?
I pronounce MyISAM as give-me-foreign-keys and InnoDB as
curse-you-cryptic-foreign-key-errors
(currently running far and fast)
--
MySQL General Mailing List
C.R.Vegelin wrote:
Hi List,
I need the lapse time in microseconds.
I have tried various things, like:
SELECT TIME_FORMAT(CURTIME(), '%f');
SELECT TIME_FORMAT(NOW(), '%f');
Your arguments are reversed. It's:
SELECT TIME_FORMAT('%f',CURTIME());
SELECT TIME_FORMAT('%f',NOW());
SELECT
this...
Insert Into tablename (myID, Qty)
Values ($myID,$Qyt)
On Duplicate Key Update Qty = Qty + $Qty
you may also be able to use...
On Duplicate Key Update Qty = Qty + Values(Qty)
But I have never used that before so I'm not sure
--
Chris W
KE5GIX
Protect your digital freedom and privacy
Mungbeans wrote:
ALTER TABLE `mytable` DROP FOREIGN KEY `keyname`
#1025 - Error on rename of '.\database\mytable' to '.\database\#sql2-6ec-11'
(errno: 152)
ALTER TABLE `mytable` DROP INDEX `keyname`
#1025 - Error on rename of '.\database\#sql-6ec_13' to '.\database\mytable'
(errno: 150
Oh
bruce wrote:
i'm trying to figure out how to create a select query that groups
the tbl around 'name' such that if i want all names that do not
have a status=3, i'd get a single row for 'sue' and 'bob'
I'm not sure why `SELECT name FROM dog WHERE status = 3 GROUP BY name;`
wouldn't give you
Duncan Hutty wrote:
I attempted to build 5.1.14-beta with ssl support and it failed
(output below).
It builds quite happily on this system without the ssl support
parameter to configure. Since it appears to fail in an area (timezone
system) that to me seems rather unrelated, I wondered if
Aaron Cannon wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all. I hope this is the right place to ask this.
I have two tables, A and B. Each of these tables has a column with
integers. The column in table A is C and the one in B is D.
SELECT c.value FROM c WHERE c.value NOT
Ashley M. Kirchner wrote:
?php
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$mins[] = $row['the_minute'];
$temp_f[] = $row['avg_temp_f'];
$temp_c[] = $row['avg_temp_c'];
}
?
I'd try php here, something like:
?php
while($row =
want to adjust the where clause to specify the correct
period, of course.
Chapter 12 in the reference manual has a bunch of time functions
which you might find useful.
Hope that helps
-Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
On Wednesday 27 December 2006 17:12, Ashley M. Kirchner wrote:
Chris Comparini wrote:
Try something like this:
select hour(time) as the_hour, avg(temp_f) as average_temp_f
from data
where time now() - interval 24 hour
group by the_hour;
Thanks Chris. Question though, why
and it fails, what things should you look for
to solve the issue? types. That's why it's really hard to find anything
like that on google. The best thing to do would be describe what exactly
this person will be doing.
--
Chris White
PHP Programmer
Interfuel
--
MySQL General Mailing List
a really
large db).
--
Chris White
PHP Programmer
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the entire slave status back in order
to see this one thing. Anyway...
If anyone has any ideas on this, I'd love to hear them.
Thanks,
- Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Friday 15 December 2006 11:23, Mikhail Berman wrote:
Hi Chris,
If you are running on *Nix you could write a script generally structured
like:
do
- show status | grep 'what_ever_string_you_want_to_see'
- insert into table
- sleep [seconds]
done
Yes, we
On Friday 15 December 2006 11:53, Steve Edberg wrote:
At 11:12 AM -0800 12/15/06, Chris Comparini wrote:
Hello,
Say I wanted to log some various server status variables to
a table. What I'd like to do, ideally, is something like
this:
insert into SomeLogTable (Threads) show status like
I tried this out this morning on MySQL 5.
It works. Please try this in MySQL 4 and see.
Unless I'm way off, I do not believe your solution will work in 4.x because
it doesn't support sub-queries...
thnx,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
site.
You are in a dugeon, there is a door to your left and a torch to your right.
The wind of sarcasm slowly blows by you, and you sit and wonder in dispair.
1) Move
2) Jump
3) Fight
--
Chris White
PHP Programmer
Interfuel
--
MySQL General Mailing List
For list archives: http
Here is a query I'm trying to run. It doesn't look like it is overly
complex and, granted, it's joining on a few tables, I wouldn't imagine it
would take 6.5s to execute.
SELECT
TRIM( users.username ) AS username,
TRIM( games.game_name ) AS game_name,
CASE
WHEN 0 != UNIX_TIMESTAMP( MAX(
Make sure that all joined fields are of identical types, otherwise the
query executor must cast each and every join value, which may be
affecting the query time...
Can you even define fields having foreign keys to be of a different type?
Anyway, taking a look at my JOIN
INNER JOIN users ON
VeeJay wrote:
I am a novice with Unix and user of MySQL on windows…..
I have a problem, i.e.
I want to install MySQL5.0 at my FreeBSD 6.1 box with following
configurations:
--prefix=/usr/local/mysql
--with-mysqld-user=mysql
--with-unix-socket-path=/tmp/mysql.sock
is required, you could have something like:
SELECT SUBSTRING(value,2) as value_num, value FROM num_test WHERE value x;
where x is one of the following depending on the situation:
REGEX('N[0-9]+$')
REGEX('N[0-9]+')
REGEX('N[0-9]{3}$')
depends on how specific you want to get really.
--
Chris White
PHP
script editor and do it there.
--
Chris White
PHP Programmer
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
for your function, but it doesn't return
anything, what you probably want is:
WHEN x50 THEN return ceiling(x+x*0.25)
and the like for the rest of the cases.
--
Chris White
PHP Programmer
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
| N500 |
+---+---+
2 rows in set (0.00 sec)
--
Chris White
PHP Programmer
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Thursday 07 December 2006 16:34, Ed Reed wrote:
Thanks for the quick reply Chris.
It's close but it's a little off. Your example also returns all
instances that where the letter N exists in another words as well
SELECT SUBSTRING(value,2) as value_num, value FROM num_test WHERE value
like
Patrick Aljord wrote:
hey all,
I have two tables like that:
artists(id,name)
albums(id,artist_id,album_name)
and I need to transfer the data of this database to three tables that
look like this:
artists(id,name)
albums(id,name)
artists_albums(album_id,artist_id)
any idea what's the fastest
Mohsen Pahlevanzadeh wrote:
Ben Clewett wrote:
Hi Mohsen,
Thanks for the reply.
I'm looking in the home directory, as well as the other directories
used by mysql and I can't see any files which I do not recognise. (I
am UNIX so there are no hidden files.)
I am also a little confuses as
in advance...
Any reason in particular you need that specific functionality? You can always
hit one of the standard library time functions (man time.h for example).
--
Chris White
PHP Programmer
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Agarwal, Abhishek wrote:
I am not able to start the mysql server.
You haven't shown us what happens when you try to start mysql. You've
shown us what happens when you install the rpms.
You need to
/etc/init.d/mysql start
or maybe it's
/etc/init.d/mysqld start
--
MySQL General Mailing
, Field2, Field3 From MyTable
Where Field3=strVal;
End
varchar is meant to be variable, so it MUST have a length supplied. If you
want the same flexibility without specifying a specific length, use TEXT
instead.
--
Chris White
PHP Programmer
Interfuel
--
MySQL General Mailing List
a prepared query.
--
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]
Anil Doppalapudi wrote:
Hi List,
Any update on this
Thanks
Anil
Hi List,
Below is the output of mysqldumpslow. In the output query execution time is
showing -ve value how to interpret the below output i.e how to interpret
-ve value for query execution time please advice
Nobody has
be received by:
SELECT @cur;
--
Chris White
PHP Programmer
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
not showing
separation of frontend and backend, but the php/mysql interaction stays the
same. Take it for that and it's a great book imho.
--
Chris White
PHP Programmer
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
be
converted to a timestamp storage wise and would become an indexable integer.
Even 1,000,000+ rows shouldn't have that much of an effect. You'll also have
the nice functionality of MySQL's date/time functions.
--
Chris White
PHP Programmer
Interfuel
--
MySQL General Mailing List
For list archives
the
idea. I don't remember any examples of the first two cases, and am too
lazy to figure any out, but they do exist.
--
Chris W
KE5GIX
Protect your digital freedom and privacy, eliminate DRM,
learn more at http://www.defectivebydesign.org/what_is_drm;
Gift Giving Made Easy
Get the gifts
John wrote:
I am getting this error when installing a db:
An error occurred while trying to build your MySQL
database tables. The errors were: 'Invalid default
value for 'AttachmentID'
Invalid default value for 'MapID'
Invalid default value for 'ServerSendID''. Click on
the Try Again button
Rob Cochrane wrote:
Hi All,
I am a Web developer and have been using MySQL for a couple of years. I
have just changed to a new development machine away from WinXP to Ubuntu
Linux. My Dbase administration in the past has been via MySQL-Admin and
SQLYog. I am now trying to bring all my
John.H wrote:
I have two tables and I must do :
select `id`,`bid`,`title`,`link`,`bname` from table1 where `bid` in
( ...this is a subquery in table2 )
should I create a index (`id`,`bid`,`title`,`link`,`bname`) so that my
query
will take less time
or should a index contain so many colums?
John.H wrote:
I found that when I use a query as a subquery it will not use the right
index at all??
Post the query, the explain and the relevant table details and someone
might have a suggestion.
Also - not every single query is going to be able to use an index, this
may be one of those
John.H wrote:
but why when I do a query with 'explain' ,it shows that the
'possible_keys' is null or primary rather than the index I just create
Please always CC the list - you will get much faster responses and
others will be able to offer their input as well.
Post the query, the explain
Anyone have any info
on MySQL Workbench? In it's latest state it isn't usable at all. It looks like
it'll be really great.
Thanks,
Chris ParkerAardvark
Tactical, Inc.IT Manager1002 W
Tenth St. Azusa, CA 91702phone: 800.997.3773 x130 fax:
626.334.6860[EMAIL PROTECTED]
with this installation? I haven't really
pushed it hard enough to tell if it will try to use both CPUs or not (always a
tricky thing).
Thanks. I really wish this (libraries in use, how to run on multi-cpu machines)
was better documented!
Best,
chris
--
MySQL General Mailing List
For list archives: http
Alan Nilsson wrote:
On Oct 30, 2006, at 3:27 PM, Jay Blanchard wrote:
[snip]
I am trying to find records where the value of a filed is NULL. I
know that there are records that have null values but the result is
always an empty set.
eg:
select test_id from tests where test_id=NULL
always
this condition exists?
--
Chris W
KE5GIX
Protect your digital freedom and privacy, eliminate DRM,
learn more at http://www.defectivebydesign.org/what_is_drm;
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
Chris W wrote:
Suppose I have table t with fields k1, k2 and k3 that all make up the
primary key. Then I have fields x, y and z. If fields x, y and z all
have the same values in more than one row, there is a good chance they
are duplicate records. What is the best way to list all
Chris wrote:
Chris W wrote:
Suppose I have table t with fields k1, k2 and k3 that all make up the
primary key. Then I have fields x, y and z. If fields x, y and z
all have the same values in more than one row, there is a good chance
they are duplicate records. What is the best way to list
Chris W wrote:
Chris wrote:
Chris W wrote:
Suppose I have table t with fields k1, k2 and k3 that all make up the
primary key. Then I have fields x, y and z. If fields x, y and z
all have the same values in more than one row, there is a good chance
they are duplicate records. What
[EMAIL PROTECTED] wrote:
From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
What is going slower, INSERT / UPDATES or SELECTS?
Complex SELECTs
CHAR should make for quite efficient processing, since to a
large degree nobody cares what's in there: it just slams the
data in, or does a simple
Hello,
Originally I had this long explanation of what I'm doing and why I'm
asking this question but I thought I'd just cut to the chase and ask...
For a db that doesn't get a lot queries is there much of a performance
difference between BLOB and VARCHAR(255)?
Thanks,
Chris.
--
MySQL General
RV Tec wrote:
Folks,
A few months ago, I came here asking for directions on how I could
improve performance of MySQL. Back then, I was using OpenBSD on a dual
Opteron 248 with 2GB, LSI MegaRAID 320-1, 15k RPM SCSI discs, MySQL was
(still is) 4.0.27, the database is MyISAM, reaching 50GB.
- Jane W.
Doe John
Try this page with several examples and see if it will do what you
want it to do.
http://hrrdb.com/FormatName.php
The main line of code that does the work is...
$FormatedName = preg_replace('/^([A-Za-z]+)([^a-zA-Z]+)(.*)$/', '$1,
$3', $FullName);
--
Chris W
KE5GIX
Martijn Tonies wrote:
No,I mean the position of the recorde in the table
In the SQL world, records don't have a position in a table.
When you request data, you will get a resultset, not access to a table.
The resultset is derived from the actual table data.
He wants the last_insert_id
黄小聪 wrote:
When I insert a record into a table
Does the insert return a value that where the record have been inserted
into?
No.
You need to select last_insert_id() or use a function in your
programming language (eg php has php.net/mysql_insert_id).
--
MySQL General Mailing List
For list
Don O'Neil wrote:
Why does this query return no results:
SELECT * FROM FileList WHERE MATCH Filename AGAINST (9640)
When there are entries in the Filename list that have 9640 in them?
How many rows are in the table? Full text won't work with only a couple
of rows.
And you do have a full
On 10/21/06, Dwight Tovey [EMAIL PROTECTED] wrote:
Hello all
Maybe it's been a long week, but I'm trying to do something that should be
simple and just not getting anywhere.
I have two tables:
accounts
acctid: int unique
acctowner: char
...
docs
docid: int unique
acctid: int
2. If I could split the tables up into smaller tables would this
help ? My dilemma here is that I can split the data, the data would be
in different tables but on the same hardware, the same number of deletes
would still have to happen so would it actually make any difference ?
No idea
Renish wrote:
Hello,
Sorry. Again u r wrong..
Thers no connection with MYSQL here.
Lets imagine I only have Oracle 7.3 data and then import the same data
into Oracle 10g
He's saying you need to talk to an oracle mailing list or forum.
We don't use oracle so we can't help you.
--
MySQL
group by distinct and what they do.
If you have some records:
name - chris
name - mary
name - fred
name - chris
and run something like this:
select name, count(*) from table group by name;
it will return:
chris - 2
mary - 1
fred - 1
*then* if you have an order by mysql will order the results
kalin mintchev wrote:
Basically you can't do what you want either without temporary tables or
using a subselect. Subselects are only available in mysql 4.1+ (I think
- check the docs) so that may or may not be an option.
thanks... pardon my ignorance - how would i do that using subselects?
On 10/16/06, kalin mintchev [EMAIL PROTECTED] wrote:
but that will get you all records for that category not just the most
recently updated.
that's the main problem, isn't it?
what i'm looking for is the last record for EACH of the categories in the
table. i'm aware of the aformentioned
they had version
4.3.11. If you are considering using godaddy.com for hosting, you can
use this information to make the decision as to if their service offers
what you need.
--
Chris W
KE5GIX
Protect your digital freedom and privacy, eliminate DRM,
learn more at http://www.defectivebydesign.org
entry
for that user. Can someone give me some ideas?
Php info gives me this ...
PHP Version 4.3.11
MySQL Client API version 3.23.49
My version of mysql is 4.1.15
and I have set it to use the old style password.
Anyone have any ideas on what to look for?
--
Chris W
KE5GIX
Protect your
Chris, this sounds great but when I read about mysqlhotcopy I
didn't see a way to make it create a live table that's open within
the same database, it seems to want only to create a separate backup
file in some directory.
--
Chris Wagner
CBTS
GE Aircraft Engines
[EMAIL PROTECTED]
--
MySQL
I have an update operation where I am able to update 10 million records in
approx
2.5 mins.
But when I tried to do the same update on say 40-50 million records, mysql
takes forever to finish. Its the same table, and same update operation, i am
just changing the range of ids using where
A workaround is to use mysqlhotcopy to snapshot the table and also only copy
the header to the MYI file. Then delete the original and rename the copy back
to the original. This will effectively drop all indexes and should take no
more time than what the disk takes to copy the .my* files.
in them and almost no data actually.
mySQL 5.0.15
ÐÆ5ÏÐ
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Chris W
KE5GIX
Protect your digital freedom and privacy, eliminate DRM
Surendra Singhi wrote:
Hi,
I am using mySQL 5.0 and I have 2 tables with few hundred millions of
records.
To optimize things, I am using MyISAM tables, using the smallest possible data
type and have set indexes.
Now, the problem which I am facing is that mySql process is wasting lot of
Robert DiFalco wrote:
Here's an odd one.
I have a table called Elements and another table called ElementNames.
The ElementNames table has a unique ID and a VARCHAR display name. The
Elements table has a ElementName.ID, a node ID, a rule ID and some other
stuff.
I have an index on the NameID,
m i l e s wrote:
Hi,
Can anyone tell me if this is the correct syntax for a self reference
Index ?
-- ALTER TABLE `RPI_CTYPE` ADD FOREIGN KEY (`RPI_CT_REPLCID`)
REFERENCES `RPI_CTYPE`(`RPI_CT_ID`);
-- CREATE INDEX RPI_H_REPLCID_idxfk ON RPI_HOW (RPI_H_REPLCID);
If you try it what
Daevid Vincent wrote:
Currently I run an 'updater' script to run through a directory of .sql files
using something like this in PHP:
$COMMAND = mysql .$OPTION['db_prefix'].$db. .$mydir.$filename;
system($COMMAND, $ret);
What would be the equivallent way to to this in a PHP
Renish koshy wrote:
Hi all,
I have installed MySql 4.1 in my system. when I tried to run Mysql , I
always gets this error.
Could not start MySql service on a local computer
Error 1067: the process terminated unexpectedly.
Stop sending this message!
We get the idea!
The more you send it,
and, to quote the
immortal Mr Jobs, 'Boom! You're done.'
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
Outside of the killings, Washington has one of the
lowest crime rates in the country.
-- Mayor Marion Barry, Washington, DC
--
MySQL General Mailing List
For list archives
with some on this list!)...
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
It isn't necessary to imagine the world ending in fire or ice -
there are two other possibilities: one is paperwork,
and the other is nostalgia.
-- Frank Zappa
--
MySQL General Mailing List
this in mysql ?
I did somewhat of a mock sequence generator using stored procedures:
http://www.gen2net.net/articles/mysql-stored-procedures
hope that helps.
--
Chris White
PHP Programmer
Interfuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
to invoke it from
Term I get a 'cmd not found' message.
trying to figure out what I'm doing wrong:
chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
201 - 300 of 2034 matches
Mail list logo