Hi Gautam
nope yours is not a bug. That's all fine. Hex numbers are 64 bit
unsigned.
So for -1 you have to insert cast(0x as signed).
Cheers,
Daniel
Hi Daniel,
I can see the problem without using update. However, I am a newbie
at
mysql,
so can't say for certain if it's
Hello,
My name is Nick and I am contacting you on behalf of one of our clients,
Novell (www.novell.com http://www.novell.com/ ).
I am writing to you regarding the content of your webpage
(http://sunsite.univie.ac.at/textbooks/mysql/manual.html). I noticed
that you have included a link to
I have a server that I've been using as a MySQL Slave for a while now. I
want to change it over to a regular server now. I could simply stop the
slave (STOP SLAVE), however, I'm concerned that if I re-boot the server,
then it'll re-start the slave. What else do I need to do to stop using a
Hi Jesse,
Just add 'skip-slave-start' to your configuration file, restart there you
go.
Best regards,
Amit Sharma
On Tue, Nov 25, 2008 at 7:12 PM, Jesse [EMAIL PROTECTED] wrote:
I have a server that I've been using as a MySQL Slave for a while now. I
want to change it over to a regular
Hi everyone,
I'm fairly new to MySQL and I have a procedure that writes some status
info to a table. The problem is, I just want the values and row to be
replaced, rather than constantly adding a new row. I tried using REPLACE
as well as different timestamp methods, but I always get a new
We have a pretty large database (several terabytes and hundreds of tables).
When I do a simple query from the information schema, e.g. select table_name
from tables, it can minutes to come back with the answer. Yet, if I do a
show tables, describe or show create table the response is instant.
Hello,
We are planning on trying to do an Oracle to MySQL migration in the near
future. The issue of a Mysql equivalent to Oracle's flashback was being
discussed. After some digging it appears that there is no such feature
in Mysql. One thought that I had was to do some intentional
Hi Dave,
You have no primary key on your table, thus MySQL has no way of knowing
when the row is unique and needs to be updated rather than inserted.
REPLACE INTO effectively does the following:
- insert into table
- did a primary key violation occur?
--- yes - delete existing row from
Ack! Such a simple but important step. No wonder it wasn't replacing the
existing row.
That worked great, thank you very much.
Also, thanks to Brent who replied first. I ended up going with the
primary key over the unique index, but I'm sure that would have worked
as well.
-Dave
Andy
Hello all!
We have a master-master replication system. Both nodes run 5.0.54,
the version compiled by centos, running on CentOS 5.1 x86_64. The
boxen have 8 GB RAM, 1 GB swap, and the cpu is Xeon(R) CPU X3220 @
2.40GHz (shows as 4 cpus to the system). db1 is serving the live
site, db2 is used
Hi Shain,
If you are using InnoDB its possible to patch to allow this functionality.
Percona are in the early stages of developing a patch specifically to
allow flashback type access to previous table states.
https://bugs.launchpad.net/percona-patches/+bug/301925
If you wanted to go down the
Hi,
I am pretty new in optimizing tables with index and may need some help.
This is my query:
EXPLAIN SELECT timestamp
FROM Meting_INT_COPY
WHERE blockid = '200811252000'
ORDER BY timestamp DESC
LIMIT 1
If I have an index(blockid),
EXPLAIN will return the following information:
type
slave lag should be easy to do with a simple bash script. i.e. -
desired_delay=3600 # one hour lag
while sleep 60
do
behind=`mysql -u root --password=foobar -e show slave status\G |
grep 'Seconds_Behind_Master:' | awk '{ printf %s\n, $2 }'`
if [ $behind $desired_delay ]; then
mysql
What Charset and Collation should I use while creating a mysql table
such that it can take data from unicode SQL Server DB table?
Thanks
saqib
http://doctrina.wordpress.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
stop slave;
reset slave;
restart mysql server
On Tue, Nov 25, 2008 at 7:12 PM, Jesse [EMAIL PROTECTED] wrote:
I have a server that I've been using as a MySQL Slave for a while now. I
want to change it over to a regular server now. I could simply stop the
slave (STOP SLAVE), however, I'm
stop slave;
reset slave;
Krishna Chandra Prajapati wrote:
stop slave;
reset slave;
restart mysql server
On Tue, Nov 25, 2008 at 7:12 PM, Jesse [EMAIL PROTECTED] wrote:
I have a server that I've been using as a MySQL Slave for a while now. I
want to change it over to a regular server
STOP SLAVE;
RESET SLAVE;
CHANGE MASTER TO MASTER_HOST='';
RESET SLAVE only clears away relay logs.
CHANGE MASTER TO MASTER_HOST='' will delete the master.info
Replication is eliminated from that point going forward
-Original Message-
From: Claudio Nanni [mailto:[EMAIL PROTECTED]
Sent:
Hi,
I'm using VS Express 2008, and trying to use linq with Mysql.What I have done
1. Created a db with a single table name account(fields : acct_num
int, amount int)
2. created a Linqto sql file with same model as db table.
3. A page with gridview and code behind is (on page load
Hi,
you're using Sqlserver syntax for handling reserved words.
In MySQL you use backtick` for the same, i.e.
select `t0`.`amount` etc.
/Johan
Sharique uddin Ahmed Farooqui skrev:
Hi,
I'm using VS Express 2008, and trying to use linq with Mysql.What I have done
1. Created a db with a
19 matches
Mail list logo