7,368 Topics
| |
I created a foreign key on a table just using this statement. When I wanted to drop it, phpMyAdmin didn't allow me to do so. Would anyone suggest a nice way of getting away with it? [code] ALTER TABLE `likes` ADD CONSTRAINT (fk_user_id) FOREIGN KEY REFERENCES `users` (user_id); [/code] This … | |
hi everyone, i encounter problem when trying to create a form page to upload images to images folder and imagelocation will store information for the pathname where the image will be located ( will be used for display image in future) the code below does not have any error when … | |
I am getting an access denied error when I am writing to the database I am using this line [CODE] LOAD DATA INFILE 'upload.txt' REPLACE INTO TABLE Test FIELDS TERMINATED BY ',' [/CODE] I have made sure I allowed remote SQL, and I made sure to give the user all … | |
hi! another query! i want to insert values into the table 'employee' for the 'adddress' field in such a way that the large address comes in two or three lines like this [code] empid empname address mobile grade basic Joyban1 Joy banerjee 5/67, 1234567890 2000 10000 nehru colony, kolkata 700045 … | |
I have a very simple wish, to dump all databases so I can lock up a backup of the databases, tables, users and so on. It looked like [CODE]mysqldump -v --all-databases -u root -p secret > "${directory2}""$h"_mysql_dumpall.sql[/CODE] worked, however the file contained a little error message telling me I had … | |
is it possible to move a database from one machine to another? maybe like copying the tables... | |
i am creating a table employee which looks like this [code]use employeemaster; drop table if exists employee; create table employee ( serial int unsigned NOT NULL auto_increment, empid tinytext NOT NULL , empname varchar(255) NOT NULL, address text NOT NULL mobile bigint unsigned NOT NULL, grade char(2) NOT NULL, basic … | |
So I'm having this weird issue, where I can do SELECT statements and INSERT statements just fine, but when I do this UPDATE statement, it sorta works. It runs without errors, and even outputs that 1 row is affected. But when I check the MySQL, nothing is updated. I've echo-ed … | |
All right. So i have child, parent, activity and register table and i want know how much money a parent will pay for his child if the child have 1 or more activities. So i came out with this code: [CODE]SELECT CONCAT_WS (' ', parent_title, parent_fname, parent_sname) AS 'Parent/Carer Name', … | |
Hello everyone, I haven been trying to connect to my database but i have been getting this error: Error message: SQLSTATE[28000] [1045] Access denied for user 'mgs_user'@'localhost' (using password: YES) Does anyone know what is causing this error? please advice thanks | |
WELL I AM TRYING TO DO THIS BUT NOT GETTING ANY RESPONSE FORM SERVER DELIMITER // CREATE PROCEDURE getchgp(in ol varchar(100),in nw varchar(100),in sch varchar(100),out res varchar(100)) BEGIN SELECT pass INTO res FROM registration WHERE pass=ol AND schno=sch; UPDATE registration SET pass=nw WHERE schno=sch AND pass=ol; END // DELIMITER ; … | |
Am trying to restore a MySQL database using the 'mysql -u root db < my_db' command. In vb's process.start. it gives me the default output you get when you type MySQL - help. Can someone tell me what's up. I guess it cannot see the < symbol. Regards. | |
I have a database full of user. This is roughly how the database looks: [CODE]| username | sex | birthdate | zip_code | |----------+-----+------------+----------| | coolUser | M | 02-14-1987 | 90210 | | blueUser | F | 06-16-1982 | 10011 | | . | . | . | . … | |
I have a database full of user. This is roughly how the database looks: [CODE]| username | sex | birthdate | zip_code | |----------+-----+------------+----------| | coolUser | M | 02-14-1987 | 90210 | | blueUser | F | 06-16-1982 | 10011 | | . | . | . | . … | |
I know this sounds strange, but I messed up in a 'Manual' change to a DB table, and need to find a couple of records that I have no pathway to find... Explanation We have a member table called 'members' several different position tables, one for each level called position_1, … | |
Is there anyway i can link a session to a particular table within my database, well i think this is how i need to do it. I have different tables which hold information for different shifts. The user selects the Site from one page, then selects the shift from another … | |
hello , can any one tell me how can i update a password using procedure in mysql , if the oldpassword is same other wise get any mgs by the procedure . plssssssssss help me out | |
Hello, My db table is this (semester result table) [B]sem1 regno(int) s1(enum) s2(enum), s3(enum), s4(enum) [/B] I want to find number of subjects in which the student with given id has gotten a particular grade. (ie no of subjects he/she has failed). Is it possible or shld i change the … | |
if somebody can help me please i want to write a store procedure in mysql to insert,update and delete but it should be dynamically because i have many tables and columns in my database the store procedure should be call than it should take the table and column dynamically ,can … | |
Hi... I have two site both have different login, now i want to merge database of 2 sites. need to merge both database and unique login for both. same user can use both site via one login. Thanks Hem | |
I have created an online form and am trying to post the info into a mysql database and I keep getting back a query error. Below is my PHP code. If anybody can help me, that would be great. Thanks a lot. [CODE] <?php $property_type = $_POST['property_type']; $number_of_bedrooms = $_POST['#_of_bedrooms']; … | |
Hello, Am new to php and I have a question that is probably very easy. I have been watching tutorials online to learn how to work with databases, but none of them speak on how to upload to server. This is my problem: am using vertrigoserv but specifically using PHPMyAdmin … | |
i am using mysql for the first time and following an online tutorial. i am using the command prompt to connect to the mysql server. the problem is that , i want to create a new database named bookstore. so, in the mysql> prompt i am writing [CODE] create database … | |
I am trying to link fields between 2 of my tables but its not working. I have a table called assets, which consists of Asset_ID and AssetType and a table called t5_week3_shift3 which also consists of these 2 plus others. Im not sure whether to do away with the assets … | |
hello :) i wanted to know that how can i move my database here and there..?? i'm working on Sql using some 'xamp' named software.. i have to create few tables, then i need to give this database to my friend..he'll add few more tables in it..then finally, we have … | |
I am trying to write a program that can access my database from a remote computer and change it. How can I figure out the url of my database? according to my source it should be something like this [CODE] jdbc:mysql://host_name:port/dbname [/CODE] Thanks for your help. | |
Hi there, I was wondering if someone could tell me how to store multiple checkbox values into a MySQL table? I know how to work it with Python on its own but I need to store into a database. Any ideas? | |
hello, I have a situation that i'm wondering if there's a solution. I have specific databases for different cities in texas. I plan on adding more but i do not nkow how many more or what their names will be. Every city is going to have the same tables in … | |
Hi! Im new to MySQL RDMBS. I know the basic CRUD if you know what i mean. Create Read Update Delete. I have 2 tables: Category table and Product Table Products should be categorized. Product table has PK as an ID and FK to Category Table How to INSERT INTO … | |
Hi everyone! I've been looking for a solution, but i just can't find it anywhere... Ok, so the problem is: i have a database which looks something like this: user_id product_id score 14 . 235 . 79 23 . 235 . 32 53 . 665 . 21 14 . 235 … |
The End.