Hi, I am trying to get the content of one MSSQL database to a second MSSQL database. There is no conflict management required, no schema updating. It is just a plain copy and replace data. The data of the destination database would be overwritten, in case somebody would have had changed something there. Obviously, there are many ways t...
Earlier I have created tables this way: create table workflow ( id number primary key, name varchar2(100 char) not null, is_finished number(1) default 0 not null, date_finished date ); Column is_finished indicates whether the workflow finished or not. Column date_finished is when the workflow was finished. Then I had ...
I'm trying to convert from a MSSQL .bak database to MYSQL. This question and answers have been very useful, and I have successfully imported the database, but am now stuck on exporting to MYSQL. The MYSQL Migration Toolkit was suggested, but seems to have been replaced my the MYSQL Workbench. Is it possible to use the MYSQL Workbench to...
I am using this query: SELECT p.id, count(clicks.ip) FROM `p` LEFT JOIN c clicks ON p.id = clicks.pid WHERE clicks.ip = '111.222.333.444' To select clicks from table "c", that has "pid" = "p.id". The query seems to work fine, but now I want to use that query with date ranges. The "c" table has a column "time" that uses MySQL CURRENT_T...
I'm trying to display all rows from one table and also SUM/AVG the results in one column, which is the result of a where clause. That probably doesn't make much sense, so let me explain. I need to display a report of all employees... SELECT Employees.Name, Employees.Extension FROM Employees; -------------- | Name | Ext | ------------...
I have a few large databases, greater than 100 million records. They consist of the following: A unique key. An integer value, not unique, but used for sorting the query. A VARCHAR(200). I have them in a mysql isam table now. My thought was, hey, I'll just set up a covering index on the data, and it should pull out reasonably fast....
Lets say I have a domain already, for example www.automobile4u.com (not mine), with a website fully running and all. The title of my "Website" says: <title>Used cars - buy and sell your used cars here</title> Also, lets say I have fully SEO the website so when people searching for the term buy used cars, I end up on the second or f...
I am in the process of learning C# (using Visual Studio 2010) to design some stand-alone applications for desktop users. Almost all of my programming experience is with Java for web development. I have read a few books now on C# and am comfortable with the programming but would like to see an example of building an actual program using...
What is the difference between select * from A, B and select * from A cross join B ? They seem to return the same results. Is the second version preferred over the first? Is the first version completely syntactically wrong? ...
As cloud computing seems to be one of the most popular topics, It got me thinking, And as i dont know much about the topic excuse me for any ignorance in the question. What exactly is a cloud database and how would this service even be created. Would it simply be a MySQL database with a web frontend that would allow users to create thei...
Is it faster to do a single database query that finds all the results you need for a page, then do several loops through it with if/else statements to extract what you want to show in each section, or to do several database queries selecting the exact data you require and then just loop through each one separately? For instance: @compl...
In a table with 5 millions rows, a SELECT count(*) FROM table would be instant in MyISAM but would take several seconds in InnoDB. Why is this that way? Why haven't they optimise count in InnoDB like MyISAM? Thanks. ...
I am examining a Windows application that uses a database of unknown type. The database consists of several files with file extensions, .i, .iz, .b1, .p and .bi. Is there an API that can be used to view the design, tables and contents of this database? The ambition is to migrate the data to a MySQL environment. ...
SQL Server 2008 has added some cool new Spacial types and given SQL Developers a lot more powerful ways of manipulating spacial data but it still eludes me how to efficently return, for example, only the locations that are within ## mile radius of a long list of zips (20 to maybe 15 thousand distinct zipcodes). Is there a simple way to ...
I am running Windows 7 inside VMWare on a Mac as I am working on a cross plattform project. I want to keep all my plattform independent files in the same folder - that's why I want to organize everything in a folder on the mac and share it with windows that's running in the VM. When I try to compile the project in the shared folder, I ge...
Can we define a string and a number both as a primary Key in table? ...
What kind of Computer Data Structure is being used internally in a LDAP Database? Is it Binary Tree, B+ tree or Trei or something else? ...
Possible Duplicate: What's the Attraction of Schemaless Database Systems? What are the advantages of document oriented databases over relational databases? Where should i use document oriented databases? ...
Hi all, I need a stored procedure to search for a string in any database in a database server. For Eg there are 5 databases in a database server and i want to search for string "sooraj" in all tables of all databases in that server. Kindly let me know if this is possible. Thanks Sooraj ...
Is there any way given a column, which table it belongs using SQL Query? ...