I have some data in one of my mysql table stored as utf8. The data is some japanese text. I need to export it to excel. Could you tell how to do it? Exporting by SELECT … INTO OUTFILE returns some plain text file. I’m not sure how to read it back in excel so that japanese character would show
Tag: sql
clearing an entire column in access
is there a way to clear an entire column in a datasheet in access? i can just right click on it and delete it but that will affect the structure, i just need to clear all the records. how do i do this? perhaps the question i should be asking is how do i clear the entire contents of a
How to use a value from one stored procedure in another?
I have the following statement in a stored procedure: DECLARE @Count INT EXEC @Count = GetItemCount 123 SELECT @Count Which calls another stored procedure with the following statement inside: SELECT …
Guid Primary /Foreign Key dilemma SQL Server
I am faced with the dilemma of changing my primary keys from int identities to Guid. I’ll put my problem straight up. It’s a typical Retail management app, with POS and back office functionality. Has …
From Now() to Current_timestamp in Postgresql
In mysql I am able to do this: now in postgresql I am using this query: but I get this error: How can I resolve ? Answer Use an interval instead of an integer:
Keep local MS SQL 2008 DB table and remote SQL Azure DB table in sync
I have a dedicated server which hosts a Windows Service which does a lot of very heavy load stuff and populates a number of SQL Server database tables. However, of all the database tables it populates and works with, I want only one to be synchronised with a remote SQL Azure DB table. This is because this tab…
how to show partial key in uml er diagram
in chen’s notation partial keys (discriminator) were shown as dashed lines, how are they shown in uml er (entity-relationship) diagram?
Remove trailing zeros from decimal in SQL Server
I have a column DECIMAL(9,6) i.e. it supports values like 999,123456. But when I insert data like 123,4567 it becomes 123,456700 How to remove those zeros? Answer A decimal(9,6) stores 6 digits on the right side of the comma. Whether to display trailing zeroes or not is a formatting decision, usually implemen…
Detecting abuse for post rating system
I am using a wordpress plugin called “GD Star Rating” to allow my users to vote on stories that I post to one of my websites. http://everydayfiction.com/ Recently we have been having a lot of abuse of the system. Stories that have obviously been voted up artificially. “GD Star Rating” …
Clustered index – multi-part vs single-part index and effects of inserts/deletes
This question is about what happens with the reorganizing of data in a clustered index when an insert is done. I assume that it should be more expensive to do inserts on a table which has a clustered …