Hi Manisha
I have used the same thing in a pretty different way.
Basicallyi have stored the date in string format say 'MMDD' and then
done simple comparison say 20031125<20031029 by converting it into Long
format in my local code (note::this will specially work in case of MMDD
forma
PHP and MySQL Web Development, by Luke Welling and Laura Thomson
It's an excellent book.
-Original Message-
From: Richard Bewley [mailto:[EMAIL PROTECTED]
Sent: Monday, November 24, 2003 6:53 PM
To: [EMAIL PROTECTED]
Subject: FW: How To Learn php and mysql.
The best way to learn is by t
Braulio Lumbreras wrote:
What is the best way to learn php and mysql? What book is recommended for
self study of both ?
Braulio
The PHP website is an excelent place. The online manual is real nice,
and there are plenty of user comments which I have found useful. The
PHP mailing list is a goo
S Kusumo wrote:
Hello ..
I'm a CLIPPER programmer. I'm looking for programming language (like Clipper) for MySql, that supports constructs such as LOOP, If-then-Else etc.
Appreciate someone who could respond..
S Kusumo
[EMAIL PROTECTED]
I'm not familiar with CLIPPER. Is it a scripting language,
> >Hi!
>
> Please reply to the list, not to me personally, so that others can
> follow this discussion. Thanks.
>
Sorry,
> >
> >
> >
> >> At 13:21 +0200 11/21/03, Jozsa Boti wrote:
> >> >Hi!
> >> >
> >> >How an i get the last Check-time of a specific table without using
LIKE
> >> >state
Dear everyone,
(B
(BI'd like to ask you a question, thanks in advance.
(B
(BQ: How long will it take to import 100GB data into MySQL DB by command "mysqlimport" ?
(B
(BBest regards,
(BMay Yang
(B
(B
(B--
(BMySQL General Mailing List
(BFor list archives: http://lists.mysql.com/mysql
(B
Well looks like it has quite a few dependencies. I'll have to install
these other dependencies
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 25, 2003 12:10 AM
To: jason steig
Subject: RE: FW: running sql-bench scripts redhat 8.0
>Thank you much!
Would appreciate in anyone can help me.
Let's say I do a query in php, eg. $query = "select
shed from structure"; With the mysql_fetch_array
function and a loop I could see all the values stored
in the column, shed, using the command: echo $shed;
Let's say now that I am carrying over a variable
InnoDB seems to have crashed on us, and put the errors below into the log
files... It took several crashes and some time but I was able to isolate the
extremely simple query involved.
Server is OSX 10.3 running on a Dual 200MHZ G5 with 4Gigs ram. MySQL is
4.0.16.
The original queries to crash wer
I am getting the following error when I try to access a merged table:
This:
Select * from subjects_2; or insert into subjects_2 (subj_id) values('10');
Returns:
ERROR 1017: Can't find file: 'subjects_2.MRG' (errno: 2)
Any Ideas what this means and how I can correct it. I can access the two
t
Thank you much!
-Original Message-
From: Michael Weiner [mailto:[EMAIL PROTECTED]
Sent: Monday, November 24, 2003 11:18 PM
Cc: [EMAIL PROTECTED]
Subject: Re: FW: running sql-bench scripts redhat 8.0
looks like you'll need to install the perl-DBD-mysql rpm to satisfy the
requirement.
HT
At 23:11 -0500 11/24/03, jason steig wrote:
Hi all,
I'am getting this error when I try to run any of the sql-bench tests.
For instance, here is an attempt to run the test-connect script. This
happens to me when I try any of the scripts. I attempted to change the
location my perl install at the b
looks like you'll need to install the perl-DBD-mysql rpm to satisfy the
requirement.
HTH.
Michael Weiner
--
On Mon, 2003-11-24 at 23:11, jason steig wrote:
> Hi all,
>
> I'am getting this error when I try to run any of the sql-bench tests.
> For instance, here is an attempt to run the test-connec
Hi all,
I'am getting this error when I try to run any of the sql-bench tests.
For instance, here is an attempt to run the test-connect script. This
happens to me when I try any of the scripts. I attempted to change the
location my perl install at the beginning of the script(RH 8.0) can
anyone he
Thanks,Kim. G'day to you too.
Braulio
"Kim Kohen" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
G'day Braulio
> What is the best way to learn php and mysql? What book is recommended for
> self study of both ?
As an absolute newbie I used "Build Your Own Database Driven Websi
G'day Braulio
> What is the best way to learn php and mysql? What book is recommended for
> self study of both ?
As an absolute newbie I used "Build Your Own Database Driven Website Using
PHP & MySQL" from http://www.sitepoint.com/books/phpmysql1/ It got us up
and running pretty painlessly
Thanks, Richard. What is the name of the book by Luke Willing and Laura
Thompson?
Braulio
""Richard Bewley"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> The best way to learn is by taking a script (I used a message board
written
> in php/mysql) and hacking it, then running it o
Hello Stefaan,
> Stefaan Van Dooren wrote:
> > Hi,
> >
> > I'm trying to install (compile, since there are no binaries for this
> > system) MySQL on an SCO OPenServer 5.0.6 system.
> >
> > Prior to compiling MySQL, I installed the following packages for SCO :
> >
> > FSU Pthreads (ver 3.9)
>
Hello Stefaan,
Stefaan Van Dooren" <[EMAIL PROTECTED]> wrote:
> I'm totally lost now..
>
> As you can (could) see in my previous post, I managed to get MySQL working
> on SCO with "--with-debug" as a configure option.
> Whenever I remove "--with-debug", I can compile and install it, but I
I'm building up a new MySQL server. The box specs are:
2U, Dual 3Ghz Xeon processors, 6 Gigs ram, 500 gigs of Raid 5
storage.
I'll have the hardware in my hands tomorrow. I've used RedHat
on all my previous linux servers. I'm planning on going with
Red Hat Enterprise Linux ES.
But, I've heard t
The best way to learn is by taking a script (I used a message board written
in php/mysql) and hacking it, then running it on your webserver, breaking
it, and fixing it again. Just make tiny changes at first, play with logic,
then work on bigger things.
As for a book, I recommend the one on PHP an
What is the best way to learn php and mysql? What book is recommended for
self study of both ?
Braulio
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have a table with start_date (date), end_date (date), rate(float) as 3 fields, I
want to compare today's date with start and end date if it is inside this range then
pick up the corresponding rate.
But how mysql stores dates ? (-MM-DD ?) how can i compare with today's date ? I
tried some
Adding this file (g_common_func.php). This is 'included' by the web
form file's code along with the connection script), I thought I should
include all referenced files and forgot this one:
# g_common_func.php
# common functions to gotcha application
# display header information
function header
Are you talking about a multiple key PRIMARY KEY?
CREATE TABLE Blah
(
MyDate datetime,
MyID INT NOT NULL AUTO_INCREMENT,
...
PRIMARY KEY (MyDate,MyID)
)
for each unique MyDate the Auto Increment sequence will start over.
If that's not what you're asking for, could
Here is my connection script (conn_inc.php):
if (!$connection) {
echo "Could not connect to MySQL server!";
exit;
}
$db=mysql_select_db("test_gotcha",$connection);
if (!$db) {
echo "Could not change into the database test_gotcha";
exit;
}
?>
Here is a web form (g_add_gotcha.php -- I have inse
I have a request to create an auto increment field
that increments like so:
1-112403
2-112403
3-112403
4-112503
etc...
Is that possible???
Any variant of that is fine the big issue is they want the Date with the ID number of
the record.
Thanks,
Rob
--
MySQL General Mailing List
For list arc
On Nov 24, 2003, at 6:25 PM, zzapper wrote:
I need to test if any values in a column are the same (or are unique)
eg (my made up syntax "Unique")
SELECT * from tbl_addresses WHERE txtName is UNIQUE;
How should this be done???
To get a list of all 'txtName' values that appear only once in the
On Monday 24 November 2003 03:25 pm, zzapper wrote:
> Hi Y'All
>
> I need to test if any values in a column are the same (or are unique)
>
> eg (my made up syntax "Unique")
>
> SELECT * from tbl_addresses WHERE txtName is UNIQUE;
SELECT DISTINCT txtName from tbl_addresses;
--
MySQL General Mail
Hi
php
http://www.php.net
would be a good start.
Peter
-Original Message-
From: S Kusumo [mailto:[EMAIL PROTECTED]
Sent: 24 November 2003 12:09
To: [EMAIL PROTECTED]
Subject: programming language
Hello ..
I'm a CLIPPER programmer. I'm looking for programming language (like
Clipper)
Hi
>I'm a CLIPPER programmer. I'm looking for programming language (like
>Clipper) for MySql, that supports constructs such as LOOP, If-then-Else
etc.
Use xharbour
download ftom www.xharbour.org
news group news://news.xharbour.org/xharbour
Regards
Luiz
---
Outgoing mail is certified Virus Free
At 16:33 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote:
I wanna deploy two different Mysql versions 3.23 and 4.0
As far as I understand this is not possible am I correct??
No, it's perfectly possible. I have dozens of versions installed
on my main machine. See the manual here:
http://www.m
Hello ..
I'm a CLIPPER programmer. I'm looking for programming language (like Clipper) for
MySql, that supports constructs such as LOOP, If-then-Else etc.
Appreciate someone who could respond..
S Kusumo
[EMAIL PROTECTED]
Hi Y'All
I need to test if any values in a column are the same (or are unique)
eg (my made up syntax "Unique")
SELECT * from tbl_addresses WHERE txtName is UNIQUE;
How should this be done???
zzapper
--
vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?"
http://www.vim.org/
Carlos wrote:
& have got no idea how to uninstall it completely off
the system.
You could try something vaguely like this:
# mkdir -p cd /tmp/mysqluninst
# cd /tmp/mysqluninst
# tar xvzf path-to-mysql-bin.tar.gz
# find . -exec rm /{} \;
DO NOT RUN THIS if you do not understand how it functions.
Hello !
I hope all is good with you.
It's a Red Hat Linux 8 with latest version of mysql.
I'm used to using RPMs and uninstalling with rpm -e,
however, this time a binary version of mysql was used
& have got no idea how to uninstall it completely off
the system.
Been looking over the Internet & n
don't forget to change the port number that the server is listening on if you plan on
running them simultaneously
> -Original Message-
> From: Peter Sap [mailto:[EMAIL PROTECTED]
> Sent: Monday, November 24, 2003 4:59 PM
> To: [EMAIL PROTECTED]
> Subject: Re: My.cnf
>
>
> You could in
Not correct.
The manual explains how.
Use separate data directories, and put the my.cnf files in the data
directories.
Arnoldus Th.J. Koeleman wrote:
I wanna deploy two different Mysql versions 3.23 and 4.0
As far as I understand this is not possible am I correct??
Since both version hav
You could install version 3.23 under a different username (like mysql323)
than the 4.0 version (like username mysql40).
Then put each .my.cnf in the ~ directory.
Regards,
Peter Sap
- Original Message -
From: "Arnoldus Th.J. Koeleman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Mond
maybe one more particle of information is that enums are actually
strings, not numbers, so you may have to do a conversion somewhere. this
is a pain for us, so we use tiny ints.
jeff
"Mike [tmw]" wrote:
>
> I always gone with ENUMs b/c TINYINT(1) still allows you to insert a '2'
> into the field
Hello, mysql Gurus,
I am wondering if there is any data integrity protection can be done if I
allow uses to update database from mysql Control Center or Excel and any
other applications that is connected to mysql thru mysql ODBC. I need to
reject the action if it makes violation of the data int
Hello, mysql Gurus,
I am wondering if there is any data integrity protection can be done if I
allow uses to update database from mysql Control Center or Excel and any
other applications that is connected to mysql thru mysql ODBC. I need to
reject the action if it makes violation of the data int
I wanna deploy two different Mysql versions 3.23 and 4.0
As far as I understand this is not possible am I correct??
Since both version have different needs in case of my.cnf
I always gone with ENUMs b/c TINYINT(1) still allows you to insert a '2'
into the field and the last idiot at my current job actually used '0'
for 'true' in a some fields in some tables.
I believe both would use 1 byte.
Mike
Paul Fine wrote:
Normally for a column with 2 possible values, I wou
When you do a mysqld -? it will say:
Default options are read from the following files in the given order:
/etc/my.cnf /var/lib/mysql/my.cnf~/.my.cnf
So that's the reason you can not start it anymore. (I'm using 4.1.0-alpha.)
Hope this helps.
Peter Sap.
- Original Message
Normally for a column with 2 possible values, I would use TINYINT(1) and
programmatically assign a value (ie. Yes/No) to 0/1. I assume that this is
the correct: way?
Now how about using ENUM instead? Is there any difference in overhead?
Thanks!
--
MySQL General Mailing List
For list archive
Normally for a column with 2 possible values, I would use TINYINT(1) and
programmatically assign a value (ie. Yes/No) to 0/1. I assume that this is
the "correct: way?
Now how about using ENUM instead? Is there any difference in overhead?
Thanks!
Paul DuBois wrote:
At 14:37 -0600 11/24/03, John Nichel wrote:
Paul DuBois wrote:
Paul DuBois wrote:
At 14:17 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote:
I like to install the my.cnf in another directory and not the default
/etc/my.cnf
When I move this file to another directory it can't sta
At 14:37 -0600 11/24/03, John Nichel wrote:
Paul DuBois wrote:
Paul DuBois wrote:
At 14:17 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote:
I like to install the my.cnf in another directory and not the default
/etc/my.cnf
When I move this file to another directory it can't start anymore.
Is there
Paul DuBois wrote:
Paul DuBois wrote:
At 14:17 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote:
I like to install the my.cnf in another directory and not the default
/etc/my.cnf
When I move this file to another directory it can't start anymore.
Is there a way to install my.cnf in a different loca
> This is exactly what i use as well.both tools have their benefits and
> limitations
I guess this goes for all tools :-)
If you're running Windows, you might want to take a look at
Database Workbench as well. It's not free and new to MySQL,
but it includes other tools and features as we
Paul DuBois wrote:
At 14:17 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote:
I like to install the my.cnf in another directory and not the default
/etc/my.cnf
When I move this file to another directory it can't start anymore.
Is there a way to install my.cnf in a different location and which file
n
Paul DuBois wrote:
At 14:17 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote:
I like to install the my.cnf in another directory and not the default
/etc/my.cnf
When I move this file to another directory it can't start anymore.
Is there a way to install my.cnf in a different location and which file
n
Versions:
> > Server is Win32 MySQL max 4.0.16
> > Client is FreeBSD MySQL 4.0.13
-- R
> Should work.
> What are the server and client versions?
>
>
>
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.net http://www.ensita
What administrative tasks should I do often on my database?
__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAI
This is exactly what i use as well.both tools have their benefits and
limitations
Julian Zottl
Yes i think it too. I use it but i thought that there
are more tolls.
--- Kenn Murrah <[EMAIL PROTECTED]> wrote:
> IMHO, there's nothing quite as intuitive and easy to
> deal with as
> phpmyadmin ... i can't begin to tell you how much
> time it saves me every
> day.
>
> kennM
>
>
> Sale Zenzo
That depends :) I use phpMyAdmin and mysqlcc, just depending on what I
want to do.
j-
At 11:36 AM 11/24/2003 -0800, Sale Zenzo wrote:
I would like to know what is the best program for
administering MySAQL databases: is it PHPMyAmin or
something else?
__
Do you Yah
IMHO, there's nothing quite as intuitive and easy to deal with as
phpmyadmin ... i can't begin to tell you how much time it saves me every
day.
kennM
Sale Zenzo wrote:
I would like to know what is the best program for
administering MySAQL databases: is it PHPMyAmin or
something else?
--
M
I would like to know what is the best program for
administering MySAQL databases: is it PHPMyAmin or
something else?
__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.
At 14:17 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote:
I like to install the my.cnf in another directory and not the default
/etc/my.cnf
When I move this file to another directory it can't start anymore.
Is there a way to install my.cnf in a different location and which file
need to be update
Héctor Villafuerte D. wrote:
Hi all,
Could you please tell me what can be causing this warnings? How can I
see them?
My Python script is dying because of this warnings :(
Since I'm using 4.0.16, I can't use SHOW WARNINGS.
Thanks in advance,
Hector
mysql> create table new_web select a.* from otr_
I like to install the my.cnf in another directory and not the default
/etc/my.cnf
When I move this file to another directory it can't start anymore.
Is there a way to install my.cnf in a different location and which file
need to be updated to look into the new
Location for the my.cnf file
"Reverend Deuce" <[EMAIL PROTECTED]> wrote:
> Egor,
>
> Thanks for the info. However, like I said, I already have "local-infile=1"
> and "set-variable = local-infile=1" in my my.ini on the server. I also have
> already done 'show variable like '%infile%' ' and receive "local_infile
> ON" in the re
Hi all,
Could you please tell me what can be causing this warnings? How can I
see them?
My Python script is dying because of this warnings :(
Since I'm using 4.0.16, I can't use SHOW WARNINGS.
Thanks in advance,
Hector
mysql> create table new_web select a.* from otr_new as a join internet
as b o
Thank you all for your prompt answers.
It works find. As you can see, I am an infant as of now. I just picked up a
Mysql & PHP for Dummies book.
If you have better learning references that I may consider, I would be very
appreciative.
Edgar
- Original Message -
From: "gerald_clark" <[EM
The problem is:
I am developing a database application in Adobe GoLive using MySQL and PHP.
I can retrieve a record with no problem.
When I modify the record and attempt to update it (Submit Button) the system
thinks it should download mysql.actions6.php (from my computer) and when I
click OK, i
>From MySQL Manual:
"If you want to change the number or the size of your InnoDB log files,
you have to shut down MySQL and make sure that it shuts down without
errors. Then copy the old log files into a safe place just in case
something went wrong in the shutdown and you will need them to recover
Using a backup I recreated the /var/lib/mysql directory and when I
restart mysqld I am getting the following error:
InnoDB: Error: log file /var/lib/mysql/ib_logfile0 is of a different
size 0 5238827 byes
InnoDB: than specified in the .cnf file 0 5242880
Of course, the database never starts bec
Hi,
> > > You are not using any indicies, because there aren't any that could be
> > > used in this query.
> > > Try adding an index on (status,deleted)
> >
> > I wonder: how many possible different values would such an index
> > return?
>
> mysql> select distinct status, deleted from urlword;
> +
Hi,
I have noticed also that SHOW TABLE STATUS became slower in 5 times at least
(from 1 sec to 5-6 secs).
Since I've switched to version 3.23.53 to version 4.0.14.
But I have changed type of all my tables (~30 tables) from MyISAM to InnoDB
as well.
> How long does an "ls" command in the database
Egor,
Thanks for the info. However, like I said, I already have "local-infile=1"
and "set-variable = local-infile=1" in my my.ini on the server. I also have
already done 'show variable like '%infile%' ' and receive "local_infile
ON" in the result set.
I run the command line client with --local-in
Hi!
Please reply to the list, not to me personally, so that others can
follow this discussion. Thanks.
At 13:21 +0200 11/21/03, Jozsa Boti wrote:
>Hi!
>
>How an i get the last Check-time of a specific table without using LIKE
>statements?
There isn't another way.
>There's the SHOW TABLE
Martijn Tonies wrote:
>
> Hi,
>
> > You are not using any indicies, because there aren't any that could be
> > used in this query.
> > Try adding an index on (status,deleted)
>
> I wonder: how many possible different values would such an index
> return?
mysql> select distinct status, deleted fr
There could be a number of things going on.
It would help troubleshoot your problem if your
script check for errors and print them if there are any. You cant
just assume a connection is being made just because phpmyadmin connects.
Your web app has to make its own connection.
So how about showing
Hi Robert,
I did not see any suggestions to you. So here is one. If you want
a guarantee simple brute force dump the entire DB with mysqldump and
recreate of the slave.
For Exmaple
mysqldump --opt mydb | mysql -umyuser -pmypwd -hremotehost myremotedb
You can run this through an ssh tunnel for
Hi,
> You are not using any indicies, because there aren't any that could be
> used in this query.
> Try adding an index on (status,deleted)
I wonder: how many possible different values would such an index
return? If this is a (very) low value, won't the index make things
slower (if it's being u
Janusz,
> Now the question is: how should I set up (and maintain?) my MySQL server
> to prevent it
> from using indexes inefficiently?
Quite a good question, no idea.
But if the query
select url_id from urlword where deleted=?? and status=??? and origin=?;
is a query that you will use very often
You are not using any indicies, because there aren't any that could be
used in this query.
Try adding an index on (status,deleted)
Janusz Krzysztofik wrote:
Marc,
Thank you for your prompt answer.
I run EXPLAIN in both cases and got:
MyISAM (fast):
mysql> explain select url_id from urlword wh
End your commands with a semicolon.
Edgar Powell wrote:
Hi All,
When I type a command after the mysql prompt nothing happens and no error. For example:
mysql> CREATE DATABASE members
> SHOW DATABASES
>
What do you think is the problem.
This is an apache web server.
The OS is Redha
> When I type a command after the mysql prompt nothing happens and no
> error. For example:
> mysql> CREATE DATABASE members
> > SHOW DATABASES
> What do you think is the problem.
> This is an apache web server.
> The OS is Redhat
This is just a shot in the dark, but there are no semi-col
Marc,
Thank you for your prompt answer.
I run EXPLAIN in both cases and got:
MyISAM (fast):
mysql> explain select url_id from urlword where deleted=0 and status=200
and origin=1;
+-+--+---+--+-+--+--++
| table | type | possible_keys |
Hi All,
When I type a command after the mysql prompt nothing happens and no error. For example:
mysql> CREATE DATABASE members
> SHOW DATABASES
>
What do you think is the problem.
This is an apache web server.
The OS is Redhat
Edgar
I'm totally lost now..
As you can (could) see in my previous post, I managed to get MySQL working
on SCO with "--with-debug" as a configure option.
Whenever I remove "--with-debug", I can compile and install it, but I can't
connect to it.
Can someone please explain what this "--with-debu
I have RH9 running on a p4 machine. I have mysql 3.23.58 running on
this linux machine. Through Websphere studio application developer on
windows xp machine I am trying to connect to my MySql database on the
Linux machine.
The error I receive is: connection refused
I then tried to telnet t
Daniel Kiss <[EMAIL PROTECTED]> wrote:
>
> I would like to know how to configure MySQL with the --with-vio and=
> --with-openssl options.
>
> I have a MySQL-4.1 installed on a Red Hat 9 system from .rpm packages.
> When I use the show variables command, it returns have_opensll =3D NO.
> Does it m
That worked like a charm, thanks so much! I don't know why I didn't try
that before!
Julian
At 02:46 PM 11/21/2003 -0600, Paul DuBois wrote:
At 10:56 -0500 11/21/03, Julian Zottl wrote:
Andy,
Thanks for responding. I think that I am going to go with the idea of
creating a tale for each day. M
ike,
Well, there are quite a few wierdnessess that I have experienced. One, for
instance, is if you are working in the GUI editor interface, and are mucking
around with the User priveleges I have actually had the GUI
wipe the passwords to null for all rows. I'm sure its just because I'm not
ike strong <[EMAIL PROTECTED]> wrote:
> Can anyone help me to figure out why suddenly I
> cant gain access into MySQL database with my password,
> which I assigned myself and which was working fine
> until yesterday when access was suddenly denied to me
> with the following meassage:
>
> Error 104
Innodb may not use an index (full scan) where MyIsam does (index crc which is the only
relevant one).
Have you done an EXPLAIN on your query ?
May be an index on (origin,status,deleted) could help.
Marc.
-Message d'origine-
De : Janusz Krzysztofik [mailto:[EMAIL PROTECTED]
Envoyé : lun
"Chris Streeter" <[EMAIL PROTECTED]> wrote:
>
> Does MySQL have a description column avialable for columns within table definitions?
> What I mean is when you do and "explain TABLE_NAME" can you get a column that as a
> description for each field? This would of course be especially useful for
>
Hello,
I am trying to optimize MySQL (3.23.49 from Debian stable) setup for
ASPseek application. I decided to try InnoDB in order to be able
to update tables while performing time consuming selects.
After converting all tables to InnoDB I noticed a big difference
in processing speed of one of the
Does MySQL have a description column avialable for columns within table definitions?
What I mean is when you do and "explain TABLE_NAME" can you get a column that as a
description for each field? This would of course be especially useful for
documentation purposes.
Thanks for your help.
Chris
Does MySQL have a description column avialable for columns within table definitions?
What I mean is when you do and "explain TABLE_NAME" can you get a column that as a
description for each field? This would of course be especially useful for
documentation purposes.
Thanks for your help.
Chris
[EMAIL PROTECTED] wrote:
I hope someone might be willing to help out.
I'm trying [still] to learn MySQL and php - to create some simply web
based database.
I have installed quite a few php/MySQL web database apps from books,
however, none of them will get data entered into my database.
When I
Hi there,
I'm seeing some problems with the way I've granted access to different
users. I've setup the server to allow access only from certain clients.
For example, the backup user is only allowed access from some machines:
GRANT SELECT ON testdb.* TO [EMAIL PROTECTED]
The problem is that when
"Alan Dickinson" <[EMAIL PROTECTED]> wrote:
>
> I've got a query that looks like this..
>
> "SELECT Foot_Id, Dir_Uni, Part_Suffix, Part_Number, Appln_No, Description,
> Product_Ref, Vehicle_Ref, Part_Prompt, Part_Description, Foot_Id,
> Qualifier, Years
>
> FROM appl
Any word on G5/64bit compiles of mysql?
I know I am not the only one wanting to know Does it work, and How to
compile best for it.
or am I alone in the universe?
--
Adam Goldstein
White Wolf Networks
http://whitewlf.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
I hope someone might be willing to help out.
I'm trying [still] to learn MySQL and php - to create some simply web
based database.
I have installed quite a few php/MySQL web database apps from books,
however, none of them will get data entered into my database.
When I create the database exact
99 matches
Mail list logo
