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

    how to pass array in mysql procedure parameter

    Guptarun5 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 Morisy8,323 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:
  • Web development course and Microsoft qualifications

    I recently left my job in the UK as a project manager from a niche organisation that provides business services to public service bodies. I am thinking of sharpening my skills by doing some web development training and getting certified with some Microsoft and Adobe products and moving into Web...

    Tobeeornot25 pointsBadges:
  • MySQL vs SQL server

    If I was going to get some web pages designed to interact with a database on my server would I be better using MySQL or SQL small business server? Is there a huge difference in what they're cabable of or does it just change what front-end you use? Why would I need a WAMP stack and what exactly do...

    Katy20 pointsBadges:
  • The future of PHP

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

    Sudiprai1010 pointsBadges:
  • Install MySQL as Non-Root User

    Have you been able to install MySQL as a non-root user, if so what steps did you follow.

    Djp0820 pointsBadges:
  • Starting a session in MySQL

    how to start a session in my sql?

    98672129495 pointsBadges:
  • 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.

    NewnanIT1,110 pointsBadges:
  • Advantages and disadvantages of MySQL 5.0

    Can someone explain me what are the advantages and disadvantages of MySQL 5.0??

    Espada0075 pointsBadges:
  • How to secure MySql server?

    How to secure a MySql server for webhosting?

    Ashishagw5 pointsBadges:
  • 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

    Iamjeannie30 pointsBadges:
  • 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?

    NewnanIT1,110 pointsBadges:
  • 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       ...

    Iamjeannie30 pointsBadges:
  • iSeries accessibility to VB.NET, ASP 2.0/3.0 ,NET programmers in Visual Studio

    My shop does not have WebSphere but does have a sizeable VB.NET team using the MS Visual Studio. They need access to the iSeries files in DB2/UDB - real-time. We already thanks to me have a number of batch/DTS package type transfers. Do any of you know packages that can make the iSeries files...

    JohndeCoville0 pointsBadges:
  • mysql connection using jsp

    how cna i connect mysql database with my login form using jsp in linux operating system?

    Aniya82875 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