Loading
Everything in MySQL
Anyone know how to convert cvs files from encoding utf-8 to utf-16?
Anyone know how to convert cvs files from encoding utf-8 to utf-16?
How to remove lock tables on MySQL
How to remove lock tables on MySQL and how to check cdc enabled on MySQL on table level pls help ?
query in mysql to get top3 product names which got sold
How to write a query in mysql to get top3 product names which got sold
any alternate way to do this?
I have one query I have partion table and partitioning is done in dates but due to some reasons , i need yo fetch the data using some other dates ..data is in millions and taking around one hour ..however before that when I was using partitioning date , it was taking only 20 min....any alternate way to do this ??
How to make mysql database remember my input password in the next log
How to make mysql database remember my input password in the next logins from the same server ?
how can i do that?
i need some help writing a stored procedure to archive old rows (delete and insert to archive tables) i want to run a select that will return users ids that were deleted the past 24 hours, and then archive all their rows from tables according to this id. how can i do that?
how can I select all rows from the past hour? i have a column in unix
how can I select all rows from the past hour? i have a column in unix timestamp
help on below output
create table Total_Points ( id int primary key identity(1,1), Code int Unique, Points int ) --insert into Total_Points values(1001,10) --insert into Total_Points values(2001,20) --insert into Total_Points values(3001,30) --insert into Total_Points values(4001,40) --insert into Total_Points values(5001,50) --select * from Total_Points --select * from Points_TRN --create table Points_TRN --( --id int primary key identity(1,1), --RefCode int , --EarnPoints int --) --insert into Points_TRN values(1001,1) --insert into Points_TRN values(1001,2) --insert into Points_TRN values(1001,3) --insert into Points_TRN values(2001,2) --insert into Points_TRN values(2001,2) --insert into Points_TRN values(2001,2) --insert into Points_TRN values(3001,7) --insert into Points_TRN values(3001,5) --insert into Points_TRN values(3001,4) --Expected Output -- id Code Totalpoint Earnpoint FinalPoint 1 1001 10 6 4 2 2001 20 6 14 3 3001 30 16 14 4 4001 40 0 0 5 5001 50 0 0
How fix the line 6?
Hii frd actually I am stock on a line of code, any on here please resolve the problem.
Hi frends Any one having idea about this task please help me
Hi frends Any one having idea about this task please help me We would have the same database schema in Production and Development as well for an application the data that is there is production is real time and the data in the Dev is test data or development data. right now the requirement is on a daily basis, I want the data from Production to the Dev database .. say today I restored a backup of production database to Dev.. both the databases would have same data right tomorrow, you might have new data into the production database ,which is not in the Dev database.. so that differential data (the data that is loaded for that particular day i.e today to tomorrow) should be created as back up and it should be restored to the Development database
Mysql:how can i show people who are over 40 years old
in mysql how can i show people who are over 40 years old. I have a column that contains birth dates.
Hello, I am trying to get the phone number from which the oldest call
Hello, I am trying to get the phone number from which the oldest call was made. Is there a more efficient query for this?
Hi MySQL community server How much data can be stored
Hi, MySQL community server How much data can be stored
update time whenver update existing column
Hi Guys,I want update time whenver update existing column
Hi, how can I find duplicate rows on a table that doesn't have PK?
Hi, how can I find duplicate rows on a table that doesn't have PK? i mean there might be rows that all the columns are the same, how can I find those?
how can I ignore this and update only the data that is not empty?
Hey I have a request: UPDATE category SET name = (?) , title = (?), image = (?) WHERE id = (?) Instead of (?) I substitute values, but sometimes they can be empty and the request is not accepted, how can I ignore this and update only the data that is not empty?
How to solve MySQL error code :1114 The table '/rdsdbdata/tmp/#sql74c
How to solve MySQL error code :1114. The table '/rdsdbdata/tmp/#sql74c4_26_1'is full. Can anyone help me to solve this issue
Setup Local Database In SQL Server
In this blog, you will learn how to setup local instance in sql server management studio.
Compare JSON In MySql
In this article. you will learn how to compare 2 Json Records in MySql.
Important Queries In MySQL
A list of Important Queries In MySQL. These queries are very useful whenever we face any difficulty in MySQL.
