Home » Databases » Page 1
కృష్ణ+91-8875513486 get your love back in Thane
23/12/2014 12:31 pm by ravijay502 in Databases
contact number +91-8875513486 vashikaran vashikaran yantravashikaran specialist vashikaran totke mohini vashikaran vashikaran vidya contact number +91-8875513486
vashikaran mantras love vashikaran get your love back by vashikaran vashikaran guru
how to do vashikaran vashikaran for love vashikaran puja vashikaran specialist baba vashikaran vashikaran tilak
kala ja

Convert postgresql functions to mysql
by frugivore in Databases
I can't find any conversion tools that will convert postgresql functions/stored procedures to mysql.
Has anyone achieved this in some way?
My functions are very simple like below, but I have 100s of them so need a way to do in bulk, even if it's by copying and replacing text in the dump file
Syntax: [ Download ] [ Hide ]SXBB[id].writeCmd();Syntax: [ Download ] [ Show ]CREATE OR REPL

Need to insert two columns from one table another only if th
by Mistere in Databases
I want to enhance this mysql sql statement so that the two columns are only inserted if they don't already exist as a pair in the table.
insert into ingredient_owner (ingredient,owner) select distinct ing, (select owner from recipe where id=recipe_ing.recipe) as owner from recipe_ing where ing is not null;

converting a php script for mySql to microsoft sql
by Micah in Databases
I have a script that is designed to work with mysql and i need it to work with microsoft sql. I have already built a web app using mvc and have it connecting to the database. i have also built a mobile app using a software called App inventor 2 shich just uses code blocks. I need the mobile app to connect to the same database but in order to do so i have to use a php script but the problem is this

Sql video tutorial?
by Sankarsan Bose in Databases
Hello
I was watching this forum for a while now and I'm wondering.. Can any one recommend me a good video sql tutorial?
I'v used the search button and didn't find nothing helpful. Any links? Names?
Remember a beaginers guide step by step!
Ofc I could google it but it's better to ask experienced ppl ^^
/cheers!
TAGS : video tutorial

Need some help stopping multiple signups.. php/mssql
by Murali Ravipudi in Databases
It's been a couple years now since I've worked on website on a daily basic.. I thought you could never really forget how to program, but I am running a small project now and I am moreless confused on how to fix an issue..
I have a simple signup page requesting a username, password, password2 and email. I currently check only to see if the username exists and show an error if it does.
Wha

Table row is not adding !!!
by eskimospy in Databases
I'm a learner of PHP and MySQL. For learning purpose I'm trying to enter a table row using Terminal. But unfortunately, the row is not adding to the table and there is no confirmation. The code is below :
Syntax: [ Download ] [ Hide ]Syntax: [ Download ] [ Show ]INSERT INTO aliens_abduction (first_name, last_name, when_it_happened, how_long, how_many, alien_description, what_they_did, fan
TAGS : Table adding

Multi DB connection, locally, won't connect to 2nd DB
by Mistere in Databases
Syntax: [ Download ] [ Hide ]Syntax: [ Download ] [ Show ]$dbuk = mysql_connect("localhost","root","")or die ('Could not connect to site1.co.uk');
$db2uk = mysql_connect("localhost","root","")or die ('Could not connect to site2.co.uk');
mysql_select_db('site1', $dbuk) or die ('Could no

INSERT Query via CSV taking ages
by Jeeebus in Databases
I am trying to upload a 350,000 line CSV file.
Each row is checking that it doesn't exist already (to avoid duplicates), and then remove the " at the end of the run.
I thought it would take maybe a minute or two. It's taking a lot longer. Is my script badly done, causing it to be slow?
Syntax: [ Download ] [ Hide ]SXBB[id].writeCmd();Syntax: [ Download ] [ Show ]if ($update ==

How do you replace the first two chars in field for two?
by Brazil in Databases
We have had a script running that enters codes into a stock field, but with two additional characters at the start, such as this:
es5656565
es3jgjr
esXL55
es7fg
I want to replace the "es" with "fr". There are hundreds. I'm sure there is a 'REPLACE' script but cannot quite work out how to do it. I'd say it should do it only if it finds 'es' as well, in case there are som

require, require_once, include: which and why?
by evgen_povt in Databases
Syntax: [ Download ] [ Hide ]Syntax: [ Download ] [ Show ][Mon Mar 31 11:07:25 2014] [error] [client 180.76.5.27] PHP Notice:  Constant DBHOST already defined in /var/www/vhosts/site.co.uk/httpdocs/dbconn.php on line 9
[Mon Mar 31 11:07:25 2014] [error] [client 180.76.5.27] PHP Notice:  Constant DBUSER already defined in /var/www/vhost

Can't enter SQL commands phpMyAdmin
by Master843 in Databases
Hi,
I'm using Debian(jessie). I created a database(Cars) using phpMyAdmin's Create database function. I'm following along a book "The Joy of php". After the table is created the author wants to create a table (INVENTORY) using SQL commands. Well, phpMyAdmin will not let me enter any text in the SQL query text area. I created the table using the Create table function(buttons). If I click

Problem setting up connection to MySQL
by Triumph in Databases
Hey guys and gals,
I am a noobie to programming and these boards so first greetings to everyone. I started learning html/css/php/mysql a couple of weeks ago and think I am progressing nicely but as I got into databases I started having some set up problems. A couple of stats:
Mac OSX Mountain Lion
XAMPP 1.8.3-3
PHP 5.5.9.
I am learning from TheNewBoston tutorials and all

Upload Large Database
by ertuzio in Databases
I have 5GB database that need to upload in phpmyadmin.There is any solution that can less time to upload it?Please do help me by showing step in uploading the sql file. I have search through internet but could not understand.

how do i FORMAT OUTPUT from php-mysql database
by Brian Drum in Databases
Hi
i got a php code on internet that works fine. It retrieves details of suppliers from a mysql table "suppliers". All column headings are displayed horizontally.
It retrieves data and displays as shown below:
ID | NAME | ADDRESS | PLACE | PHONE | EMAIL
----------------------------------------------------------------
1 | TOM | XYZ | ABC | 123

Localhost !
by drnickriviera in Databases
Hi..I am new and beginner in programming. I try to display live data at localhost by http://localhost/alimtest/ but it show this error.
Server error!
The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there was an error in a CGI script.
If you think this is a server error, please contact the webmaster.
Error 500<
TAGS : Localhost

How do I reset a column in my database every x days?
by Igal in Databases
I am a PHP beginner.
Every x days (every 7 days for example), I would like all the values in a certain column in my MySQL database to reset back to '1'. How do I do this?
Please note: My web host does NOT have the MySQL event scheduler enabled so that is not an option. Also, my web hosting plan does not allow me to do cronjobs so that is not option either. Any other ideas?
Thanks!

Can you spot if one of more fields have the same data?
by Gianluca Riccardi in Databases
We have an issue where one or more fields of the database has the same data in it - ie same product stock codes.
We use this to show tickboxes on screen to select "additional accessories".
Trouble is, for whatever reason we have "mini ***" and then "small ***", which are actually the same product.
I'm not bothered about disabling one to be seen, but moreso creating a simple page th

Join two table and fetch data!
by buschman31 in Databases
I have two table and want to fetch data from them.
This query working fine:
"Select * from myads join users on myads.id = users.id";
but the problem is I want to use one of the field as counter
For the Single table this works for me:
"SELECT *,(30-DATEDIFF(now(),updateDate)) as counter FROM myads";
Now, my question is how can i combine this two querys.. any help will
TAGS : Join table fetch data


Privacy Policy - Copyrights Notice - Feedback - Report Violation - RSS 2017 © bighow.org All Rights Reserved .