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.

Answer Question   |  June 22, 2012  8:10 AM
MySQL, MySQL Database, MySQL query

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 varchar(200)) BEGIN [...]

Answer Question   |  May 16, 2012  5:55 AM
MySQL, MySQL Database

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

Answer Question   |  May 27, 2012  6:54 AM
MySQL, MySQL Database

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 [...]

Answer Question   |  March 27, 2012  8:58 PM
MySQL, MySQL Database, Oracle

MYSQL DATABASE!!!
Hello everyone! please help me about transfering MYSQL DATABASE from one computer to another….. I am a student and got to show a project on JDBC. I am using Windows 7 os and Mysql server 5.1.. Thank you.

Answer Question   |  February 28, 2012  10:09 AM
Mysql 5.1, MySQL Database, Windows 7 OS

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.

Answer Question   |  March 31, 2012  8:45 AM
CentOS, LAMP, MySQL, MySQL Database, MySQL functions

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 [...]

Answer Question   |  March 31, 2012  3:54 PM
Database security, MySQL, MySQL Database, SQL Database Security

How to Join MySQL database box to a Windows Server 2008 DNS
How do I add a Mysql database server to my win 2008 r2 domain. Firstly do I install the Mysql on another Win 2008 box then join to DNS. I also need to add a Apache web server which will be in the DMZ. I need to install the following MySql database on a seperate [...]

Answer Question   |  April 11, 2011  6:47 AM
Database, DNS, LAN, MySQL Database, Networking, Server Architectures, Windows Server 2008

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?

Answer Question   |  February 12, 2011  2:49 AM
Linux databases, MySQL, MySQL Community Edition, MySQL Database

Upgrading for database structure
hello everyone  Maybe my previous question was not the correct question to ask. I am in the middle of making an application upgrade which includes DB structure upgrade with keeping Data “data loss is not accepted here”. I have a complex DB structure in my application which depends “in some cases heavily depending” on database specific features. [...]

Answer Question   |  January 25, 2011  7:42 AM
Java/J2EE, JBoss application server, MySQL Database, Oracle, SQL Server, SQL Server 2005, WebLogic Server, WebSphere Application Server

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.

Answer Question   |  January 17, 2012  3:30 PM
MySQL, MySQL Database, SQL

Free IT Book: Next-Generation Data Center Architectures from Cisco
This week’s free IT book is your complete guide to planning, configuring, managing and troubleshooting NX-OS in enterprise environments: NX-OS and Cisco Nexus Switching. For your copy of this great resource for Next-Generation Data Center Architectures, simply answer one of five questions below and provide a link to your answer in the discussion area of [...]

Answer Question   |  November 15, 2010  4:15 PM
Cisco Routers, Giveaways, IT Books, ITKE, ITKE Contests, Linux firewalls, MySQL Database, SonicWALL, Symantec Backup Exec 12

Question on achieving ultimate network security
Hello I would be grateful if you could advise me on a security issue I have on my network security. I have a web application on linux with my data stored on a mysql database on the same server (actually it is a sugarcrm) The sugarcrm which contains information about my clients is used by [...]

Answer Question   |  November 15, 2010  1:34 PM
Firewalls, IDPS, IDS, Linux applications, MySQL Database, Network security

Put date time into 15 interval value in MySQL
does any one know if mysql have a function where I can convert datetime value into : 15 mins interval for example : 03NOV2010:00:00:02 –> 0-15 03NOV2010:00:16:02 –> 15-30

Answer Question   |  November 4, 2010  10:19 PM
MySQL, MySQL admin, MySQL Database, MySQL functions

Keep the “first” value using groupby – MYSQL
Input : col1 col2 a      1 b       1 c        2 d       2 I would like to : Create the new colX to get the first value in col1 group by col2 and save the value in colX   results : col1 col2   colX a      1       a b       1      a c        2      c d       2       c [...]

Answer Question   |  October 15, 2010  7:51 PM
GROUP BY statement, MySQL, MySQL Database, MySQL functions

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?

Answer Question   |  October 19, 2010  7:20 PM
Backup and restore, Host management, MySQL, MySQL backup, MySQL Database

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?

Answer Question   |  September 21, 2010  3:14 PM
MySQL, MySQL Database, MySQL functions, SQL, SQL 2005, SQL Server 2005, SQL Server migration, Windows

Get data from one MySQL datebase server to another in real time
hi     I am useing 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    

Answer Question   |  September 17, 2010  4:59 PM
MySQL, MySQL 5.0, MySQL Database, MySQL functions

best solution for integrating longitude and latitude into another Database in mySQL
I have databases with longititude and latitude and one with Business Info – What is the best solution for getting the longitude/latitude into the Business Database? or Do I even need to merge them?

Answer Question   |  December 17, 2009  8:26 PM
Database management, MySQL, MySQL Database

PHP Datagrid
Hi! I m new to php and MySQL database. I want to know how whether php provides any class for datagrid

Answer Question   |  February 14, 2011  4:57 PM
DataGrid, MySQL Database, PHP/MySQL