Click here to Skip to main content
15,867,568 members
Home / Discussions / Database
   

Database

 
QuestionError in IF statement in MySQL Pin
Jassim Rahma29-Oct-15 4:31
Jassim Rahma29-Oct-15 4:31 
AnswerRe: Error in IF statement in MySQL Pin
Eddy Vluggen29-Oct-15 5:08
professionalEddy Vluggen29-Oct-15 5:08 
AnswerRe: Error in IF statement in MySQL Pin
Wombaticus29-Oct-15 5:45
Wombaticus29-Oct-15 5:45 
QuestionGet all Tables which have Duplicate values on Columns Name and Description Pin
indian14328-Oct-15 14:09
indian14328-Oct-15 14:09 
AnswerRe: Get all Tables which have Duplicate values on Columns Name and Description Pin
Jörgen Andersson28-Oct-15 22:31
professionalJörgen Andersson28-Oct-15 22:31 
GeneralRe: Get all Tables which have Duplicate values on Columns Name and Description Pin
indian14329-Oct-15 8:29
indian14329-Oct-15 8:29 
AnswerRe: Get all Tables which have Duplicate values on Columns Name and Description Pin
RNA Team30-Oct-15 20:13
RNA Team30-Oct-15 20:13 
QuestionLoad data from Excel which has columns in multiple rows Pin
indian14328-Oct-15 4:08
indian14328-Oct-15 4:08 
Hi All,

I have an Excel file in which there are multiple sheets and its columns are spread in multiple rows like a parent has multiple children and those children have their children.

How can I load this data in to a table sheet by sheet, means for each load if it loads from one sheet that's fine but important thing here is columns are spread into multiple rows.

I am also searching, but any link, any suggestion or code snippet is going to be very very helpful. Thanks in advance.
Thanks,

Abdul Aleem

"There is already enough hatred in the world lets spread love, compassion and affection."

AnswerRe: Load data from Excel which has columns in multiple rows Pin
Richard MacCutchan28-Oct-15 7:18
mveRichard MacCutchan28-Oct-15 7:18 
GeneralRe: Load data from Excel which has columns in multiple rows Pin
indian14328-Oct-15 8:37
indian14328-Oct-15 8:37 
GeneralRe: Load data from Excel which has columns in multiple rows Pin
Richard Deeming28-Oct-15 10:05
mveRichard Deeming28-Oct-15 10:05 
GeneralRe: Load data from Excel which has columns in multiple rows Pin
indian14328-Oct-15 11:02
indian14328-Oct-15 11:02 
QuestionUse column output, to get new column Pin
Karan_TN27-Oct-15 19:54
Karan_TN27-Oct-15 19:54 
AnswerRe: Use column output, to get new column Pin
Mycroft Holmes27-Oct-15 20:42
professionalMycroft Holmes27-Oct-15 20:42 
Questionselect to Cancatenate sub group values under a group Pin
indian14327-Oct-15 3:07
indian14327-Oct-15 3:07 
QuestionStoring Result Of A Select Statement In A Variable Pin
MadDashCoder23-Oct-15 13:13
MadDashCoder23-Oct-15 13:13 
AnswerRe: Storing Result Of A Select Statement In A Variable Pin
CHill6025-Oct-15 4:52
mveCHill6025-Oct-15 4:52 
AnswerRe: Storing Result Of A Select Statement In A Variable Pin
Anudeep Jaiswal - MCA17-Nov-15 18:22
Anudeep Jaiswal - MCA17-Nov-15 18:22 
Questionhow to create a database if data is given? Pin
Member 1127090223-Oct-15 6:00
Member 1127090223-Oct-15 6:00 
AnswerRe: how to create a database if data is given? Pin
Eddy Vluggen23-Oct-15 6:29
professionalEddy Vluggen23-Oct-15 6:29 
GeneralRe: how to create a database if data is given? Pin
Member 1127090223-Oct-15 7:02
Member 1127090223-Oct-15 7:02 
GeneralRe: how to create a database if data is given? Pin
Eddy Vluggen23-Oct-15 7:17
professionalEddy Vluggen23-Oct-15 7:17 
GeneralRe: how to create a database if data is given? Pin
Member 1127090223-Oct-15 7:28
Member 1127090223-Oct-15 7:28 
GeneralRe: how to create a database if data is given? Pin
Eddy Vluggen23-Oct-15 8:08
professionalEddy Vluggen23-Oct-15 8:08 
GeneralRe: how to create a database if data is given? Pin
Member 1127090223-Oct-15 8:25
Member 1127090223-Oct-15 8:25 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.