10,940 Topics
 | |
| | When I want to create a database by through MySQL Workbench 6.1 CE the database always creates at "C:\ProgramData\MySQL\MySQL Server 5.6\data\". But I want to save it in my desired folder. How do I do that? |
 | Hello, In my database schema, for one fiels "exp" i have made it as float(3,2) it stores value properly up to 9.99 but for then it goes out of range and stores 9.99 how?? whats wrong in this? i expect it store values up to 999.99 but it stores uo … |
 | I have a simple php code which enters value into MySql database and then retrieves it and displays it. However when retrieving it always return null and Empty Set is echoed everytime. Can someone please help. I am using WAMP Server. Database name is trial and name of table is … |
| | i want the procedure to export .mdb file to sql file move file to server using ftp and import into mysql database using a batch file. |
| | //In Node/JS myDate = moment(data.myTime.format('YYYY/MM/DD HH:MM:SS')).toISOString(); //myDate shows '2014-09-24T04:09:00.000Z' Insert INTO (dateColumn..) Values(myDate)... This is the error I get after inserting, note column in Mysql is a "datetime" type. MySQL Error:: { [Error: ER_TRUNCATED_WRONG_VALUE: Incorrect datetime value: '2014-09- 24T04:09:00.000Z' for column '_dateColumn' at row 1] code: 'ER_TRUNCATED_WRONG_VALUE',  |
| | I want to insert a NULL value into my integer column. if ($startYear == "") { $startYear = NULL; } mysqli_query($con, "INSERT INTO Application (startYear) VALUES ('".$startYear."')"); Before you ask, I have checked if $startYear is ever empty, and it is, so this should work. When I run this query … |
| | < Hi All, i'm new to this can u please tell me this how can i retrieve username and password from mysql db using asp.net .... **this is my aspx.cs page** i write this code but it doesn't retreive those things... using System; using System.Collections; using System.Configuration; using System.Data; using … |
| | How to create reports in visual basic 2010 express with mysql as database please tell me the whole process as I am very new to it and tried by several ways and places but always failure please help |
| | |
 | Column 'group_id' in where clause is ambiguous. I wonder why? invoice.php <?php //LOAD GROUP $result2 = mysql_query("SELECT group_name FROM `group` INNER JOIN invoice ON `group`.group_id = `invoice`.group_id WHERE group_id = '".$_GET['group_id']."' ORDER BY group_date") or die(mysql_error()); $result = mysql_query("SELECT * FROM `invoice` WHERE group_id = '".$_GET['group_id']."' ORDER BY group_date ASC") … |
| | hello i have seen that tables are locked in mysql while reading the same table..so should i continue using mysql in my website... |
| | I'm trying to create a store procedure in mysql and it is giving me errors and I don't know why since the sql code works just find. Here is the sql code: CREATE TEMPORARY TABLE IF NOT EXISTS table2 AS ( select AVG(Score) as AVG, MovieCode from UserMovies group by … |
 | I have this sqlqry, icarrelli have the value 0 and the q2 value 64(sum) why the result is 64 and not -64? <?php $result = mysql_query("SELECT *,iCarrelli-SUM(q2) as total9 FROM articles,inc"); $row= mysql_fetch_assoc($result); echo "" . $row['total9'] . ""; ?>  |
| | hy, unfor its not showing nothing...what it is wrong...? <?php include('config.php'); error_reporting(0); ?> <table border=1> <tr> <td rowspan="3">Ditta</td> <td colspan="6">mandatori riceve</td> <td colspan="6">mandatori consegna</td> <td colspan="6">saldo</td> </tr> <tr> <td colspan="3">carelli</td> <td colspan="3"></td> <td colspan="3">carelli</td> <td colspan="3"></td> <td colspan="3">carelli</td> <td colspan="3"></td> </tr> <tr> <td>carrelli con piastra luc.rosso</td> <td>carrelli con piastra luc.nero</td> … |
| | |
 | I am try to figure out how to check current time against time in database and header the user to "expired page" if the current time is greater than the one in database "1 hour" $email = $token = $check_time = ""; $crossToken = $db->prepare("SELECT email, token, check_time FROM pw_reset_company … |
 | I have created a procedure and a table. I was wondering how can I call my procedure in a sql file and insert the result into my table? |
| | Hy ihave this phpcode, how can i paginate this?to make more pages from the sql results... because i have a lots of rows... <?php $qry=mysql_query("SELECT *,replace(category, ',', ' ') as category FROM articles ORDER by articles.id DESC ", $con); if(!$qry) { die("Query Failed: ". mysql_error()); } /* Fetching data from … |
| | hello, how could i populate drop down list from resultset of a mysql query?? |
 | I intend to build the web app using a database on a server. I have tomcat running. I am. Working on creating the server on eclipse (mars). I was planning on working with MySQL. What additional set up do I have to do to work with this db in my … |
| | can I get code to bring out the state under a country when the country is selected. both state & country from the database displayed in a select dropdown |
 | <?php include ("connect.php"); $_SESSION['username']="kai"; $username=$_SESSION['username']; echo "Welcome,".$username."!<p>"; $query= mysql_query("Select * from avatar where name = 'username'"); if(mysql_num_rows($query)==0) die("User not found"); else { $row = mysql_fetch_assoc($query); $location = $row['imagelocation']; echo "<img src='$location' width='200' height ='200'>.</p>"; } ?> <p/> Upload New Avatar <form method="post" enctype='multipart/form-data' action='view.php'> File: <input type='file' name='myfile'> <input type='submit' …  |
| | hello i have databses and tables in mysql db... i want to auto suggest databases name in a input box after depending on database string i want to auto suggest the tables inside that database....how could i do this? |
 | For some reason my triggers are recursing, while I think they shouldn't. I'll simplify the examples for the sake of you not having to read through all the code. Trigger 1: CREATE TRIGGER table_1_after_delete AFTER DELETE ON table_1 FOR EACH ROW BEGIN DELETE FROM table2 WHERE table2.table_1_key = OLD.table_1_key; END … |
 | Hi guys, i am currently stuck at live update the data fetched from mysql. The problem now is, if the table has thousand of data, the webpage will hang/lag because of the setInterval() are fetching the data over and over again. My question is, what is the best solution for … |
| | I am trying to update the field id_key which is an unique value using uniqid() function. When I print to the screen the value for uniqid() [$id] is different for each record. Which is correct and is what I want. However when I go inspect the table all the values … |
 | Is it necessary to use mysqli_real_escape_string function for values inputted from the selection option in PHP? |
| | How to create common connection in c# for Windows CE based .net application? I have one barcode scanner, I want to use only one mysql connection at each form becaue opening connection on each form taking too much time. And my device connect server via wifi so.  |
 | I'm converting old MySQL code to MySQLi, and running into some questions. When selecting data from the database, is it necessary or strongly advised to use prepared statements, or can I safely escape my user-derived parameters like the sample below? In a perfect world I'd have all the time I … |
| | any tutorial for insert data in mysql with c language  |
The End.