Hello,
Q: Is there a way to direct MYSQLDUMP to export VIEW's with data (and not just the CREATE SQL)? I want to use the resulting SQL to create a new table.
Thanks!
Jon
Hi all,
Well I have read ALOT of posts and I can't quite find the perfect answer to my question, (or I have and havn't realised it!:-))
I have a large csv file that I want to read into my program and sve it to a SQL database table.
I'm useing VB2008 and my dabase is SQL2008.
Any help would be appreciated.
Cheers Cookster
I want to read data from html5 web database and post to sql server using vb.net server side. I have used following link as reference:
http://www.html5rocks.com/en/tutorials/webdatabase/todo/
I have created a web database and created table and stored some data in it. Now I want to store this data to sql server. How to get the data from html 5 web database and post to sql server each hour ( using some js timer).
Please suggest solution
Hi,
I want to convert the mysql database table contents to an Excel(.xls) or comma seperated file(csv) using python script... Is it possible? Any one can help me?
Thanks in advance,
Nimmy
Can I bind a table name in a Java Prepared Statement?
i.e.
PreparedStatement pstmt = aConn.prepareStatement("SELECT column FROM ? ");
pstmt.setString(1, "MY_TABLE");
Nope, no I can't. New question, anyone know how to delete a question?
I have a table view in that i am showing an text fields now my problem is i want to read the data from those text field i am able to get the value but i even want to know its from which text box i want the index of the text box
Hello,
I am learning Cocoa and trying to create an application for Mac that displays a simple book list. Each book is an NSView with its cover image, title and author. I want to present this list as a NSTableView with a single column and a book view in each cell. However i can't yet figure out how to display a custom view inside a table cell in interface builder or programmatically. Any tips would be very appreciated :)
Inso.
i have inherited a database application from someone else and there are a few tables that dont have any primary keys. I want to add a new column into an already existing table and have it autonumber (starting from 1). how would i go about doing this?
Hi,
I have a tabel in an Sql Server 2005 database. I have the following column
IndPL INT DEFAULT 0 NULL
I want to change the column to be of the type NVARCHAR but I receive a constraint violation due to the fact that the column has a default value constraint attached to it.
I need to find out how to remove a default value constraint from a table column or how to change the column type without impeding the constraint.
Consider a table or CTE structured like this:
Name Num
---- ----
Abc 12
Abc 12
XYZ 70
XYZ 80
Bar 50
Bar 55
Foo 44
Foo 44
Baz 88
The requirement is to determine the Name where multiple different Nums exist.
The desired resultset is
Name
----
XYZ
Bar
What TSQL statement would you use to derive this resultset?
Hi, I was using KohanaPHP ORM but I can't use it with my database table structure. So, I need a framework or library ORM to use with it.
With Kohana I need to follow a naming convention. I can't use a field name (foreign key) like 'idUnidadeMedida'.
Are there any suggestions?
Thank you.
I'm trying to turn a method I have right now into a more "generic" method that returns a string. Right now, the method uses a statement like this:
var app = (from d in testContext.DAPPs
where d.sserID == (Guid)user.ProviderUserKey
select d).ToList();
I process the results of "app", add extra text etc. The piece that changes (that I need to make more "generic") is the table name (DAPPs). Is there a way I can do that, or, a better way to go around this all together?
Seems like max table comments length in mysql is only 60 characters.
I'm developing an aplicacion in php symfony, which automatically generates sql ddl sentences, and in many cases those comments are far beyond 60 characters.
Is there some way to increase that limit?
thanks a lot
Hello,
For the HTML table column below, the $count++ displays in the middle of the row. How can I get it to display at the top of the row?
Thanks in advance,
John
Code:
echo '<td class="commentnamecount">'.$count++.'.</td>';
CSS:
.commentnamecount { width: 20px;
overflow:hidden !important;
color: #000000;
vertical-align:
}
I'm a bit embarassed asking this here, but here goes:
I've got two tables, which you can see here:
http://img411.imageshack.us/img411/4562/query.jpg
I need to copy the effortid from the one table into the other, making sure that the values still maintain the correction relationships. The primary key for each is a combination of loggerid & datetime. What's the best way to do this?
Thanks in advance, and don't make fun :)
I have a table called 'highscores' that looks like this.
id udid name score
1 1111 Mike 200
2 3333 Joe 300
3 4444 Billy 50
4 0000 Loser 10
5 DDDD Face 400
Given a specific udid, I want to return the rank of that row by their score value.
i.e. if udid given = 0000, I should return 5.
Any idea how to write this query for a MySQL database?
Hi, i've got a table like that :
Article Number Last Voucher Number Last Voucher Date
0557934 519048 04/02/2005
0557934 519067 04/02/2005
0557934 528630 09/29/2005
0557934 528631 09/29/2005
0557934 529374 10/13/2005
0557934 529375 10/13/2005
0557934 529471 10/16/2005
0557934 529472 10/16/2005
0557934 535306 01/08/2006
0557934 535307 01/08/2006
0557934 1106009 08/10/2006
0557934 1106010 08/10/2006
0022738 22554 02/20/1995
0022738 22595 03/12/1995
0022738 22597 03/15/1995
0022738 22605 03/19/1995
0022738 22616 03/25/1995
0022738 22621 03/28/1995
0022738 22630 04/05/1995
I would like to have only the record with the last date :
Article Number Last Voucher Number Last Voucher Date
0557934 1106010 08/10/2006
0022738 22630 04/05/1995
I can do directly on SQL or on Linq.
Any idea?
Ju
Hi
I have an existing iPhone application which starts from a UIViewController.
What I want to do is add two new table views, one which will require the navigation controller. Can anyone provide info on how to retrofit this into my app or will I need to start again from scratch using the navigation template?
Thanks
Aidan
Hi to All,
I developed an iPhone app which displays iPhone AddressBook contacts list.
I want to add extra fields to the selected contact.
Using AddressBook framework,it was not possible.So,i want to attach those values to the "contacts" table of my database.
How can i store(insert) those existing contacts into contacts(using sqlite3 insert command).
Please,help me with a sample code.
Thanks in Advance,
Ramya.
Hi,
Can anybody tell me the 'call out table' in unix? The explanation is given in 'Maurice J. Bach' book but I'm getting difficulty in understanding the example especially, the one explaining the reason of negative time out fields. For what purpose the software interrupts are used there?
Thanks!