| Subject | Date Asked | Expert |
|
| How to find a unique id split into 3 tables efficiently | 11/16/2009 | stuart gregory |
Q: I'm new to MySQL and I have a problem. I'm dealing with 3 types of assets, for an example (and to ... A: I think i know what you are trying to do. are you trying to access this information from a web page? ...
|
| coding for free? | 10/8/2009 | stuart gregory |
Q: I've heard about Open Software, and Free Software, and all those projects that are carried on by ... A: You have raised a very good point, There is an artical coming soon on ...
|
| Calling Procedure | 10/7/2009 | stuart gregory |
Q: I have 80 procedures and I want to call all the procedure one by one Automatically and I am passing ... A: I am not use to using Toad, i tend to stay away from all programs like that for refrence to MySql, i ...
|
| Calling Procedure | 10/7/2009 | stuart gregory |
Q: I have 80 procedures and I want to call all the procedure one by one Automatically and I am passing ... A: How are you trying to run this script. If this is a script that a browser can call the information ...
|
| Cross checking Databases in mySQL | 9/28/2009 | stuart gregory |
Q: I'll preface this by saying that I haven't with a command line in any way shape or form in years, so ... A: I'm not fully sure what you mean here but heres what i think you mean, please correct me if i am ...
|
| MySQL CLUSTER INSTALLATION | 9/5/2009 | stuart gregory |
Q: I am confused with the installation procedures of MySQL packages, i have noticed, that to install ... A: I am sorry but i am unfermiular with that OS (CentOS 5.3, 32 bit platform.) and software does ...
|
| MySQL running locally? | 8/2/2009 | stuart gregory |
Q: Can a website with an SQL database behind it, be created and run on a local PC, or does it have to ... A: Yes you can use your own pc to run an sql database and a website. This would mean cconfiguring your ...
|
| Multiple Search Query | 7/27/2009 | stuart gregory |
Q: Can you please advise on the follow. I am currently using mysql and db2 and I would like to create ... A: There are a number of diffrent options avalible depending on what format you are coding your pages ...
|
| mysql | 7/21/2009 | stuart gregory |
Q: sir, i am student of Master of Computer Application from India I want to insert the two record in ... A: If i simply give you the answer that defeats the object. try reading up on mysql joins. If you ...
|
| backing up and restoring mysql | 6/30/2009 | Marty Landman |
Q: Beginner question for you Marty. I wanted to use mysqldump to backup MySQL databases from my Redhat ... A: John, Looking at the discussion on http://littlelink.webtrouble.com/?WH5H I'm thinking that your ...
|
| MYSQL CLUSTER | 6/23/2009 | Marty Landman |
Q: I am much impressed with your profile. Now i have one question I Need to configure a MYSQL cluster. ... A: XAMPP will do this for you! http://littlelink.webtrouble.com/?ZLkd has the FAQ for Mysql using ...
|
| php, database array | 6/17/2009 | stuart gregory |
Q: iam having problems trying to get an array working, i want to get all data from the database thats ... A: Arrays can be a little confusing, here is a basic array that will get the data from a database table ...
|
| Selecting a row in which to retrieve a value from a specific column | 6/16/2009 | stuart gregory |
Q: I have a really newby question that I am not succeeding to solve. If I want to show trough PHP the ... A: This is really simple to do. I can now help you with your script. I have wrote you a very simple ...
|
| Selecting a row in which to retrieve a value from a specific column | 6/16/2009 | stuart gregory |
Q: I have a really newby question that I am not succeeding to solve. If I want to show trough PHP the ... A: Can i just clarify a few things before answering this question for you. You want to select from ...
|
| Php & Mysql | 6/12/2009 | stuart gregory |
Q: I design a project on music album library in mysql(use as backend)& php (use as frontend). so how ... A: I am not sure what you are asking. Are you asking how to create a MySQL database table and what ...
|
| SQL Table with current date | 3/26/2009 | Marty Landman |
Q: I am trying to create a table and I need one of the columns to be automatically filled with the ... A: Luis, I got it to work by using quotes CREATE TABLE USERINPUT ( COMMENTS VARCHAR(200), DATEID DATE ...
|
| Large MySQL query | 2/19/2009 | Marty Landman |
Q: Marty, I have an older MySQL database (3.23.52) which has been very stable running on Linux RedHat ... A: Ray, Check out the stuff on http://acs.ucsd.edu/info/jobctrl.shtml especially the renice command at ...
|
| MySQL access denied 1045 | 2/17/2009 | Marty Landman |
Q: Marty- This is a continuation of a past question that I did not get a chance to follow up on. Hope ... A: I've used winamp too but haven't encountered this. Try logging onto Mysql as root from the console, ...
|
| phpmyadmin and password add | 2/16/2009 | Marty Landman |
Q: Marty- I am about to upload my first database site and didn't realize till now that I never set a ... A: Rich, I have always done this either through the cPanel Mysql screen which makes it easy, or from ...
|
| mysql is is free? | 2/12/2009 | Marty Landman |
Q: i know that mysql is free, but i just want to clarify if it is free to use on our company. thank ... A: Nhoel, Please see the solutions page on the Mysql website for the options - there are free and paid ...
|
| multiple insert | 1/20/2009 | Marty Landman |
Q: "hi... good day... i would like to ask whats wrong with my query I tried to insert multiple record ... A: Madzmar, Your question is quite long - I only read the beginning of it. According to the Mysql ...
|
| mysql and jdbc | 7/2/2008 | Marty Landman |
Q: i am a new user of mysql. I am trying to connect my sql database with java program.But i am unable ... A: Keerthi, Is there any more to the message than that? It sounds like when you import java.sql.* ...
|
| Query about mySql | 4/25/2008 | Marty Landman |
Q: I want to store & retrieve the images in MySql. Is it possible? If Yes pls send me the procedure to ... A: Sachin, You can use the blob MySQL data type, described at http://littlelink.webtrouble.com/?tQXc ...
|
| case in update command | 4/9/2008 | Jeff Carouth |
Q: I have a problem with update command using case statement. my table structure is following. table:- ... A: You *could* do something like this update game set black_player = ( case when black_player = ...
|
| mysql drivers | 3/8/2008 | Marty Landman |
Q: my question is how we know abt the driver means which to use? for ex..."com.mysql.jdbc.Driver" and ... A: Tulsi, I found this download by googling http://dev.mysql.com/downloads/connector/j/3.1.html ...
|
| select statement | 2/27/2008 | Jeff Carouth |
Q: this is parth, i have problem in select query.i want to fetch a paticaular column from a table. my ... A: To make this happen, I would use the CASE construct as follows: SELECT qid , CASE answer ...
|
| Database Join Non Related Tables | 2/20/2008 | Jeff Carouth |
Q: I'm trying to develop a site where I need to join multiple tables that aren't really related in ... A: You are welcome for the insight. UNION is a powerful construct. For this type of situation I think ...
|
| Database Join Non Related Tables | 2/17/2008 | Jeff Carouth |
Q: I'm trying to develop a site where I need to join multiple tables that aren't really related in ... A: I am not familiar with the basecamp dashboard, but if I understand what you are asking you could ...
|
| MySql with java | 2/3/2008 | Jeff Carouth |
Q: Respected sir, I have given the brief description about my problem in retrieving the data ... A: I apologize for the delay in getting back with you. I have been under the weather the past few days. ...
|
| SQL Programming Help | 1/30/2008 | Marty Landman |
Q: I was hoping you may be able to help me. I have a large amount of data and it is currently in CSV ... A: Michael, 18 million numbers is a lot of data, and I can't promise you that Mysql will do the job ...
|
| auto inc field | 10/9/2007 | Marty Landman |
Q: I am trying to write code in Delphi to write to an existing MySQL db. The table I wish to write to ... A: Karen, I haven't used Delphi so may not be much help. My only thought is, could you try inserting a ...
|
| mysql | 8/11/2007 | Marty Landman |
Q: i have a mysql database under WinXp, i want to connect to it remotly, but always get error - host ... A: I haven't set this myself but think you'll need something like ODBC installed in order to make the ...
|
| Showing database content within a html table | 8/7/2007 | Marty Landman |
Q: I used a simple script to display all the entries in the table "news" in my database. You can see ... A: Try my open source application FormATable - link at bottom. It's written in Perl and uses an HTML ...
|
| php | 7/26/2007 | Marty Landman |
Q: Ok, I just learn how to write a php scrip to get up a database. but know how do i setup a login and ... A: The easiest way would be to use an open source product such as Drupal - http://drupal.org. If you ...
|
| Mysql Copying | 7/19/2007 | Marty Landman |
Q: i'm doing a Mysql database app in vb.net with about 200 entries in the tables. When i'm trying to ... A: Do you see your table name when going into the database and typing show tables; Are you making a ...
|
| mysql database - messenger | 7/19/2007 | Marty Landman |
Q: I'm building a database using C# (Visual Studio) I'm using MySQL to store the data. I have created ... A: The problem I foresee with your approach is that you can't easily predict the number of friends each ...
|
| 1:1 relationship between tables | 7/13/2007 | Marty Landman |
Q: How can I create 1:1 relationship between 2 tables using MySQL. Following are my 2 tables. Create ... A: If I understand the question then the answer is to insure that there is a customer row for every ...
|
| Mysql administrator | 6/24/2007 | Marty Landman |
Q: I want to create a database using Mysql administrator tool. please tell me how to do it. when i open ... A: If you can't connect then you're stuck! The only thing to do at this point imo is to check your ...
|
| ODBC Connection | 6/10/2007 | Marty Landman |
Q: I am trying to connect to a MySQl database hosted by a hosting compay, I have downloaded the latest ... A: Rob, If your hosting provider has PHPMyAdmin available to you then the connection info will be ...
|
| avg for count more than | 6/6/2007 | Marty Landman |
Q: Here's my db structure StuNo StuName Department GrandMark sample record 100A Mandy ... A: To get the number of students in each department you can use SELECT Department, COUNT(Department) ...
|