• 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 selectes the record that has the highest 'VersionNumber' Can anybody suggest how I would achieve this? Thanks in advance.

    LewisT5 pointsBadges:
  • Recovering the MySQL database

    In the process of editing my database, I accidentally deleted the MySQL database. I thought I recovered it, but when I opened MySQL Query Browser, it was not there. Is there an easy way to recover it for good?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL TAGS

    Why am failling when am using mysql to create database and am using the exactly tags?

    Abcdefg071541520 pointsBadges:
  • Pass table name to procedure including fields

    I want to do the following with a procedure: I have per user that has the same structure. The only difference is the table name. I need to be able to pass the table name to a procedure and retrieve data for that table. At the moment I have this: sp_getdata(id, givendate datetime,tablename...

    Sonyadba5 pointsBadges:
  • Get MYSQL data on iSeries

    Datas are on a Linux server = mysql database and I want to transfert some datas to a DB2 database on iseries. At this time, I go throw Excel but sure we can do better !!...

    Fredolatama5 pointsBadges:
  • create database using java

    How to create database (not table) using java? For example, I want to create database in MSAccess, MySQL, Oracle etc.

    Theremustbeananwer5 pointsBadges:
  • Restoring a MySQL database

    Perhaps somebody can point me in the right direction. I have a MySQL database that I inadvertently deleted all records from. There is a regular backup I have which I can access, but I have no idea where the MySQL database tables reside in the system. I have the root password and complete access to...

    Linux - Ask the Expert270 pointsBadges:
  • Security issues for mysql in a cloud environment?

    Hi everyone, in general, I've been asked by my manager to find out about running a mysql db on a cloud (like this one) -- has anyone done this, and what do you think are the security issues that can come up when doing so? More specifically, IT has questioned me about how auditing would work on a...

    MillyT5 pointsBadges:
  • A question about system integration testing

    I have two development teams looking at integrating testers / test developers from traditional QA team. How should we best handle system wide integration testing that would include devices, firmware, and web software? Most books are written for software only teams. Our integration and regression...

    Cwatkins5 pointsBadges:
  • MYSQL database high availability

    I have cent os based LAMP system. My question is that, what is the best way to make mysql database high availability. As per me database clustering is a good option can you please suggest me.

    Chetanm145 pointsBadges:
  • Creating Views in MYSQL via Sysdate

    Hello Guys, I can create simple views for MYSQL Database tables but I am unsure on how to create a view for the following requirement: I want to create a view which restricts staff user access to a specific table between working hours of 13:00 - 14:00. I have been told that this can be implemented...

    Help1235 pointsBadges:
  • Question on Database Development Options

    Our organization is going to build a database program where there will be millions of entries. Data entry will be done from around the country. The central server will be located in the capital city. Presently we use Windows OS, planning to migrate to Linux OS in next 4-5 years. I'd like to know...

    Abdurrahman40815 pointsBadges:
  • vb.net development environment

    I am coming out of retirement and have a couple of projects I was going to do in VB6. After doing a little research it became clear that I needed to migrate my development environment from VB6/sp6 to VB.Net. My question is very basic,, what do I need to start VB.Net development? I do not have any...

    GlennSwett5 pointsBadges:
  • Letting users upload pictures MYSQL Database

    What is the easiest way in DW to allow users to upload a picture to my website. I don't know much coding so ...how can it be done using the functionality of DW. I am using a MYSQL database.

    PBen5 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:
  • How to pass array in MySQL procedure parameter

    how to pass array in mysql procedure parameter

    Guptarun5 pointsBadges:
  • MySQL Replication I think!

    Hi, I have a local Access Database that is the management system for a business. They now want to take some feature online so customers can do some functions themselves. What I am thinking is migrate the data to MySQL and use a local install of MySQL as the backend and point the Access front end at...

    Awestrope5 pointsBadges:
  • Adding a MySQL user when no MySQL users have admin rights?

    I'm working on a MySQL installation that has a user already created ("admin"), but that user doesn't have a password, and doesn't have any permissions, so I can't create new users or even reset the password of that user. I'm using Ubuntu Server, and after looking through the help files I still...

    Michael Morisy7,943 pointsBadges:
  • MSQL Auditing

    Hello. I'm dot.net developer, and i'm working a lot with MSQL. My current task is when some user executes select query on database, i should "catch" the query data. What do i mean is if select query is "select * from UsersTbl where UserID = 5", i have to get  '5'. Does somebody have any idea...

    Dimon745 pointsBadges:
  • MySql Select multiple columnsfrom distinct rows based on one column

    I am building one sql query based on 5 select statements unioned all together. Each select is built as a variable with where clauses based on filters selected by the users. All 5 selects are concatenated together to build the one dynamic query. The one select below needs to be changed to select...

    Canuhp235 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