MySQL Database Forum

The mysql server is running on 172.x.x.x:3306 and the phps are on server having 192.x.x.x. The database on 172.x.x.x is to be accessed for read/write on 172.x.x.x but the same database is required to be accessed for read only on 192.x.x.x. Presently one proxy is running in between these 2 networks. How to connect the database on 172.x.x.x...

I'm still fairly new to MySQL and I've been given a task by my lecturer that I just can't make work. She wants us to use SET to add a row to a table instead of the regular VALUE method. Here's my code and the error I received: mysql> INSERT INTO Instructors -> SET FacId = 96 -> SET FirstName = 'Chris' -> SET LastName = 'Explorer' -> SET...

I'm a MySQL newbie.. So, please forgive me if it's a simple question :) I'm developing a system to get some specific data and store it to a database using C#. I have almost finished the system. I'm using a MySql database running locally on my machine. I need this database to be accessed remotely so that my employer can view the data. He told...

I m using a mysql table(say tbl_student_mark) which have the data id,student_name,mark_physics,mark_chemistry,mark_biology.... I have to find the name of 3rd Heighest scrorer across the table Can any one help me??

I have 2 tables both have a primary key which links them, How can I run a count query to look at the first table and check the id, then look at the second table and count up how many records have that same id? table one key - software_make 1 Adobe 2 Microsoft

In trying to start fresh, I have deleted everything in the c:Xampp folder EXCEPT MYSQL>DATA>ib_logfile0, ib_logfile1, ibdata1, mysql.err, pbxt-lock/ message says I cannot delte because it is being used elsewhere I have searched Xampp, apatchefriends, my sql and deleted everything that produced. so far as I can tell, these 5 files and two...

Hello, I have a database for my products. In there is a table with all the products and there is a table with te actual prices. I need to select a product and inner join the price table an get the latest (read latest id) from the price table. What is the best way? Table structure: products: ID int(3) PK

Greetings, I'm trying to execute a sql file in the command line for sql 5.5 on a windows 7 computer. My sql file is on my c drive in the directory "john". My sql file is named mysql-start.sql. How do I execute the source command to run this sql file? This is something I am learning from a free online database class from Stanford. Here is how...

is there any way to backup an sql server 2000 database using the front end (Vb6) ...... Had been it in Access itz even possible via save as dilog I ve done it but sql 2000 is a problem

I know there is a way to create a temporary column as part of a basic Select Statement search that shows the result of mathematical calculations done in that search, but I can't remember the syntax and googling it has been a wash out. I have a list of classes in a database. I need to list all classes with less than 12 students in them, that's...

I need to retrieve all rows which suits a set of values in an array. Now am using $bound = implode(",",$arr); $sqls="SELECT * FROM main where area IN ( $bound )";

Hi! New to this forum im looking for an easy way to create a table from ex. an xls or csv file? Would be ok to create all columns as VARCHAR, I could then correct "Type" after the table creation manually. Have a MySQL 5.5 server on my Mac Pro running OS X 10.7. Also have Sequel Pro, MySQLWorkbench installed, and have phpMyAdmin set up on...

I have the following create statement $query = "CREATE TABLE P( code int(2) NOT NULL, value decimal(3.6) NOT NULL, PRIMARY KEY(code) "; but when I look at the data field using phpadmin, value is (3.0) , and when I insert a value say "123.123456" this number gets converted to 123.

i m a degree student i have been given a project in where i have to do a database using OLAP and get the chart... the basic problem is that i cant get the software installed on my machine... please suggest me which IDE to use and how to configure it so i can create a OLAP schema cube... thanx...

Hello all, I need to delete records from a table in a MySQL database that are more than 700 days old. There is a column with the time of the record's entry "pPostDate", & the dates are in RFC 2822 Format... the column's format is VARCHAR, not date or datetime. The date record looks like this... Sun, 08 May 2011 14:21:50 +0000. I have...

Hi, I have a big table (1M rows) with the following columns: source, dest, distance. Each row defines a link (from A to B). I need to find the distances between a pair using anoter node. An example: If want to find the distance between A and B, If I find a node x and have: x -> A

Hello I was wondering if there are any alternatives, instead using SQL? Thank you in advance :)

Hi all , i need to add pricing structure for bookings , what do you people suggest, minimum how much tables would be needed for this. Winter Member Guest Weekend 40 50 Weekday 30 40

There are two table from which i want to get value 1. heads 2.subheads The field name in heads table is: id, head_name.

hi i have an html input which is built from php and have an onclick function that calls the javascript function and sends some arrays to that function which are initialized via php and then passed to javascript function and then again submitted to a php file via an AJAX call but the problem is that when passed to the php file via AJAX it try to...

I have a table "search_log" that logs all search by client here are some of the fields query_date , query_result, query_code here is the thing as the owner of the site I want to be able to see a user that searched four times in a row that has no result to be able to save them and stop the from being disappointed if a client searches and...

package com; import com.opensymphony.xwork2.ActionSupport; import java.sql.*; /** * <p> Validate a user login. </p> */ public class retrieve extends ActionSupport

im making my own php driven website, with next to no previous knowledge. everything im learning is coming from tutorials so i keep hitting brick walls. my latest problem is i want to link two rows in my database (i think im explaining it correctly) basically i have 5 rows so far admin - used to store admin information for back end...

Kindly view the code: <?php include("../db.php"); $result = mysql_query("SELECT * FROM accounts WHERE id LIKE 7"); while($r=mysql_fetch_array($result)) { $clientname=$r; $date=$r; $clentid=$r; $data1=$r; $data2=$r; $data3=$r;

hello, I have a form C_details with several fields. i have 2 fields.....1) emp no 2)emp name if the value of these two fields are same corresponding to a previous entry, i like to lock some certain fields of the form and these locked field should carry the same value entered previously.