[mysql] Forum Topics

Sometimes a person can get too close to their work that they cannot see what is going on wrong. I hope that is the case here. I have been working on my favorite project, a large wood knowledge base at: [url]www.prowebcanada.com/taxa[/url]. There is enough data to look up already and …

Dear Sir/Madam, We are using NSIS to install an application. and we have a MySql Script file, which is using inside the installer class. This file is working with Mysql but not from the installer. This is giving a ERROR 42000 syntax error. Any help will be appreciated Arun G.K

I have a photo management system that I have build locally which uses mysql to store the images. the problem is that I exceed the max_allowed_packet value when my images are too large. I know how to set the max_allowed_packet value through the CLI with: [CODE=sql]SET GLOBAL max_allowed_packet=16*1024*1024*1024;[/CODE] The problem …

Hi Pals, I am Anes , from Kerala ,India. I am a PHP Programmer Basically but have interest and now studying C++ , I plan to take data from MySql in C++, for that I install mysql-connector-c++-1.1.0-win32.msi in my Windows XP. I got a Script from net , but it …

Hi. is it possible to decrement a value inside a table every seconed or day or whatever? if it's in the wrong section i'm sorry.

Dear All, I have a scenario where I notice in my log file for few different instances there is one query running and another one is called and kills the former running query.My application is based on C# and using .net connector.I have attached two sample cases but I have …

I have data value of a table column. I want to know in which database and in which table and in which column the data value appeared in mysql.

Hey guys, I'm trying to normalize a database for a friend, who has a car database. I'm trying to separate the database by having one table for the car brands (BMW, Honda, etc), one table for the car types (SUV, car, sports car, etc), and the final table for the …

Hello, Is it possible to select a specific row in one table and post it into another table in a different database? Thanks, Waffles

Hello all I am on a windows application form where people can log in and add status ... and it's all online via sql database. What i am looking for is a sql query that Insert into the table the current time,so i can print on the application the time …

Hello all I am on a windows application form where people can log in and add status ... and it's all online via sql database. What i am looking for is a sql query that Insert into the table the current time,so i can print on the application the time …

Hello, anyone has an idea of how to use php to check to see if a field in a mysql table is empty or has no values? i tried this $query="SELECT fieldId FROM table WHERE fieldName IS NULL" ; but this works only if the field in the table has …

I have an idea for a friends list based off a user's account info. 'guid' is the character id number 'account' is the player's account number 'friend' is the player he is friends with 'online' 1 = online; 0= offline Here's what the layout is like: Friends List [CODE] `character_social` …

I had created a MySQL database to install wordpress but due to some tinkering I did in the phpmyadmin it displayed an error "No Privileges". I'm don't have much knowledge in mysql databases, I spent a week searching for a solution, tried many but nothing seemed to work. In the …

Hi guys ! Please help make a sql-query - There are three tables - [CODE] table STUDENT ( STUDENT_ID NUMERIC not null, SURNAME VARCHAR(60), ); table SUBJECT ( SUBJ_ID NUMERIC not null, SUBJ_NAME VARCHAR(100), ); table EXAM_MARKS ( EXAM_ID NUMERIC not null, STUDENT_ID NUMERIC not null, SUBJ_ID NUMERIC not null, …

I have a table with 3 fields: id (auto_increment), name (string), x. in my x field i want it to be kind of like a auto_increment but with letters and numbers being used. For example, if id field is 1, x will be "aaaa". if id is 2 x will …

I am new to mysql How can we count the number of rows in mysql table

I have made this stored procedure DELIMITER // DROP PROCEDURE IF EXISTS find_max; CREATE PROCEDURE find_max (IN type INT,OUT maxx INT) BEGIN SELECT max(card_id)+1 INTO maxx FROM cards; END; // DELIMITER; and i want to have this stored procedure DELIMITER // DROP PROCEDURE IF EXISTS add_card; CREATE PROCEDURE add_card (var_member_id …

i am learning php and i am trying to insert data into a database from a form using php. here is the php [CODE]<?php include "connecttodb.php"; $name = $_POST['name']; $email = $_POST['email']; $password = $_POST['pass']; $query = "INSERT INTO ******* SET username='$name', password='$password', email='$email'"; mysql_query($query) or die('There was an error …

Here's the code I have [code] $query = "SELECT partID, fname, lname FROM tblPartInfo WHERE lname = '$lname' or fname = '$fname'"; [/code] Works like a charm. Now, I want to be able to use wildcards so that the user can enter, for exemple, HO to search for HOUSE so …

i have created new database it is there in C:\xampp-win32-1.7.3\xampp\mysql\data that directory but it can't visible in [url]http://localhost/phpmyadmin/[/url] in that phpmyadmin that combo box please can u help me

Hi guys! Im kinda new here and lately I'm developing a[B] PHP MySQL Module Generator[/B] that will help us to easily manipulate the database. since I want to make thing fast and I know lots of you agree with me that doing data manipulation stuffs like MySQL is boring so …

I am still fairly new to PHP, so I will do the best at explaining what I am trying to do here... I have a database table where I store a bunch of invoices. I am now trying to make a front end to run queries. I don't know how …

Hi, I'm trying to create a drop down menu with dynamically populated options. So, within a typical HTML form I have: [CODE] $conn = mysql_connect ("localhost", "xxxx", "xxxx"); mysql_select_db ("wkho_TTX", $conn); $query = "SELECT * FROM venues"; $result = mysql_query($query) or die(mysql_error()); $num=mysql_numrows($result); $i=0; while ($i < $num) { $option …

Is there any free migration tool for mySQL to Oracle ?

Hi, I'm trying to access two databases and retrieve the same data from each but I only want one "No People are on" to be displayed if there is no one on in both databases. If one user is online, in only one database, I would like only the users …

Hello everyone, I have a database with a list of characters and I would like to display which characters are currently logged in on a webpage I have. My database looks like this: [CODE]`characters` (`account`, `name`, `online`) VALUES (6, 'Frod', 1);[/CODE] I hope that makes sense. So if 'online' = …

Guys i`m trying to archive something like facebook,twitter wall Display. I have a friend table,inside it has id,friendid and userid. also got feeds table which contains id,action,sender_id,statusid,status,date. What i have succeeded to do is if You are logged in you can see all the updates from your friends...As the code …

I have a database which, because of a Vbulletin mod error during uninstall, has left me with a database I can't restore. It says there is a query for a table that doesn't exist and a username attached to the table. Is this fixable?

I'm trying to pick up the latest record for 6 groups, and I'm using the following Select statement: [CODE]SELECT * FROM newproducts LEFT JOIN (suppliers, newsrchGrps) ON (suppliers.supplierName = newproducts.supplierName AND newsrchGrps.groupCode = newproducts.groupCode) GROUP BY newproducts.groupCode ORDER BY newproducts.updated DESC LIMIT 6[/CODE] which does pick up a total of …