11,093 Topics
 | |
| | Hello, I'm creating a project in C# that requires me to use access a remote MYSQL server.. I have an online hosting account, that is hosting the database HOWEVER, i don't know how to access it.. In the 'Remote MYSQL' part of the site it just has this: 192.168.1.% So …  |
| | Hi, I have a table with 2 laksh records. If i use rand() in mysql query it takes approximately 1.5 seconds to run So i use mt_rand(1, 200000) It returns most of the times results in 1,000,00s The query is like this. $query = "SELECT * FROM tbl WHERE Length(word) … |
| | Hi I have not installed mysql on my own, its the default one that is coming with fedora14 at /usr/local/mysql I am giving you some screenshots, please check if you can find out something. ********************************************************************************************************************************************************* The first issue is while I login using command mysql -u root -p it asks …  |
| | Hey, I have a problem.. I'm working on my final project and wanting to do some database intigration, now I have chosen MYSQL to do it in, however, when I try and create a database (locally) it won't let me connect.. This is annoying! So, is there any way that …  |
| | how do i find the foreign key and primary key constraints of a particular table through a sql query? |
| | Hello, I am trying to connect to a database "database1" using C#, however, everytime that I try to connect I get this error: [I]Unable to connect to any of the specified MySQL hosts.[/I] This is the code that I am using to connect to database1 [code] string connString = "Data … |
 | Hey Guys, I know there has to be a way to automatically delete a row in a MySQL table on a specified date. I am just brain dead today :icon_confused: Let's just say I have CMS that I input posts and want one of the fields in the table to … |
 | Hi, today for the first time I get this error Lock wait timeout exceeded; try restarting transaction when using sentence [CODE] UPDATE info_psl SET eil_nr = eil_nr + 1 WHERE eil_nr >= 4 [/CODE] The table is such [CODE] CREATE TABLE IF NOT EXISTS `info_psl` ( `psl_id` int(11) NOT NULL … |
| | Hi Everyone, As i wannna to be my Primary Key Em_Id auto increment in MySql but it should be a varchar datatype....as i want my id like em001,em002....something like this.... So can any body help.... Thanks, Ashish |
| | Hi, I would like to know if there is a way to sort data in a table, not when selecting it, but the actual data in the table. I would like to sort it by 2 columns though. For example the "topic" should go from A-Z and then inside all … |
| | i am currently working on a survey project and the answer should be something like that Poor,Average,Good,Very Good,Excellent and their value will be 1 2 3 4 5. but i can't bind them into my database, the questions show using datalist, and i got no idea how to fix this.. …  |
| | Hi Guyz, i just wanna know how to fix my problem, or rather fix my code and simply my code base on my MODULE. heres the error " You have an error in your SQL syntax; check the manual that corresponds to your mysql server version for the right syntax … |
| | Ok, I'm really really stuck with this. I've tried everything to my knowledge to fix it, but I just can't. So please, can anyone here help me with this error: [CODE]Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'host-ip' (4) in /home/ashley/public_html/pw/inc/config.php on line 7[/CODE] This is my PHP: … |
| | hi, i have a site which i want to generate a weekly report of activity from. the monthly report should be fine as i could set the query to format the date into month and where "date" is NOW() however how can i generate a weekly report in mysql? any … |
| | Hi, I am using a prototype PayPal payment system which does not ever need to properly work, but I am having trouble writing to the database as well as redirecting to the PayPal payment page at the same time. Here is the form: [code=php] echo '<form name="purchase" target="_blank" action="https://www.paypal.com/cgi-bin/webscr" method="post">'; … |
| | I am trying to write or find scripts that will: 1- create a script that will allow someone to Unsubscribe to a mailing list based on email address. 2- export data to a predefined excel file which will be used to print mail labels. I have looked and looked and … |
| | Hello I asked a similar question a few posts before but not the same, so I started this thread. I am trying to add a user to MySql which I installed via XAMPP. I found this command: [CODE]CREATE USER 'root'@'localhost' IDENTIFIED BY 'mysqlpass';[/CODE] But I don't know where to put …  |
| | Hi!The code I use for getting the values from dynamic javascript form fields is not working dont know why? The problem might actually be because of form tags and submit buttons, I guess.So now I have three sets of pages using same code, #1.Working in excellent condition #2.Partially working if … |
| | I needed to fetch the points for a Building at a certain level. For this, I created a Stored procedure in MySQL Workbench 5.2 CE as following: [CODE=MYSQL] CREATE DEFINER=`tribalwars`@`%` PROCEDURE `GetPoints`(IN BuildingID INT, IN BuildingLevel INT, OUT Pts INT) BEGIN Select Points INTO Pts From Points Where BID = … |
| | how to get from table only one column and its downstair data? from this: [URL="http://lashatt.comoj.com/table1.JPG"]http://lashatt.comoj.com/table1.JPG[/URL] show only this: [URL="http://lashatt.comoj.com/table2.JPG"]http://lashatt.comoj.com/table2.JPG[/URL] what will be mysql code of this? |
| | invalid use of property [CODE] Dim search As String search = Trim(txtSearch.Text) Select Case cmbSearch Case "By: Customer Name": Call DataGrid("select * from list1 where CustomerName like '" & search & "%'") Case "By: Date": Call DataGrid("select * from list1 where Date like '" & search & "%'") Case "By: …  |
| | i have de following code [CODE] <?php require_once('Connections/conn.php'); ?> <?php $oras = $_POST['oras']; $zona = $_POST['zona']; $camere = $_POST['camere']; $tip_apartament = $_POST['tip_apartament']; $chirie = $_POST['chirie']; $tableName="anunturi"; $targetpage = "afiseaza.php"; $limit = 2; $query = "SELECT COUNT(*) as num FROM $tableName WHERE oras='$oras'"; $total_pages = mysql_fetch_array(mysql_query($query)); $total_pages = $total_pages[num]; $stages = … |
| | Hello, I have a problem using the MySQLdb library. I'm trying to insert values into my table but MySQL isn't showing them. What's more strange is the primary key is changing when I manually insert values using command prompt. Here's an example: [CODE] '786', '2011-02-16 14:52:38', NULL '787', '2011-02-16 14:52:52', …  |
| | Hi there, i am desperately trying to compile the MySQL++ library header & cpp files in order to create the actual lib. I do follow the exact instructions given in the ReadMe for MinGW. [ICODE]Prerequisite: MySQL C API DLL Import Library ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Before you can build MySQL++ with MinGW, you …  |
| | Hi, I'm a database novice and need a few pointers (please). I've created two tables in MySQL: [CODE]CREATE TABLE `Users` ( `Username` VARCHAR( 20 ) NOT NULL , `Password` VARCHAR( 18 ) NOT NULL , `Secret_Question` VARCHAR( 100 ) NOT NULL , `Secret_Answer` VARCHAR( 100 ) NOT NULL, `First_name` Varchar( … |
| | I have a script that calls up a picture stored in a database. I then have a script that displays said picture on another page. If there is no picture in the database I would like for their to be a no picture icon displayed. New to php but I … |
| | I tried to import a table intro a database and MySQL give me the next error message: "[COLOR="Red"]MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''table_ro2' INSERT INTO 'table_ro2' … |
| | Hi all, i have a problem in writing a block of SQL code in mysql. The block of code will have too delete a single row/record from about 23 related tables all at once. The code that i have written so far will only delete 1 row/record in 10 related … |
| | hello, I am new in perl..i am just trying to connect perl with mysql database. for this i installed xampp server in my system..and now perl,apache and mysql are running on my system. i also check server by running cgi program on it.. evrything is right.but i dont know why …  |
| | Dear All, I have a server with 16 cpus and 32g ram. The problem below when I run my top it show mysql %cpu is more than 100%. Below is my top results. The problem here I would like to why is mysqld is using up 137.2% of the cpu … |
| | Hi all, i have a problem in writing a block of SQL code in mysql. The block of code will have too delete a single row/record from about 23 related tables all at once. The code that i have written so far will only delete 1 row/record in 10 related … |
| | Hello. I'm working with a webpage where its going to a Google Store Locator. [URL="http://code.google.com/intl/no-NO/apis/maps/articles/phpsqlsearch.html"]Goolge Store Locator guide[/URL] I did follow. I got it working for a while, but here in Norway we have some characters, ÆØÅ that we use. This is the problem. When I search for a place, … |
| | Hi... I need to establish a connectivity for mysql in c++ on a linux fedora 12.0. please let me know a solution.  |
 | Please Explain me what is difference between cluster and non-cluster index. Also if i create a primary key on a Table which index will be created automatically, cluster or non cluster. Thanks in advance. |
| | Hello. I have gone through various checks, and I can't seem to figure this one out... [CODE]while($row_sizes = mysql_fetch_array($sql_sizes)); { $sizes = $row_sizes['size']; $product_list .= count($sizes); $product_list .= "<li>".$sizes."</li>"; }[/CODE] Its not outputting any sizes. However, my count($sizes) outputs 0. And that shouldn't because I have [CODE] $sql_colors = mysql_query("SELECT … |
| | Hi, I am trying to create a foreign key between 2 tables. I am using MySQL Workbench but every time I create the foreign key relationship, it just dissappears after clicking "apply"... Initially I thought it was Workbench so I tried the legacy Query Browser - but it does the … |
| | I'm trying to insert into MySql, using DBI/Perl... What I'm doing is storing all my Print statements into an array, then dumping them out to print, and inserting into a MySql table in a foreach loop... Print resolves ok, but the MySql inserts are being split into fields at the …  |
| | Hello! i have a very simple query: [CODE]SELECT * FROM fornitori ORDER BY ragSociale[/CODE] this works perfectly in localhost on my PC (windows 7 pro-apache 2.2.17-mysql 5.1.54-PHP 5.3.4) but on my VPS doesn't work and it give me a query error without number or error description (VPS: centOS 5.5-apache 2.2.16-mysql … |
| | Hi All, I'm very new to PHP and MYSQL and I'm having hard time trying to insert data from PHP form in MYSQL DB. I'm able to echo out the output on webpage but i'm not able to figure out how to insert the data in DB. Please help me … |
| | Hi, There are three tables involved here. A kind of quiz localhost site, i did for me. Table 1 contains questions. ========================== question_id (autoincrement) questions (varchar 250) category_id Table 2 contains choices ======================== Choice_id (autoincrement) Choice_value (varchar) question_id Table 3 contains answers ======================== question_id choice_id I am displaying 10 questions … |
| | i need to develop a search query for city portal ..select * from ....takes lot for time is there any good query to get fast retrieval form database??????? plz reply its urgent |
| | Hi again!!I wanted to know that is it possible to backup the mysql database just by running query?I am trying to find out the code so that if a user clicks backup button, the whole database will be stored somewhere. |
| | I'm trying to display a picture stored in a msyql database. I have the following script, picscript.php, to call the picture from the database: [CODE] <?php $username = ''; $password = ''; $host = ''; $database = ''; mysql_connect($host, $username, $password) or die("Can not connect to database: ".mysql_error()); mysql_select_db($database) or … |
| | [B]Can somebody help me to retreive one or more checkbox values from the database using php and MySQL? Thanks and I appreciate that.:)[/B] In checkbox.html file the checkbox as follow: [CODE] <form method="post" action="Process.php"> <fieldset> <legend>Choose feature(s) to search for apartment</legend> <table border="0"> <tr> <td><input type="checkbox" name="feature[]" value="walkincloset">Walk in closet</td> … |
 | I am creating a login script and I need to check that the username and e-mail don't current exist in the database otherwise it will print an error. I've tried the following but it's not working: [CODE=php]//Create Username Array $SQL = "SELECT Username from user" $Result = mysql_query($SQL); $Array = … |
| | I'm a php noob and I have a feeling that there is a simple solution to my question. I have a php mysql table search that returns a result sucessfully. What I would like to be able to do is select one of the results to be inserted into a … |
| | hi, i have found a few ways on the internet to import an excel sheet into mysql. one of which is save to a csv and upload to a site which creates the sql statements and this is great and i have used in past. however my problem is i … |
| | Hi, I've been racking my brain for the last few days to figure out what is wrong with my PHP coding. I've managed to get the default value from my combo box into my database, but when I change the option it is breaking on me. I have reduced my … |
| | Hi, I've been busy writing a script to upload photo's to my webserver, and after a lot of searching I finally managed to get the permissions correct, but now I'm having another problem. There are quite a lot of posts about it, but they all come down to having the … |
| | Hi I am having trouble trying to normalise my tables, I would really appreciate some help! So far I have: [B][U]Customer Table[/U][/B] CustId(pk) Cust Name Cust Address Cust Postcode Cust Email [B][U]Order Table [/U][/B] OrderID (pk) Order Date_Time CustID(fk) [B][U]OrderDetails[/U][/B] DetailsID(pk) Quantity OrderNo(fk) DeliveryID(fk) [B][U]Product[/U][/B] ProductID(pk) ProductType ProductDescription DetailsID(fk) PartID(fk) … |
The End.