• Removing MySQL rows from a table using SQL Query

    In MySQL, I have a table that currently holds the following topics: id url title company site_id So I have to go in and remove the rows that have the same title, company and Site_ID. Can this be done using a SQL Query? Thank you!

    ITKE440,470 pointsBadges:
  • ASP.NET web solution: Should I store my images in a database or file system?

    I have an ASP.NET web solution, which includes thousands of images. I also get a pretty good amount of traffic to it too. But I'm worried about its performance and here's my question: Should I store my images in a database or a file system? Appreciate the help.

    ITKE440,470 pointsBadges:
  • Finding data from a table that is linked with another table using foreign keys

    I want to see all the customer names and their city who have an account in a specified bank. Problem is my customers are listed in one table and accounts are listed in another. But I do have another table called depositor where it only store account name and customer name. How can I see customers...

    Rezoan5 pointsBadges:
  • How do I connect to a MySQL database in Java?

    I apologize if this is a simple question but can anyone help me with connecting to a MySQL database in Java? Thanks so much!

    ITKE440,470 pointsBadges:
  • Linked Server Query Returns Incomplete Results

    I have set up a linked server using Microsoft OLE DB Provider for ODBC Driver to an Oracle DB ODBC DSN. The Oracle table I'm querying has 865 rows but when I try to fetch all the rows I only get back 766 rows. Why am I not getting the complete results? Here is the query I'm using: select * from...

    Apickel350 pointsBadges:
  • Base Runtime files

    Will Base run on computers that do not have open office suite or does need run time files installed on setup?

    Burtik5 pointsBadges:
  • Fingerprint recognition in Java

    I want a programing source code for fingerprint recognition time and attendance payroll system in Java language. I also want the source code for capturing a fingerprint image and storing in MS Access in Java language for the same project.

    Anikketthakre5 pointsBadges:
  • Access Forms

    I am viewing my form in access that I have made in form view and the form is cut off half way down. It does scroll all the way down on the right, however the scroll on the left only goes halfway down. How do I get it to stop doing this?

    bubbie965 pointsBadges:
  • MS Access DATABASE and combobox in VB6.0

    hellooo plz i need helpĀ  i am new to VB6.0 and i've learned alot now i have a database in MS Access and i want to create a combobox named (Combo1) that will be populated from the field (Name) in table (Customer) in the database (weighbridge.mdb) and then when i choose a name in the combobox i want...

    Ahedfares895 pointsBadges:
  • MySQL: Threads showing in freeing items state

    I've been running SHOW PROCESSLIST in MySQL and there are a bunch of threads in the 'freeing items' state. A friend of mine told me that this is because of the query cache. But mine is set to zero so it should be disabled. What's happening here? Thanks!

    ITKE440,470 pointsBadges:
  • Linked tables corrupted Access 2007

    I have been using an Access database for some years now, it comprises of a front end called sitecal.mdb and has a back end which I think are all linked tables called sitedata.mdb Last week the sitedata.mdb which contains the linked tables crashed and I now get the error: Unrecognized database...

    domingoo5 pointsBadges:
  • SAP PI app server and database

    What is the SAP PI app server and database? How do I install it?

    Jeevitha125 pointsBadges:
  • Audit application access controls

    Hi, I'm reviewing access controls for a list of applications and some of the app owners claim they don't have human users. Is there a way to validate that? What procedures and evidence would give an auditor a good level of assurance that the app indeed has no users? Thanks. P.S. I'm not talking...

    stantastic5 pointsBadges:
  • Local domain server / database server / unmanaged switch = slow transfer to clients PC

    A network consists of domain server database server and unmanaged switch. Now the clients software is taking more than usual time when accessing database and their software hangs for some time. The client PC also have some shared data that other PCs on network. I think its because the database size...

    nomanisprfct5 pointsBadges:
  • how to display 10records in the browser again when we press the next button it will display 10 recors

    I am creating a form with three fields eno,name,salary and search button. I may or may not enter the values to the text fields and then press the search button. Here based on the values the query will generate and execute now the 10 records are display if may available otherwise it will display...

    suneelkumar15 pointsBadges:
  • SQL Server: Moving database files

    I currently have a SQL Server database and I need to move several .MDF and .LDF files somewhere else. But I can't stop the SQL Server service and I can't export it to another server too. How can I do this?

    ITKE440,470 pointsBadges:
  • Export / import database in MySQL using command line

    Can I import / export my database in MySQL using the command line? I already have MySQL system configured and WampServer is installed. Thank you so much.

    ITKE440,470 pointsBadges:
  • Monitor progress of SQL file

    I'm trying to import a pretty large SQL file (roughly 6 GB) to my local database. Here's what I'm using: $ mysql -h localhost -u root 'my_data' < foobar.sql $ mysql --version /usr/local/mysql/bin/mysql Ver 14.12 Distrib 5.0.96, for apple-darwin9.8.0 (i386) using readline 5.1 So, I'm wondering if...

    ITKE440,470 pointsBadges:
  • SQL Server: Document databases

    Over the course of the past month, my department has noticed that several of our clients are not documenting their SQL Server databases and that's making us worried. First off, should we be worried? If so, then what should we do? Thanks!

    ITKE440,470 pointsBadges:
  • Moving MySQL database to another server

    We have a MySQL server that is using a InnoDB table and the size is right about 30GB or so. Now, we actually need to move to our new server. How can we go about doing this?

    ITKE440,470 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.