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
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
how to start a session in my sql?
Answer Question | December 13, 2010 9:48 AM
MySQL, MySQL functions, MySQL query
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 a MySql server for webhosting?
Answer Question | November 17, 2010 5:20 PM
MySQL, MySQL functions, Security management, SQL Server, Web hosting
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
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
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
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
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
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
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
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
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
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 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
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
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
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
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