7,368 Topics
| |
Dear friends, This is my table: CREATE TABLE IF NOT EXISTS `exam_student` ( `exam_roll_no` int(10) unsigned NOT NULL AUTO_INCREMENT, `enrol_id` int(10) unsigned NOT NULL, `exam_id` int(10) unsigned NOT NULL, PRIMARY KEY (`enrol_id`,`exam_id`), KEY `exam_roll_no` (`exam_roll_no`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; I am trying to get the field **exam_roll_no reset … | |
Hi, I want to update a column in **same table** if another column is updated but I'm getting error message. > Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger I tried two different approaches but no luck. Same error. … | |
Hi all, i have 2 shared host server(www.nextsoftech.com(ip:64.202.123.78) and www.simpletelecomltd.co.uk (ip:208.91.198.107)). i want to access nextsoftech.com 's database from simpletelecomltd.co.uk 's script. that's means i stor all script simpletelecomltd.co.uk this server. Would any one help me how can configure and what is the connect code in php? thanks you sumain | |
Hi all, I'd like to know if it is possible to create a perl script that would take the names of image files with its extension of say 10,000 images from out of a folder and place them into a database table in separate rows to use as sample data? … | |
Hi all, I'd like to know if it is possible to create a php script that would take the names of image files with its extension of say 10,000 images from out of a folder and place them into a database table in separate rows to use as sample data? … | |
I am developing an sql query to use to grab information from a postgres db. The scenario is as follows: the database I am grabbing information is the backend postgres database of an application (Tableau). My objective is to pull all of the workbooks, views, and datasources (considered objects) that … | |
Hi, If i want to create a user in MySQL only to allow the Php program file to access the database and show results in my website what priviliges should i give to the user. So that access to my database is never compromised if someone can get the password … | |
I recently decided to try out a simple PHP/MySQL pagination script I found online. After replacing all the required data and creating a connect.php file with my db information, I got a bunch of errors on the page with the script: here they are, in order: Warning: include(connect.php) [function.include]: failed … | |
Hi all, I have a registration page which allows the user to open up separate windows to include additional information. But for some reason it freezes the page and doesn’t allow data to be submitted into the MySQL database table. I’m mot sure whether this is a php or a … | |
Hi all, I have a registration page which allows the user to open up separate windows to include additional information. But for some reason it freezes the page and doesn’t allow data to be submitted into the MySQL database table. I’m mot sure whether this is a php or a … | |
I have a project in which I desire to upload and download blob files in php. I have written the codes to upload the files into mysql however, when I try to download the files, be it pdf, .doc or jpeg, the error message I get is "The selected file … | |
> Here **My Application is used MySQL as a database. and on my server MySQL is running. server is highly configured on Win XP Os and other on Win 7. Mysql version - 4.0.18-nt My problem is , Mysql is stopped working everday after 5 to 6 hours. It is … | |
I'm a novice to PHP and MySQL, and would like to create a mailing list on my site, which can send HTML documents (basically styled to match the actual website). Can someone point me towards a good tutorial, or show me how to do so? | |
I am trying to do something that should be trivial. I have a database table that I want to load into an array so that I can use the elements later on in my code. What I dont understand is how to put the elements into a simple 2 dimensional … | |
Question: Does anyone have any recommendations that are likely to keep a large database healthy/speedy? I'm designing a database that is going to retrieve around thirty million data points a year, up to around three hundred million to a billion in a few years time when all of the sensors … | |
| in this code- CREATE TABLE `tablename` ( `id` int(10) unsigned NOT NULL auto_increment, `a` varchar(10) NOT NULL, `b` varchar(45) default NULL, `c` varchar(45) NOT NULL, `d` varchar(45) default NULL, PRIMARY KEY (`id`), KEY `Index_a` (`a`), KEY `Index_bcd` (`b`,`c`,`d`), KEY `Index_cd` (`c`,`d`) ) ....; what do the lines that start with … |
Hi, Guys i need a simple help from you guys. There's a scenerio that i m sure is very common in mysql and i know most of you can answer that but i m new to mysql so need some basic polish. so my scenerio is that for example i … | |
Hello, I have two tables one for the customer_records and one for the jobs. Both tables are linked together(both contains customerID and foreign key is set) I am trying to insert data into the job table by obtaining the customer ID that is given in the textbox. I have: INSERT … | |
guy plz help me out with this. If i have a table, in the table is a column called veh_status, the row data will be varchar storing one or many comma seperated numbers so veh_status could be 1,2,3 each number represents an id to the relevant vehicle statuts name and … | |
Please help me create views and generat report using only MySQL manager thank you | |
Hey, I am having a really annoying problem when trying to set up a foreign key in my database... I have two tables - Sell and Category I want the 'c_id' from the Category table to be the foreign key for 'p_id' in the Sell table. Both tables are InnoDB … | |
Hi all I'm struggling with a MSSQL database that, ultimately, I want to get into MySQL, but for now I just want to import to a local server. I know nothing about MSSQL, but I am pretty familiar with MySQL. I have a .bak file exported from my current hosting … | |
Hello: I'm trying to get a record from mysql based on the query of another the queries separately: set @row_num = 0; SELECT @row_num := @row_num + 1 as row_number,queue_num,clientID,customerid, todays_date, request, details,status FROM queue_sys ORDER BY todays_date; outputs row_number queue_num clientID customerid todays_date request details status 1 14 44DWS … | |
Below is my code which worked up until this morning. conn.Open if giving error 10060. I downloaded the latest odbc driver from MySql and that didn't help. Dim rst As ADODB.Recordset Dim conn As ADODB.Connection Dim gs_SQL As String Set rst = New ADODB.Recordset Set conn = New ADODB.Connection CheckADOConnection … | |
Hello, can anybody help me here? I am using mysql database and xampp server. Now, I made the database using my laptop computer and I have to distribute the database with its records to another laptop computer. The problem is when I tried to transfer the database file to the … | |
Hi, I have a problem in making a query.I have two tables patient and encounter. Patient has one to many relation with the encounter table. The encounter table has a field encounter_date. I want to make a search query in which I enter the date ranges and the query fetches … | |
I'M just trying to work my way through the book "Head First SQL" but I can't seem to get it installed. I just need the simple DOS like pompt MySQL program to learn on. Here's what I'M getting when I try and install it. mysql-server-5.5-winx64:6 - Looking for valid template … | |
Hello all, I'm hoping you can help me with my first search engine/join query. I have 3 tables with differing numbers of coulumns - clients, projects and tasks. Table "clients" with the columns "cid", "client" and "date" Table "projects" with the columns "pid", "cid", "projects" and "date" Table "tasks" with … |
The End.