• What wiki software do you recommend?

    Just as the title suggests, what wiki software (DokuWiki, MediaWiki, etc...) do you suggest to run?  The purpose of this is nothing more than to make a remote note-taking sort of scenario, so it's not something for anyone but me to be used.  I know I could do my own thing and stuff, but I'd...

    Eric Hansen2,065 pointsBadges:
  • How to store an IP address in MySQL

    Could anybody tell me what the right field type would be for storing an IP address in MySQL? Also, what's the right way to store it too?

    ITKE351,965 pointsBadges:
  • Free online practice exercises on SQL/Oracle

    I would like to know is there any website which offers free practice exercises on SQL/Oracle queries? Preferably advanced level queries. Thanks, Kruti

    Kpatel0 pointsBadges:
  • Migrate MySQL database to SQL 2005

    We are looking to migrate from MySQL to a full blown iteration of SQL 2005. Are there tools in place that will allow us to migrate our data and tables or are we on our own for getting our data into the MS database?

    Karl Gechlik9,860 pointsBadges:
  • How can I determine by database size in MySQL?

    Does anyone know if there's a specific query or function that can determine the size of my database in MySQL? If there isn't one, what's the best way to go about it? I tried this and it came up with 474989023196466.25 MB (even though I know the database is 400 MB). SELECT...

    ITKE351,965 pointsBadges:
  • How should I store large files in a MySQL database?

    We have a PHP script that we upload large files with (up to 500MB) and it's stored in a MySQL database. Here's the code we're using: mysql_query("INSERT INTO table VALUES('')"); $uploadedfile = fopen($_FILES['file']['tmp_name'], 'rb'); while (!feof($uploadedfile)) { $line =...

    ITKE351,965 pointsBadges:
  • How to I insert a table if it doesn’t exist in a MySQL database?

    In a MySQL database, I'm trying to do the following query: INSERT INTO table_listnames (name, address, tele) VALUES ('Rupert', 'Somewhere', '022') WHERE NOT EXISTS ( SELECT name FROM table_listnames WHERE name='value' ); But it keeps returning the same error. I don't want to insert a record if the...

    ITKE351,965 pointsBadges:
  • How can we check if a MySQL database exists?

    Can anyone tell me if it's possible to check if our MySQL database exists after we've made a connection? We already know how to check if a table exists in our database but now we need to see if the actual database exists. Thanks!

    ITKE351,965 pointsBadges:
  • Database Migration code in MySQL

    Code to migrate database in MySQL (tables, triggers, stored procedures, functions and views) to Oracle, MS Access & vice versa.

    akashi5 pointsBadges:
  • What’s the better database option: MySQL or SQLite?

    Our organization is deciding to use either SQLite and MySQL for our database. We understand that SQLite is a single-file database and MySQL is just a normal database. But in your opinion, what's the better option?

    ITKE351,965 pointsBadges:
  • How to export a MySQL database to SQLite

    I apologize for the short question but can anyone help me export my MySQL database into a SQLite database? Thanks so much!

    ITKE351,965 pointsBadges:
  • Multi-use of the database

    Hello. I've developed a local website using xampp, and I want to access the mysql database in it to develop a J2SE application. Is it possible? if so could you give me the right keywords to search since I kept trying every single word that could pop into my mind. Thank you very much.

    Hanai5 pointsBadges:
  • How to install the MySQL JDBC connector?

    Can anybody tell me how to install the MYSQL JDBC connector. I am getting error "java.sql.SQLException: No suitable driver ". I placed the driver in the java-jre\lib\ folder also in the shared folder of tomcat 5.0. Even in the lib folder of WEB-INF. But I am getting the same error.

    Advancedjava25 pointsBadges:
  • Migrating MySQL hosts

    We need to migrate a MySql database from one host to another. Will a simple backup and restore work? Are there references to the database inside itself? Will this work?

    NewnanIT1,110 pointsBadges:
  • MySQL vs. Oracle

    what is the major two comparison of mysql5.0 and oracle 10g?

    Mysql10 pointsBadges:
  • Loading image into MySQL database from Excel file

    I have an excel file that contains an image in the first col. When I save it to an csv format, the excel program creates two images ( 1 small, 1 large) for each line in the excel file. How do I load both the file data and the large image into my mysql database?

    Wlm49hv5 pointsBadges:
  • MySQL CrossTab Query

    MySQL does not have a crosstab query. Does anyone have some code that will return a datastructure on a crosstab query?

    Carbon0 pointsBadges:
  • Equivalent for crosstab query

    Is there any function in MySQL that can create a query similar to crosstab query in MS Access?

    Sgheorghian5 pointsBadges:
  • How to sync MySQL contacts with Microsoft Exchange

    In our PHP web application, we have a MySQL contacts table. It's integrated with the application so it allows you to add a contact, edit, etc. But it's currently self-contained. Our organization would like to integrate it with Microsoft Exchange but we've run into a few problems communicating and...

    ITKE351,965 pointsBadges:
  • How do I display session ID on the web

    Hi, I am doing a login page with MySQL and ASP.NET/C#. I would like the program to run in the following sequence. The user login The login page will search through MySQL database, When it is Authenticate, it will allow the user to access. My concern now is how to you use the session ID to display...

    Blue50 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following