10,940 Topics
 | |
| | Hello all... Anyone plz help for "TRIGGER CONCEPTS" & "STORED PROCEDURES". Materials wanted. |
| | Hi, I have 2 questions regarding the auto increment datatype in mysql. Q1) Since we all know that if we create an auto increment column, it will start from the number '1' but is there a way we can force it to start with the number '300' and it should … |
 | EDIT: I just realized I should have posted this in the MySQL section. If a mod can move it there I'd appreciate it. Thanks :) Hi all I have two tables. The first one has the details of each fruit, its code, markup percentage, it's cost price and the amount … |
| | Hello everybody, how do I rank mysql search results by column weighting? thanks for your input. |
| | Hey guys.. I have been trying to debug this mysql statement for the past 2 hours.. here is the statement: [CODE] $sql1 = "SELECT * FROM cpmip WHERE adid='$a' and ip='$ip'"; $res1 = mysql_query($sql1) or die(mysql_error()); [/CODE] I just can't figure out why this won't work.. it throws the following … |
| | Hello. I am new and hope to find an answer to my query. I run a classified database and have been doing so for quite a few years, I recently upgraded the Plesk CP on my server and suddenly a problem appeared with the way the DB is returning the … |
| | Hi, PO-1-09/09 is a data stored in varchar column. When i do [inlinecode]select * from table myid='PO-1-09/09'[/inlinecode], it doesn't return any value. If i change PO-1-09/09 to 5, and search for it, 5 returned related data. Why PO-1-09/09 doesn't work? Thanks |
| | hello all. I have python 3 and want use mysql but i dont find mysqls modouls please say me a link.  |
| | Hello... I need to get data from one table while omitting data that exist in the other table. This is the query I am running but I keep on getting duplicates since there are more the one row in the second table. Table1 - 'countries' with fields 'Country_Code' and 'Country_Name' …  |
| | Hi all, I have 2 tables.i.e. Table1 and Table2. Table1 --------------- Code --------------- a_b c_d e_f f_g Table2 ------------ Msg ------------ s_c_d_1 r_a_b_o t_f_g_k A_e_f_D I want to compare the two columns of the respective Tables and get the output as.. Table2 ---------------------- Msg || Code --------------------- s_c_d_1 || c_d … |
| | I created a job site using my web masters, now I wanted to use the same script for my other job domains. I tried copying all my php web pages in to the server, and also changed the database configuration to match the new server password, I created tables in … |
 | Hello everyone i have been looking on ebay and i went to mysql home page to trying follow their directions but for some reason I cant create a new user. I do not know how to get started, i choose the mysql file in the temp folder and that opens … |
| | I get the following error: [B]Warning: mysqli_query() expects parameter 1 to be mysqli, string given in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\docdue\create_group.php on line 50[/B] Anyone have any ideas what is wrong? Thanks [CODE] <?php session_name("duedate_session"); session_start(); ?> <?php require_once("includes/db_connection.php"); ?> <?php require_once("includes/functions.php"); ?> <?php include("javascripts/validation.js"); ?> <?php include("includes/header.php"); ?> <?php $groupid …  |
| | I would like to have a graphic interface for MYSQL database, most people use PHPmyadmin for browsing DBA stuff [B]any other alternative software that will connect to MYSQL database[/B] -- i.e. alternative to PHPmyadmin and look more pretty and can do most stuff by MOUSE ?? many thanks |
| | Hey, first of all... I have no experience on JSP at all so my question might be a bit silly.. However, what I want to do is to query mysql database and get three columns and put them into a table, so that the "URL" column would be a link …  |
| | I've searched through the threads and I can't find what I am looking for exactly. I apologise if I'm posting something already resolved for someone else. I have a page for browsing the contents of a database. An option for each of those records is to update/edit. The user clicks … |
| | Hi there I need to create three dropdown boxes (box 1:colour, box 2: price, box 3:brand) and when the user presses "GO" they are returned with the correct information, pulled from corresponding fields in my MYSQL database. For example, colour: silver, price £100-£200, brand:samsung...should return 5 items on the page. … |
| | Hi all, I've recently begun working with mysqli in a php site in order to make use of bound queries. Now I have a config file that I am including in all pages that has something similar to: $dbc = new mysqli(_HOST,_USER,_PASS,_DBNAME); and this works as expected. If I then …  |
| | I am using mySQL to develop a database collected from internet sources. Python is used for the spider coding, but I'm having issues with the mySQL portion. I'm pretty new to mySQL, so I'm a bit lost. I need a way to lock a single row of a table and … |
| | Hi, i really need help with this :/ the export field in my localhost PHPmyadmin has many fields and I must be doing something wrong, because the receiving end doesnt load the database at all. I set: SQL in STRUCTURE: Add AUTO_INCREMENT value Enclose table and field names with backquotes … |
| | I'm writing a query to summarize survey results. There are two tables... 1) The Profiles table contains the users' answers. There are four columns: ProfileID (for the unique key), QuestionID (a number representing canned questions from another table), Answer (a number representing multiple choice answers from another table), and UserID. … |
| | Hi, How to find number of rows affected in update statement using mysql (not using php mysql). Thanks, Pradeep  |
| | Hello all, Just wanted to see if I am leaving open some security hole in a script I have! When the user logs in it creates a session based on the id field of the users table! For example .... my id is 10 so a session is created with …  |
| | Hi, I have the following query, which does not return any results. [ICODE] select (sum(t.minutes) / 60),d.fiscalmonthnum from kpifntime t inner join kpiddate d on t.datekey=d.datekey inner join kpidacts a on t.activitykey=a.activitykey inner join kpidfees f on t.feeearnerkey=f.feeearnerkey where a.activitycode in (11,12,13,14,15,16,17,18) and d.fiscalmonthnum=11 and d.fiscalyearnum=2009 and t.feeearnerkey=520 group by … |
| | hai am using a stored procedure in mysql. in that stored procedure i have an temporary table. i want to check if that temporary table is already exist then drop it. else create it. reply your comments |
| | Hi, I've having a bit of difficulty with an update statement. The following select statement returns 34 records... [CODE] select b.* from budget as b inner join ntime t on b.feeearnerkey=t.feeearnerkey inner join date d on t.datekey=d.datekey inner join acts a on t.activitykey=a.activitykey where a.activitycode in (11,12,13,14,15,16,17,18) and b.fiscalmonth=d.fiscalmonthnum and … |
| | Can Crystal Reports be used with MySQL? If not, what reporting tool do you recommend?  |
 | Length/Values1 what do i put there. this is a collumn in one of my tables its bigint so the number can get increased by alot. its a point system. it asks for length/values whn i edit the name of the column but i dont understand what to put there. i … |
| | I have a mysql table that was working fine. I'll try to be brief. I have a table that has two primary keys, both are also foreign keys to other tables. The primary keys are qid and pid. If I try to enter a record, using pid > 10, I … |
| | Hey guys, I have a new server :P I am currently configuring it and I ahve come across an issue. The issue being that PHP 5 does not support MySql from standard. I have managed to resolve an issue with the installation of PHP on IIS BUT I am strugling … |
The End.