[mysql] Forum Topics

hi, i am a newbie in mysql and i have some questions about performance tuning. 1-) in a system where you have to store information about a user, such as, user_name, id, last_log, is it better to store all the information needed in one table (lets assume 30 fields in …

Hi I will explain what I am trying to do: I have used MYPHP admin to create a database where user booking details will be stored in a table called bookings. Now I need to retrieve all the bookings for a specific date. For achieving this I have created two …

I have a java applet on my web page. How do i get it to send data to my mysql database? I was looking at jdbc but i don't think it works on remote servers(I am using a web hosting service).

Hello everyone ! This mysql user management fcking damn BULLSHIT (i think we can state it) begins really to drive me mad.. I got a win 2003 server running mysql, somehow i lost root access from the localhost meaning that i'm actually unable to make a backup from my database, …

Hi there Guys! I migrated my site to a new server and I had backed up my site. I uploaded the compressed version of the backup to the new server. But when the upload was completed i saw that i wasn't compressed. Anyways, I'll tell you step by step of …

I need mysql queries for the following : (A)i have table with column headings emp name and password sno empname password 1 ani abcdefgh 2 venus bcde 3 joe bcdef 4 mary abcdef Q1:I want a mysql query to select and display the passoword whose character length is from 3 …

I have mySQL 5.1 installed on a Windows Vista machine. I'm really curious as to where the file lives that holds the databases I created. I'm assuming it's in the mySQL install directory but I just don't know where (C:\Program Files\MySQL Server 5.1\?). Does anyone know?

plz give me a brief description how to take a incremental backup

Hi. I am working on a php-mysql project. My table contains a field called "ID", which i have declared as teh PRIMARY key. but what i want is, that when the user tries ot insert record B into the table, an **ERROR message** should be displayed, showing that a record …

here is my problem i have a data base and i have one table named request_recommend(requestid,status,for_email,sender_email,receiver_email) and one named connections(mail,connected_mail,type_of_con,comment,dateOfJoin) and i want to create a trigger who does not allow to create request_recommendation tuple if the writer and the recommended is not connected i really do not how to …

this is the link i got it from: [URL="http://www.learnphponline.com/scripts/email-activation-for-php-forms"]http://www.learnphponline.com/scripts/email-activation-for-php-forms[/URL] this is the error im getting please also consider im n ew and dont know how to find the manual maybe it is a common known thing or something im asking anyways i wouldnt know waht to look for either its …

basically i want to be able to display an image from a mySQL database using PHP. I heard about this BLOB binary stuff & decided it was too complicated. How would i store a url so that i could access and display it directly in PHP. For example, would i …

Hi all ! I have been assigned a task to implement an insert query into table a [i] only if [/i] a record doesn't exist in table c. I have been scratching my head for past 2 days and even my best friend [i] google [/i] didn't help me much, …

I apologize beforehand if this topic is in the wrong place. Quite honestly I am desperate for help. I have a project for school involving Firefox and making an extension that is a visual database. My professor suggested I use SQL Lite to make the database. I am so beyond …

hello i got this error while taking a backup in mysql usung mysql administrator Error Performing Backup: Could not open file for writing backup. what does it mean how can i get rid of it the error at last table to be backedup

hi all i would like to create a registration and login and selection database, css, mysqladmin. need lots of help.. thanx something like this for example.. I am/We are a: Man Woman Couple (man and woman) *Interested in meeting: a Man a Woman a Couple (man and woman) a Group …

Dear Masters, I have a problem on comparing data. I have two databases that have a similar (if not same) tables, but holds different data, and I want to merge the two tables. But can't seem to figure the easy way to do that, again and again I use script …

Hi i'm trying to write a simple SQL command to use within PHP. I want to select the whole table, sort by one of the columns, then only display the top 100 rows. Without the[B] WHERE rownum <=10[/B] it works fine. But it displays the whole contents of the table …

i am having an issuse not sure how to approach this i have setup a area that grabs user's / user data by a search now i dont get the same results when i do lower case and uppser case any ideas ? [code]$query = "SELECT * FROM `users` WHERE …

how can i find size of my database what is the max table size in mysql is table size shown is in terms of kb or mb in mysql by default actually dis is the max_data length shown using "show table status" 281474976710655. means data size is shown in kb …

i want to insert into table some dummy data so as to large my database is there any script or procedure in mysql to execute a insert statement about some thousands times

mysqldump: Got errno 28 on write what is this error . plz give me a solution for it

attached is a screenshot of what my table already has for the URL micorosft.com. The column headings are the same as column names. Now, if I do the following statement: [CODE=MYSQL]select * from assign2 where UPPER(keyword1) LIKE '%MICROSOFT%';[/CODE] OR [CODE=MYSQL] select * from assign2 where keyword1 LIKE '%microsoft%'; [/CODE] I …

Hi, I am attempting to write a query to return whether or not a particular items value entered is the lowest value and also unique. For example, if an item as 6 values against it e.g. user_id item_id value 1 101 3 2 101 3 2 101 4 3 101 …

i want to insert dummy data for testing my database.so i want to execute a single insert statement 1000 times. is there any function to do so or is there any script todo. if so plz help me

I can handle errors just fine on MySQL, but what about warnings? If I use the following code I still get to see the warning, while that is not what I want: [code=php] if(mysql_connect($host, $user, $pass)) { $conn_server = true; } else { $msg = "Fout bij verbinden naar de …

I am using Wamp server, I reinstalled Wamp after uninstalling it to try Xaamp.I have completely removed all of the Xaamp files.Recently,I opened my phpmyadmin directory and discovered an error message which hinted to me that there were two MY SQL servers installed on my computer(please refer to [url]http://i89.servimg.com/u/f89/13/69/31/58/sql_mi10.jpg[/url] ). …

Hi everyone, I am creating a student timetable. I have the table done in html and I now need to input the values in the database. I was trying to use something along the lines of [code]if(day = 'Monday' && time = '9') { echo(subject); }[/code] i keep getting an …

Hi Everyone, I am facing one problem in inserting query when i am inserting value of textarea in database. Let me explain whole of this. i am working as a empoyee form in which form when we insert value of all information regarding leave of that employee . In this …

HI there [QUOTE]Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`database/t1`, CONSTRAINT `t1_ibfk_1` FOREIGN KEY (`ID`) REFERENCES `t1` (`ID`))[/QUOTE] The field ID is an auto-increment field and I altered the field to a lower number and now I can't insert any …