Database import error syntax

I have tried to import my sql database into Phpmyadmin because I'm moving to another hosting. I'm having a similar kind of error when trying to add another database. I don't know where the problem is. Could it be because my old or new server has som...
more »

2017-04-20 11:04 (2) Answers

Save the Contact Form Data Details in Another Site

I am using the Contact form 7 in my site1. I have added "Contact Form Advanced Database" Plugin to show the Submitted Records. I have an another Site2 in which I want to show the Contact Form. And want to save the Data in my Site1. Is it possible i...
more »

2017-04-20 09:04 (2) Answers

Storing Dynamic Data & Data Types in MySQL

I am building a data storage and visualization system using the traditional LAMP stack. The users need to be able to define the data types(string, int, decimal, boolean) and restrictions (length, decimal places, auto increment, etc) for the data ro...
more »

2017-04-19 19:04 (1) Answers

query and subquery join in laravel

i m trying this on laravel but i m getting error like this SQLSTATE[42601]: Syntax error: 7 ERROR: subquery in FROM must have an alias LINE 3: (select * from subcategory a inner join s... HINT: For example, FROM (SELECT ...) [AS] foo. (SQL: selec...
more »

2017-04-19 10:04 (2) Answers

Use Redis as primary database in Rails app

Hello I am newbie to Redis. I am trying to use Redis as my primary database instead of sqlite as provided by default with Rails. I tried enough googling but could not find relevant stuff. How to achieve this? Or if iam wrong whether can we use Redis ...
more »

2017-04-19 07:04 (1) Answers

Update SQL Server database from datagridview

I need to update my database on a local PC with SqlDataAdapter. The project is Windows Forms. This method selects information from database and returns a DataTable to be used as data source for a DataGridView : static string querySelect = "selec...
more »

2017-04-18 10:04 (1) Answers

Laravel 5 Eloquent Model Results

I am using eloquent model to retrieve data from database.My query $tests_details = Previous_Mocks::where($data)->orderBy('sno', 'desc')->get(); As of my knowledge $tests_details will return array of objects(results) but when i echo is_array(...
more »

2017-04-18 09:04 (1) Answers

How to find a candidate key

I have a relation A,B,C,D,E with functional dependencies 1) A->BC 2) CD->E 3) B->D 4) E->A Using 1 gives A,D,E and then using 4 will make it D,E Using 2 gives A,B,C,D and then using 3 gives A,B,C and using 1 gives A Using 2 gives A,B,C,D and u...
more »

2017-04-18 09:04 (1) Answers

Group by expressions with condition - Linq

I am trying to use LINQ and LAMBDA expressions for querying tables from ORACLE database. When using group by clauses, the time to fetch data is growing considerably. In the following code block, there is a group by expression which contains if cond...
more »

2017-04-18 09:04 (2) Answers

How to UNION multiple databases as one source

I have 40+ databases (linked servers) in my SSMS connection, each has the same schema, tables, columns but with unique data for each individual location. I'm looking for the best way to UNION them all together into a VIEW or Alias that would allow me...
more »

2017-04-17 17:04 (1) Answers

Android SQLite database is not created

The SQLite database is not created. I am playing with this for the past few hours but now i got tired a lot. I am not getting any errors or warnings in the Log Cat. Here is my code what I have tried so far. Help will be appreciated. public class MyS...
more »

2017-04-16 22:04 (1) Answers

Excel, issues editing large csv file

I have a Large CSV File, that is about 1GB. When I try to open it in Excel to edit it and do some preprocessing on the data I encounter issues. Namely when I finish the edit and save the file, when I open it later the majority of the file is clippe...
more »

2017-04-16 22:04 (1) Answers