Hello, I have a large database with a lot of queries and was trying to
tune MySQL to get the best performance. I was reading the manuals and it
said to set the key_buffer_size to the best value, you take the first
two of the following values and divide by each other. I believe it said
you should g
Hello!
My tables are linked in following order:
T0->T1->T2->T3
T0->T10
Haw I can delete a record from T0 and, of course, all dates linked from
T1, T2, T3 and T10?
Thank you,
Cristi
-
Before posting, please check:
http://w
Hi, I get trouble with redhat 7
i compile the rpm source with this command
rpm -bb MySQL-3.23.32.src.rpm
then I install the binary rpm.
when I run mysql, i get problem with show tables and show databases. it
return some rows, but the contents is none.
mysql>show databases;
Databases
++
|
Thanks for the info..it's working great here now.. Had to boot the windoze
to get it right.
Next I just have to get my ASTA Server and Client hooked in and I am good to
go..did a small test and it seemed to be fine
If anyone happens to be Delphi type go to
http://www.astatech.com/support/server
There are no DB defined space limits on MySQL Databases ?It's dangerours .How to
control
the database space on my database user?
Hi all
I find out that the performance of Heap table seems bad than MyIsam table.
of course, MyIsam table usually on the H.D., so it will slow down
because of I/O.
but i do a test. I mount a memory disk on FreeBSD
and update/inser a table. I find out that would faster
than use Heap table with t
Hi.
On Thu, Feb 15, 2001 at 09:25:56PM -0800, [EMAIL PROTECTED] wrote:
>
> > Could you please post the result of "EXPLAIN" for both queries and "SHOW INDEX
>FROM album_by_city".
>
>
> I haven't used EXPLAIN before.
Just put it before the SELECT in your query. I don't know whether this
will w
"Ashley M. Kirchner" schrieb:
>
> Shawn Boedecker wrote:
>
> > I just wanted to confirm that MySQL is supported on RedHat 7. I saw
> > references to RedHat 5.x and 6.x on the website but no references to RedHat
> > 7.
>
> I'm running the latest stable release under RH7 with no problems.
>
Benjamin Pflugmann wrote:
> > Or, should I drop Linux and go with Windows CE, or some other RTOS?
>
> Well, I am biased there, but I would really avoid Windows. ;-)
>
> Other RTOS are probably a good idea, as someone else already said.
>
> > Or, should I stop being a software developing and be
Hi.
On Thu, Feb 15, 2001 at 03:53:39PM -0500, [EMAIL PROTECTED] wrote:
> 15/02/01 15:14, Quentin Bennett, [EMAIL PROTECTED]:
[...]
> > Adding the author to the query means that the query now has to go to the
> > data file to get the information, and since there is no restriction on isbn,
> > the
I have got the same confg and works perfect. WinNT & Linux MySQL.
Why dont U directly edit the user table of mysql DB.
Let Host be '%' and give some username & password.
mysql> insert into mysql.user
values('%','username',password('passwd'),'Y','Y','Y');
For test purpose let all priv field
Hi.
On Thu, Feb 15, 2001 at 02:00:04PM -0500, [EMAIL PROTECTED] wrote:
[...]
> Can they (MySQL / Linux) work in such an environment, continuously, without
> error or failure, or requiring operator intervention, for years on end?
Well, I see no principle problem here. The servers I administer run
> Could you please post the result of "EXPLAIN" for both queries and "SHOW INDEX FROM
>album_by_city".
I haven't used EXPLAIN before.
There are indexes on each column.
> And, for how much cities does this gets executed?
There are about 100 cities or regions that are used for ranking.
> Ad
Hi All
Where are some good tutorial sites for beginners in the MySQL World. I read
the man pages as sugested but I am stuck on the GRANT HOST issues. I am
connecting my NT MyODBC to my LINUX's MySQL Server.
I tried
mysql> GRANT ...
ON *.*
TO myusername@"%100.100.100.1"
Hi.
Could you please post the result of "EXPLAIN" for both queries and
"SHOW INDEX FROM album_by_city".
And, for how much cities does this gets executed?
Additionally, I would be interested, if you used the same method with
Oracle or another. If so, would you please post it, too.
Bye,
In the last episode (Feb 15), [EMAIL PROTECTED] said:
> I have a customer that is running on a Netware network. They do have
> the TCP/IP protocol running on the workstations that are using the
> Microsoft Client for Netware. I am planning to attach a SCO
> Openserver 5.0.5 Unix server running M
Hi.
On Wed, Feb 14, 2001 at 03:28:23PM -, [EMAIL PROTECTED] wrote:
> >Description:
> Upgrading from 3.22 to 3.23 with a field having a reserved name
> ALTER TABLE barfs and doesn't let me do
> ALTER TABLE casualties CHANGE when cas_when DATE NOT NULL;
ALTER TABLE casualties CHANGE `when` cas
Hi.
You know, this question is off-topic on the MySQL list.
On Wed, Feb 14, 2001 at 09:54:44AM +, [EMAIL PROTECTED] wrote:
> Hi folks,
>
> I am trying to compile a simple program to play with mysql. But i am
> running into single problems, but i guess easy to solve by too many of
> the wiza
thanks for your help,
i have read the vararies through mysqld,
there's no the varary defining the max_space of a certern database.i think it's
important defect in mysql.
i can define how much space will be dispensed to a database,and show how much
space have been used to my database u
At 19:49 15/02/2001 -0700, Mike wrote:
Hi!
First read the MySQL Manual about the GRANT/REVOKE commands and
How the privilege system works on MySQL. Here you will learn
how the MySQL grant tables handle the client machine (IP number or DNS or
localhost when you are connecting the server locally),
> "MK" == Mikel King <[EMAIL PROTECTED]> writes:
MK> guys I think you are making this a way bigger problem than it
MK> really is...e-merce crap is generally taxed based on the location
MK> of the vendor; much the same way in which mail order businesses
MK> are taxed. You really only have to w
Everytime I try and connect to MySQL Server I get Host then it's IP address
is not allowed to connect to this Server..
Where can I get more info for a newbie to do this..
Cheers
Mike
/'^'\
If you wish to continue to receiving our FREE "Stock Pick" newsletter, you must click
here:
http://www.actionstocks.com, and enter your
email address. Otherwise, you will not receive any future updates.
Cyber Digital, Inc. - OUTLOOK
Overview
Cyber Digital, Inc. (OTC BB: CYBD) is a leading ma
On Thursday 15 February 2001 18:50, Rodolfo Sikora wrote:
>Does this problem exist in 3.23.32??
>
>
>
>>
>>Thanks for the bug report. The problem is a bug in the code that skips
events
>>when it sees a log entry with the same server id - something that can only
>>happen in the bi-directional re
I've setup MyODBC (Win98) so I can access a MySQL db from Excel. It works
fine, except that everytime I refresh the data, I get the MyODBC prompt,
even when I select the option "Don't Prompt on Connect". This is kind of
anoying, as I need to execute well over 700 queries.
Anybody have any ideas?
What about repairing the table and what does DESC tablename say?
- Original Message -
From: "Laszlo G. Szijarto" <[EMAIL PROTECTED]>
To: "Ryan Wahle" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, February 16, 2001 3:20
Subject: Re: SQL executes on command-line but not in PERL
Hi,
U can do nested ifs in Mysql.
I am not sure if there is a limit in the no of levels it can go upto.
If U R going to do this for 1000's of records there may be a slight drop in
performance.
SELECT field1, if(field1="a",100,if(field1="b",200,"ERROR")) FROM table;
will do perfect.
Cheers!
Hi,
Look in the manual under Flow Control functions for use in select
statements, and you should find what you need.
Regards
Quentin
-Original Message-
From: John Halladay [mailto:[EMAIL PROTECTED]]
Sent: Friday, 16 February 2001 12:32
To: MySQL List (E-mail)
Subject: If, then, else .
Does this problem exist in 3.23.32??
>
>Thanks for the bug report. The problem is a bug in the code that skips events
>when it sees a log entry with the same server id - something that can only
>happen in the bi-directional replicaiton setup. Fix:
>
>--- 1.85/sql/slave.cc Sat Jan 27 15:33:
*
I left out a piece of probably important information the first time:
search_messages_archive contains 11.5 million records.
messages_archive contains 760,000 records.
Thanks.
-karl
**
If I am querying a field that has either "a" or "b" as a value and I want a
second field's value to be dependant on the first field's value, how would I
right that?
SELECT field1, IF(field1="a",100,IF(field1="b",200,"ERROR") FROM table;
The IF,THEN,ELSE is the only thing I can think of, but that
Also some states, like California, base their sales taxes for mail-order on the
recipients postal code, not the vendors, unless the codes are the same. There are
eight or nine different sales tax rates in CA depending on local taxes.
Mike Wexler wrote:
> Mikel King wrote:
> >
> > guys I think yo
Shawn Boedecker wrote:
> I just wanted to confirm that MySQL is supported on RedHat 7. I saw
> references to RedHat 5.x and 6.x on the website but no references to RedHat
> 7.
I'm running the latest stable release under RH7 with no problems.
(NOTE: I compiled it myself, instead of using
Hi,
I am trying to install the latest distribution of mysql on a win 2000
box. The install program returns the following error each time:
"An error occurred during the move data process -132"
I noticed that someone else has brought up the same problem in the
past on this list. I'm very curiou
Most of my clients get around this problem by incorperating the web side of
the business under a different name. There have typically been two reasons
for this; 1. it circumvents the tax issue. 2. if the web business encounters
legal troubles et cettera...they can go belly up w/o affecting the cor
Mikel King wrote:
>
> guys I think you are making this a way bigger problem than it really
> is...e-merce crap is generally taxed based on the location of the
> vendor; much the same way in which mail order businesses are taxed.
> You really only have to worry about the state/locality in which
Bob Hall writes:
>>What I want to do is something like this...a set variable in a table
>>has a current value of "a,b,c" and I want to add the value "d" to it
>>so the new value is now "a,b,c,d". The type is already defined as
>>setval SET ('a', 'b', 'c', 'd', 'e', 'f')
>Ma'am, by variabl
Duh why didn't I think of that.
Thank you graciously. :)
> -Original Message-
> From: Quentin Bennett [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 15, 2001 4:26 PM
> To: 'Roger Ramirez'; MySQL List
> Subject: RE: Query/Left Join problem
>
>
> Hi,
>
> Your left join tried to find
guys I think you are making this a way bigger problem than it really
is...e-merce crap is generally taxed based on the location of the vendor; much
the same way in which mail order businesses are taxed. You really only have to
worry about the state/locality in which you are incorperated/operate fr
I have an Access 2000 Db on a Win98 system with tables linked to a MySql23.32-1
database on Suse Linux 7.0
using the latest MyODBC with a System DSN specifying anyname.dsn, the IP of
192.168.2.5 for the host, the
database name of "metrics" and port 3306. I had to setup the privileges very
carefull
Hi,
I just wanted to confirm that MySQL is supported on RedHat 7. I saw
references to RedHat 5.x and 6.x on the website but no references to RedHat
7.
Thanks,
shawn
-
Before posting, please check:
http://www.mysql.com/manu
Hi,
Your left join tried to find members in newsletter_subscriptions that don't
exist in perms.
How about they exist, but are 'No'?:
SELECT newsletter_subscription.member_id
FROM newsletter_subscription LEFT JOIN perms ON
newsletter_subscription.member_id=perms.id
WHERE newsletter_subscription.
Just wanted to say thanks to all the people that help out here. I have seen
more problems solved here than anywhere and not just on mysql. It has been
so much fun to be on this list and see everyone cooperate to get these
problems fixed.
Thanks again.
Alan Halls
Adoption.com
Webmaster
-
Thanks again, that works great. One more question.
Aside from giving it a percentage sign, how could I specify that I wanted to
see two characters after the decimal? i.e. instead of 25% I would want
25.00%
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thur
How about...
mysql> select concat(50/1432, '%') as percentage;
++
| percentage |
++
| 0.03% |
++
1 row in set (0.00 sec)
mysql> select concat(1324/4.14, '%') as percentage;
++
| percentage |
++
| 319.8068% |
++
1 row i
15/02/01 15:14, Quentin Bennett, [EMAIL PROTECTED]:
> Hi,
>
> I think you are mis-understanding the information provided. What the "using
> index" note means is that the isbn column is part of the index, and since
> that is all that is selected, the index file is used to provide the data,
> the
Hi Carlo :
You should be able to use MyODBC for windows which work with mysql
karl chen
Programmer , Information System Department
Valley Presbyterian Hospital
Tel (818) 782-6600 ext. 5141
-Original Message-
From: Carlo Macis [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 16,
PHP4.0.4pl1 does not appear to fix the "lost connections" problem as it
relates to persistent connections. It does appear to be fixed in the
latest CVS version (currently 4.0.5-dev). Just FYI.
"Ken Menzel" <[EMAIL PROTECTED]> wrote:
On the PHP errors Are you using the latest PHP 4.0.4pl1
SELECT CONCAT(data1*100,'%') as percdata1, data2, data3 FROM table;
John Halladay <[EMAIL PROTECTED]> wrote:
I can't find this in the manual (maybe I'm looking in the wrong place).
How
do I show a value as a percent? For example.
SELECT data1, data2, data3 FROM table;
Assuming data1 is 0.25
Hey folks...
quick question -- are there any performance issues associated with databases
of extremely large size?
I'm not talking about hundreds of thousands of records to be searched -- I'm
talking about a few hundred images being stored in a database. It's not like
I'd be full text searching
I have a customer that is running on a Netware network. They do have the
TCP/IP protocol running on the workstations that are using the Microsoft
Client for Netware. I am planning to attach a SCO Openserver 5.0.5 Unix
server running MySQL to their network and then use MyODBC to connect a MS
Acce
http://www.qnx.com/
Tey actually have a headline right now about BerkleyDB being ported.
While I take nothing away from the Mysql/Linux combo as a stable OS. I
would stay that a specifically designed RTOS for embeded devices might be
better in this situation.
Gregg
- Original Message
I implemented something almost identical to this setup in 1999. It worked
well with Netware 4.11 (with IP enabled on the network) and mySQL 3.22.x
running on both a Solaris and FreeBSD box. It should work fine with newer
versions of Netware controlling the network. There are the standard
integ
Hi,
I think you are mis-understanding the information provided. What the "using
index" note means is that the isbn column is part of the index, and since
that is all that is selected, the index file is used to provide the data,
the data file is not touched. Since there is (usually) less data in t
Actually its even more complicated than this. There are city taxes and
other taxes on other boundaries. In addition the rules as far as what
things are taxable vary by locality. For example, some localities charge
taxes on shipping and others don't.
Brady Orand wrote:
>
> This is not as easy (c
Hi Dan:
I am looking for solution now , please email me if you get the
answer
karl chen
Programmer , Information System Department
Valley Presbyterian Hospital
Tel (818) 782-6600 ext. 5141
-Original Message-
From: Daniel Kirk [mailto:[EMAIL PROTECTED]]
Sent: Thursday, Februa
Hi :
Yes , you first import access into a flat file , modify it to a SQL
format (you can write a pascal or c program to
automate this procedure) , and then upload this file to your server . using
mysqldump database_name -u username -p < access_flat_file
karl chen
Programmer , Information S
Hi there.
I'm having a problem with a couple of tables I'm using and finding some
missing records and I was hoping someone could help me.
Here is the setup.
I have a table that is called "perms". Within here I have a bunch of
columns, only 2 of which are important.
ID which is an auto incremen
Mark:
You can either load perl module and use perl/cgi , or install php with
mysql module enabled
karl chen
Programmer , Information System Department
Valley Presbyterian Hospital
Tel (818) 782-6600 ext. 5141
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Se
couldn't you just do:
SELECT data1 * 100 FROM table;
which if data1 is 0.25, you'd get a result of 25, and depending on what
you're using for the frontend, it would be really easy to add on the
percentage sign
- Atle
On Thu, 15 Feb 2001, John Halladay wrote:
> I can't find this in the m
Hi,
There are no DB defined space limits on MySQL Databases or tables unless
explicitly defined using the table_options value max_rows. Your space is
only limited by available disk space or, possibly, the space limit set for
the 'user' that runs mysqld.
Hope this helps
Quentin
-Original Me
Hi Alan,
Sounds like you need to do some tuning, you are running MySQL low
on resources. This is one situation MySQL does not handle well. You
need to adjust the login class to have more memory for instance you
could create a class named "sql" and place it in your login .conf,
then use vipw
I've been having a problem for quite awhile now with a particular query
sometimes taking a long time. The query in question is a web-based
search for messages in a bbs archive. Every time a message is added to
the bbs each word in the message is parsed out and added to the
'search_messages_archi
Thank you, Ryan,
but the PERL code runs perfectly if I try it on any other field. It just
doesn't run on THIS field. It's not a SPECIAL field in any way (like PRI
Key or Unique or anything like that). When I run it in a compound statement
like
"update accounts set users=10, loggedin=10 where u
Hi,
I'm having a hard time figuring why mySQL does not use the index when
sorting a table without any where clause when I include more than 1 field in
the select part. To resume the case, I created a temp table with 3 single
fields, added an index (see bottom for more details), ran 2 queries with
NuSphere has been asked to chair the MySQL track for the
upcoming O'Reilly Open Source Conference (July 23-27 in San
Diego, CA) and the deadline is virtually here -- decisions
must be made by next Tuesday, Feb. 20. This is very short
notice but we need your input by end of day tomorrow, Feb.
16.
Hi!
I've been monitoring this list for a while now (re: lurking), I've seen only
passing comments about embedding MySQL, so I thought I would come out and
directly ask the MySQL community for your opinions, or better yet, actual
facts - based on experience.
I am evaluating MySQL / Linux for use
Hello,
I have a high volume database driven website run on apache webservers using
php and mysql.
I am using mysql_connect() to establish the connection from the web servers
(there are 2) to the db server. The servers are all in the same location,
with a private network set up between them. I
I'm moving over a music play database from Oracle to MySQL. So far MySQL is faster for
all reports except this one where Oracle takes 8 seconds & MySQL will take 108 with my
current method.
I have a big table of times that an album is played like so :
album_id INT,
total_plays INT,
date DAT
you probaly don't have your code setup correctly. put some of the perl
code that does the statement to let us help you more.
On Thu, 15 Feb 2001, Laszlo G. Szijarto wrote:
> Hi, everyone,
> I've recently run into a strange phenomenon.
>
> I try to tun the statement "update accounts set loggedi
> --
> From: Entryon Corp., Chief Technical Officer - P.
> Hasenfratz[SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, February 15, 2001 12:13 PM
> To: mysql EN
> Subject: user variables length
>
> How many Bytes can I save in a user variable?
>
> Because I have the fol
This is not as easy (conceptually) as it sounds. You have to know the
current state tax plus any county taxes applicable. If you set up a table
with this information, you can cross reference the location of the buyer
with the table, calculate the appropriate taxes, and charge them
according
Dear Sir,
I have a Red-hat Linux6.2 . And i have installed MySql -3.23.32 server. It installed
successfully. now when go to install MySql-3.23.32.rpm it doesn`t install, same for
MySql-devel-2.32.32 it also doesn`t install.
And also tell em how to Uninstalled .rpm.
Pls reply me asap.
Regards,
I can't find this in the manual (maybe I'm looking in the wrong place). How
do I show a value as a percent? For example.
SELECT data1, data2, data3 FROM table;
Assuming data1 is 0.25, how do I show it as 25%?
SELECT PERC(data1), data2, data3 FROM table;?
Thanks.
John Halladay
-
I have a customer that is running on a Netware network. They do have the
TCP/IP protocol running on the workstations that are using the Microsoft
Client for Netware. I am planning to attach a SCO Openserver 5.0.5 Unix
server running MySQL to their network and then use MyODBC to connect a MS
Acce
On Thu, 15 Feb 2001, Jay Lawrence wrote:
> Atle, your suggestion is for the last time a record was updated. I am
> interested in the entire table.
A temporary workaround could be select max(timestamp) from sometable.
Jan
-
Be
How many Bytes can I save in a user variable?
Because I have the following strategy:
I want to save all PrimaryKeys in a user variable
SELECT @a:=' ';
SELECT @a := CONCAT(@a, ', ', TPrimKey) FROM table WHERE ;
so it is very important to know how many bytes can be stored.
regards
Philipp Has
Hi, everyone,
I've recently run into a strange phenomenon.
I try to tun the statement "update accounts set loggedin=10 where username='user'" --
works fine from the command line. But I used it in a PERL DBI situation and it does
NOTHING -- no error, nothing. I know the PERL code is fine, beca
Hello,
We created a database in mysql and would like to know if there is any
way to access them through a Web browser using Apache?
Thanks for your help
Mark
-
Before posting, please check:
http://www.mysql.com/manual.p
Save to a CSV (comma-delimited file) from Excel, and take a look at the
"load data infile..." command within the mysql documentation.
regards,
P
On
Thu, 15 Feb 2001, Joe Ferrara wrote:
> I am not a Perl Guru. How would I set up this environment? Or is there
> another way to go from excel
Hi,
I am running a PIII 733 with 256 MB Ram and the mysql server keeps locking
up. I go into the "top" program and the mysql process is taking up 95-98% of
the processor and continually has to be killed and restarted. We are running
on an BSDI4.2 / Apache server using PHP pages, I am not u
Within the last few days we've started having serious problems with our
database. We have no problems connecting to it using "mysql" and
"mysqladmin". For instance, this command lets us into the database just
fine:
mysql -ucustomer -p customer_database
The database seems to be working correctly
mysqladmin create newdatabasename
mysqldump olddatabasename | mysql newdatabasename
Of course you'll need the usual username/password parameters as well.
On Thu, 15 Feb 2001, Joe
Ferrara wrote:
> I want to make an exact duplicate (differenet name) of my entire DB for
> test purposes. My DB
I believe so. I was trying that and was missing something because I could
not get it to work.
Dave Hodgkinson wrote:
> kentj <[EMAIL PROTECTED]> writes:
>
> > I have been reading the mysql book by Dubois and trying to figure out
> > how to implement his restart methods
> > on a SUSE Linux 7.0 Bo
In article <000d01c0975e$08f57d40$[EMAIL PROTECTED]>,
"Ali" <[EMAIL PROTECTED]> writes:
> Hello,
> does anybody know why the following statement does not work when it contains
> "IF NOT EXISTS"
> CREATE TABLE IF NOT EXISTS tab_name.
> This is given in the manual but it does not work in this c
Hi,
We would be very interested in the possibility to link our application to
mysqld library.
We wanted to know if some concurrency will be managed to provide data
integrity if two instances of my application are working at the same time...
If not, is there a possibility to do it or do I just hav
Hi;
I have mysql-server-3.23.22.6 and mysql-3.23.22.6, pakages
installed on my PC during Linux RedHat 7.0 installation.
The probleme occurs when starting mysqld program :
The command :
mysql_install_db
is OK
but the command :
safe_mysqld
starts the server mysqld witch stops immediatly after.
W
I am not a Perl Guru. How would I set up this environment? Or is there
another way to go from excel to MySQL?
--
Joseph Ferrara
Member of the Engineering Staff
LOCKHEED MARTIN
Naval Electronics & Surveillance Systems
-
I want to make an exact duplicate (differenet name) of my entire DB for
test purposes. My DB is not too large 8 tables, about max 200 records
in any table. What is the best way to do this?
--
Joseph Ferrara
Member of the Engineering Staff
LOCKHEED MARTIN
Hi,
I'm trying to do a select in a table an want to get the result ordered by a
column 8col2) of type FLOAT.
select col1,col2 from table where col1='vvv' ORDER BY col2;
It does not work.
Is this supposed to work and if so how should I do it.
/Pelle
-
Hi !
I have two servers in a co-master relationship
between an ISDN router. When I shutdown the router
(so the connection is down), the slave thread doesn't
react. On the show processlist, I have reading master
update even if the connection is lost. Why ?
It's a problem because on the other serv
Atle, your suggestion is for the last time a record was updated. I am
interested in the entire table.
The closest that I have seen thus far is:
SHOW TABLE STATUS
The Update_time field is most likely what I am after.
However I was hoping to do something more like
select Update_time from
At 18:13 15/02/2001 +0800, Li Sze wrote:
Hi,
I had connected a Win2k machine against a Linux Server using
MyODBC but I don't remember if it was before or after the use
of the encryption feature of Samba on the Linux Server. How
you know Win2k machine only uses the encryption authentication.
So I g
Hello,
does anybody know why the following statement does not work when it contains
"IF NOT EXISTS"
CREATE TABLE IF NOT EXISTS tab_name.
This is given in the manual but it does not work in this case. Any hint is
appreciated.
Ali
---
yindu wrote:
>
> hello,sir;
> i do know i can use "show tables" to get the table names list.but i need get a
>table name
> array to use in my application.like the array
> i get by "select" function .
> how can i do it?thank you!
> yin du
"show tables" returns a
Teddy A Jasin wrote:
>
> Hi All,
>
> Currently I have four websites using one MySQL server. The MySQL and the four
>websites
> each is placed on different server.
> However this MySQL server, I dont know why after running for a few days can
> stop responding that I have to restart the MySQL ser
Hi:
the way I handle this situation is:
"create temporary table if not exists tblName (somefld I need, etc.) select
iptable.* (or field names) from myTable where bluemoon = yes"
Works every time for me. You need to know that temporary tables are only
available to the creating user during the s
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e
Sir, 99% of the time, if someone can't create a TEMPORARY table, it
means that they're using an earlier version of MySQL that doesn't
support temp tables. The best thing to do is to update to the most
recent version. If you can't update (e.g. if MySQL is being
maintained by a web hosting servi
Sir, haven't you posted this before? It looks familiar.
You can't apply an aggregate function to an entire table if the
SELECT statement has a GROUP BY clause. The aggregate function will
return totals for the groups, not for the entire table.
Bob Hall
>Can someone help me combine this statem
1 - 100 of 125 matches
Mail list logo
