Search Results

Search found 20838 results on 834 pages for 'mysql num rows'.

Page 215/834 | < Previous Page | 211 212 213 214 215 216 217 218 219 220 221 222  | Next Page >

• How to list records for a query and to display 'no records' when no rows returned using a single que

  - by Vijay

  How to list records for a query and to display 'no records' when no rows returned using a single query? Now i'm using a count(*) query or using the mysql_num_rows and then another query in different result set to list data.. Please tell me whether its possible with a single query..?

  Read the article

• How to change this mysql select into sql server select statement?

  - by Pandiya Chendur

  I use this mysql statement for concating description which has a length greater than 30.. select if (CHAR_LENGTH(description)>30,CONCAT(SUBSTRING(description,1,30), '.....'),description) as description from table How to change this mysql select into sql server select statement?

  Read the article

• How do you set a default value for a MySQL Datetime column?

  - by Brian Boatright

  How do you set a default value for a MySQL Datetime column? In SQL Server it's getdate(), what is the equivalant for MySQL? I'm using 5.x if that is a factor.

  Read the article

• How many of you have gone from MySQL to Postgresql? Was it worth it?

  - by trustfundbaby

  I'm thinking about moving from MySQL to Postgres for Rails development and I just want to hear what other developers that made the move have to say about it. I'm looking for personal experiences, not a Mysql v Postgres shootout, just the pros and cons that you yourself have arrived at. Stuff that folks might not necessarily think. Feel free to explain why you moved in the first place as well.

  Read the article

• where is the actual data in a mysql db stored on a linux machine?

  - by noam

  Which files are the actual files holding the data in the tables in a mysql db? I went to /var/lib/mysql/ and I can see there a bunch of relatively small directories corresponding to my tables, and a lot of files named servername-bin.0000001 etc. Is the data stored in those files?

  Read the article

• In python, is there a simple way to connect to a mysql database that doesn't require root access?

  - by Matthew

  I'm writing a script to parse some text files, and insert the data that they contain into a mysql database. I don't have root access on the server that this script will run on. I've been looking at mysql-python, but it requires a bunch of dependencies that I don't have available. Is there a simpler way to do this?

  Read the article

• How to count how many items for distinct items in mysql?

  - by Vincent Duprez

  Imagine a have a table with a column named status: status ------ A A A B C C D D D How can I count how many rows have A, how many rows have B etc? this kind of output: A |B |C |D |E ------------------ 3 |1 |2 |3 |0 As for E = O , this will always be A,B,C,D and E Output should be one row (thus 1 query). When doing a distinct count (most returning answer on my searches, it does return how many different elements there are, 4 in this case...)

  Read the article

• Database design (MySql)::should we put html data in text field inside database table or more efficie

  - by meyosef

  Hi, We building big Web Application and we use mysql, we want to make mysql database more fast. Some of us think if we will put message html body inside table and not inside text.txt in will make database heavy and not fast. Thanks, *Part of main table that hold message: option 1:hold html message body inside database message { id (int) subject (varchar) body (text) } option 2: hold html message body inside body1.txt file message { id (int) subject (varchar) file_body_path (varchar) } *

  Read the article

• MySQL UPDATE clause removes slashes in values - any way to disable the sensitivity to slashes?

  - by Jeremy Rudd

  A MySQL UPDATE clause removes slashes in values, although double slashes ensures that the values save correctly. Any way to disable the sensitivity to slashes? Can I disable it in my connector? I'm using the official connector "MySql.Data" for C#.

  Read the article

• PHP or MySql error; Possible to display an "error page" in browser?

  - by Camran

  My classifieds website uses mainly PHP and MySql. On error, (for example if a variable isn't found), I would like to have an error-page to show, is this possible? And I mean for every error to point to the same error-page. I am thinking about htaccess, but maybe there are other ways also? Same with MySql, how is it done there? Thanks

  Read the article

• MySQL Date_Format based on today's date and another column?

  - by JM4

  I am aware of the MySQL Date_Format function but am looking to achieve the following: I have on column with a day date in 2 digit format (01-30). I am trying to update another date formatted field with the current year, the next month (m+1) and the day field mentioned previously. In PHP i would do this using mktime function but this must be done using mysql calls only. Is it possible to transform in this way?

  Read the article

• How do I use a MySQL subquery to count the number of rows in a foreign table?

  - by James Skidmore

  I have two tables, users and reports. Each user has no, one, or multiple reports associated with it, and the reports table has a user_id field. I have the following query, and I need to add to each row a count of how many reports the user has: SELECT * FROM users LIMIT 1, 10 Do I need to use a subquery, and if so, how can I use it efficently? The reports table has thousands and thousands of rows.

  Read the article

• Easiest way to activate PHP and MySQL on Mac OS 10.6 (Snow Leopard)?

  - by matt

  What is the easiest way to activate PHP and MySQL on Mac OS 10.6 (Snow Leopard)? I'd prefer to use any built in versions before resorting to downloading from the PHP or MySQL websites. I'm comfortable at the command line in Terminal.

  Read the article

• Connection to mysql works through php but not through a form submission?

  - by Legend

  I have a download.php file that connects to a remote mysql database. If I run it using php download.php it works fine. But if I create another php file form.php and then submit the form to this download.php, it complains the following: Can't connect to MySQL server on '<IP_ADDRESS>' (13) Does anyone know why this might be happening? I can't see a reason why this works directly but fails to work upon form submission...

  Read the article

• Php/MySQL to ASP.NET/MSSQL, Suggest if its worth the trouble.

  - by user302656

  Hello Guys, We have been using PHP/MySQL for our web application which has been growing a lot, the database is around 4-5GB and one of the table is 2GB sometimes, hence slowing down whenever any queries to that table is called. Should we just try to optimize, or are we using MySQL above its limit? Will switching our web app to .NET/MSSQL resolve the issues? Thanks

  Read the article

• How to hack MySQL GROUP_CONCAT to fetch a limited number of rows?

  - by Misier

  I somehow need this feature,but MySQL doesn't support it at this moment. I'm using GROUP_CONCAT(CONCAT(...)) to generate a xml-like stuff. But when the size exceeds the limit,the xml is just broken! So I have to somehow make it only retrieve 5 rows !

  Read the article

• How to load file into mysql DB on a shared hosting platform?

  - by Vasu

  A process running on my machine collects data from various websites and stores it in the local mysql db. Same data is exported using SELECT INTO OUTFILE and FTPed to the shared host every few hours. My hosting provider doesn't allow LOAD DATA INFILE to be executed on the shared host? What are my other options for automated/scheduled load to MYSQL db on my shared host?

  Read the article

• Easiest way to choose a percentage of an amount of rows from a MySQL table?

  - by Rob

  I have a script that has a GET variable: $_GET['percentage'] I have a MySQL table of data. Now lets say that there are 100 rows of data in this table. In pseudo-code: SELECT data FROM table Now would it be possible to select $_GET['percentage'] of random data from table? For example (again in pseudo-code): $_GET['percentage'] = 10; SELECT 10% of data from table order by rand() If this IS possible, how could I do it?

  Read the article

• Is there a way to get a MySQL table defined encoding in PHP ?

  - by Brad

  I see i can get a MySQL database defined encoding in PHP using the function mysql_client_encoding(...), but is there a way to get a MySQL table defined encoding in PHP ?

  Read the article

• how to send multiple row to mysql at same time(like bulk copy)?

  - by Ayyappan.Anbalagan

  I am using asp.net + Mysql. I have multiple rows in my dataset; I have to store the rows in my database table. How to do that?

  Read the article

• how do i specify connection parameters on the command line to run mysql in batch mode?

  - by hmak

  I need to be able to write a script to automatically connect mysql in batch mode so that I can run some .sql files. I tried to enter the following at the prompt: ./mysql -u root -p mypassword but I keep getting a "Enter password: " prompt. What am I doing incorrectly? Thanks.

  Read the article

• how to solve syntax error in procedure in mysql?

  - by Shooter

  Hi all, i am executing a procedure in mysql, procedure is- delimiter $$ create procedure getFacility (in id int, out MyFacility VARCHAR(200)) begin select Facility into MyFacility from facilities where FacilityID = id ; end $$ delimiter ; and it is giving error below- Error Code : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'end $$ delimiter' at line 1 (0 ms taken) how to solve this error? Thanks, Yugal

  Read the article

• where should I do the calculating stuff,PHP or Mysql?

  - by SpawnCxy

  I've been doing a lot of calculating stuff nowadays.Usually I prefer to do this job in PHP rather than Mysql though I know PHP is not good at this cuz I thought mysql may be worse.But I found some performance problem :some pages were loaded so slowly that 30 seconds' timelimit is not enough for them!So I wonder which is the better practice to do the calculations,and any princles for that?Suggestions would be appreciated.

  Read the article

• Is there a Veil-like plug-in for MySQL?

  - by Kevin

  We have a MySQL database and would like to have row-level security implemented at the database level. I have been playing with the Veil plug-in for PostgreSQL and like what it does. Is there something similar for MySQL so we do not have to convert over to PostgreSQL?

  Read the article

• Is this safe? Is this OK to do in MYSQL?

  - by alex

  I have always done this: mysqldump -hlocalhost -uuser -ppass MYDATABASE > /home/f/db_backup/MYDATABASE.sql mysql -uuser -ppass MYDATABASE < MYDATABASE.sql But, if I do this instead...is this safe? Is this identical to the above??? mysqldump -hlocalhost -uuser -ppass MYDATABASE | gzip > /home/f/db_backup/MYDATABASE.sql.gz zcat MYDATABASE.sql.gz | mysql -uuser -ppass MYDATABASE

  Read the article

< Previous Page | 211 212 213 214 215 216 217 218 219 220 221 222  | Next Page >