rchawdhari

create table dummy{id int ,invoice int } insert into dummy values(191,10),(192,11),(193,0); I have to update 193 with invoice 13 but i want to fetch max invoice and then increment invoice by 1 for 193 . i had tried update dummy set invoice=(select max(invoice) from dummy)+1 where id=191. It wont work …

I have storing major data in mysql and logs are stored in cassandra. Cassandra db getting heavier and difficult to do queries. So I want to migrate all my cassandra's table in mysql is it possible?

I have done master master replication . I want to do multi master master replication. I research and found mostly master master replication in circular topology. But I want to do one supermaster who reads and update other masters. Is it possible? Is anybody did this?

Hi all, This is my array of hash [{"gate_pass_type_id"=>2, "tag"=>0, "total"=>2000}, {"gate_pass_type_id"=>125, "tag"=>0, "total"=>300}, {"gate_pass_type_id"=>661, "tag"=>0, "total"=>750}, {"gate_pass_type_id"=>661, "tag"=>2, "total"=>100}] I want to convert it into [2 => { "0"=> 2000}, 125=> {"0"=>300}, 661=>{"0" =>750, "2"=>100}] Is any simple way without using so much loops

Hi Everyone, Can anybody suggest me. I have mysql with two database operations and production. My operations db have master master syncing on live server . I want to make production's master slave syncing onsame live server . Is it possible. How can do it?. Please help me. Thanks in …

Hi Guys, I am moving my project from angular 1 to react. Is anybody can help me that how can I authenticate every api calls . I check before every api call that access token exist in cookie or not . Is it not exist redirect to login page

Hi everyone, I have to integrate SOAP api using SAVON gem When I am calling url it gives reponse and operations too But When I call methods and posting data it gives me error client = Savon.client(wsdl:"http://netconnect.bluedart.com/Demo/ShippingAPI/WayBill/WayBillGeneration.svc?wsdl") client.operations => [:generate_way_bill, :import_data, :cancel_waybill] client.call(:generate_way_bill, message: data) => The server was unable …

Hi everyone, I have database in cassandra . I am facing difficulties in cassandra. So I want to migrate cassandra tables in mysql. Is it possible ? How I can do this? Please help me.

Hi, I have two tables as employee id int primary key, purchase_order_product int, bundle int fabric_bundles id int primary key, purchase_order_product int, bundle int, quantity I want to make assciation between employee and fabric_bundles via purchase_order_product and bundle

Hi all, My project is on ruby on rails. I have one of ruby api returns json.jbuilder But I want that my api should not return json , it will display html.erb file Is anybody can help me???

Hi , I want to create a class in lib folder , from that class want to create mysql view . such as in mysql CREATE VIEW rocket_current_activities AS SELECT rocket_activities.status AS status from rocket_activities.... This can be do in mysql but how to do from rails. I dont want …

Hi all, Is it possible to ignore temporary tables in mysqlbinlog file for replication.

when i run select on temporary table in mysql it gives all records. But when i tried in my php page it give blank reason. Please help me out.

I have a requirement to make a sales report from 1-aug-2014 to 24-aug-2014 like this: Product Name First Week Second Week Third Week a 12 6 2 b 0 0 4 c 0 3 0 My table like this. products( prod_name varchar(200), quantity int, qty_ordereddate datetime ) my sql query …

Hi all, I have two db, one db "latestdb" which have latest six months records second db "backupdb" which have oldest records of "latestdb" and this records deleted from "latestdb" I have a query which should return records from both db. Query will return new records from "latestdb" and old …

Hello all, My master master synchronization working properly but from yesterday after 4pm my sinking get stopped. My uplink working properly but downlink not working.I failed to found any issues. Please tell me why such master master get stopped and any solution for it.

create table invoices( year int not null ,invoice_number int not null auto_increment ,primary key(year, invoice_number) ); insert into invoices(year) values(2009); insert into invoices(year) values(2009); insert into invoices(year) values(2009); insert into invoices(year) values(2010); insert into invoices(year) values(2010); insert into invoices(year) values(2010); select * from invoices; +------+----------------+ | year | invoice_number | …

I want to print series like A,B,C ......AB or T,U,V,.....AB or BA,BB,BC,.....CA in series i will input start and end characters can anybody give me logic Thanks

I have one zend form.In this form i have on dropdown and blank div. In view page on dropdown change blank div fill another dropdown. I want to validate div's dropdown so that without selecting second dropdown form could not submit. Plz suggesssst any help