 | | | MySQL General | | I am trying to drop several InnoDB and am unable to do
so. I login to the command line client and enter "drop
database [db_name] " and then get this error
ERROR 1217 Cannot delete or update a phi all!
i was wondering whether anybody has encountered the same situation i am
with and how you deal with it
i 've got several mysql servers running in various locations (all
connected byAre nested IF statements valid? Doesn 't say anything here
http //www.mysql.com/doc/en/Control_flow_functions.html
Trying to get a conditional count using the following statement - but Im
receivMark wrote
>Hello
>
>I am long since using MySQL 3.23.58 and it works perfectly. In fact it
>works so well that I have always been very hesitant to upgrade to the 4.x
>series. Especially Check out DISTINCT.
Respectfully
Ligaya Turmelle
" "Clive Luk " " <clive@(protected) > wrote in message
news 00e301c412bb$022b8f50$cd0010ac@(protected)
> Use
>
> Select * from a
> Group by [Ed Reed wrote
>Thanks Jeff
>
>After a little more investigation it turns out that the problem only
>exists when I run the query through a MS Access database attached to
>MySQL via ODBC. If I
Hi!
I assume most of you know that we will have our annual MySQL User
conference at April 14-15 in Orlando.
During the conference we will give a lot of information about new
MYSQL features t
Are you assuming that all months have 30 days? You can use the same syntax
with INTERVAL 1 MONTH
I would also format the date comparison to use the same precision that the
DATE_ADD function outp >I have a table of properties that is linked to a table f images with a one
property to many images relationship. I >have manged this with nested
queries but want to try and do it on one line. My curHi there
I am running a website on a host who has blocked access to mysqldump.
Is there any way I can show all the sql commands for creating and
populating a table from within mysql? Again I dDear all
My system specs are Sun Solaris 8. As I do not have root permission is it
possible to install mysql locally in my home drive ? I checked the manuals
but there does not seem to answer mMarc
please send the printouts to me.
Best regards
Heikki Tuuri
Innobase Oy
Foreign keys transactions and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB w "Bing Du " <bdu@(protected) > wrote
> Greetings
>
> I did
>
> mysql > grant all on LTM.* to ltm@(protected) identified by 'secret '
>
> But
>
> mysql > select * from user where user 'ltmuserHi
I would appreciate help on the following.
I have a column in a table. Each entry in the column can
have 0 1 2 3... maybe four entries in it.
I would like to parse the column and grab each Hi
I want to perform a mysqldump (with the --add-drop flag) of an entire
database that excludes 1 specific table only (named 'phpbb_config '). Can
anyone supply the mysql for this?
I know I c
On 25 Mar 2004 at 15 23 joe collins wrote
> Hi
>
> anyone know what happens if while I am doing a database dump someone
> logs
> into the database and updates records what records areSorry if this is an obvious question but is version 3.23 still supported by
MySQL AB. And if it still is is there a date when it will not be.
One of our systems uses it but the users are not conv Was wondering if anybody knows if there are advantages to using
"mysqladmin -pPassword shutdown " compared to "/etc/rc.d/init.d/mysqld
stop "? I have a script that was using mysqladmin to shutdownFirst full text indices have nothing to do with importing the data
it 's just a special type of indexing for searching. The reason you got
several rows is that you probably did not specify delimiThorsten
> i write a front-end in vb.net and want to save data`s out of a text field
> into a MySQL database.
> But i have trouble with this.
On http //www.vbmysql.com/articles you will findgowthaman ramasamy <gowtham@(protected) > wrote
> hello list
> this is a MySQL realted question
>
> I have a mySQL table with 15 columns. I query that table and group
> (using GROUP_CONYou need to set a user in MySQL with privileges to that database. From the
mysql console
mysql > GRANT <options > ON <database_name >.* TO <user >@ '217.219.201.2 '
IDENTIFIED BY 'password ' USING GRAN
On 25-Mar-2004 doug@(protected) wrote
> Not using perl or php I came up with
>
> mysqlshow -u user --status db_name | awk -F "| " '{print $2 $5} ' | grep
> -i pattern
>
> Is there a query toBonjour Samana
I will write in english for the list and then french for Samana.
His problem is that he is not supplying a valid user and password.
Je vais ?crire en anglais donc fran?ais.
At 17 55 -0800 3/24/04 Jim Richardson wrote
>I have a rather heavily loaded server which I would like to tweak a
>little more performance out of. It currently is binlogging although
>there is noAt 21 44 -0400 3/24/04 WebMaster Inform?tica007 wrote
>Hi
>
>
>
>I have problem with a Query.
>
>
>
>It does not recognize EXISTS.
>
>
>
>My version is MySQL 4.0.11a-gamma
Subqueri "Ed Reed " <ereed@(protected) > wrote
>
> yea I thought it would be that easy too but it doesn 't work.
It should work.
Did you get error message?
>
> Any other ideas?
>
> > > > "Peter
Chip Wiegand wrote
>When running mysql from the command line (Putty terminal) and trying to do
>some updates the updates fail. First the query I am running -
>
>mysql > update warranty_tempArvind Gangal wrote
> I have been using the mysqlbinlog to investigate the 'saturn2-bin.051 '
> binlog file.. I have come to pinpoint the problem position in the binlog
> but don 't know how i can Consider the following schema and data
CREATE TABLE person (pid INTEGER name CHAR(5))
CREATE TABLE phone (pid INTEGER num CHAR(10))
INSERT INTO PERSON VALUES (1 'Bob ')
INSERT INTO PERSO |
|
|
