The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
1answer
17 views

How to use a table as a reference for another table in MySQL

I have code from generic SQL that I need to find out how to run in MySQL: CREATE TABLE firstTable ( freq int NULL, w1 int NULL, w2 int NULL, w3 int NULL ) CREATE TABLE secondTable ( [wID] [int] ...
2
votes
1answer
140 views

General access denied error while using import data in SSMS

I am using SQL Server Management Studio with the following version information below: Microsoft SQL Server Management Studio 10.50.4000.0 Microsoft Data Access Components (MDAC) ...
0
votes
0answers
78 views

For creating a quiz database, can I start with XML?

I'm trying to create a database consisting of quiz questions with multiple choice answers. The questions are expected to have the following components: a question 4 or 5 multiple choice ...
0
votes
0answers
901 views

how to import .xls file into SQLite database?

I have an issue with importing .xls file into SQLite database. I am working on windows xp and using a SQLite manager for maintain the database. I can import the .csv file to the database by using ...
0
votes
0answers
313 views

import openoffice .ods file with specific structure like date and value fields

How I can import with keeping the structure of the data like date fields and numiric fields the rest of the fields is text. With import into mysql with import function from phpmyadmin from an .ods ...