Search Results

Search found 25547 results on 1022 pages for 'table locking'.

Page 212/1022 | < Previous Page | 208 209 210 211 212 213 214 215 216 217 218 219  | Next Page >

• How to pass a table from frontend to a stored procedure?

  - by vaibhav

  I want to pass a table as a parameter to a stored procedure. Is it possible to do it. Please give some example.

  Read the article

• Can I restore a single table from a full mysql mysqldump file?

  - by Mobius

  I have a mysqldump backup of my mysql database consisting of all of our tables which is about 440 megs. I want to restore the contents of just one of the tables form the mysqldump. Is this possible? Theoretically, I could just cut out the section that rebuilds the table I want but I don't even know how to effectively edit a text document that size.

  Read the article

• Retrive all data from mysql table using fluent nhibernate step by step process..

  - by chandru_cp

  As i am a newbie to fluent nhibernate i would like to get step by step tutorial that explains configuring mysql with fluent nhibernate and retriving a table data from it... Any suggestion....

  Read the article

• Can I use an "IN" filter on an Advantage Database Table (TAdsTable)?

  - by Anthony

  I want to apply a filter to an advantage table using multiple values for an Integer field. The equivalent SQL would be: SELECT * FROM TableName WHERE FieldName IN (1, 2, 3) Is it possible to do the same on an AdsTable within having to repeat the field using an "OR"? I want to something like: Filter := 'FieldName IN (1, 2, 3)' Instead of: Filter := 'FieldName = 1 OR FieldName = 2 OR FieldName = 3'

  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

• MYSQL - Query to check against other table (hard to explain...)

  - by Sam

  I have a query that gets a list of emails who have subscribed for a newsletter trial which lasts 30 days.. $thirty = time() - 3024000; SELECT c.email FROM tbl_clients AS c JOIN tbl_clientoptions AS o ON o.client = c.id WHERE o.option = 'newsletter' AND c.datecreated $thirty What I want to do is do a check in that same query so it also returns clients OVER 30 days old if they have the tbl_clientoptions.option = 'trialoverride' (ie; a row in the client options table with the value "trialoverride") basic columns are: TBL_CLIENTS id,name,email,datecreated TBL_CLIENTOPTIONS id,client,option

  Read the article

• How to create view from more than one table in MS Sql Server database?

  - by GK

  I have to create a view from more than one table in MS Sql Server database, but i am not able to get the correct syntax for the same. need help. thanks.

  Read the article

• mssql Is it possible to get procedure or table creation and last alter date?

  - by Woland

  mssql Is it possible to get procedure or table creation and last alter date? If it is then how do to it? Ms sql 2005 server

  Read the article

• How to handle click event on table at first column using jquery?

  - by kumar

  $('tr').click(function() { $("#showgrid").load('/Products/List/Items/'); }); Using this I am handling click event on the row of the table. How can I handle only on the first column? that is, giving click action to only first column not on entire row? thanks

  Read the article

• Why each request with activerecord is doing SHOW TABLE?

  - by dynback.com

  My test page is processed if believe to trace in 46 ms, while 11 of them I am doing this 20:53:06.111597 system.db.CDbConnection Opening DB connection 20:53:06.118046 system.db.CDbCommand Querying SQL: SHOW COLUMNS FROM `questions` 20:53:06.122476 system.db.CDbCommand Querying SQL: SHOW CREATE TABLE `questions` Is this obligatory?

  Read the article

• mysql: Can I use two "where"s? Like, "SELECT * FROM table WHERE something and something"?

  - by KeriLynn

  I have a table with my products and I'm trying to write a page that would pull bracelets with certain colors from the database. So here's what I have right now (in php): $query = "SELECT * FROM products WHERE (products.colors LIKE '%black%')"; But I only want to select rows where the value for the column "category" equals "bracelet". I've tried a few different things, but I keep getting warnings and errors. I appreciate any help you can give, thank you!

  Read the article

• Can i insert an image in a MYSQL DB table?

  - by Shinigami

  is there a way to insert pics(not url,the pic)into a MYSQL table made with phpmyadmin? and if there is when i want to get that picture and insert it in the page , what should i do? :)

  Read the article

• How do I line up my textboxes without using a table? html/css

  - by SLC

  I want to display Name [Textbox] Age: [Textbox] BlahBlahCatfish: [Textbox] but if I simply plonk the code in, it gets lined up exactly as its lined up above. What I want is for it to be lined up like this: Name: [Textbox] Age: [Textbox] BlahBlahCatfish: [Textbox] Ordinarly I would use a Table but I am trying to get out of that habit and use lovely CSS. Ideas of how to do this without billions of divs and stuff?

  Read the article

• How to give over right (table) permission in Sqlserver 2008?

  - by Ayyappan.Anbalagan

  I am using SQL Server 2008.i tried to modify the table.But it not allowing to over right. How to give overright(modify) permission in Sqlserver 2008?

  Read the article

• What happens when I create an index on a view? Are there any benefits versus using a table with ind

  - by Gilbo

  From what I understand the data will be "persisted" (physically stored, not just retrieved when i need it). Is this correct? If so what would be the advantage of using an indexed view versus just using a table?

  Read the article

• Can I make a SQL Server 2005 Table Column accept only letters and numbers ?

  - by Space Cracker

  When we have a column that will store a username that will only accept letters and numbers we always do validation on this input field using javascript or even server validation from code .. but i want to know if is there any way that can allow me make this validation on the Table column itself even some one try to enter data from any place it don't accept and throw exception ?

  Read the article

• Sql Server - How to calculate the size of some rows in a table?

  - by Tom S.

  How can i calculate the size of only some rows in a table? For example, with the code: EXEC sp_spaceused 'Users' you obtain the size of all rows, however i want to calculate the size of part of them, something like this: EXEC sp_spaceused 'Users WHERE Gender='f'' How can i achieve this? Thanks in advance

  Read the article

• How to give over right (table) permission in SQL Server 2008?

  - by Ayyappan.Anbalagan

  I am using SQL Server 2008. I tried to modify the table. But it not allowing to update. How to give UPDATE permission in SQL Server 2008?

  Read the article

• Mysql : should i put my data into 1 table or split per user?

  - by Haroldo

  This data is for a holiday cottage's simple accommodation calendars. The data is simple and stores dates when each cottage is booked. The cols would be cottage_id, booked_from_date, booked_until_date and I would expect around 60 rows per user per year * 200-300 users. I should put this is one table right?

  Read the article

• MSSQL + Select only two records for each masterID in a table.

  - by Nev_Rahd

  I got childtable wherin it got 1 to n records liked to mastertable with MasterID column. How can i select from child table only first 5 records for each MasterID.

  Read the article

• Can emacs generate a table of comments and number sections of a document?

  - by mp3foley

  I'm writing a plain text document with numbered sections or chapters and am wondering if emacs can help with numbering and re-numbering sections. And of course would be great if it could then generate a table of contents as well. I have had a search on google and looked through the emacs wiki but did not come up with anything other than for latex stuff and possibly muse mode, but I would like to keep this as a plain text README style document. Thanks for any help or suggestions.

  Read the article

• How to select the last record from MySQL table using SQl syntax.

  - by Vafello

  I have a table with several records. There is an id field. I would like to select the record with the most recent id (i.e. the ighest id). Any ideas?

  Read the article

• I am searching for a string like Cityname, State in mysql table where state name is 2 letter char.

  - by subson

  I am searching for a string like Cityname, State (e.g.Moline,IL) in mysql table. How can i make the query using regexp in mysql.

  Read the article

• How should I structure my settings table with mysql?

  - by incrediman

  I want to use MySQL to store a bunch of admin settings - what's the best way to structure the table? Like this? Setting _|_ Value setting1 | a setting2 | b setting3 | c setting4 | d setting5 | e Or like this? |--------|_setting1_|_setting2_|_setting3_|_setting4_|_setting5_| Settings | a | b | c | d | e | Or maybe some other way?

  Read the article

• iPhone:How do i insert few rows in the middle of existing table?

  - by user187532

  Hello all, If i want to insert few rows in the middle of the existing table, how do i approach it? Where all that i should be careful when doing such thing? Is there any good sample source available? Appreciate your helps. Thank you.

  Read the article

< Previous Page | 208 209 210 211 212 213 214 215 216 217 218 219  | Next Page >