11,093 Topics
 | |
| | Below is the table and the data related to it .How to do we go ahead and create partitioning for this table .Below table had like 50 million of records. [code] CREATE TABLE l_play ( Pl_id int(11) not null auto increment E_Id` int(11) NOT NULL, F_Id` int(11) DEFAULT NULL, P_Id` … |
| | Hi What is the best way to store tags in mysql database? Please help me with this. Thanks |
| | HI! I am trying to find a way to plug some data that is spit out of a mysql query into another mysql query. example. [CODE] $zip1 = $_POST[zip1]; "SELECT * FROM zipcodedb WHERE ZipCode >= '". $zip1 ."'" [/CODE] lets say i get that query to spit out these … |
| | Hi, how to create trigger in mysql 5 with java. i have code like this, but still error " java.sql.SQLException: 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 'DELIMITER $$ CREATE TRIGGER `a1`.`xData` …  |
| | [CODE]<?php include("access.php"); mysql_select_db($dbname); $user="ym_chaitu"; //$e=mysql_query("select email from userlogin where username='$user'"); //$email=mysql_query($e,0); $query = mysql_query("SELECT username,password FROM userlogin WHERE username = '$user'") or die(mysql_error()); $data = mysql_result($query); echo $data; ?>[/CODE] this is my code,,when i am using it out, it is giving me an error Warning: Wrong parameter count for mysql_result() …  |
| | I keep getting some weird errors in this script: errors: [code] [B]Warning[/B]: mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in [B]/home/www/ikhelper.freehostia.com/globinc/loginfunc.php[/B] on line [B]86[/B] [B]Warning[/B]: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in [B]/home/www/ikhelper.freehostia.com/globinc/loginfunc.php[/B] on line [B]87[/B] [B]Warning[/B]: mysql_query(): supplied argument is not a … |
| | I am a Student working on a project useing mysql. I am trying to set up a view and keep getting an error that there is duplicate columns. Is there anyway other then specifiying each table.culumn to stop the view from trying to show both of the columns. If it … |
| | I have 2 buttons in my form. The first button to fill the JTable from .xls file and the second button to save the content of the table to database (MySql). I haven't figure out yet the way to save data from JTable to MySql. :confused: So, can anybody help … |
| | Hi need help with this code. i get a the error msg Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result but dont know were to change. my connection is fine???? [code] <?php include ("connect.php"); // max display per page $per_page = 5; // get start variable $start = …  |
| | I have an SQL Query question that I'd like help with if possible :) I have two tables "tbl_jobs" and "tbl_jobs_done" Here are the fields for both tables: tbl_jobs -jobs_id -jobs_description -jobs_datestart -jobs_dateend -jobs_datetype -jobs_user -jobs_updateuser tbl_jobs_done -jobs_done_id -jobs_id -jobs_date -jobs_comment -jobs_datedone -jobs_timedone -jobs_user How this works is, I have …  |
| | I have a table that holds a users id and a cd number, what I would like is to be able to only increment the cd number based the users id not just incrementing it every time a new cd is created table [code] CREATE TABLE IF NOT EXISTS `cdcreation` … |
| | Hello everyone. Basically, I am making a small site for my friends where we can create users and edit profiles and comment eachother. Like a scaled down social network site. The problem is, I really can't get my head around the whole idea of relational databases. What I have is … |
| | [B][COLOR="DarkRed"]this is post table [/COLOR][/B] [IMG]http://www.divran.com/script/upload/images/post.jpg[/IMG] [B][COLOR="DarkRed"]this is thread table [/COLOR][/B] [IMG]http://www.divran.com/script/upload/images/thread.jpg[/IMG] lie you see firstpostid in thread table = postid in post table and threadid's i wanna update title column in thread table as title in post table but how ? i create following query for trying but i … |
| | Hi everyone, I've been a reader for a long time, now I've joined up, as I'm fairly stumped on this one!! I'm currently teaching myself mysql and php at work, and have a problem. I am using php to produce a listing of restaurants on a page, and I would … |
| | Hi Been trying to write a query... I have a table of documents, and a table which registers everytime someone downloads a copy of the document. I want to create a report, in one query, which pulls out each document and counts the views... I thought it woudnt be too … |
| | hi there, im sorry if this has been posted before i have searched through the threads and have not found what i am looking for, however it is entirely possible that i have missed it, i have spent the whole day looking at search results and basically i need some … |
| | Hello, New here so hello. I need to transfer an Excel file to Mysql with a large amount of data. I looked on a few forums but have not found much. Do you know how to do this? Is there an easy solution? Thanks a lot. |
| | i m searching for it from last two hrs. but didnt find anything useful.. i hope some reply to this topic..!!! i just need a php script to upload excelsheet data into mysql table..!! thanks  |
 | I would like to get everyones opinions on what processes should be used to validating and protecting the input into your storage medium aka MySQL. In particular listing possible php functions that hsould be run and maybe once we have a list we put them in order, from most to … |
| | A company has several employees and projects. Each employee may be working on several projects. Design a database to hold information about projects and employees, choosing some sensible sample fields and data. Write an SQL query to display the number of women and the number of men working on each … |
| | The below mysql query yeilds the following result: [CODE]SELECT COUNT(ProgramType) AS Counter FROm credential_state GROUP BY ProgramType;[/CODE] Results: Counter 4 7 7 I would like return the max from the above (7). The following query is giving my an error that says: Every derived table must have its own alias. …  |
| | Can any one help me in solving my problem. My problem is I have Windows 2003 server which maintain different user with different authentication. No I am developing a login program in PHP (PHP and CSS file is attached) I need to fetch the user details from Active Directory of … |
| | I need to make ten selections. One of all the datetimes in the last 24 hours, the next one from 24 hours to 48 hours, and on back in 24 hour blocks for the last ten days. I've tried various approaches to this, but this is what I currently have: … |
| | I tripped on this one. I have an HTML form that has all kinds of input elements - text, textarea, radio buttons and checkboxes. I have no problem inserting or updating data in MySQL DB from the HTML form. But when I want to display what is already in the …  |
| | I have the following python code to access a MySQL database: [CODE] #!usr/bin/python # server_version.py - retrieve and display database server version import MySQLdb con = MySQLdb.connect (host = "localhost", user = "username", passwd = "password", db = "test") cursor = conn.cursor () cursor.execute ("SELECT VERSION()") row = cursor.fetchone () … |
| | Just so you know, I'm a PHP beginner, so I won't understand complicated stuff or anything of the like. xP I've started to make a part of my website (may I link to it, or should I just post the code) and I'm pretty happy with it. A user can … |
| | Can someone help me store a string that has an apostrophe within it? I thought that using [B]mysql_real_escape_string[/B] was supposed to add a slash when retrieving, but remove the slash before storing. Here is a portion of my code and then also the result of the data after it is … |
| | I got a query to calculate the percentage as , [CODE] Select votes, rating, votes/sum(votes) as percentage [/CODE] But I want to take the values from two different tables. I tried [CODE] Select elec.sum(votes) from elec, stat.sum(rating) from stat where year=2009, elec.sum(votes)/tat.sum(rating) as percentage; [/CODE] This doesn't work. plz help. |
| | How can I use Mysql for JDBC connection.How to make data source? I can able to done with MS-SQL. |
| | Hello, I have a MySQL 5.0 Database used for management of my service, with 13 tables. The two tables most important now are "customers" and "cust_packages". The table "customers" has one column "cust_email". This column has e-mails of customers of the my service. The table named "cust_packages" has one column … |
| | I keep getting this message Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/j/a/c/jackattacksite/html/register.php on line 80 Here's the code: [CODE=php] // Connect to database include_once "scripts/connect_to_mysql.php"; $emailCHecker = mysql_real_escape_string($email1); $usernameChecker = mysql_real_escape_string($username); $emailCHecker = eregi_replace("`", "", $emailCHecker); $usernameChecker = eregi_replace("`", " ", $usernameChecker); // Database …  |
 | mysql_connect("localhost", "root", "") or die(mysql_error()); mysql_select_db("test") or die(mysql_error()); $root = 1; function display_tree($root) { // retrieve the left and right value of the $root node $result = mysql_query('SELECT lft, rgt FROM tree '. 'WHERE name="'.$root.'";'); $row = mysql_fetch_array($result); // start with an empty $right stack $right = array(); // now, … |
| | Hi and I have been working on a project involving a rather large database. My question is "For a database with over 20529860 rows, is it better to have 3330 tables spreaded equally or to split into multiple databases or would it be better to have 49950 tables in the … |
| | Hi, I am trying to get the primary key (which is number) from a field of the same table. however i encountered "Undefined index" shown on my screen. [CODE] $orange_insert = "INSERT INTO orange (orange_id, orange_name, orange_add) VALUES (NULL, '$val_name', '$val_add')"; $result = mysql_query($orange_insert) or die (mysql_error()); $orange_sel = "SELECT … |
| | For example, when searching string_1 in MySQL table found NO RESULT, then want to add string_1 into database table. Using code below: while (res->next()) cout<<"This word means "<<res->getString(2); if (res==0)/[U]/I use this if statement , but don’t work![/U] { cout<<"Would you like to add this word to database?"<<endl; } What …  |
| | I am facing problem connecting problem connecting remote MySQL server which is firewall protected. I used the valid user name and password, but it throws me the error [I]OperationalError: (2003, "Can't connect to MySQL server on 'www.myreomtemysqlserver.com' (10061)")[/I] I want to connect from python. I searched in Google is there … |
| | |
| | |
| | Hi I really hope I am posting this in the correct forum area. I have a html page on my currently existing web site where I sell books over the internet. I need to change this page so that it can do a search on my MySql database that I … |
| | i have a project that implements the using of database. i chose to use php as the application interface and mysql as the database. at the end of this month, we should submit the softcopy. now, i'm confused with the files of my project. i'm using wamp server, and in … |
| | Is there a simple way to link up a data website to my newly created Access program? I need specific information to fill in the tables, and currently I am manually entering the info in from the site; it would be much easier to have this website post it for … |
| | Hi, I want to create a mysql table in a database in C#. this table should have unlimited fields where the user can add more information to it without having to overwrite the already existing information. I want to do this cos I will not know the amount of info …  |
| | |
| | [icode] "My wamp server got damaged recently and i had no backup for my databases. I had reinstalled the wamp server and replaced the bin/mysql/data folder to the new one but I only get the database and not the tables inside it. I need help!!!!!!!! "; [/icode] |
| | Hi, everybody. I've been a member for a while, but I'm not a coder, so I haven't made any posts. But I get frustrated not knowing how to do things. So I'm taking the plunge. I'm working through a tutorial on PHP and MySQL (here: [url]http://dev.mysql.com/tech-resources/articles/ddws/[/url]), and things have been … |
| | the following is the code: [CODE] <%@ page import="java.util.*" import="java.sql.*" import="java.io.*" language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <% Integer hit = 0; Connection con = null; Statement stmt=null; ResultSet rs = null; %> <% try { out.println(); Class.forName("com.mysql.jdbc.Driver").newInstance(); con = DriverManager.getConnection("jdbc:mysql://localhost/lab2","root","root"); stmt=con.createStatement(); rs=stmt.executeQuery("SELECT hitCount from table1"); hit = rs.getInt("hitCount"); hit = hit … |
 | I have a database that needs to hold names of people from all around the world. Some names have special characters in them such as é and ¢ Is there a character set I can use that will accept any character no matter what language it is (with the exception … |
| | Hi; I want to connect MySQL database from turbo c++.I have installed MySQL 5.0.Also MySQL c++ connector.But it's not working.How can i connect.Any body have any procedure for it? Is it possible to connect it directly without any connector?If yes,then how?  |
 | How to handle UTF-8 characters in HTML, JavaScript, PHP and MySQL ... |
| | I created some data files with 'outfile ' command. The files are created in the mysql folder.{I use WAMP} I want to create those files in another directory. How can I do that? Thankx in advance. |
The End.