7,494 Archived Topics
Remove Filter  | |
 | hi everyBody, Can some one tell me the steps of how to make daily back up database from SQL Server 2008, when i do this Script and job it give me an error cant be completed, any help plz...  |
 | Hi, i want to create a query which select three columns from a table on certain condition now i have got certain with three columns and i can bind this data to a datagridview but before this i want to add a column to dgv say col_new and fill its … |
| | Dear All, I have 2 tables one tblAssociate and tblData. The link between them is one to many. My search will be based on date time range where if I find even one data in tblData between the set range then I want to show the tblAssociate data. So I … |
| | I have a MySQL database with a table that has a field/column labled "user8" (which is the field for users' state). I have this PHP call and its working fine if I call all states individually and I only want numbers of rows. <?PHP mysql_select_db("freeskat_promail") or die(mysql_error()); $result = mysql_query("SELECT … Databases mysql |
| | Hi I have written a shell script to execute my data base query mysql -uroot -pshruti2 -B -e "use WebNmsDB;select HEADERINDEX from tekelec_meas_headers where CLLI=$clli and IVALSTART>="$ivalstart" and IVALSTART<"$ivalend" and RPTTYPE="$rpttype";" > win.txt But the output in win.txt is /mysql Ver 14.12 Distrib 5.0.44, for unknown-linux-gnu (x86_64) using EditLine wrapper … Databases mysql |
| | Hi can somebody tell me how to delete a table space? Some days ago I deleted a table because I thought I didn't need it anymore. When I tried to recreate it I got this error: ERROR 1813(HY000): Tablespace for table 'test','employees' exists.PLEADE DISCARD the table space before import; I … Databases mysql |
| | hi I had a question in an exam that asked for the code of a trigger that cancels a transaction if a query result doesn't meet a condition in oracle database. is it possible? I am googleing but I can't find an answer thanks Databases oracle |
| | In MySQL I have created database "[B][COLOR="Red"]mydata[/COLOR][/B]" with the table "[B][COLOR="red"]contacts[/COLOR][/B]". The fields are as follow: [B][COLOR="green"]ID[/COLOR][/B] (Primary Key) (INT(10) [B][COLOR="green"]Name[/COLOR][/B] VARCHAR(45) [B][COLOR="green"]Title[/COLOR][/B] VARCHAR(45) [B][COLOR="green"]Address[/COLOR][/B] VARCHAR(45) [B][COLOR="Green"]Comments[/COLOR][/B] TEXT Based on info at [url]http://www.webmasterforums.com/php-development/1683-php-form-entering-data-mysql-database.html[/url] I have created following two files: [B][COLOR="green"][COLOR="Red"]new_record.php[/COLOR][/COLOR][/B] [CODE]<? $usr = "myusername"; $pwd = "mypassword"; $db = "mydata"; … |
| | I am trying to DELETE multiple checkbox values in my database but these values are being retrieved from the database and checkboxes are added here is the code [code] <?php $host="localhost"; // Host name $username=""; // Mysql username $password=""; // Mysql password $db_name="test"; // Database name $tbl_name="test_mysql"; // Table name … Databases mysql |
| | A simple insert query works as : INSERT INTO <table-name> VALUES(val1,val2,val3); and DONE. Suppose I wanted to insert only into last two columns I will do as : INSERT INTO <table-name>(col2,col3) VALUES(val2,val3); For less no of columns its not a big deal but what if i have 10 columns and … Databases mysql |
| | Hi need some help.I am creating a small hotel booking system.I have a mysql Db whith tables rooms, clients, bookings,prices,supplements, supplements booked. I have a search form. Clicking on a calendar img will display a calendar.Clicking on the calendar will insert the date in the box.Also I can select n.persons, … Databases mysql |
 | Hello, Will apache experienced problem for a database that required 500 GB of space? Davy Databases apache  |
| | Hello, i want to search date greater than particular date but my date column datatype in text, How could i do,i used following query SELECT * from $table Where postedDate>='21-August-2013' and postedDate<='22-August-2013' ORDER BY modified_date DESC this not working properly Databases mysql |
| | Hi, I have a table in which there are two columns. One column is id and the other is value. When I try to retrieve the data that is not empty it gives me unwanted error. I have to apply join to some tables as well. My query is something … |
 | This query is not working. I need urgent help. Thanks a lot in adv. **ROWS affected: 0** I have cross checked the data in the table for the given condition. $sql = 'UPDATE LTE_noria_cellule cel_bk_up SET cel.NAP_'.$site->ur().' = '1' '. 'WHERE cel.nidt IN ( select gn from LTE_noria_candidat_bk_up can INNER … Databases mysql |
| | I have 2 checkboxes on one page and a search button on another page that needs to take into consideration if the checkboxes are checked or not. I need to be able to search 4 different ways: both checkboxes are checked neither checkboxes are checked checkbox1 is checked and checkbox … Databases |
 | Hello, Self taught guy here. Thanks for reading my post. I've made a app to track the sales of floating rubber ducks for a duck race. I have a database which contains data similar to this: id soldby package ------------------------ 1 John 6 2 John 25 3 John 1 4 … |
 | Using Linux. I'm trying to learn PHP so I'm also going to need to learn some MySQL to work with my PHP code. Do I need mysql client or mysql server? I thought it was on my system but after issuing the command 'mysql' I got the following error. garrett@bedroom … Databases client-server mysql |
| | Any idea why this is happening? garrett@bedroom ~ $ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Databases mysql |
 | Hey everyone, I have an array of checkboxes that hold a value from 1-30, and when I first update the database it stores these values in a comma seperated list like 1,8,9,22 in the MYSQL database. Now my question is, can I when I go to the edit page to … Databases mysql |
| | (Linux System) Everytime I try to log into MySQL or create a database I get "Access denied for user@localhost". I just recently installed mysql using apt-get install and I don't recal creating a password or anything for it when I installed it. Any ideas? Databases mysql |
| | Ok so what i want to do is break up a string after the lenght of the string is = to 160, then i want to add a line break..but all this needs to be done in the Select...can anyone help me with this thankx in advance select case len(COD_P2_Q1) … |
| | Hi, Can anyone help.. I iam creating a UDF Script in SQL 2005. But i have a mesaage saying "Select statements included within a function cannot return data to a client" Here is my whole code.. set @SubjectString = 'The quick brown fox JuMp over the lazy dog.' set @CategoryString= … Databases mysql |
 | Hello there, I have problem as: have two tables **Candidate** and **candidate_interview** for perticular vacancy_ID , Candidate's status becomes "In Proces" and when his interview is schedule , entry is added in candidate_interview table againt that vacancy with status In Process. now what i want is , such candidates whose … Databases mysql  |
| | Forgive me if this is something obvious or a simple question. I am having issues with my date field when loading data into my database. I am having it load using a python script using the below command and once complete the date is 0000-00-00. the file I am loading … Databases mysql |
 | its my Data base structure , I want to create login for admin , franchisor , distributor , seller , its gives me a problem that when i take a user name 'David' for franchisor then can i also registor 'David' as a seller . i want a user name … Databases data-structure mysql |
 | im trying to do this : alter table project_info change column number proj_id int not null auto_increment, add primary key (proj_id); but mysql tells iv got an error. any help with whats wrong here ? i followed this from head first sql book (page 210 if anyone's interested ) . Databases mysql |
| | HI, I have a table with three columns id,history_nr,value. Now I want to make a query that should concat value with different nr. I have tried this syntax but it is not working. SELECT CONCAT((SELECT value FROM table WHERE history_nr=63 and id=1),'',(SELECT value FROM table WHERE history_nr=803 and id=1)) FROM … Databases mysql |
| | Hi, I would like to know how to export my schema WITH the table rows/content into a .sql script in MySQL (If it's possible). I tried using Forward Engineering with MySQL Workbench but when I select "GENERATE INSERT statements for Tables" it doesn't do it... I tried googling and finding … Databases engineering mysql  |
 | I have multiple columns I wish to order by. I have columns: # # # # (1, 2, 3, 4) A 0 0 0 0 B 1 0 1 3 C 1 0 2 3 I want to ORDER BY 4, 3, 2, 1. Syntax I am using: [code] "SELECT … Databases mysql |
| | I don't know what I'm doing wrong here, but I'm having hard time trying to insert data from a form into the database.The $_session['username'] is set and the database is included and working Here is my table CREATE TABLE IF NOT EXISTS `accounts` ( `accid` int(11) NOT NULL AUTO_INCREMENT, `acc_number` … |
| | hello friends I have three tables with similer structure and same column name id,sname,ssno,grade. I want to copy rows from table1 to table2 and table3 based on column grade . I am getting an error No value given for one or more required parameters. can someone kindly tell me how … Databases data-structure mysql open-source |
| | $query= "SELECT * FROM games where games.league='".$receivedleague."' AND games.gamedate >='".$todaydate."' AND '".$elnowla."' <= games.eldatetime AND (Not EXISTS(SELECT gameplayed.gameid,gameplayed.userid FROM gameplayed WHERE games.id=gameplayed.gameid AND gameplayed.userid='".$Userid."')) order by games.eldatetime asc limit 0,2" or die(mysql_error()) ; Hello gurus ! Can anyone help me to improve this query below ? I am no experty … Databases mysql |
 | Hi All, I am creating a simple query with a not so simple twist, at least it's not simple to me. First, the query: select distinct b.Bank_Mnemonic as [Bank],bd.Demo_Name as [Demography],ei.BEFI_Description[Economic Indicator],bsd.BSD_Year as [Year],bsd.BSD_Data_Value as [Value] from dbo.tblBank_Source_Data as bsd inner join dbo.tblBankDemographics as bd on bsd.Demo_ID=bd.Demo_ID inner join dbo.tblBanks … |
 | Hello, I have two tables one for the company staff and one for their projects(table name objecte). The table objekte has 4 colums that are connected with the id of the staff. The problem is that I want a query that shows all staff's names. I have also included the … |
 | Does'nt say could not connect. This is a new one for me. Don't know what to submit other than <?php $MySqlHostname = "mysql1.000webhost.com"; //the name of your host - if its local leave it as is. $MySqlUsername = "a8271678_unet7c3"; //the username to your database. $MySqlPassword = "pw"; //the password to … Databases mysql |
| | I faced to a huge problem when i coding some stored procedure. How to combine some string to sql string in stored procedure??? This is what i did upto now. @WhereCondition = ' WHERE id = 102 ' DECLARE recoredSet CURSOR FOR SELECT SUM(Amount) as AmountSum FROM sale + @WhereCondition …  |
| | I'm curious about write locks with MySQL and how they are prioritized with eachother. Specifically, I'm wondering if "low priority write" locks have lower priority than "normal" write locks, or if they are equal. The only documentation I can find states that the low priority locks have lower priority than … Databases mysql  |
| | Hey everyone having some troubles here with an update statement. I want to update a value(scanISN) if it exists and show information updated and if it doesn't exist show an error right now it show information updated even if it doesn't exist. How would I do that? <?php if(!isset($_POST['addMe'])){ //show … Databases mysql |
 | |
| | hi, i'm making a library database and if the user returned the book passed the due date given.i want to find the day difference and multiply that to a given fine amount.like this daydiff = due_date_of_book - date_returned fine_amount = daydiff * amount thanks in advance Databases vb.net |
| | im on win 8. neither can i find the bin folder as i could on my xp machine , nor do i get any command line. googleing didnt help much either. either i got some really hard to understand mysql doc page , with no specific answer to my problem … Databases machine-learning mysql windows-vista-7-8 |
 | hi guys, am trying to make a simple PHP form submission and insert some data to MySQL, my tables are: category: -id -category_name table1: -category_id(FK) -title -description table2: -table1_id(FK) -filetype -filesize -filedate -filename Form: -Date -Title -description -category(drop down) -upload file (get the file info like type,ext,size,filename) Or is there … |
| | Hey everyone, I am trying to create an excel spreadsheet that is populated with data from a table in sql server. I would like to make it so it will update several times a day with out the user having to do so. I have no clue how to go … Databases microsoft-office mssql sql  |
| | Hi! Got errors on site... Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/content/13/11394913/html/header.php on line 30 Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/content/13/11394913/html/config.php on line 4 Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/content/13/11394913/html/index.php on line 16 … |
| | Hello. I created a little recover page. Users write the email and a random password is sent to them. The random password is successfully send in their emails but when they login with the new password it doesn't login. I think the new password does not updates in my database. … Databases mysql  |
| | How to do the code for design and develop an PHP/MySQL application involves insert, view, search, delete, update/modify a record from a database Databases database-design mysql php  |
| | One of the people where I work did a migration from Access to SQL Server and just about everything migrated okay. However, all of the UPDATE and DELETE queries, when they were migrated, ended up having the "`" character interspersed throughout the query, which causes errors when trying to run … Databases microsoft-access mssql sql |
| | I have these templates: temp1(id,country_id,county_id,town_id,location_id,street_id) country(country_id, language,country_name) county(county_id, language,county_name) town(town_id, language,town_name) location(location_id, language,location_name) street(street_id, language,street_name) For now i am joining all these for the selected language to find the names of temp1 id's location. Is there a better way to retrieve the informations? Would be better to make a table … Databases mysql  |
| | Hi, I am using windows 7 sp1 32bit, try to install "Oracle 11g release 2" I am getting below errors and not properly installed help me to solve this errors thanking you file not found C:\app\I\product\11.2.0\dbhome_1\oc4j_applications\applications\em.ear file not found C:\app\I\product\11.2.0\dbhome_1\oc4j_applications\applications\em\em.war file not found C:\app\I\product\11.2.0\dbhome_1\ctx\admin\dr0ulib.sql.sbs file not found C:\app\I\product\11.2.0\dbhome_1\ctx\admin\dr0ulib.sql.sbs file not … Databases oracle  |
The End.