http://dev.mysql.com/doc/mysql/en/mysql-config.html&e=9888
If you have questions, try http://dev.mysql.com/doc/mysql/en/index.html
first as you will often find the answer there. BTW this manual is for the
latest version that you are using.
> Hi,
> Iam using Mysql5.04
> What does it mean,
>
> "To
Nevermind. I figured it out. It somehow corrupted the db table in the
mysql db. I blew that away and recreated it with just root access to all of
the dbs and it works now.
First I would like to start off by saying I am a complete noobie to MySQL.
I have MySQL 4.0 running on a freebsd machine
I recently exported a large Access database to MySQL using MyODBC.
It took me a while to figure out that MyODBC was the thing to try, but once I
did tried it, it only took me a few minutes to do the export. I highly
recommend that approach (MyODBC).
-Eric
> Original Message-
Hi,
to convert '16.00' to 16.00, you can use select '16.00'+0
mysql> select '16.00'+0;
+---+
| '16.00'+0 |
+---+
|16 |
+---+
1 row in set (0.08 sec)
for ur columns, select col+0 from tbl;
Mathias
Selon Jerry Swanson <[EMAIL PROTECTED]>:
> I need to change format
Hi,
Anybody have any experience with setting up MySQL replication with
dynamic failover, preferably using keepalived (http://www.keepalived.org)?
What we need is a system so that if the master server dies one of the
slaves will become the master.
It looks like it should be possible, and merely
Hi ,
look at prepared statement :
http://dev.mysql.com/tech-resources/articles/4.1/prepared-statements.html?rated=0
Mathias
Selon weetat <[EMAIL PROTECTED]>:
> Hi all ,
>
>I need to pass paramter to mysql script , for example , my script ,
>
> INSERT INTO SYSTEM_PARAMETER_TABLE
> (bran
Hi,
Iam using Mysql5.04
What does it mean,
"To install the mysqli extension for PHP, use the
--with-mysqli=mysql_config_path/mysql_config
configuration option where mysql_config_path
represents the location of the mysql_config
program that comes with MySQL versions greater
than 4.1."
in this,is
First I would like to start off by saying I am a complete noobie to MySQL.
I have MySQL 4.0 running on a freebsd machine. All was fine and dandy till
I tried to connect to it using the W32 MySQL Administrator tool. Now if I
try and execute a script against it I get "DBI connect failed : Access
Hi all ,
I need to pass paramter to mysql script , for example , my script ,
INSERT INTO SYSTEM_PARAMETER_TABLE
(branch_code,param_name,station_id,param_value)
VALUES(?,?,?,?)
Anybody have any ideas how to do that ?
Thanks
- weetat
--
MySQL General Mailing List
For list archives:
Richard Dale wrote:
Over the last week I added in lots of comments pasted in from various
places. I'd appreciate those running with Opteron and MySQL to have a close
look at the WIKI and make any amendments/suggestions.
http://hashmysql.org/index.php?title=Opteron_HOWTO
My Opteron server will be h
You can try a freeware utility you can find at:
http://www.bullzip.com//products.php (I have tried it and works quite well)
Additionally you could use DBDesigner (www.fabforce.com) and make a reverse
engineer of you database and export it to a Sql file.
Hope this help you.
Best regards,
Alvaro
2005/5/17, Kristen G. Thorson <[EMAIL PROTECTED]>:
> I actually had something similar to this at one point, but I never got it
> working. Your query returned 148 rows, which I can tell you right away
> can't be right since there are only 130 items in `page`. I believe the
> problem is that it do
Over the last week I added in lots of comments pasted in from various
places. I'd appreciate those running with Opteron and MySQL to have a close
look at the WIKI and make any amendments/suggestions.
http://hashmysql.org/index.php?title=Opteron_HOWTO
My Opteron server will be here shortly and I'
I need to change format from varchar(10) to decimal.
When I alter the table the data is trimmed.
What I'm doing wrrong?
TH
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Philip Denno wrote:
I'm no database expert, so I may be wrong but I do not think this
functionality exists. Usually this type of notification is handled at
the application level. That is build an application layer on top of the
database which handles all reads and writes to the database. This layer
Hi,
logbin can help you to track transactions and then write your notification code.
trigger in mysql 5.x will help you a lot (v5 in still in beta state now).
Mathias
Selon Philip Denno <[EMAIL PROTECTED]>:
> I'm no database expert, so I may be wrong but I do not think this
> functionality exis
Hi Scott,
I show you timestamp usage, but there is also datetime and date. you can read
detailled infos at :
http://dev.mysql.com/doc/mysql/en/datetime.html
mysql> create table items(itemRef varchar(10), dat timestamp default
current_timestamp);
Query OK, 0 rows affected (0.20 sec)
mysql>
mysql>
I'm no database expert, so I may be wrong but I do not think this
functionality exists. Usually this type of notification is handled at
the application level. That is build an application layer on top of the
database which handles all reads and writes to the database. This layer
would also keep tra
Hello,
I would like to do the following: I am creating a site where people can add
items to a cart. In order to keep items for [X] amount of days, I would like to
create a database table in mysql to hold a 'itemRef' and a 'Date'. Then in a
relationship table I can hold the 'itemRef' and 'items'
I actually had something similar to this at one point, but I never got
it working. Your query returned 148 rows, which I can tell you right
away can't be right since there are only 130 items in `page`. I believe
the problem is that it doesn't take into account that a page may be a
child page
Shawn,
Thanks so much, this is exactly what I was looking for. I was having
trouble getting the condition (page_links.page_id=6) in the right
place. I had gotten as far as
SELECT page.page_id, page_keyword
FROM page
LEFT JOIN page_links
ON page.page_id=page_links.child_id
WHERE page.page_id<>6
2005/5/17, Kristen G. Thorson <[EMAIL PROTECTED]>:
> I am moving some code that was developed against MySQL 4.1 to a server
> with 3.23, and I have one query that uses a subquery. I'm having a bear
> of a time wrapping my mind around how to convert this. The original
> query is this:
>
> SELECT
"Kristen G. Thorson" <[EMAIL PROTECTED]> wrote on 05/17/2005
02:37:12 PM:
> I am moving some code that was developed against MySQL 4.1 to a server
> with 3.23, and I have one query that uses a subquery. I'm having a bear
> of a time wrapping my mind around how to convert this. The original
Atle,
Thank you for your help
Mikhail Berman
Ives Inc
(508)476-7007 ext.27
[EMAIL PROTECTED]
-Original Message-
From: Atle Veka [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 17, 2005 1:16 PM
To: Berman, Mikhail
Cc: mysql@lists.mysql.com
Subject: Re: Is there a way
SELECT ... INTO OUTF
I am moving some code that was developed against MySQL 4.1 to a server
with 3.23, and I have one query that uses a subquery. I'm having a bear
of a time wrapping my mind around how to convert this. The original
query is this:
SELECT page.page_id, page.page_keyword
FROM page
WHERE page.page_id
Hi,
Where should I look to find information about
having clients notified when a table/record is
updated?
I have a situation where multiple clients will each
have an open database connection, and I would
like for them to be notified when the database is
modified by a member of the group.
Somethi
On Tue, 17 May 2005 17:17:31 +0100
"S.D.Price" <[EMAIL PROTECTED]> wrote:
> Hi,
> can anyone explain how I would export a database created in Access
> to MySQL using PHPMyAdmin - I can't seem to import the data as csv
> or txt.
Acess should allow exporting to CSV. Otherwise you can skip
phpMyAdm
SELECT ... INTO OUTFILE 'filename' export_options':
http://dev.mysql.com/doc/mysql/en/select.html
The 'export_options' are the same as this syntax:
http://dev.mysql.com/doc/mysql/en/load-data.html
That may work for you.
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
On Tue, 17 May 200
>> It may not be. Do you specify this file when you start the server on
>> the command line? If you don't then you need to move my.ini to the
>>windows directory:
You are quite right. When I moved the my.ini file to c:\windows it worked.
I assumed that it would work 'cos the mySQL installer c
Thanks everyone!! It was just a typo and everything was updated :(
That's okay, I got my Admin guy to restore backup files. I'll just
Have to get in the habit of using commit and rollback.
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 17, 2005 10:1
Adam Lipscombe wrote:
I have MySql 4.1.12 installed on an XP box in C:\mysql.
I have the settings below in my C;\MySql\my.ini file:
I have the transaction-isolation set to READ-COMMITTED but the server seems
to ignore this.
When the server starts up the tx_isolation as reported by mysqladmin
extend
Adam Lipscombe wrote:
I have MySql 4.1.12 installed on an XP box in C:\mysql.
I have the settings below in my C;\MySql\my.ini file:
I have the transaction-isolation set to READ-COMMITTED but the server seems
to ignore this.
When the server starts up the tx_isolation as reported by mysqladmin
extend
Hi,
can anyone explain how I would export a database created in Access to
MySQL using PHPMyAdmin - I can't seem to import the data as csv or txt.
Thanks
Steven
NNGau,
It works because 'where invoiceid-12217' is true for every invoice
except invoice 12217.
To undo it, assuming your server is running a binary log, back up the
table in its current state to a safe place, restore the most recent
backup of the table, then run mysqlbinlog for that database (
I have MySql 4.1.12 installed on an XP box in C:\mysql.
I have the settings below in my C;\MySql\my.ini file:
I have the transaction-isolation set to READ-COMMITTED but the server seems
to ignore this.
When the server starts up the tx_isolation as reported by mysqladmin
extended-status is REPEATA
[EMAIL PROTECTED] wrote:
Help! I did this query and it updated everything!
update customer_order_history set customerID="123 456 789 0123" where
invoiceid-12217;
WHERE expects an integer (and will convert other types to an integer).
0 is false, null is null, everything else is true. Hence, "WHERE
Are your php scripts by any chance called phpWebSite? If so, you might
find more help here:
http://www.phpwsforums.com/
What you're getting is almost definitely a PHP script catching some kind
of error trying to connect to the database server. You should have a
file called configure.php or so
Thankyou,
That worked a treat! Thankyou so very much
--
David Scott
- Original Message -
From: "Michael Stassen" <[EMAIL PROTECTED]>
To: "Critters" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, May 17, 2005 5:01 PM
Subject: Re: A question of joining...
Critters wrote:
Hi,
I am having problems
Hi,
your query updates all the records where invoiceid != 12217
That's the same than :
update customer_order_history set customerID="123 456 789 0123" where
invoiceid != 12217;
because invoiceid-12217 !=0. It's so true.
have you a backup if the command is old (no flashback query in mysql) ?
Mat
Critters wrote:
Hi,
I am having problems with the JOIN function.
MESSAGES
memberID_1, memberID_2, Message
MEMBERS
id, name
I can only manage to replace the "memberID_1" in MESSAGES with the "name" in MEMBERS, I
can not replace both memberID_1 and memberID_2 with "name".
Please can someone tell me
Hi,
I am having problems with the JOIN function.
MESSAGES
memberID_1, memberID_2, Message
MEMBERS
id, name
I can only manage to replace the "memberID_1" in MESSAGES with the "name" in
MEMBERS, I can not replace both memberID_1 and memberID_2 with "name".
Please can someone tell me what I shoul
Help! I did this query and it updated everything!
update customer_order_history set customerID="123 456 789 0123" where
invoiceid-12217;
I typed a '-' rather than an '='.
I haven't did a commit or a rollback saving point. Is there any other
way To undo this update??
Thanks.
--
MySQL Gener
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have a query where I am fetching, in my test 68, rows. Using OR was
faster by about 1.5 times, than the same query using IN. Should this be
expected, using mysql 5.0.4, on Solaris 8, java 1.5.
SELECT name, id FROM table WHERE idx=? OR idx=? OR idx
Dan,
Have you tried LOAD INDEX INTO CACHE? See
http://dev.mysql.com/doc/mysql/en/load-index.html
Mike
At 09:06 AM 5/17/2005, Dan Salzer wrote:
So I don't think this is a mysql issue, but I wanted to bounce it off the
group anyways and see if anyone had seen similar behavior.
I'm running
On 5/17/05, Jigal van Hemert <[EMAIL PROTECTED]> wrote:
> From: "Rod Heyd"
> > Tables Version_(1-5)
> >
> > --
>
> > ID |PRODUCT_ID |DATA1 |DATA2 |DATA3 |.|DATA_N |
> > -
So I don't think this is a mysql issue, but I wanted to bounce it off the
group anyways and see if anyone had seen similar behavior.
I'm running MySQL 4.1.10 on a Dell Poweredge 1850 with 2 EM64T Xeons and
2GB of memory running Redhat Enterprise 3 ES. I've been trying to address
some slowness i
The message contains Unicode characters and has been sent as a binary
attachment.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello everyone,
I am looking for a way to dump a number of tables from mysql Ver 14.7
Distrib 4.1.9, for sun-solaris2.8 (sparc) into tabulated (csv) files
with tables's column names being on the top of each data column,
something like:
IDColumn Name 1Column Name 2
1
[snip]
I read the instalation document particulary but I didn't understand it.
They told "--with-mysql
[=dir] configuration option" where it is found or where I should type
that please give details so that mysql will works And on thing I want to
know is I want MYSQLI (extenstion of MYSQL ) in php n
You should have a compound index in all your tables on ID+PRODUCT_ID,
since that is what you are joining on. Ideally, you should also have an
index on the DATA column that you will be using in the WHERE clause.
But your structure does really lend itself to this.
Going forward, you may think
In article <[EMAIL PROTECTED]>,
Mauricio Pellegrini <[EMAIL PROTECTED]> writes:
> Wow, that's simply magic!!!
> You couldn't imagine how many diferent things I've tried
> to solve this problem..
> And when I thought it was impossible ...your solution worked
> just fine at once!
> God bless expe
Hi
I have a table with about 20m rows. It is a MyISAM table. I do a alter
table disable keys before loading with "LOAD DATA". Re-creating the
primary key after import takes a long time. I have increased the
myISAM sort buffer to 75MB and the Key buffer is 100MB.
Is there anything else I can do t
Shawan,
Here you go.
mysql> select * from spam_stats
-> where rank <=10 ;
+-+-+--+---+---+---+
| report_date | report_sender_domain_id | rank | processed | spam | suspected |
+-+-+--+---
Thank you very much, it worked fine!!!
I just had a problem with aclocal which was version 1.4-p6, but by updating
the automake to 1.7 everything was ok (in case of somebody trying to install
and having the same problem).
Could someone explain me what's the difference between adding an UDF, a
n
[snip]
in it, it gives fatal error " undefined function
Mysqli_connect() on line no etc.,, " in browser.
IS that correct, can I use "Mysqli" functions in
this because I am using Mysql 5.04 (beta) version
in PHP documentation it was told that those who
are
using Mysql 4.0 or higher can use Mysqli
hi,
I use php 5.0,Mysql 5.04 ,IIS 5.0 ,IE in
windows2000 NT os and still got errors in running
php script with Mysqli functions.
when I execute the Php script with Mysql functions
in it, it gives fatal error " undefined function
Mysqli_connect() on line no etc.,, " in browser.
IS that correct
> Iam using php 5.0, IIS 5.0, Mysql 5.04 ,win2000 NT
> and IE as web browser and executed the php
> script,but got a fatal error describing that
> undefined fuction mysql_connect() in the file and
> not getting the desired output.
This is not a MySQL problem/issue. The error undefined function ind
From: "Rod Heyd"
> Tables Version_(1-5)
>
> --
> ID |PRODUCT_ID |DATA1 |DATA2 |DATA3 |.|DATA_N |
> --
Are you getting a MySQL error?
On 5/17/05, madderla sreedhar <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> Iam using php 5.0, IIS 5.0, Mysql 5.04 ,win2000 NT
> and IE as web browser and executed the php
> script,but got a fatal error describing that
> undefined fuction mysql_connect() in the file and
>
Hi,
Iam using php 5.0, IIS 5.0, Mysql 5.04 ,win2000 NT
and IE as web browser and executed the php
script,but got a fatal error describing that
undefined fuction mysql_connect() in the file and
not getting the desired output.
I had uncommented the php.ini file the entry named
'extension=php_mysql.
60 matches
Mail list logo
