How to keep backup of our database in MySql.
- by Sanjeev
I want to keep backup of my database and import it into different System? and how to make .dmp
or store file in MySql?
Search Results
Search found 42428 results on 1698 pages for 'database query'.
Page 555/1698 | < Previous Page | 551 552 553 554 555 556 557 558 559 560 561 562 | Next Page >
-
-
How To Work With SQL Database Added As Item In Visual Studio 2008?
- by mdvaldosta
If I'm letting Visual Studio take care of adding an SQL Server database to an existing project, it adds the connection string to app.config. How can I use use THAT connection string to make my own connections and datasets?Read the article
-
how do I display list of URLS say maximum 50 per web page from MySQL database??
- by mathew
I do have thousands of urls in my database. what I want to do is display all urls in multiple pages say number of URLS per page is 100 and alphabetically then when ever a user search for a URL info it should get updated on relevant page. for example if it is google.com then it should get updated on "G" page and no duplicate entry. how can I do this with PHP and MySQL??Read the article
-
Best approach to developing a cross-browser javascript widget that populates from a MySQL database?
- by MindSculpt
I'm currently researching the best way to approach building a javascript widget someone can embed on their site, which would retrieve and display information from an external MySQL database. The gist of the widget would mimic the needs/functionality of Twitter's widget (http://twitter.com/about/resources/widgets), where it uses some combination of JS, PHP and/or AJAX and retrieves information from a MySQL DB with secure (or at least somewhat safe) cross-browser access. Thoughts or ideas on the best and most reliable way to approach something like this?Read the article
-
Is it a good idea to Strtolower the username then store it in database?
- by Axel
Hi, In a php/mysql application where people can registre, is it a good idea to strtolower the username then store in the database in order to not have problems in the future? because people are using DiFfeReNt cases and i'm afraid that will make conflict in some queries. ThanksRead the article
-
How to load 1 milion records from database fast?
- by Leonard P.
Now we have a firebird database with 1.000.000 that must be processed after ALL are loaded in RAM memory. To get all of those we must extract data using (select * first 1000 ...) for 8 hours. What is the solution for this?Read the article
-
How can I make the Entity data model designer use my database column descriptions?
- by Jack
I am using EF4 with Visual Studio 2010. I have a SQL database already created and all my columns are documented with the Description property in SQL management studio. When I create the edmx in Visual Studio, how can I make it read those descriptions and use them to add comments to my generated classes? I know I can use the Summary and LongDescription in the edmx properties but I'm looking for a way to do this without having to copy and paste every description. Thanks!Read the article
-
how to retrieve the most entered value from database mssql using vb.net ?
- by D Infosystems
if i have mssql database with record displayed below : Id Serv-code Value 1 100 3 2 100 4 3 100 3 4 100 3 5 101 5 6 101 5 the logic i want when i search for the record using serv_code 100 then the output will be the average means 3 will be displayed in textbox because the value 3 will be entered 3 times than 4 as shown above .... and if if i search record with serv_code 100 and if the value of serv_code is equal means 3 and 4 only then the recent entered value will be displayed in textbox..Read the article
-
Is it possible to get Java fmt messages bundle from database ?
- by newbie
I nedd to localize application and now files are loaded from text files. Is it possible to change source to database? This is how localized messages are now loaded: <!-- Application Message Bundle --> <bean id="messageSource" class="org.springframework.context.support.ReloadableResourceBundleMessageSource"> <property name="basename" value="/WEB-INF/messages/messages" /> <property name="cacheSeconds" value="0" /> </bean>Read the article
-
Can I do an ASP.NET Dynamic Data project against a Sybase database?
- by theog
Or must it be a SQL Server database? If I'm reading the documentation right, as long as I use Entity Framework and not Linq to SQL, I can go against a Sybase data source. But I'm not certain...Read the article
-
mysql update enums
- by FFish
I have a field with enums: 'preview','active','closed' When I query like this: $query = "UPDATE albums SET album_active = preview WHERE album_id = 3"; $result = mysql_query($query); if (!$result) die('Invalid query: ' . mysql_error()); I get : Invalid query: Unknown column 'preview' in 'field listRead the article
-
How do you connect to a remote database with SQLTALK?
- by NitroxDM
How do you connect to a remote database with SQLTALK? I was going to add a SQLTALK tag but I'm not cool enough again. So... could someone re-tag this question? Thanks.Read the article
-
How do I backup Oracle database (about 1TB size) in VMware without using RMAN?
- by vaishalee
It's been a while since I am struggling to find a backup solution for cold backup of Oracle database on Linux in VMware. I am obviously not looking for entire vm image backup.Read the article
-
How to disconnect an existing ruby sequel connection to a database?
- by MG
I mean the one which was previously established as DB = Sequel.sqlite('my_blog.db') or DB = Sequel.connect('postgres://user:password@localhost/my_db') or DB = Sequel.postgres('my_db', :user => 'user', :password => 'password', :host => 'localhost') or etcetera. The Sequel::Database class has no public instance method called "disconnect" or so though it has "connect" one. Maybe somebody already faced that problem. I would appreciate any idea.Read the article
-
Report Designer for vb.net using Visual Studio 2008 and a SQL 2005 back end database other than Crys
- by GaryBrown
We are developing in vb.net using Visual Studio 2008 and a SQL 2005 back end database and are looking for a Report Designer that can be used to build reports and give the User the ability to modify and create reports once the software is sold and in use.Read the article
-
how to store hour and minute in database table while using mktime() function?
- by Learner Miz
I am using a form to get the hour and minute using post method and then store it to mysql DB. Such as : $hour = $_POST['hour']; $minute = $_POST['minute']; ** There is no need of date, month and year. I just need to store the hour and minute in a column of a table (ex: exam_time) Column structure: exam_time time NOT NULL Now how to store these value into database using mktime() function. I tried but it stores 00:00:00, not the one which I am sending via form.Read the article
-
Fill business object from database by calling stored procedurs?
- by grady
Hello, I have several stored procedures in my database, some of them have params, some have no params. I tried to fill a business object by calling the stored procedures, but failed so far. How could I do that dynamically? Later, I want to use this object as a datasource for a report...but thats the next step. The important facts are: different stored procs return different amount of columns stored procs can have params, but its not required How could I achieve that? Thanks :)Read the article
-
Is it possible to insert multiple rows at a time in an SQLite database?
- by Andrew
In MySQL you can insert multiple rows like this: INSERT INTO 'tablename' ('column1', 'column2') VALUES ('data1', 'data2'), ('data1', 'data2'), ('data1', 'data2'), ('data1', 'data2'); However, I am getting an error when I try to do something like this. Is it possible to insert multiple rows at a time in an SQLite database? What is the syntax to do that?Read the article
-
sql server: looking for table usage through out database...
- by dotnet-practitioner
How would I figure out what type of sql code such as procs, functions, views etc. are interacting with my table called TABLE1 through out a given database. Sample code would be very helpful for me. thanksRead the article
-
How to access the database when developing on a phone?
- by Pentium10
I am having trouble accessing the database while I am developing on the phone. Whenever I execute cd /data/data/com.mycompck/databases then if I try to run ls I get opendir failed, Permission denied Or whenever I type in: sqlite3 I get sqlite3: permission denied What I am doing wrong? Are there some applications that can help me getting a human view of content resolvers values and/or SQLite databases?Read the article
-
How to count each record in each table in a SQL Server 2005 Database?
- by Heather
I need to know how many records are in each table in a particular database. I don't care what is in the record, they will all need to be counted. I already know how to do this for a single table as SELECT Count(1) FROM [my_table_name], but this gets a little redundant for 200+ tables.Read the article
-
How to intregrate an oracle database with an asp.net web application?
- by Priyaa Muthuraman
How to intregrate an oracle database with an asp.net web application?... Any good tutorial to start with?Read the article
-
How can I automate updating my SQL Server database?
- by Sanju
I get multiple text files daily to update my database from my client side and I am not a DBA expert. Every day I update it manually. Is there any method I can use to make this easier? I think there is a way to automate it but I don't know exactly what to do.Read the article
-
how can i display the database data to an jtable(dynamic) in the swings!
- by harish0510
we are using hibernate in business layer,but the task is, by using the jtable in swings to display the dynamic data(swings) from the database. code: Criteria criteria=session.createCriteria(User.class); //here user.class is pojo class in hibernate. List studentlist= criteria.list(); System.out.println("records"+studentlist); here the data is showing in hibernate console, but how to represent that data in the format of "jtable".Read the article
-
How to run multiple jobs with spring quartz and the jobs are feched from database.
- by nataraju
How to run multiple jobs with spring quartz and the jobs are feched from database. Please provide any example code.Read the article
