Search Results

Search found 63752 results on 2551 pages for 'create table'.

Page 360/2551 | < Previous Page | 356 357 358 359 360 361 362 363 364 365 366 367  | Next Page >

• MySQL - Combine two fields to create a unix timestamp?

  - by Dan

  Hi, I'm trying to retrieve a UNIX timestamp from a query by combining a date and a time field in the table, however it keeps returning as zero. SELECT *, UNIX_TIMESTAMP(startdate starttime) AS start, UNIX_TIMESTAMP(enddate endtime) AS end FROM mytable; Can anyone help me out? Thanks.

  Read the article

• How to manage and make look of complex data <table> identical in all browser?

  - by metal-gear-solid

  What are helpful CSS properties which can be helpful for table? I have to make so many complex tables which have different type of colors in columns, thead, borders, padding, alternate row and column colors etc. I want to use as less as possible of css classes. How to make complex tables design with combination of as much as possible of HTML tags and CSS properties? and should look identical in all browsers.

  Read the article

• how to display table data more clearly. in oracle sqlplus

  - by Nubkadiya

  here is the way my sqlplus display the table data. but i want to show them as Name | Address | name1 | address1 | name2 | address2 | name3 | address3 |

  Read the article

• How can I create table / list in Wordpress post / page?

  - by Steven

  I need to make list of employees (inside a post) where I have an image to the left, and some text to the right. What is the best way of making this table without writing HTML? (My customer does not know HTML)

  Read the article

• How can i fetch all data from any table of a test DB and DUMP it on the production db in same tablen

  - by Parth

  How can i fetch all data from any table of a test DB and DUMP it on the production db in same tablename(structure)? in Mysql using PHP code? Please help me..

  Read the article

• How to write native SQL queries in Hibernate without hardcoding table names and fields?

  - by serg555

  Sometimes you have to write some of your queries in native SQL rather than hibernate HQL. Is there a nice way to avoid hardcoding table names and fields and get this data from existing mapping? For example instead of: String sql = "select user_name from tbl_user where user_id = :id"; something like: String sql = "select " + Hibernate.getFieldName("user.name") + " from " + Hibernate.getTableName(User.class) + " where " + Hibernate.getFieldName("user.id") + " = :id";

  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

• create db,table and insert data and retrive it in android.

  - by raji

  hi, I am new to android. Can anyone please help me to create db ,table and insert data and retrive it make it display in list.I am really in need of your help.

  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

• 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 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 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

• 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 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

• 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

• 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

• 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 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

• 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

• 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

• 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

< Previous Page | 356 357 358 359 360 361 362 363 364 365 366 367  | Next Page >