MySQL Database Forum

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 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 )";

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...

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

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...

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

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...

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

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'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 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...

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...

Suppose i have two database in the different server but one table name is same in both database. How can i insert data both table at the same time

I can not able to see the following query result. start running before 10 hrs. I try to fix the problem by adding index for both tables I used and also I enabled mysql query catch. For your information I used mac os X, processor 2.66 GHz intel core I7, 4 GB memory 1067 MHz DDRS. and mysql version : 5.5.14; number of records in fileinfo :...

i got this error after uploading all the files in www folder. i'm using webserver <?php /// For the following details, /// please contact your server vendor $hostname='localhost'; //// specify host, i.e. 'localhost' $user='server username'; //// specify username $pass='server pass'; //// specify password $dbase='mysql db'; //// specify...

Hi all. I have a table in Mysql. The table consists of three columns: SponsorID, LeftID and RightID. And the table consists of hierarchical data, exactly like a binary tree. LeftID and RightID can become SponsorID and have left and right child and this continues to create a hierarchical parent child relationship in the table. Now I need to...

I cant connect MySQL with Delphi 6 in Windows XP. I know that i must have driver for MySQL in ODBC and start it from administrative tools, but i can't connect BDE components with database. I have already connections with MS SQL Server and MS Access via Opus Direct drivers. Perhaps i need to clean system from all that and than try? Thank you, ...

Hi all, I am facing difficulties on creating a particular query. Sample of my data table 1: (DetailsTable) Order | Material | Quantity | Weight 123 | Orange | 10 | 123 | Apple | 20 | 123 | Guava | 20 | 233 | Orange | 10 |

hey guyz could u please help me 2 get a particular data from many tables in database without specifying the table name in query... for example.. i have marks database with table english, tamil, maths etc.. i want to select particular student mark from all tables without specifying the table name.. if u have any idea post it...

How will the following coding be changed if I'm using it in MySQL? Please someone help me... SQL Server Code create function dbo.iso6346_char_to_number ( @char char ) returns int as

How would you write a check digit in MySQL if you want to generate a random number that exists only out of 6 digits and then generates a check digit?

Hi, i want my app to run on a LAN with 8 systems. i have xampp 1.7.4 installed on the Server computer. the workstations can access the homepage of the app but cant access the database, please what do i do next

Hello! I have a table with a column called "Lesson_Names",varchar type. The following query : "SELECT Lesson_Id FROM Lesson_Names WHERE Lesson_Name='LATIN_2A' " returns 2 IDs instead of 1 ( the IDs of "LATIN_2A" and of "LATIN_2B" ) . Is there something i am doing wrong? Thank you in advance , Elias

all, i was learning the sql injection prevention and after learning it , wanted to see my current code what if it could have an sql injection here is one of the statements i have in my code $bung_id=$_GET; $q_B="SELECT * FROM bungalows WHERE bungalow.bung_id='$bung_id'"; $r_B=execute($q_B); this statement executes on a page where i...

One of my applications collects a lot of data and is outputting it to a group of analysts that view it in all sorts of ways. To speed up things we've been using a lot of indexes on our main tables. At some point, i wonder what kind of problems we can run into with all these indexes we've created. What's the a good number of indexes for...