Search Results

Search found 31483 results on 1260 pages for 'database migration'.

Page 861/1260 | < Previous Page | 857 858 859 860 861 862 863 864 865 866 867 868  | Next Page >

• Can't create/write to file (Errcode: 22)

  - by magdmartin

  Quite new with SQL I'm looking to export some data from a MySQL database into a csv file. I'm working locally (localhost). Here is my SQL statement: SELECT DISTINCT * INTO OUTFILE 'C:\Users\Martin\Downloads\result.csv' FROM provider, location, provider_has_location WHERE provider.idprovider = provider_has_location.provider_idprovider AND location.idLocation = provider_has_location.location_idLocation LIMIT 20 MySQL return the following error: Can't create/write to file 'C:UsersMartinDownloads esult.csv' (Errcode: 22) Thanks for your help.

  Read the article

• List of system tables in SQLite

  - by sovanesyan

  I am trying to filter all the tables in a SQLite database based on if they are system tables or user generated ones. So far I've found out that they are the ones with the sqlite_ prefix and AllDataTypes. Has anyone done something like this? Is there a list of them? Thanks in advance.

  Read the article

• technology for new webproject?

  - by elCapitano

  Hi there, i am planing to set up a new webproject which has to use a database and a model which can be presented in a browser. I looked at a lot of technologies (JSF, PHP, ..) but i could not find a free and easy framework/technology for me (in the end i prefered asp.net, but this is not free). What can you recommend me for a new webproject from scratch?

  Read the article

• SQL updating a column in a table

  - by tecnodude

  Hi, I have the following table in an access database id VisitNo Weight 1 1 100 1 2 95 1 3 96 1 4 94 1 5 93 Now row 2 and 4 are deleted. So i have... id VisitNo Weight 1 1 100 1 3 96 1 5 93 However what i need is... id VisitNo Weight 1 1 100 1 2 96 1 3 93 What is the SQL query i need to accomplish the above? thanks

  Read the article

• How can I connect to Sybase with Perl?

  - by Mike

  I'm trying to a good Perl module to use for connecting to a Sybase database. My Googling has led me to see sybperl as a possible choice, but it hasn't been updated since 2005.

  Read the article

• I need some advice from Experts on how to develop a PHP site with MySQL

  - by mouthpiec

  Hi, I need some advice from experts :) I will develop a website using PHP and I will use also MySQL. I bought some server space from a Virtual private server including all the service needed. How should I develop the site? Shall I develop it on my machine at home (using for example Wamp), and when ready transfer all the files to the server? If so what is the best method to transfer also the database? Thanks in advance!!

  Read the article

• How to convert numbers to words in php

  - by user225269

  Is there a function in php wherein you can convert the number 12 to its equivalent in a month. For example if the mysql database stores digits and not words for dates. how do you convert the number 12 into the word december?

  Read the article

• JQuery search page textbox

  - by Geetha

  Hi all, I am creating a search page using asp.net[c#] with jquery. Needs: If we are typing a word in the text box, for each letter it has to display the related word in the database. ex: step 1. w [display: world Whole] step 2: wor[display: World] How to achieve this using jquery Geetha.

  Read the article

• PHP - How do i display the first 20 li then have a link to display more (gallery)

  - by Matt Rogers

  I want to display about 20 li on a page with a link at the bottom that says something like 'display more'. This link will then clear the first 20 and display the next 20. How should i go about doing this. (I am creating a gallery) I was thinking about using PHP and MySQL. However for what I am doing I do not really need to store it in a database so is there an easier way of doing it only using html, php or javascript? thanks

  Read the article

• Difference between string comparrison in java

  - by Gandalf StormCrow

  Is there a difference between these ? if(myString.equals("")){ } if(myString.equals(null)){ } if(myString == ""){ } I have a string, I don't know is it empty or has some emtpy spaces I just wan't to stop it to be written in database if it is invalid(if empty or with some blank spaces).

  Read the article

• What does `?` stand for in SQL?

  - by user295189

  I have this SQL by a programmer: $sql = " INSERT INTO `{$database}`.`table` ( `my_id`, `xType`, `subType`, `recordID`, `textarea` ) VALUES ( {$my_id}, ?xType, ?subType, {$recordID}, ?areaText ) "; My question is why is he using ? before values? How do I see what values are coming in? I did echo and it shows ?xType as ?xType. No values. What does ? stand for in SQL?

  Read the article

• How to set up a progress bar

  - by user310850

  I have a php page named import.php. while executing this file a lot of database operation is doing.So i need to show the progress to the user, by using a progres bar.How is it possible using any of these php ajax, javascript, jquery,css, flash... methods

  Read the article

• iPhone connect to SQL server

  - by immuner

  Since i am new to iphone and mac dev, which is the suggested way to connect your application to an sql server/sql server express 2005 database (in my case to sync data with sqlite)? Thank you

  Read the article

• Generic object comparison diff routine

  - by MicMit

  The question stems from database tables comparison. Let's say we put left row in the instance Left and the right one into instance Right of the same type. And we'got many tables and respective types. How to implement more or less generic routine resulting in a collection of diffs e.g. propertyName , leftValue , rightValue for each such a pair of instances of the same type.

  Read the article

• How to create object of Date("23.03.2010")

  - by Ranjeet

  I have astring directly coming form the database and I am creating object of Date as Date dt=Date("23.03.2010") and it is comin NaN whereas when I use Date dt= Date("03/23/2010") it works fine. Any Idea how I can get this working?.

  Read the article

• PHP Round Minute to nearest Quarter Hour

  - by Rob

  I need to round times down to the nearest quarter hour in PHP. The times are being pulled from a MySQL database from a datetime column and formatted like 2010-03-18 10:50:00. Example: 10:50 needs to be 10:45 1:12 needs to be 1:00 3:28 needs to be 3:15 etc. I'm assuming floor() is involved but not sure how to go about it. Thanks

  Read the article

• Many-to-many relationships examples

  - by Tom

  I haven't found any MYSQL many-to-many relationships examples here and in google. What I am looking is to see a very simple example with php+mysql showing database's results. Can anybody write a very simple example?

  Read the article

• Which controller is better for displaying user details in cocos application?

  - by mikw

  I have some details of user in database but i want to display details for particular user.i want to know which controller is better for that can u give me some advice.Thanks in advance.

  Read the article

• manupluation of date in vb

  - by banita

  how can we extract system time in vb and do calculation ie. adding or subtracing time then store change time in oracle database table in earlier format .

  Read the article

• mysql Error no 2003

  - by Bharanikumar

  am i using the wamp, For phpmyadmin Database username is root and no password, and host is localhost i downloaded the mysql query browser from mysql.com , i have downloaded this mysql-gui-tools-noinstall-5.0-r17-win32 , when i try to connect the query browser , it through the error like, what i do now ? where is the step by step sol for my prob..

  Read the article

• How to upload 10 Gb of data to MySQL programmatically without crashing like on PHPMyAdmin?

  - by asksuperuser

  I'm very surprised that it seems impossible to upload more than a few megabytes of data to mysql database through PHPMyAdmin whereas I can upload a msaccess table easily up to 2 Gigabytes. So is there any script in php or anything that can allow to do so unlike phpmyadmin ?

  Read the article

• how can i add double slash into path in vb.net

  - by testkhan

  i have a path i.e D:\videos\new\video1.mpg and i want to convert it into D:\videos\new\video1.mpg... to add it in mysql database...how can i do that

  Read the article

• What's the best way to make a mobile friendly site?

  - by Frew

  Speaking entirely in technology-free terms, what is the best way to make a mobile friendly site? That is, I want to make a site that will work on a regular computer but also have mobile versions of the pages. Should I rewrite each page? The pages will probably have different functionality, so should I rewrite the backend code? Should it be an effectively different site with the same database?

  Read the article

• what's the best storage for text

  - by maryam

  Hi, I have an application that just only use for show information and search data. and my datatype is text and has larg size. would you please tell me what's the best storage for it. also I don't want to use SQL database. thaks

  Read the article

• Dynamic Date Time Dropdown List

  - by user302720

  At phpro.org and other sites there is a tutorial, "Dynamic Date Time Dropdown List". How does one get the $_POST variables for insertion into a mysql database? Thanks in advance for any and all assistance.

  Read the article

< Previous Page | 857 858 859 860 861 862 863 864 865 866 867 868  | Next Page >