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

    Shagy5 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 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 followingMySql database on a seperate server from my DNS server then join...

    Jasonjlewis45 pointsBadges:
  • PHP Datagrid

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

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

    Ingram871,285 pointsBadges:
  • 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...

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

    MelanieYarbrough6,345 pointsBadges:
  • 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 my...

    It4all5 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:
  • 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?

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

    Karl Gechlik9,860 pointsBadges:
  • 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    

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

    Tcollins15 pointsBadges:
  • MySQL Database – Multiple Images

    Hi, I am going to build a database soon for a website that can grow tremendously in the long run when it comes to the amount of records being added. This will be a MySql Database integrating with a Flash website. My main question is how should I handle multiple images being uploaded. A user will be...

    Heato11220 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