Search Results

Search found 25113 results on 1005 pages for 'grouped table'.

Page 88/1005 | < Previous Page | 84 85 86 87 88 89 90 91 92 93 94 95  | Next Page >

• how to delete duplicates on mysql table?

  - by Ronnie Chester Lynwood

  hello I need to know any way to delete duplicated items for specified sid on table. how can I do this with SQL queries ? DELETE (DUPLICATED TITLES) FROM table WHERE SID = "1" something like this but i don't know true one :/ thanks.

  Read the article

• Incorrect table name, php/mysql

  - by user296516

  Hi guys, I've got this code mysqli_query ( $userdatabase, 'CREATE TABLE `user_'.$emailreg.'` ( ID int NOT NULL AUTO_INCREMENT PRIMARY KEY, IP varchar(10), FLD1 varchar(20), FLD2 varchar(40), FLD3 varchar(25), FLD4 varchar(25), FLD5 varchar(25) )' ); echo ( mysqli_error ($userdatabase) ); that works fine on my localhost, but when I upload it to the server, it starts giving me a "Incorrect table name '[email protected]'" error. any idea? Thanks!

  Read the article

• set position in a table

  - by Senthilkumar

  Hi can any one tell .. how to set position inside a table.. I have table inside which I have span and certain links .. I made as cetre alignment and span text s starting from centre but when i do the same for all links everthing displayed in centre if it own.. but i need to start all text at the same position/.. how to do this???

  Read the article

• Create Word/RTF file with table of contents from Java

  - by Glen

  Hi, I want to create a Word or RTF file with a table of contents (with links to each section) from Java. From my understanding, iText & Apache POI do not support generating a table of contents. Some clients of the app still use older versions of Word, so I need a library that supports the older Word doc format. Does anyone know how I can do this? Thanks, Glen

  Read the article

• Cross Join 'n' times a table

  - by SDReyes

  It is possible to write a generic function/procedure/select/somethingElse to cross-join a table against himself 'n' times? (yes, 'n' is a given parameter : ) How would you do it? Example Having this table: Value ------- 1 2 3 cross join it 2 times, would return: Value | Value ------------------ 1 1 1 2 1 3 2 1 2 2 2 3 3 1 3 2 3 3

  Read the article

• delete last row in a table android

  - by Sephy

  Hi everybody, My question is quite straightforward. I have a table, with, lets say x rows, with each an id, but i don't know how many rows i have. Now i want to delete the last row of my table for some reason... Is there an easy way to do that in android? I have been trying to use the last_insert_rowid in my where clause...but no luck so far... any idea? thx for help

  Read the article

• Append SQL table name with today's date

  - by Ricardo Deano

  Hello all. I understand that I can change a sql table using the follow sp: EXEC sp_rename 'customers', 'custs' How would I go about appending this so that the new table has today's date as a suffix? I've attempt variations on the below theme with little success!! EXEC sp_rename 'customers', 'customers +(CONVERT(VARCHAR(8),GETDATE(),3))' Any help greatly appreciated.

  Read the article

• Get data from table from a list of strings on MySQL

  - by steamboy

  Hello, How can I query data from a table available on a list of strings? I only want to get the data from the list of strings. Example: Table ID Name 1 Big 2 Small 3 Extra 4 Orange 5 Drink List of Strings: Big Small Extra Thanks!

  Read the article

• Calculate and display distance between userlocation and known point in Table View

  - by Claudio

  Hi, I have a table view with a list of hotel, and i want put in cell.detailTextLabel.text the distance beetween userlocation and hotel. How can obtain the coordinates of userlocation? I see on web that i need to use CLLocationManager but i don't understand how and where implement in my table view. Then,to get the distance,i do a "getDistancefrom" between userLocation and the coordinates of the hotel ? Thanks

  Read the article

• SQL Server and Table-Valued User-Defined Function optimizations

  - by John Leidegren

  If I have an UDF that returns a table, with thousands of rows, but I just want a particular row from that rowset, will SQL Server be able to handle this effciently? SELECT * FROM dbo.MyTableUDF() WHERE ID = 1 To what extent is the query optimizer capable of reasoning about this type of query? How are Table-Valued UDFs different from traidtional views if they take no parameters? Any gotchas I should know about?

  Read the article

• mysql concat all field table

  - by hafizan

  Is there a way we can concat all field in the table(1 sql statement)(automatic) ? The reason was before user updated or delete a record,the record will push to another table for future reference.

  Read the article

• Access ELF string table section header

  - by idealistikz

  Assume: Elf_Section_Header *sectionHeaderTable //points to the start of a ELF section header table Elf_Section_Header *symtabHeader //points to the start of the symtab section header Why doesn't the following point me to the associated string table section header? Elf_Section_Header *strTabSectionHeader = (Elf_Section_Header *)((char *)sectionHeaderTable + (symtabHeader-strtab_index)); 'strTabSectionHeader-type == SHT_STRTAB' is equal to false How should I point ot the strTabSectionHeader?

  Read the article

• Mapping a property to a field from another table in NHibernate

  - by Khalil Dahab

  consider the following class: class Order { int OrderId {get; set;} int CustomerId {get; set;} string CustomerName {get; set;} //other fields go here } which is mapped to Orders table. Is it possible to map the property CustomerName to the Customers table through the foreign key relation?

  Read the article

• manually updating database table values are not reflecting in webpage - aspnet mvc

  - by FosterZ

  hi,i noticed some wierd problem i.e i have built a web page on which information comes from database table named "school", when i change some data in that table manually from mssql the web page data is still same as previous, its not gettin' changed, i dn't know how it is possible.

  Read the article

• lr parsing table

  - by flufferok

  Could any1 explain how can i transform ll(1) parsing table to lr(1) parsing table? Or are there any tables already for lr1 mathematical parsing(+,-,/,*,^)?

  Read the article

• Fastest way to check array items existence in mySQL table

  - by Enrique

  User writes a series of tags (, separated) and posts the form. I build an array containing the tags and delete dupes with array_unique() php function. I'm thinking of doing: go through the array with foreach($newarray as $item) { ... } check each $item for existence in the tags mySQL table if item does not exists, insert into tags table Is there a FASTER or MORE OPTIMUM way for doing this?

  Read the article

• [Haskell]Curious about the Hash Table problem

  - by astamatto

  I read that hash tables in haskell are crippled ( citation: http://flyingfrogblog.blogspot.com/2009/04/more-on-haskells-hash-table-problems.html ) and since i like haskell it worried me. Since the blog-post one year has passed and im curious, The hash table problem in haskell was "fixed" in the traditional compilers? (like ghc) ps: I love stack overflow, im a long time visitor but only today i decided to try to post a question.

  Read the article

• mysqldump parameter to ensure DROP VIEW IF EXISTS rather than incorrect DROP TABLE IF EXISTS

  - by doublejosh

  Wonder if there is a parameter I can pass in mmysqldump equivalent for SQL Servery mysqldump that will make the incorrect "DROP TABLE IF EXISTS" statements into "DROP VIEW IF EXISTS", so that populating a database in an automated development environment refresh will work? Clarification, I'm getting DROP TABLE IF EXISTS statements in my .sql dump file even though they aren't tables. FYI: This is a Drupal site. The tables in question are ubercart meta statistics tables.

  Read the article

• How can I alter a temp table?

  - by William

  I need to create a temp table, than add a new int NOT NULL AUTO_INCREMENT field to it so I can use the new field as a row number. Whats wrong with my query? SELECT post, newid FROM ((SELECT post`test_posts`) temp ALTER TABLE temp ADD COLUMN newid int NOT NULL AUTO_INCREMENT)

  Read the article

• How to create a table type in Sql Server 2005

  - by Nikola Stjelja

  Hi, I'm trying to create a table type in sql server 2005. Here is what my code looks like: CREATE TYPE NameResourceType AS TABLE ( ID int, [Value] Varchar(256) ) GO I receive the following error: Incorrect syntax near the keyword 'AS'.

  Read the article

• Alternate three and three rows in a table with jQuery

  - by Frode Lillerud

  I want to set the alternate background color for rows in a table - but the twist is that I don't want every other row to be colored, I want to treat them in blocks of three rows. So for a table with eight rows I want the first three to be white, then the next three to have a background color, and the last two are back to white again. How can I do this using jQuery?

  Read the article

• adjusting table content with javascript by enumerating rows

  - by Tom

  I have a table row with 4 columns on my ecommerce site and I want to replace the content of 1st column if total amount in last column (TD class "total") is over 10 EUR. How can I do this with javascript only, I guess somehow to enumerate through the table rows and look for a correct row (one with the last column class as total) and then access the content of 1st column on this row but how?

  Read the article

• Adding metadata attributes to MySQL table

  - by Jack

  I would like to add custom attributes to a MySQL table which I can read via php. These attributes are not to interfere with the table itself - they are primarily accessed by php code during code generation time and these attributes HAVE to reside in the DB itself. Something similar in concept to .NET reflection. Does MySQL support anything like this? Thanks.

  Read the article

• MYSQL DELETE from a table [closed]

  - by Hossein

  Possible Duplicate: MySQL DELETE in a single table Hi, I have this table: userurltag(id,user,Url,tag) I want to remove rows that contain urls that are used by only one user, can someone help me? It seems that DELETE...(SELECT...) is not supported in Mysql.

  Read the article

• Using NDbUnit with tables that have a table schema

  - by KevinT

  I am having issues using NDbUnit with tables that have their own schema - ie: CREATE TABLE MYSCHEMA.MyTable01 ( Id int NOT NULL, Description varchar(50) NOT NULL ) Is this a supported scenario? What do I need to do to get this to work? (working fine when the table is dbo.MyTable01)

  Read the article

< Previous Page | 84 85 86 87 88 89 90 91 92 93 94 95  | Next Page >