[mysql] Forum Topics

Ok, i have a database where i'm storing information on plants and in one of the tables is a plants table: here's the first few fields in the table plants: [code] plant_id, family_id, genus_id, species_id, auth1, auth2, ... [/code] plant_id is the pk, family_id, genus_id, species_id are foreign keys. soon …

Hi all, I hope everyone is well. :) Ok, I don't know how to explain this properly, so I'll just struggle along & if you need anything clarified, please ask. First, I'd like a quote from only very experienced MySQL/PHP programmers on how much this appl. will cost to build. …

I want to know how to copy the mysql database on my development PC to mysql server on my production PC. Please, anyone who knows how to go about this should help me. Thanks! JNORA

I've been tring unsuccessfully to find information on what each language, C and PHP, have to offer in terms of working with MySQL. Just wondering if anyone out there has preference for one or the other and why. I understand that PHP is supposed to have alot of built-in functionality …

I have a huge database in SQL on my hard drive, I am trying to figure out how I can get it online with a decent looking interface to allow my sales people to run querries on it simmilar to what infousa has going on. My database knowledge is not …

Hi all, Im trying to create a trigger but keep getting a syntax error. Basically the trigger must be created after a insert on table_1 and update another table's fields with 1 depending on what was inserted into table_1 ( apple, orange, banana, grape ) CREATE TRIGGER trigger_name AFTER INSERT …

Ok this is what my table structure looks like: username varchar(20) eadd varchar(40) for email addresses bday varchar(4) everyone is posting mmdd emailques varchar(2) they answer yes or no I want my query statement to tell me what birthdays are today and as a bonus email them on their birthday. …

Hi, i am having a problem with indexing. In my database, one of my table have 3 foreign key references, All these fields are indexed by default. I need to create an index for a regular seach item. is there any problem regarding performance, if i combine the primary key …

Hi, I keep on getting the following error message: Software error: DBD::mysql::st execute failed: 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 '-50,50' at line 1 at arp3-data.pl line 48. My host is …

Hey Guys, can you suggest any Open Source Application Server for SOA deployments. Also, wondering, if our needs are somewhat lightweight, is there some lightweight open source Application Server you could Suggest.

What are the performance implications of storing some data across 2 databases instead of duplicating this data in both databases? ie. is example 1 significantly slower than example 2: Example 1: SELECT Users.User.*, Transactions.Sales.date FROM Users.User, Transactions.Sales WHERE Users.User.id=Transactions.Sales.userid; Example 2: SELECT Users.User.*, Users.Sales.date FROM Users.User, Users.Sales WHERE Users.User.id=Users.Sales.userid; Note …

I have one doubt about WAR file........ Like i am creating a project with mysql databse and deploying it through WAR file My question is if i want to deploy it on some other machine then i am copying war file there in webapps folder.........but do you think it war …

Hi All I am trying to create 2 tables Table 1 with cust_id , username and password (Cust_id is primary key here) Table 2 wth cust_info that will store info for that cust........now i want to use this Cust_id as foreign key here in table2 but i am not able …

Hi, I have been searching around for a few days and cannot find exactly what I looking for. Was hoping someone could point me in the right direction. Looking to query MYSQL with keyword. For each of the records or rows its finds based on match. Would like to retrieve …

I have a Database which is dealing with a book library system. I have a table which has a has a field dealing with the ReturnDate of a book. I was wondering if it is possible to do a SELECT statement that would return the the fines due on an …

I want to generate a code that will automatically take the poll-id..of which the user wishes to view the result of that poll. there's the code:using mysql & java & another thing i wish to use this on a jsp page: [code] package votepiepack; import java.sql.Connection; import java.sql.DriverManager; import java.sql.*; …

Hi, I've tried several of the fixes for this that I've found on here, but I haven't been able to find a work around. Here is the code that I'm having the trouble with: [code] mysql_select_db($db_name,$db); $result = mysql_query("SELECT * FROM pages WHERE pagenumber LIKE $pagenumber ",$db) ; while ($myrow …

I have installed MySql 5.0 and also configured but after installation it shows " The Service couldn't be started" Plz help me out

Hello All, I have been trying to pass variable values as a parameter name in MySQL Stored Procedure Insert Statement when i directly pass the parameter name it works fine, but when i asign the paramter name from a variable value it is passing those values as a value not …

i tried like a million things and im ready to murder someone, can someone walk me through it? thanks.

Hi, Was wondering if anyone could help me with this little problem I'm having. I'd like to have a comma separator after every 3 digits. E.g "3,000,000". How would i go about this? Thanks in advance

Hey guys, for an enterprise wide deployment, what will you suggest and why among - Red Hat Linux, Suse Linux and Ubuntu Linux, also, do you think, we can negotiate the support pricing down?

Hi everyone. I`m looking to solve an issue. My problem is : i have more tables, but in my example will be only 3 with 2 columns: users (id,nick) comm (id,userID,text) rev (id,userID,text) So , i need to count the comm and the rev that users make, multiiply by a …

How to fastening inserting data on mysql??? I have 5000 record in excels. And I want to insert all record to mysql.. and it take time abaout 6 six minutes.. How to fastening become under 20 second to insert all 5000 records?? Peace DODOl

hi all, I am a developer intending to do Mysql 5.0 Developer Certification. How this certification is valued in the IT industry? Is it worth doing MySql certification? Please advise. And if anything you want to say about Mysql 5.0 Developer Certification. Thanks

Hi out there!! I have a problem in creating relationships in MYSQL. could some help me out there? Am a beginner in system development and I would like to learn more. YOuare great

I'm developing a small, web-based poetry sharing website. I'm a beginner in PHP and MySQL. I want users to have a personalized page where they can work on their work in progress, once they feel they can publish it for the other users to view. I've already created a login …

Hi, I'm newbie here. I just noticed that HR control panel have no feature to check and repair MySQL database if the database got corrupted. I knew CPanel have this feature and I guess the HR control panel look similiar like CPanel (CMIIW), but no feature for Check and Repair …

Greetings. My first post. I'm running a fairly popular wordpress blog (about a million page views a month). I have a plugin called "recent comments" which lists the last 20 or so comments in the sidebar of the site. However, the queries it makes are very disk and CPU intensive. …

PHP version 5.1.6 MySQL version 5.0.27-standard-log Table is super simple, 1 primary key, uid, unixtime(timestamp),blog, pro, bull, pix [code] if($uid > 0 && $id != $uid){ include('connection.php'); mysql_query("INSERT INTO history SET uid='$uid', pro='$id'"); } Thats all. Does anyone know why this would create two identical records every time? [/code] Anyone …