No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
Hello, I am in my 3rd year and would be required to submit about 5 project proposals next month. I am really interested in doing a project involving database but as many topics as i have seen look like i would get hooked mid way. So please if you have … |
|
Hi, I am using this query for count [ICODE]SELECT Count(ID) from Table[/ICODE] But its showing the count of all the fields which are empty and zeros. I want the count of fields which are empty and zero. please guide me. Thanks. Take care. |
|
Hi, I have the following table: Name Row(number) Nico 1 Marko 2 Peter 3 Joy 4 Kimi 5 I delete Nico and Joy: Marko 2 Peter 3 Kimi 5 And how to make a table would look as follows: Marko 1 Peter 2 Kimi 3 How to automatically re-arranged in … |
|
Hi guys i cant open the mdf on the ms sql express 2005 why this will happen it is another ways to open it. |
|
ok so i am doin a table that has info on all 44 presidents. i have to show the state the produces the biggest number of presidents...i am not sure how to do it. here is a lil bit of the table for you . I want it to show … |
|
Most web forums will state next to each board how many threads or posts have been been. Would you calculate that with a query for each board to count the number of "post" entries in the table for that board, or simply increment a number in the board table whenever … |
|
I have recently taken over the running of an e-commerce website. Once in a while i will need to increase the prices of certain products by any given percenatge. The products all have a code starting with 3 letters and then digits. for instance: ffc1234, ffc1245, dcc4544, dcc5799, vff300, and … |
|
Hi, [B]This was Mysql Backup Batch Script [/B] Script named as [B]mysqlbackup.bat[/B] REM [at] echo off for /f "tokens=1" %%i in ('date /t') do set DATE_DOW=%%i for /f "tokens=2" %%i in ('date /t') do set DATE_DAY=%%i for /f %%i in ('echo %date_day:/=-%') do set DATE_DAY=%%i for /f %%i in ('time … |
|
EDIT: I just realized I should have posted this in the MySQL section. If a mod can move it there I'd appreciate it. Thanks :) Hi all I have two tables. The first one has the details of each fruit, its code, markup percentage, it's cost price and the amount … |
|
what is mean by replication..can anyone explain me with example ..couldnot get clear idea in google?plz |