Search Results

Search found 14956 results on 599 pages for 'mysql dba'.

Page 298/599 | < Previous Page | 294 295 296 297 298 299 300 301 302 303 304 305  | Next Page >

• How to select domain name from email address

  - by ugesh.gali

  I have a email address like [email protected] and [email protected] [email protected] ... etc I want a Mysql select query so that it would trim user names and .com an returns output as gmail,ymail,hotmail etc

  Read the article

• Max value amongst 4 columns in a row.

  - by KandadaBoggu

  I have test_scores table with following fields: Table schema: id (number) score1 (number) score2 (number) score3 (number) score4 (number) Sample data: id score1 score2 score3 score4 1 10 05 30 50 2 05 15 10 00 3 25 10 05 15 Expected result set: id col_name col_value 1 score4 50 2 score2 15 3 score1 25 What is a good SQL for this?(I am using MySQL.)

  Read the article

• SQL time issue - need it 6 hours forward!

  - by Luke

  My server is currently based on us eastern time, and as I am in the UK, i need to move this forward 6 hours. When using now() in mysql, i am getting the wrong time, is there anything i can add to now() to bring it forward 6 hours? Thanks

  Read the article

• To share a table or not share?

  - by acidzombie24

  Right now on my (beta) site i have a table called user data which stores name, hash(password), ipaddr, sessionkey, email and message number. Now i would like the user to have a profile description, signature, location (optional) and maybe other things. Should i have this in a separate mysql table? or should i share the table? and why?

  Read the article

• Local connection with Database

  - by Leo

  How do I connect my local client application with the database on the server? I am using Delphi and MySQL.

  Read the article

• MySQLDump without locking the tables

  - by Raul Singahn

  It seems that if you have many tables, you can only perform a MySQLDump without locking them all, otherwise you can an error. What are the side effects of performing a MySQLDump without locking all the tables; Is the DB snapshot I get this way, consistent? Do I have any other alternative for getting a backup of a MySQL DB with many tables?

  Read the article

• Sun webstack vs Installing PHP, MySQL, Apache individually

  - by Vincent

  Is it possible to install PHP, MySQL, Apache individually on Solaris instead of installing them through a webstack? What are the advantages and disadvantages? I seem to frequently get a CURL error on Solaris when dealing with HTTPS sites. (error:81072080:lib(129):func(114):reason(128). I have no clue why that error is occuring and thought it might solve it, if I upgrade to latest PHP,MySQL,Apache versions. At this point I am not even sure if it's a Solaris issue. Any advice? Thanks

  Read the article

• How to disable the same person to play my RPG game as two different persons?

  - by Donator

  Ok, so title says it all. Of course, I store all players' ip addresses in mysql and I can check if there is a person with the same ip address before he registers, but then, he can register to my page at school or wherever he wants. So, any suggestions?

  Read the article

• fetch fourth maximum record from the table field

  - by chetan

  Following is the command to fetch maximum salary form empsalary table in mysql select max(salary) from empsalary; but I want to fetch employee who got fourth highest from the list of employee. I don't want to use trigger or function because I know there is direct command to fetch.

  Read the article

• WHERE vs HAVING

  - by baloo

  Why is it that you need to place columns you create yourself (for example "select 1 as number") after HAVING and not WHERE in MySQL? And are there any downsides instead of doing "WHERE 1" (writing the whole definition instead of a column name)

  Read the article

• Querying two tables with one query

  - by vipul

  I want to get two separate tables by executing one query in MySQL. If you know how, please reply.

  Read the article

• jqueryUI Slider: Setting minimum and maximum values in range from DB

  - by alexBrand

  I have a jQueryUI slider on my website that deals with price range. I have a products table in mysql that has various entries. I am using the slider to filter the results, but I need to set the minimum and maximum prices from the records in my database. Should I just generate (with php) hidden fields in my html that contain the minimum and maximum and then use jQuery to obtain them? Or is there a better way of achieving this, maybe using AJAX? Thanks

  Read the article

• Free java or flash file browser for photogallery

  - by Christian

  Hi. I'm about to develop a small web gallery, where it's supposed to be possible to upload several pictures at a time and then add some info abut the pictures.So I need a free java or flash local file browser that can pass me some info of the pictures that gets uploaded so that I can create some SQL entries for each picture. The platform for the project will be PHP and MySQL. Any good recommendations?

  Read the article

• Selecting financial values from db stored as text

  - by Midhat

  I have some financial values stored as text in a mysql db. the significance of financial is that negative numbers are stored enclosed in paranthesis. is there a way to automatically get the numeric value associated with that text. (like '5' shoudl be retuned as 5 and '(5)' should be returned as -5)

  Read the article

• How to limit a users uploaded image size using PHP

  - by LiMt

  I was wondering how would you limit an uploaded image size to 5mb using PHP & MySQL.

  Read the article

• What should every PHP programmer know ?

  - by Waseem

  I would to be a PHP/Mysql Programmer what is the technologies that i must know ? Like :- Frameworks IDEs Template Engines Ajax and Css Frameworks please tell me the minimum requirements that i must know , and tell me your favourite things in the previous list ? thanks

  Read the article

• Freeradius problem

  - by IceAgeBosna

  Hello my Dear friends! Firstly sorry to my English I am not an expert:) I am using freeradius 2.1.7 and MySQL instaled on Ubuntu server 9.04. Now, the perl script called: "auth.pl" is verifying usersnames, passwords, and updating information. The problem is that on a certain number of connections simply "NAS" - Mikrotik until the next reboot users can not connect. If you need i cann show you auth.pl script

  Read the article

• changing value of a primary key in a table and FK in referenced tables

  - by sergiogx

  I wish to change the primary key of a table, and also change the foreign key of the tables that reference it. for example table employee has PK idEmployee = 1 table payroll has FK idEmployee = 1 I want to update employee to idEmployee = 2 and let the table payroll change FK idEmployee automatically. is this posible in mysql? thanks.

  Read the article

• Does column ordering in databases affect performance?

  - by Rhubarb

  I am using Django with MySql. I have a CharField with max length of 64 as the 2nd to last column, and a Boolean as the last column. Will reversing the order of these provide better optimization of space?

  Read the article

• Generate table schema inspecting Excel(CSV) and import data

  - by Frank Malina

  How would I go around creating a MYSQL table schema inspecting an Excel(or CSV) file. Are there any ready Python libraries for the task? Column headers would be sanitized to column names. Datatype would be estimated based on the contents of the spreadsheet column. When done, data would be loaded to the table. I have an Excel file of ~200 columns that I want to start normalizing.

  Read the article

• Should $new_link be used in mysql_connect()?

  - by Eddie

  I'm maintaining an inherited site built on Drupal. We are currently experiencing "too many connections" to the database. In the /includes/database.mysql.inc file, @mysql_connect($url['host'], $url['user'], $url['pass'], TRUE, 2) (mysql_connect() documentation) is used to connect to the database. Should $new_link = TRUE be used? My understanding is that it will "always open a new link." Could this be causing the "too many connections"?

  Read the article

• Do all databases use the USE statement to switch databases?

  - by thearchitect

  MySQL uses the USE database_name to change the active database. Does that work on all databases? EDIT: By databases I mean DBMS. Thanks for bringing it to my attention.

  Read the article

• Transmogrify into date from multiple columns

  - by Dave Jarvis

  What is a better way to program the following SQL: str_to_date( concat(convert(D.DAY, CHAR(2)), '-', convert(M.MONTH, CHAR(2)), '-', convert(M.YEAR, CHAR(4))), '%e-%m-%Y' ) as AMOUNT_DATE I want to convert the columns D.DAY, M.MONTH, and M.YEAR to a date field using MySQL. The above works, but seems much more complicated than it needs to be. (If there's an ANSI SQL way to do it, that would be even better.) Thank you!

  Read the article

• Simple SELECT query problem...

  - by Povylas

  Hi, I have this MySql select query witch seams to have a bug but I am quit "green" so I simple can not see, so maybe you could help? Here is the query: SELECT node_id FROM rate WHERE node_id='".$cat_node_id_string."' LIMIT ".$node_count_star.",".$node_count_end." ORDER BY SUM(amount) GROUP BY node_id Thanks for help in advance...

  Read the article

• How to get the one paramater from list of items in php

  - by Mirage

  I have one field in database table with following lines show_email_icon= show_hits= feed_summary= page_title= show_page_title=1 pageclass_sfx= menu_image=hd_events.png secure=0 All the stuff is stored as text in one field of mysql table Now i want to get the menu_image. How can i get that

  Read the article

< Previous Page | 294 295 296 297 298 299 300 301 302 303 304 305  | Next Page >