[mysql] Forum Topics

Hi, Thanks in advance for any help someone could offer. I'm trying to display a list of stories submitted to my site from a table titled stories, the name of the person who submitted the story and how many comments about the story have been posted. I'm working with three …

Sorry all, this is probably an asked question already, but can't seem to find it. I have designed and uploaded a website for a company. Static pages (3) with a simple form using php to direct the form to one of the companies e-mails. I now need a members log-in …

hello guys, i know all of you are gurus at this as for i am a rookie, i am currently using MySQL 2000 and i would like to retreive information from the database from a certain table via an HTML website what are the scripts that i could run to …

I am new to MySQL and did not notice this before. In order to get the query to work I have to use two different quote marks. Notice that the single quotes on the left where I list the column names are from the keyboard key with the tilde `~ …

Hi, I wanted to make use of a algorithm script for computing scores nd though i started doing it with a single database, i after testing script, decided to get a master and score databases both having same tables and data. I imported 2.5 GB of data dump to both …

First off i'm not sure if this post goes in mysql or php so if this is the wrong place please move this post for me. I am setting up a page with a list of commands that are pulled from a mysql database. I have the page that displays …

hi guys! i am enim, i usually post thread in PHP and i guess its my first time here in mysql.. i have problem regarding the total count of the terminatecause.. i need the count of ANSWERED calls only and the total count of all calls.. can i do this …

Good morning everyone, Is there a way to find out [B]how many MySQL connections are on a particular page[/B]? I am limited to 50 db connections (MySQL+Linux shared server). It seems that my site cannot handle more than two people at once. I have been told by my hosting provider …

Ok ... after receiving some great help and education as to how to design a relational database, I went on to try and create the front end for one. I am learning here so bear with me. To put this into context, so you know, I am using DreamWeaver and …

Hi there, please can someone help me with this. I have a VARchar field for NAMES and I need it order numbers correcly and I cant seem to work out the right SQL systax. My sql is this [CODE] SQL = SQL & " Select Distinct" & vbCrLf SQL = …

Hello, I have a master/detail table, in the detail I have a filed payment and another field sum_payment, all I want is when a new record is inserting the values of the field payment to displayed in the field sum_payment. I tried default value but nothing supports this, also tried …

Hi all, I've been given a project to design/build a distributed database on a small parallel cluster. I have plenty of experience with mysql but none with distributed databases. I've been searching information all over the net, but haven't located much on actually building a distributed DB. Can somebody point …

Hello all. Thanks for the help! Two tables: Table `posts` holds 'p_id', 'post', 'u_id' Table `users_profile` holds 'u_id', 'profile_key', 'value' How do I return [U]one[/U] row for each 'p_id' that includes all the information in the `posts` table as well as the information in the `users_profile` table WHERE `posts`.`u_id` = …

I'm a nubbie network administrator in my office, a couple of guys installed a mysql server, deployed a database(along with it) and also an application program that accesses data from the mysql server. I can ,using sqlog, log using a specific username, pwd, port number, servername(here i use localhost) . …

Hi, freinds how do i create new database in mysql pls help me its important

Hello ALL The project we're working on is a document retrieval system I have 3 tables as follows. Table 1 contains words from a example doc. Table 2 contains words from documents in a database. Table3 contain only one column ‘DocID’. I would like to search the database to find …

Hi to xperts here, I do not know how to update with the follwing requirement [code]$score_update_query = "UPDATE participation_score SET score_last_update = '$date' , score = (IFNULL((SELECT avg(score)*0.8 FROM entity_score WHERE entity_score.contributor_id = contributor.contributor_id) , 4) + IFNULL((select participation_score*2 from participation_score where participation_score.contributor_id = contributor.contributor_id), 1) ) WHERE participation_score.user_id is …

hi everyone i think this is common problem among many, i'm getting this message when try to open ssh shell using cpanel "For security reasons, shell access is not enabled by default. In order to activate shell access on your account, you will have to contact your server administrator" i …

Hi ppl! Im using a java servlet to access a mysql 5.x database, BUT when I run the servelt from my web browser I get this error : "No suitable driver found for jdbc:mysql://localhost:3306/spacemandb?User=root&Password=admin " I have intsalled all the necessary drivers viz mysql driver and it is working. here …

I was under impression that declaration of [icode]char(4)[/icode] can store only values of [B]exact length[/B] of 4 characters. However I was able to insert empty string and strings of less characters than 4. Is there some datatype that will only accept string of declared length? Strings with less characters should …

Im trying to connect from windows xp using my program using odbc connector and SQLyog to a mysql server which is installed in windows 2000 server.. i keep on getting the same error.. i tried to use wamp server also but i was not able to connect at all.. i …

Hi all, THere is no intersect statement in MySQL. I figure out a workaround as shown below. However, I am not sure if it is correct or not. Please help. [code] SELECT * FROM ( SELECT DISTINCT col1 FROM t1 WHERE... UNION ALL SELECT DISTINCT col1 FROM t1 WHERE... ) …

hi all, how to display last 10 record form a table.please help me.

Hello ALL, I did the following query. the EXPLAIN result showed 'NULL' in the 'key' colume, meaning that NONE of indexes have been used. However, indexes have been created on Name fields for both tb1 and tb2. I wonder why MySQL does not use the indexes to speed up the …

What I have done/tried: 1) Download JDBC driver from Centura/Gupta/Unify website. Called and confirmed the JDBC driver is backwards compatable with sqlbase 7.6 2) Put jdbc file into mysql migration toolkit lib directory: C:\Program Files\MySQL\MySQL Tools for 5.0\java\lib\SQLBaseJDBC.jar 3) Open MySQL Migration Manager, configure: - source database Database System: Generic …

Hi, I need to find out the term for two different query types. I know that we name queries as PL/SQL stored in the database and called in web pages like view, str.proc. What do we call queries used in web pages as a string and send to dabase to …

Hey, I have installed Mysql and launched it from command line using cd Mysql/bin/mysql. I want to now how to give user credentials as soon as it opens. Also, is there any default username by which it opens. I ask this because, without logging in I'm able to run all …

i'm using vb.net 2005 express + mysql connector to connect to mysql database. i want to save image into mysql database. so i've created a table with img field as longblob. to save the image, first i convert it into byte() and then insert into the table. the problem is …

We are trying to implement MySQL clustering on our E-commerce database, but presently the tables are MyISAM based and some of the tables have full text search index on. In the wake of Clustering environment, one of the requirements is moving to InnoDB. However, that would pose the problem of …

Hi guys I am building a website which allows people to advertise their property online for free. I allow people to upload up to 5 images to my database. I store the name of the file in the database and the image itself is stored elsewhere on the server. I …