MySQL Database Forum

I've got a library of PHP code whose first line is a mysql_connect statement, like this: $dbh=mysql_connect() or die("mysql connect failed: $php_errmsg"); Approximately 1% of the time it just fails, for no stated reason: Warning: mysql_connect() http://www.php.net/function.mysql-connect]: in /var/httpd/htdocs/pi/pi.php on line 3 mysql...

Hey all, I have a web app that uses SQLServer 2000. I am switching to MySQL 4. 1.1. I have re-created all the tables but I'm running into 2 problems. 1. In SQLServer I can create a date field and as the default value I

I have a slackware 10 box with mysql 4.0.20. I have just started learning to use mysql. I have used the medium file for my my.cnf file and have uncommented the innodb stuff as that is what i wanted to play with. I imported 3 million recs from my postgresql table into mysql as an myisam table and ran some speed tests... I then converted...

(MONEY TRANSACTION) Hello, My name is Dr.Bala Mohammed, and I work in the international operation department in a Local Bank here in South Africa.On a routine inspection I discovered a dormant domiciliary account with a BAL.Of 36,000,000 (Thirty Six Million USD) on further discreet investigation, I also discovered that the account...

I would like to write the spent time for a mysql select, in the style of Google's searches: "x results found for xxxxxx in xx secs". How could i get the spent time from my PHP code? When you do a mysql statement on a terminal this is shown at the end of the results, but i can't find how to get this from PHP.

I have two tables populated during the use of an application to log user events and application states. They are named "EventTable" and "StateTable" and the structures follow: EventTable: ID EventTimeStep EventID -- ------------- --------- 1 5 E1 2 22 E2

I am new to MySQL so I apologize in advance for my ignorance. I have two tables say TableA and TableB. I want to be able to select a group of entries from TableB but only display the records that meet the search criteria and are NOT in TableA. For example. TableA: 111,John,55 112,Joe,13 113,Matt,55

I have this type of setup for a weekly schedule I'm trying to make: Four tables: Schedule-Fields=id,mon,tues,wed,thur,fri,week,group,user Schedule_Users-Fields=id,group,fname,lname Schedule_Items-Fields=id,item Schedule_Groups-Fields=id,group The idea here is to have a weekly schedule for our users as to where they will be on any given...

Hello all I am a newbie to Linux, Apache and mySQL etc. I am running a standard RH9 build with yum updates. All appears to be working ok except one aspect. Simple database (indexed 2 table)activity works but on a more sophisticated existing database accessed through a perl script I get this error (taken from logs): - lbf.cgi: DBI...

I am using Access 2K as a front end to a MYSQL database. I am trying to run a Union query on a MYSQL database. The query is SELECT as ID from faxdata UNION SELECT as ID from letdata UNION SELECT as ID FROM MEMODATA; I get an ODBC error. The same query runs when the backend files are MDB files and it runs with MYSQL if I only combine...

Hello, I am using the LOAD DATA INFILE command to import a textfile into mysql. However, there is much moor text in the file the needed in my tables. How can I make a selection from the text line. For example position 5 - 10 in field a, position 20-23 in field b, etc Regards,

I have a very small db of only like 15 files, and with 120 records. If I do a query from the page, via a php file it seems to take 2-3 seconds for the results to come up. I'm anticipating having a lot more records, upwards of 300-800 records. I'm looking for the best way to create my indexes for fast response times. I think right now that...

Complements=2C Dear Sir=2C I am Mrs=2E Patrika Kovac a Yugoslavian and company secretary to YUKOS OIL South Africa owned by Mikhail Khodorkovsky =28M=2EK=29 one of the richest men in Russia and owner of the following companies=3A Chairman CEO=3A YUKOS OIL =28Russian Most Largest Oil Company=29 Chairman CEO=3A Menatep SBP Bank =28A well...

This has to do with mySQL 101. I know it's supposed to be super simple, but I'm an idiot. I can't get my join to work (1st time I've tried doing joins.) I've read http://www.mysql.com/doc/en/JOIN.html, but I'm just not groking it. When I try to do the same thing, I can't "convert" one field into the data from another. Here's what I...

I have a question about the "grande" entries in the 'user' table of MySql 5.0.0-alpha. What is this? Also, why are there two rows with "root" (one with localhost and one with "grande")? Why two entries? Thanks for the help

Hello, I would like to model and implement a simple application for keeping track of user survey data for our marketing department. The concept is very simple: a user of our website can opt-in to answer a short list of questions for data collection. The answers to all of the questions are presented in drop-down boxes, so no free form...

Hello I'v got the following tables CREATE TABLE `aa` ( `aaid` tinyint(4) NOT NULL auto_increment, `test` varchar(255) NOT NULL default '', PRIMARY KEY (`aaid`) ) TYPE=MyISAM AUTO_INCREMENT=4 ;

Hey all, I have 3 databases replicating (ver 3.23) A to B and B to C On C I want to modify one of the tables and add a column. Tables A and B will not have this new column added. Will this cause a problem replicating data form B to C? Thanks,

> Executing just the search on the word table, with no joins to the > table with the dates, is still slow: Then it is not worth while to focus on anything else until you fix that. Are the contents of this field always in lower case? Is so, then change the column to a binary type. The explain says: > rows: 318244 > Extra: Using where;...

hi, i have a website built with php / mysql the database seems to take about 30 seconds to return the result of a query. the query is "select * from table where record_id=$record_id" I have made the record_id field in the database primary key.

cvb

Object : How to optimize mysql architecture for better web connection ? Hello, I use phpMyAdmin 2.3.2 and MySQL 3.23.58 and I do not know how to well-organize mysql architecture for the user convience and speedness. On my web site, I call all the stucture from one table (5 colums and 50 rows).

Hi I have two tables: T1 --------- sequence start end T2 --------- id pos

I'm currently teaching a course in web programming where we're using PHP to connect to MySQL. A book we're using has a sample database in it for use in practicing, but the database is not well populated with data. This works fine for some applications, but I'd really like the students to experience working with a variety of database...

Hi, i need some help with a select statement, i tried many different MySQL fucntions and looked through the MySQL manual, and it didnt help me any. What i want to do is select all rows from a table where my time column(DATETIME) is less then or equal to 5 minutes ago from now(). Any help is appreciated, thanks