MySQL Database Forum

Hi I am running SuSE 9.0. I have installed, MySql 4.0.15. Apparantly versions 4.0 and above are supposed to come with InnoDB tables already enabled, this is not the case with mine, the have_innodb variable is at NO. I edit the my.cnf file to include the following as per mysql manual innodb_data_file_path = ibdata1:10M:autoextend...

Hi.. we are running a webserver on IIS with a mysql backend. The mysql service shuts down extrememly frequently with an event log code 7031. Has anyone seen this before. Is it a configuration issue? If so any and all help would be greatly appreciated. Regards Peter S Morton

I have the following table structures; create table Platform ( PlatformId mediumint Primary Key auto_increment, PlatformName varchar(25), ProjectName varchar(50) ); create table PlatformSubType ( PlatformSubTypeId mediumint Primary Key auto_increment,

ATTENTION; Finding it tough to make money on the Internet? Want to know some well guarded secrets that will essentially make all the difference between not making money and earning a good income online? Ahh...Never mind. It's too unbelievable. http://www.freeadguru.com/cgi-bin/i.pl?c=a&i=20496

Hi folks, What I'd like to do for a website I'm designing with PHP/MySQL is have a number of registered users who can make friends with each other... so if person 1 wants to be friends with person 2, 1 can add 2 and then they will be recognized as friends. I also want, if person 3 is friends with 2, and goes to person 1's page, person 3...

Hi, I am converting some queries from stored procedures in MS Access to MySQL, and have hit my first problem. The Access query references another stored procedure, which is where the problem lies. I have the following table data: (apologies if the columns aren't aligned properly... it looks ok in a fixed-width font) img_num img_page ...

27h Bao Feng Mansion, 299 Jingjiang Road, Shanghai China www.cmiec.com Dear Sir/Madam, We are co-operation who deal on raw materials and export into america/europe. We are searching for representatives who can help us establish a medium of getting to our costumers in america and europe as well as making payments through you to us. Please if...

Can some one help me? I am using mysql 4.0.20a Here's the situation (I know it sounds kinda strange, but please follow me here): I'm trying to create a messaging forum. I have Forums (for example sports), within those forums, I have topics, for example "Who will win the World Series." There is another table which contains threads,...

I'm looking for documentation on the wire protocol used between the MySQL clients (odbc, jdbc, etc)and MySQL server. Pointers to files in the source code would be great too. I've been browsing the source but haven't come across any key headers or source that documents/implements it. Can anyone help? Thanks very much.

I have problems getting character set convertion to work in 4.1.4 gamma under linux. Can sombody point me to the online recource other than standard MySQL doc so that I get more information.

test

I am new to MySQL and my problem is with storing a datetime value in a table. I created a table with a column designated as DATETIME. I fill it with the NOW() function. No matter whether I default it or try and set with code, all I get is a date! Even running "SELECT Now()" only returns a date. If I run the following query: ...

Hi I am running SuSE 9.0. I have installed, MySql 4.0.15. Apparantly versions 4.0 and above are supposed to come with InnoDB tables already enabled, this is not the case with mine, the have_innodb variable is at NO. I edit the my.cnf file to include the following as per mysql manual innodb_data_file_path = ibdata1:10M:autoextend...

I'm looking to do something similar to a feature found on Ticketmaster.com, where you select your seats at a venue, and then you have two minutes in which to take or leave them. QUESTION 1a. Inside (or just after) the same query that searches for available seats, I need to SIMULTANEOUSLY mark those seats as "on hold". I've only read...

Hey, I'm going to give some background on my situation in case anyone can point out a way around my problem altogether... for the problem itself, please skip to the bottom of the post. thanks. I've been having some problems with database performance... Several threads are constantly attempting INSERTs of new records into a large table -...

Hi I uploaded a file to my mysql-db via commandpromt (which I have done 100 times before) everything went fine exept "warnings 1" how do I see what that warning is about ?? -- Erik Denmark

Can these lines of sql statements be consolidated into one sql statement (possibly using reg exps??) BEGIN CODE ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Update applications Set news_article = replace(news_article, '<FONT face="Times New Roman" color=#000000 size=3>', ''); Update applications Set news_article...

Hi, I have heared about the database index, I know its something that makes the index of some of the fields and can result in a very fast search for a large DB. I wanted to know if we have database index in mysql and if yes where can I read more about it, like creating and using them with php. I googled a lot but may be I don't know the...

I have set up MySQL on my machine and can successfully use it. However, I'm trying to set up TOra so that I can browse the databases effectively. I'm having lots of trouble trying to get TOra to work with MySQL. Please take a look at the notes below and please let me know why I'm having trouble and how to fix it..... Thanks -Saqib

Can somebody tall me how many concurrent users the mysql database can support? 15? or 150? Someone told me 1000 persons however it seems unbelievable.

I'm entering in MySql world and I have some issue to solve. I'm not finding a very well solution about the distribution of application upgrade. I use a FE MSaccess-based, and I use a MSaccess-based launcher and update checker. To manage MySql DB from MSaccess, I use ADO, and it run well. The question that I'm not solving is on my...

Hi, I have a products table which apart from other things has a column called manufacturer. I want to run a query that returns x number of products PER manufacturer for each manufacturer that matches some criteria. table::products -------- id

I want to learn MySQL. I started reading the book MySQL by Paul DuBois, second edition. I have the option of downloading and installing a copy of MySQL on my computer (PC) or use MySQL provided by my ISP. The question is how do I use/reach MySQL on my ISP's server? It appears easy enough to setup the database usernames etc. since the setup...

I have a table "Subscriptions". Subscriptions contains the columns "ChannelID" & "MemberID". The "Channels" table contains a column called "Title" When someone is viewing a channel, I would like to display "Members who subscribe to this channel also subscribe to ..." and then list the Titles of 3 or 4 channels ordered by the most...

I have a STATUS table consisting of a uid and description, that looks like this: 1 Accept 2 Accept with corrections 3 Reject I have a CHOICE table which referrs to the uid of the STATUS table, in one of it's columns.