Latest mySQL Code Snippets

Popular / Snippets

adminthanhphong created a Page  -  Jul 15, 2023

Phào chỉ thạch cao là một sản phẩm được sử dụng rộng rãi trong ngành xây dựng để trang trí nội thất. Với sự phát triển của công nghệ, ngày nay phào chỉ thạch cao được chia thành hai loại chính là phào chỉ thạch cao hoa văn và phào chỉ thạch cao trơn, mỗi loại mang đến những ưu điểm và ứng dụng riêng. Bài..

 Respond   mySQL  
maliooooooooooo created a Page  -  Jun 06, 2023

Dominobet Asia adalah platform judi online yang menawarkan berbagai pilihan permainan untuk pemain dari seluruh dunia. Dengan antarmuka yang ramah pengguna dan sistem pembayaran yang aman, ini telah menjadi salah satu platform paling populer untuk perjudian online di Asia. Ini juga menawarkan berbagai bonus dan promosi untuk membuat pemain

 Respond   mySQL  
maliooooooooooo created a Page  -  May 26, 2023

Dewabet Slot adalah situs poker online tepercaya yang menyediakan platform yang aman dan terjamin bagi para pemain untuk menikmati permainan poker. Jika Anda adalah pemain pemula, Situs dewabet slot Terpercaya dapat membantu Anda mempelajari cara bermain dan meningkatkan keterampilan Anda.

 Respond   mySQL  
mortl92 created a Page  -  Apr 24, 2013
1 212 

This stored sql procedure is used to replace a special character (or string) of your field with another string. See: for more details about the usage.

Hawkee created a Page  -  Oct 05, 2012
3 936 

This is a very handy query that sorts your tables by their physical size in megabytes. Just be sure to edit the query to include the database name.

sean created a Page  -  May 04, 2012
1 279 

The below snippet will create a MySQL user and grant them all permissions on the given database. The % wildcard identifier will allow this particular user to be accessible via any hostname. While the * wildcard will grant the user access to all tables within the supplied database. You can change either to match your specific needs.

Hawkee created a Page  -  Apr 15, 2012
2 220 

This is a very handy command to avoid running the same query twice. It will tell you how many total rows there are when you only need a handful. You need to run the second query immediately following the first. If you leave out SQL_CALC_FOUND_ROWS from the first query FOUND_ROWS() will simply return the number or results you got, 10 in this case.

alabama created a Page  -  Oct 13, 2011

Saw someone make something similar to this, but this is all the chrs in 1 dialog

Hawkee created a Page  -  Mar 28, 2007

This is more of a note to myself, but I use it to dump databases where there are additional fields in the new table. When you're upgrading a database you can either add the new fields to the old table or move the data from an older table to a newer one.

Are you sure you want to unfollow this person?
Are you sure you want to delete this?
Click "Unsubscribe" to stop receiving notices pertaining to this post.
Click "Subscribe" to resume notices pertaining to this post.