You are here:
MySQL/Questions Answered by Expert Marty Landman
| Subject | Date Asked |
| MsAccess | 10/25/2010 |
| Q: I have a problem in extracting data from db. My db is user_table with parameters like code1, code2, ... A: Albo, Here's some code that I think would work: SELECT code1, COUNT(*) FROM user_table GROUP BY ... | |
| Restore and Backup in MYSQL Problem | 8/31/2010 |
| Q: .. here is my code for the backuping of my database public static String getData(String port, ... A: If your command was pasted and is literally what you wrote then I see the problem mysqldump -uroot ... | |
| Restore and Backup in MYSQL Problem | 8/30/2010 |
| Q: .. here is my code for the backuping of my database public static String getData(String port, ... A: Madzmar, I am not an experienced Java programmer and so can't help with that code. However you can ... | |
| mySQL query search | 7/23/2010 |
| Q: I have a mySQL database with leads of businesses that's hosted online, and I need please the SQL ... A: The specifics of the query will depend on the field names, but it would look something like SELECT ... | |
| MySQL update using HTML form | 6/28/2010 |
| Q: can you please tell me how to: 1. Update a row in a mysql database using an html form? 2. Delete ... A: The fact is a database cannot be updated or written to in any way directly from HTML. It can be ... | |
| SQL code | 6/27/2010 |
| Q: i am trying to use the SQL code to update one of my customer name from Mark Tobey to Mark Toby, may ... A: I answered this - UPDATE mytable SET fullname='Mark Toby' WHERE fullname='Mark Tobey'; That ... | |
| code SQL | 6/26/2010 |
| Q: what is the code to change the spelling of Mark Tobey to Mark Toby ? Thanks for your help. A: Desmond, There may be some details I can't supply because the question can be answered in a number ... | |
| MYSQL Beginner | 2/24/2010 |
| Q: I am a Microsoft Certified Applications Specialist for Access 2007. I have been using Access for ... A: Charles I recommend you download in stall XAMPP http://www.apachefriends.org/en/xampp.html which ... | |
| Not able to add a second user in Mysql | 1/9/2010 |
| Q: On my Mysql 5 server, I’ve a user account as localhost | root | my-password with all ... A: I have never added a Mysql user afaik directly on the table. It may be that the interface does more ... | |
| backing up and restoring mysql | 6/30/2009 |
| 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 |
| 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 ... | |
| SQL Table with current date | 3/26/2009 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 ... | |
| mysql drivers | 3/8/2008 |
| 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 ... | |
| SQL Programming Help | 1/30/2008 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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) ... | |
| indexing | 3/18/2007 |
| Q: I have a query which sets all the 'lastmod' values from update_products equal to the 'lastmod' ... A: I would think you'd need to look through every row of both tables to do this query, and that's why ... | |
| Question about sorting | 3/18/2007 |
| Q: I am running a query using product ids like this: SELECT * FROM products WHERE product_id=510 OR ... A: So you do create the sort key as a new column - only on a temp table. Makes sense. Maybe there's a ... | |
| Question about sorting | 3/17/2007 |
| Q: I am running a query using product ids like this: SELECT * FROM products WHERE product_id=510 OR ... A: I don't know that you can. If there was a sort key which you could put on the table then you could ... | |
| database questions | 3/1/2007 |
| Q: OK, I want to start a website for private tutors and students. I need to have a database on the ... A: Nick, If you're going to do it all yourself then you'll need some knowledge of a server programming ... | |
| mysql consuming too much disk space. | 2/28/2007 |
| Q: I have come to notice that the /var directory is taking up over 70% of that part of the hard drive. ... A: Shailender, I am not personally experienced with this, however a search got me to this article - ... | |
| Tricky mysql query | 2/16/2007 |
| Q: i am making a application of buses.. Now i will show you some rows from my database: ROUTE|FROM ... A: Miha, I think you should collect all rows as you show, and then process them to look for ... | |
| Cant find error in syntax | 2/16/2007 |
| Q: I have this query: [query] DROP TABLE IF EXISTS linije; CREATE TABLE linije ( id INT( 23 ) ... A: Miha, Since the error message pointed to your first create I ran it on my own Mysql console, using ... | |
| mysql count query | 2/16/2007 |
| Q: it wouldnt reached to that number since the user would enter the data up to 26 or if it exceeds then ... A: I'm confused about what needs to be done. If users can only choose from a dropdown between values ... | |
| SQL JOIN | 2/15/2007 |
| Q: i have this query: [query] SELECT users.username, news.title, news.body, news.posted_by, ... A: Miha, I believe you will have to qualify the '*' with the table name just as you would for ... | |
| mysql count query | 2/14/2007 |
| Q: ..i really need your help here... in my query..im using the function count(*)...and i want the ... A: Scarlett, What do you mean? Say you issue the query >select count(*) from employees where name ... | |
| Mysql and Foxpro | 10/22/2006 |
| Q: Hope you're doing great. I'm joseph from the Philippines. I'm new to Mysql but have an idea about ... A: Joseph, I am not familiar with Foxpro myself but think you'll need the right ODBC driver for your ... | |
| Running Multiple MYSQL Servers | 10/3/2006 |
| Q: We own a site that is projected to have over 3,000 users within the next few months. Our site offers ... A: Andrew, Honestly 3,000 users doesn't sound like alot. However I am not a systems tuning expert and ... | |
| mysql allocated disk space | 10/3/2006 |
| Q: In mysql is there any command to get the disk space allocated to Database and currently how much it ... A: Shyamal, use database_name; show table status; Write back if you need more info. -- Marty ... | |
| Lock/Unlock the user | 10/1/2006 |
| Q: I have an user account in mysql name james. I want to Lock the user and after some time i want to ... A: Deepu, I think it would be easiest, as root to change that user's password. mysqladmin -u root -h ... | |
| Mysql on Windows | 9/26/2006 |
| Q: Kindly help me on the following issues. 1. I am using PHP - Mysqlmysql-4.0.12 - PWS - Windows98 ... A: Thomas, A google on that error message got me to this BBS posting: ... | |
| database | 9/24/2006 |
| Q: I was wondering if you can give me some suggestions in how to create a databae using microsoft ... A: Sue, I am not an expert on Access interactions with MS Outlook. However if you are undertaking this ... | |
| mysql query | 9/21/2006 |
| Q: sir, i have 3 tables, booking,bookingFcl,container select b.booking_id , ... A: Geetha, Could you show me by example the result you'd like to get and then the result you are ... | |
Marty Landman
Top Expert on this page
Expertise
Anything having to do with programming, installing or administering a MySQL database.
Experience
Computer programmer especially for website using MySQL with Perl and PHP also installing and running MySQL under both Linux/BSD and Windows OS'.
Organizations
Face 2 Interface Inc.
Education/Credentials
MS Computer Science.
©2012 About.com, a part of The New York Times Company. All rights reserved.