The future of PHP
Big companies are not working in php. so what is the future of php?

Answer Question   |  January 14, 2011  5:13 AM
MySQL, Open IT Forum, PHP, PHP Coding

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

Starting a session in MySQL
how to start a session in my sql?

Answer Question   |  December 13, 2010  9:48 AM
MySQL, MySQL functions, MySQL query

Backup process for several IIS hosted website
Can we create an automated process for backing up several IIS hosted websites? We want 3 backups spread out over the course of the day and it should also include mySql backups as well.

Answer Question   |  December 13, 2010  3:25 PM
Backup and restore, IIS, IIS Server, MySQL, MySQL backup, Server Backup

How to secure MySql server?
How to secure a MySql server for webhosting?

Answer Question   |  November 17, 2010  5:20 PM
MySQL, MySQL functions, Security management, SQL Server, Web hosting

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

Embedded SQL in RPGLE
I am trying to get some counts and totals from one file and put them in another. My SQL statement works fine with STRSQL, not in the RPGLE. Do I have to declare/set a cursor, exec sql and close the cursor just to put the total in another file? C/EXEC SQL C+ INSERT INTO outputfile [...]

Answer Question   |  September 29, 2010  2:02 PM
Embedded SQL, MySQL, RPGLE, SQL, SQL statements

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 where to start??? Thanks [...]

Answer Question   |  April 9, 2011  8:25 AM
Auditing, dot.net, MySQL, MySQL query, SQL, SQL audit, SQL Query

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

Using SELECT with LIMIT clause on a physical file
Hi – I’m new to PHP & SQL and wanted to know if you can use mysql SELECT with the LIMIT clause on a iseries physical file in order to do pagination. Thanks for the help.

Answer Question   |  September 24, 2010  1:18 PM
iSeries, MySQL, Oracle SQL Pagination, Pagination, SQL Select

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

Benefits/disadvantages of hosting SQL server on site versus MySQL in cloud?
What are the benefits or disadvantages of hosting a SQL server on site or using a MYSQL server in the cloud? The MYSQL box is much cheaper is there anything I will not be able to do with my web app using MYSQL?

Answer Question   |  November 3, 2010  8:14 PM
Cloud Computing, Cloud Computing in 2010, Cloud Services, MySQL, SQL, SQL Server, SQL Server administration

Connect to remote SQL server from MySQL
we have read only access to a remote sql server. the requirement is to read few tables from sql server and load to mysql tables (installed on Unix box). Please suggest the possible ways of achieving this.

Answer Question   |  August 26, 2010  4:51 AM
MySQL, Remote SQL Server, SQL Server, SQL Server 2005, Unix

error in SQL workbench
ERROR 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 2 SQL Statement: CREATE  TABLE `cape codd`.`SKU_DATA` ( )   Does anyone know how to fix or workaround this? thanks Whitney Ferrante

Answer Question   |  July 21, 2010  1:29 AM
MySQL, SQL, SQL error messages, SQL Server, SQL Server 2005, SQL Syntax

Migrating Access Tables in MYSQL Server using MYSQL Server Enterprise Manager
Can someone please help me in migrating my tables form Access to MYSQL Server Enterprise Manager

Answer Question   |  July 16, 2010  6:05 AM
MySQL, SQL Server Enterprise Manager, SQL Server Table Migration, SQL Server tables

pagination using MySql
can anybody get any query for pagination using MySql.. any helps are welcome

Answer Question   |  July 13, 2010  11:50 AM
MySQL, MySQL query, Pagination

help me create trigger update column
CREATE  TRIGGER Trigger_UPDATE_BIENLAI_TIENNOP ON BIENLAI FOR UPDATE,INSERT,DELETE AS IF (@@ROWCOUNT = 0) BEGIN PRINT ‘ TABLE is null’ RETURN END IF UPDATE(TIENNOP) BEGIN UPDATE BL1 SET BL1.TIENNOP = BL3.TIENNOP FROM BIENLAI BL1,DELETED BL2,INSERTED BL3  WHERE BL1.SOBL = BL2.SOBL AND (BL3.TIENNOP < 300000)  PRINT ‘ finish update ‘ END /* trigger not check ‘ BL3.TIENNOP < 300000′ [...]

Answer Question   |  May 19, 2010  7:03 AM
MySQL, SQL Syntax, SQLite

MySQL brain teaser
This has been driving me crazy. I’m trying to come up with an UPDATE query in MySQL that will remove the second blank space in a name and close the gap.   Example: O Brien, John E should become OBrien, John E   A simple REPLACE (name, ‘ ‘,’’) where SUBSTRING (name,2,1) like “ “ [...]

Answer Question   |  May 19, 2010  3:00 PM
MySQL, MySQL query, SQL