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

    ITKE352,580 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:
  • Get data from one MySQL datebase server to another in real time

    Hi, I am using MySQL database. I want to create one more database which I want to get updated in real time from the remote MySQL database server. Kindly help me in this. Thanks

    Chetanm145 pointsBadges:
  • Is it possible to run a query on two tables in two physical databases using MySQL?

    I understand that an Oracle database allows users to query on several physical databases. Does anyone know if there's a MySQL equivalent? I'm trying to run a query on two tables (which are in two different physical databases). Would it be possible to do this in MySQL?

    ITKE352,580 pointsBadges:
  • GROUP BY MySQL

    Hi, I have started working with a MySQL databse. I need a query that will either make use of "DISTINCT" or "GROUP BY" but that selects the record that has the highest 'VersionNumber' Can anybody suggest how I would achieve this? Thanks in advance.

    LewisT5 pointsBadges:
  • Which database is better: MySQL or NoSQL?

    We are e-learning company and have a product based on client server model. We are currently using MySQL but facing problems with the installation as it takes longer time to install all the prerequisites. Is there a better way or better database option available? Switching to NoSQL-Mongo DB will be...

    RyanHaris5 pointsBadges:
  • Access MySQL on Linux from phpmyadmin on Windows

    Hi, First I'll describe my setup: Server 1: Windows server 2003 IIS 6 PHP 5.4.33 phpMyAdmin 4.2.9 Server 2: Ubuntu Server 14.04.1 MySql 5.5.38 PHP 5.5.9 I installed phpMyAdmin on my Windows server and configured it with two servers login. I can login to MySQL on my Windows Server and edit databases...

    sevynos35 pointsBadges:
  • Limit the number of rows returned by an Oracle query

    Would there be a way to make an Oracle SQL query behave like it contains a MySQL limit clause? So, for example, here's what I can do in MySQL: select * from sometable order by name limit 20,10 This allows me to get the 21st to the 30th rows (meaning skip the first 20, give the next 10). The rows...

    ITKE352,580 pointsBadges:
  • How to import simple spreadsheet into MySQL database?

    I have a simple spreadsheet (only 2 columns) that I need imported into a MySQL database. I can convert the spreadsheet into whatever format I need to (comma delimited), but I need the MySQL commands that will import it. Does anybody know how to do this?

    Ingram871,285 pointsBadges:
  • What’s the difference between horizontally and vertically scaling a database?

    I'm working with two different databases (NoSQL and MySQL) and we're looking to measure the scalability of each database. What's the difference between vertically and horizontally scaling each one? I would appreciate any help.

    ITKE352,580 pointsBadges:
  • How to rename a MySQL database quickly

    How would I be able to rename a MySQL database quickly? Most of the time, I usually just dump the database and re-import it with a new name. But since this is a huge database, this isn't possible. Can anyone help me here?

    ITKE352,580 pointsBadges:
  • Bundling MySQL Community Edition

    Is it free to Bundle the MySQL Community Edition within our Product or along with our Product CD/DVD? Do we need expose the source of whole application software or product to the community? Our product is our main bread/butter of the company. Let me know what options are avaliable and how to do it.

    Rajeshbs45 pointsBadges:
  • Can System Center manage applications like MySQL running on Windows or Linux?

    Can System Center manage applications like MySQL running on Windows or Linux? This question was asked during the Microsoft System Center live chat on IT Knowledge Exchange in January 2010.

    ITKE352,580 pointsBadges:
  • Can we split a column in MySQL?

    In MySQL, we have a column that has comma separated data, like this: 1,2,3 3,2,1 4,5,6 5,5,5 So we're trying to run a search that would actually query each value of the CSV string individually. 0<first Is there a way to do this in MySQL? Thanks so much.

    ITKE352,580 pointsBadges:
  • Update statement with inner JOIN query isn’t working in Oracle

    We have a query that works fine with MySQL. For the past few days, we've been trying to get it to work in Oracle but keep getting the following error: SQL Error: ORA-00933: SQL command not properly ended 00933. 00000 - "SQL command not properly ended" Here's the query we're using: UPDATE table1...

    ITKE352,580 pointsBadges:
  • How can I find duplicate records in a MySQL database

    I'm trying to pull out duplicate records in a MySQL database. I've already figured out how to do it this way: SELECT address, count(id) as cnt FROM list GROUP BY address HAVING cnt > 1 This is what it results in: 100 MAIN ST 2 But I need to do a pull that shows each row that has a duplicate,...

    ITKE352,580 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