Search Results

Search found 17206 results on 689 pages for 'mysql embedded'.

Page 135/689 | < Previous Page | 131 132 133 134 135 136 137 138 139 140 141 142  | Next Page >

• mysql select from one server insert to another mysql server ?

  - by Shvilam

  I wont to do insert to one mysqll server to and get the data or do the select part of the insert into select from anther mysql server not just copy entire tables is this possible in my sql I know that in MS Sql server you can do a linked server thanks

  Read the article

• MySQL select/where statement

  - by expo101

  I have a webapplication linked to a mysql database with the following fields: field 1:trip_id field 2:trip_destination field 3:trip_description field 4:trip_duration In the webapplication I have a listbox based on the following: ListBox value =1: trip duration 1 - 5 days ListBox value =2: trip duration 6 - 10 days Listbox value =3: trip duration 11 -20 days ListBox value =4: trip duration over 20 days How do I put this in the sql select statement?

  Read the article

• PHP and MySQL - correct way to use mysqli_real_escape_string

  - by TaG

  I was wondering if the code below is the correct way to use mysqli_real_escape_string() when storing users data in a database. Here is the PHP & MySQL code. if (mysqli_num_rows($dbc) == 0) { $mysqli = mysqli_connect("localhost", "root", "", "sitename"); $dbc = mysqli_query($mysqli,"INSERT INTO info (user_id, url) VALUES ('$user_id', 'mysqli_real_escape_string($url)')"); } if ($dbc == TRUE) { $dbc = mysqli_query($mysqli,"UPDATE info SET url = 'mysqli_real_escape_string($url)' WHERE user_id = '$user_id'");

  Read the article

• MySQL Backup Procedure

  - by mouthpiec

  Is there a way to backup an MySQL database so that if something wrong occurs, it will be easy to recreate the tables with the same data?

  Read the article

• Select log lines from today in mysql

  - by ripper234

  I never remember how to do this properly - can you help me fix this query? SELECT * from log where now() - EventTime < '1 day' Note - this question seems identical but there's no solution there for mysql.

  Read the article

• 6 digit numeric column in MySQL

  - by Vatsala

  Say I want to maintain a 6 digit ID column for a table in my database -is it possible to specify this at the DB level in MySQL?

  Read the article

• mysql query fails.It gives me invalid result

  - by user2941349

  I have to write mysql query for fetching result from my database with a specified date and code like ABH18 or ABH17 or ABH19.I write the querly like below. select * from tbl_transaction where trans_name like 'ABH19%' or trans_name like 'ABH18%' or trans_name like 'ABH17%' or trans_name like 'ABH15%' and date_of_vazhipad='2013-11-20' and trans_status='Completed successfully.' There are no result in the DB satisfying all above conditions.But i got result with different dates.But i want to ensure the date_of_vazhipad='2013-11-20' so that the query may work properly Thanks in advance

  Read the article

• Getting MySQL code from an existing database

  - by nix

  I have a database (mdb file) that I am currently busy with. I would like to know if it is possible to generate MySQL code that would be used to create this database?

  Read the article

• Index a mysql table of 3 integer fields

  - by Doori Bar

  I have a mysql table of 3 integer fields. None of the fields have a unique value - but the three of them combined are unique. When I query this table, I only search by the first field. Which approach is recommended for indexing such table? Having a multiple-field primary key on the 3 fields, or setting an index on the first field, which is not unique? Thanks, Doori Bar

  Read the article

• MySQL 5.1 Schema Installer

  - by sergiogx

  I need to make an installer for a MySQL 5.1 Database, but I'm totally a noob when it comes to installers. I've been looking at NSIS and learned a little but I don't really know how to use it to just to execute a script. Anyone out there has experience installing database schemas in multiple computers? thanks

  Read the article

• mysql master/slave failover

  - by myhusky

  Is there any product that make mysql master/slave failover process easier? something that can happen automatically, rather than manually fix it.

  Read the article

• how to number the datas from mysql

  - by udaya

  Hi This is a doubt on mysql select query let me axplain my doubt with a simple example consider this is my query SELECT dbCountry from tableCountry tableCountry has fields dbCuntryId dbCountry and dbState I have the result as dbCountry india america england kenya pakisthan I need the result as 1 india 2 america 3 england 4 kenya 5 pakisthan the numbers 12345 must be generated with the increase in data and itis not a autoincrement id How can i get it is it something like loop

  Read the article

• MySQL greatest value in row?

  - by noryb009

  Hi! I'm using MySQL with PHP. This is like my table: (I'm using 3 values, but there are more) id | 1 | 2 | 3 1 | 3 |12 |-29 2 | 5 |8 |8 3 | 99|7 |NULL I need to get the greatest value in a certain row. If should get: (id - output) (1 - 2), (2-2), (3-1). Is there any queries for this? I've been trying, but I can't get it to work right.

  Read the article

• Store html into MYSql database

  - by jouzef19

  hello I'm try to store String (that contain html ) to mysql database by using Longtext data type. but its always says "You have an error in your SQL syntax". (note : i tried to store normal text , and its work)

  Read the article

• is there mysql corelib site for building queries?

  - by mjeason

  Maybe i have the wrong context but... Is there a corelib site for mysql like http://corelib.rubyonrails.org/ for ruby on rails RoR? Would be nice to have 1 stop shop. thx.

  Read the article

• Sorting MySQL table by next due date

  - by Zagga

  Hi folks, I have a MySQL table that stores (amongst other things) a persons date of birth. Is there any way to sort the table so the next due birthday is at the top? I have the date stored in standard yyyy-mm-dd DATE format and seperate year, month and day fields so I can sort it by the first birthday of the year (ORDER BY month, day) but I can't seem to get any further. Any help would be greatly appreciated. Zagga

  Read the article

• I need some advice from Experts on how to develop a PHP site with MySQL

  - by mouthpiec

  Hi, I need some advice from experts :) I will develop a website using PHP and I will use also MySQL. I bought some server space from a Virtual private server including all the service needed. How should I develop the site? Shall I develop it on my machine at home (using for example Wamp), and when ready transfer all the files to the server? If so what is the best method to transfer also the database? Thanks in advance!!

  Read the article

• Find column that contains a given value in MySQL

  - by shuby_rocks

  Hello all I have a table in a MySQL database. I am given a value that occurs as a cell value in that table but I do not know which cell is it i.e. the row and column of that cell. What is the most efficient way to find the column to which that value belongs? Thanks in advance.

  Read the article

• Mysql select multiple colomn from non related tables

  - by Ajith

  I have two table in mysql named rootpath with only one field 'root' and savecatogory with fields brandid,categoryid,name.There is no relation between these two tables.Now how can retrieve root,brandid,categoryid using single query.Please help me.

  Read the article

• Sort MYSQL Data By Number of Entries

  - by Belgin Fish

  Hi, I'm wondering how I can sort mysql data based on the number of entries. I'm doing this so I can have a page of the top purchases, so it would have to retrieve all the product_id's from a table, and then sort them by the most times one shows up, limiting it to 10 or something. Thanks!

  Read the article

• Get top rated item using AVG mysql

  - by user1876234

  I want to find top rated item using AVG function in mysql, right now my query looks like this: SELECT a.title, AVG(d.rating) as rating FROM in8ku_content a JOIN in8ku_content_ratings d ON a.id = d.article_id ORDER BY rating DESC Problem is that it takes AVG of all items and the result is not accurate, what should be changed here to get correct result ? Tables: in8ku_content [id, title] in8ku_content_ratings [id, article_id, rating]

  Read the article

• How can we detect Mysql Injection?

  - by jasmine

  A site has blocked with google. There is a site for this issue: http://25yearsofprogramming.com/blog/20070705.htm How can we detect mysql injection? Thanks in advance.

  Read the article

• How to make db structure for multiple input in MySQL and PHP

  - by bob

  Below is my current structure for MySQL database id | item_name | item_files ------------------------------------------ 1 | Item A | file1.zip,file2.zip,file3.zip 2 | Item B | file3.zip Example I create simple form to fill up Item Name and Multiple upload files then store it to db. Question :- How to design the db structure for accept the multiple files? There have a way which I don't want to use explode, implode to get the file1.zip file2.zip file3.zip

  Read the article

• Warning: mysql_query(): 3 is not a valid MySQL-Link resource

  - by Pieter

  I got this odd error and I can't figure out where it came from: Warning: mysql_query(): 3 is not a valid MySQL-Link resource in (...) What's up with the 3? I don't get it. Has anyone experienced this error themselves?

  Read the article

• Generating SQL script from MySQL database table

  - by testingmysql

  Hi, Is there any application that will read a MySQL database table and generate a SQL script of INSERT statements (so that I can copy tables from one db to another db)? OR how can I transfer content from db1.table1 to db2.table2 where table1 and table2 is same. Thank you.

  Read the article

< Previous Page | 131 132 133 134 135 136 137 138 139 140 141 142  | Next Page >