i have set of 200 documents (*.doc) containing data as follows . I want to upload it to database (mysql). how to convert it? Is there any easy steps to do? i'm using ubuntu os 1) Name: MR RAMESH KUMAR Address: 23/64,PANKAJ RESIDENCY HYDERABAD ...
Database Name = MyDB Table Name = MyTable Column Name = ColumnSurname Using SQL Server 2005 I have multiple entries in ColumnSurname and some of them are spelled exactly the same. How can i return all the distinct values with the same ColumnSurname value. Meaning i want to return "Bond" if "Bond" comes up more than twice. How would ...
I need to store long strings in a database. the string may be 5 or 6 sentences long. do you think this is a good design strategy. or should I store an id for that string and then create a relationship with another table that contains the location of the file storing the string. could you please give advantages and disadvantages of both. ...
Hi, I am having an issue with a delete I am trying to do in Hibernate. Everytime I try to delete I get an issue due to child records existing so it cannot delete the parent. I want to delete children and the parent. Here is my parent mapping: <set name="communicationCountries" inverse="true" cascade="all,delete-orphan"> <key ...
My application at present uses Microsoft Access, but now may be hosted on Linux boxes. Additionally while being accessed from multiple computers, one of these may update the records (when its being read by other users). I also require that the embedded database should support complex SQL queries - like inner SQL, Joins, etc. I tried SQ...
Hi there, im developing a simple access application that helps us to order the right products for a project. i have a table for each contractor containing its products. i have a table "favorite-products" that relates to products and gives additional information how and when they should be used. normally id have a big table (containing ...
I am currently playing with couchdb and testing out the 'standalone attachments' feature, which is described near the bottom of this page. I am trying to use curl's --data-urlencode feature to send the creation request, which only half works. I can create the attachment and retrieve it, but the Content-Type field is wrong, so the im...
What is the need for a database schema (embedded in the DB) if I can configure my MySQL DB structure and write CRUD statements to work with it directly? I've never worked with these, but I'm assuming they're only for performance optimization? I know of schema diagrams that can be exported as .sql commands which generate the DB structure...
We have a DB server with a couple web app db's on there (don't get a ton of traffic). We'd like to make use of the server and allow it to be the DB server for sharepoint. I'm assuming it's not good practice and that sharepoint should have it's own exclusive db server. Am I right in that conclusion, or is it alright if we put the datab...
Hi, I am sorry if this sounds like a silly question, but I have googled for a while for a solution and no success. I am trying to establish a connection from VS 2008 to SQL Server. I am trying to use an user that my web application has been successfuly using to access the database from in its connection string. But when doing it from VS ...
What the complexity in big O notation of adding n entries to a database with m entries with i indexes in MySQL and afterwards committing? ...
Hey im working on my first php site, and was hoping to get some thoughts from you guys. 1- I'm using a txt file database, cuz its a simple set of scripts. I know that's not recommended, but i wanted to work with it some, before getting into mysql. Thoughts on this in general? Pros, cons? Vulnerable? 2- Related to the previous question ...
I'm working on a project that I want to have be as flexible and scalable as possible from the beginning. A problem I'm concerned about is one best described by Joshua Schacter in Founders at Work, who noted it as one detail he wish he would've planned for ahead of time. Scaling past one machine, one database, is very challenging, eve...
I am looking for options other than MS SQL Server/Express. There seem to be quite a few file based or in-memory database engines supporting some subset or dialect of SQL. Preferably it would be an engine not requiring installation at all. Is any of them supported by SimpleRepository? Is any of them supported by ActiveRecord? Is there at...
I'm using Visual Studio Web Setup Project to instrument web application install kit. Unfortunately, the database is done by a Database Project created by VSTS Database Edition by my colleague(I'm using VSTS Developer Edition). It seems that VS Web Setup Project does not recognize the output of the DB project, so it can't include the out ...
I'm new to PHP and MySQL. For my project I want to make a site for lyrics. How to design the database and the relationships? Here is what I have so far: Artist Artist_id Artist_name Artist_bio Artist_thumb Albums Album_id Artist_id Genre_id Album_title Release_year Genre genre_id genre_name Tracks track_id track_title alb...
When I try to import an SQL Server database into access I am getting this error I am using OS: Windows Vista App: MS Access 2007 DB: MS SQL 2005 Error: Connection failed SQLState; "01000' SQL Server Error: 52 [Microsoft] [ODBC SQL Server Driver] [DBNETLIB] ConnectionOpen (Connect()). Connection failed; SQLState: '08001' SQL Server Err...
Currently I am working on failover support of an existing application. The application uses postgres to store data but does not use any special feature (view/trigger etc). The database is more of a configuration storage rather than real data storage. When the application starts, it loads the data in memory and seldom goes back to datab...
How to list row count of each table in the database. Some equivalent of select count(*) from table1 select count(*) from table2 ... select count(*) from tableN I will post a solution but other approaches are welcome ...
I have a number of different objects with a varying number of attributes. Until now I have saved the data in XML files which easily allow for an ever changing number of attributes. But I am trying to move it to a database. What would be your preferred way to store this data? A few strategies I have identified so far: Having one singl...